FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

fix(grid): treat 0-row DML as a failed save, not success · Issue #773 · QueryaHub/Querya-Desktop · GitHub

fix(grid): treat 0-row DML as a failed save, not success #773

Description

Summary

applyTableViewStagedChanges toasts N change(s) saved from plan.statementCount. A concurrent edit (or stale PK) can make UPDATE … WHERE pk = old match 0 rows; the transaction still commits, the local buffer is replaced, and the grid lies until Refresh.

Scope

  • After execute, check affected row counts (or GET DIAGNOSTICS / driver rowcount) per statement.
  • If any statement matched 0 rows, fail the apply, keep the staging buffer, show Save Failed.
  • Do not claim success from statement count alone.

Out of scope

  • Full optimistic-concurrency columns (xmin / row versions).

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    backendBackend database driver execution and queriesbugSomething isn't workingdata-gridInteractive data grid, cell editor, filtering, groupings

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions


      Back | FazBrowse Home | New Git URL