Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

wrong data shown with default constraint #3594

rkoe opened this issue Oct 13, 2019 · 0 comments

wrong data shown with default constraint #3594

rkoe opened this issue Oct 13, 2019 · 0 comments


Copy link

@rkoe rkoe commented Oct 13, 2019


Directly after adding rows, SQLiteStudio shows wrong values for columns, which were set by a default constraint.
Reloading the table-data fixes this.

As #3580, the reason for this seems to be that SQLiteStudio tries to be "smarter" than the database, and fails.

Solution: Fetch the data of the added rows from the database and show this data; and do not guess what the data may be.

This would probably also improve #3588, since then the "lost" data would be visible before a table-data-reload.

Steps to reproduce

  • CREATE TABLE test (col1 NOT NULL DEFAULT ('test'));
  • now, click 'Insert row' and 'Commit'
  • SQLiteStudio now incorrectly shows 'test'
  • after reload, the correct value test (without quotes) is shown.

Operating system


SQLiteStudio version


@pawelsalawa pawelsalawa added the bug label Oct 14, 2019
@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Oct 14, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
2 participants
You can’t perform that action at this time.