Database Changed Heuristics - False Flag?

Details for the issue

I would like DB4S to improve its "Database Changed" heuristics.
Maybe parse the SQL text for "CREATE, ALTER, UPDATE, etc."?

Useful extra information

Ex. SQL code triggering "Database Changed".
--< START DELAY
WITH RECURSIVE
cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<1e6)
SELECT x FROM cnt WHERE x=0;
--< END DELAY

I'm opening this issue because:

DB4S is crashing
DB4S has a bug
DB4S needs a feature
DB4S has another problem

I'm using DB4S on:

Windows: ( version:10 Pro_ )
Linux: ( distro: ___ )
Mac OS: ( version: ___ )
Other: ___

I'm using DB4S version:

3.10.1
3.10.0
3.9.1
Other: ___

I have also:

Tried out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

I have found several queries that create a FALSE flag for Database changed.
Any chance to bump this topic to BUGS?

--Open a database
--Execute the following in a Execute SQL tab:
SELECT * FROM main.sqlite_master; --< This prompts the Write/Revert Changes gui prompt!
--ATTACH 'c:\mydatabase' AS db2; Also prompts Write/Revert Changes.
--Click 'Write Changes' and the Flag becomes grayed but the database file remains unchanged?
--This confirms the False Flag bug.

This can be considered a bug, both your first example and this later one. But the later is more severe: just a single select statement followed by a space is triggering it. I'll take a look when I have some time

@sky5walk

Good find @sky5walk. 😄

Navigation Menu

Repository navigation

Database Changed Heuristics - False Flag? #1297

Details for the issue

Useful extra information

I'm opening this issue because:

I'm using DB4S on:

I'm using DB4S version:

I have also:

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Database Changed Heuristics - False Flag? #1297

Description

Details for the issue

Useful extra information

I'm opening this issue because:

I'm using DB4S on:

I'm using DB4S version:

I have also:

Activity

sky5walk commented on Sep 19, 2018

mgrojo commented on Sep 19, 2018

justinclift commented on Sep 19, 2018

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions