RowID cannot be extracted (in 3.1.0 this was possible, not in 3.1.1)

[pawelsalawa]

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 3238
Originally created at: Sun Dec 11 11:12:45 2016
Originally last updated at: Sun Dec 11 11:12:45 2016

In 3.1.0 I was able to edit the cell contents of the column �Status� from this query:

SELECT *
  FROM [Data oprollen]
 WHERE Lokatie LIKE "Beijumerbos"

and

WITH
 _A AS (
  SELECT Datum,
         Lokatie,
         sum(Aantal) AS Aantal
    FROM Genitaliseren
   GROUP BY Lokatie,
            Datum
)
SELECT G.Buisje,
   G.Status,
   G.Bakje,
   G.Soort,
   G.Datum,
   G.Lokatie,
   G.Aantal,
   G.Foto,
   G.URL,
   G.Opmerking
FROM Genitaliseren G,
     _A
WHERE G.Datum = _A.Datum AND 
     G.Lokatie = _A.Lokatie
ORDER BY _A.Aantal

and

SELECT *
  FROM [Gevulde buisjes]
 WHERE Status IS NULL OR Status NOT LIKE 'G'
 ORDER BY Buisje

and

SELECT *
  FROM Opslag
  WHERE Soort IS NOT NULL AND 
        Soort NOT LIKE ""
  ORDER BY Buisje

and

CREATE TABLE Opslag (
  id        INTEGER PRIMARY KEY AUTOINCREMENT
                    UNIQUE,
  Buisje    INTEGER NOT NULL,
  Status    TEXT    REFERENCES Status (id),
  Bakje     INT     NOT NULL,
  Soort     TEXT,
  Datum     DATE,
  Lokatie   TEXT    DEFAULT Beijumerbos,
  Aantal    INTEGER DEFAULT (1) 
                    NOT NULL,
  Foto      TEXT,
  Waarnemer TEXT    REFERENCES Waarnemers (id) 
                    DEFAULT KVD,
  URL       TEXT,
  Opmerking TEXT
);

and

CREATE TABLE Status (
  id     TEXT PRIMARY KEY
              UNIQUE,
  Status TEXT NOT NULL
);

but in 3.1.1 this is not possible anymore. When trying to enter a value in the datagrid of column �Status� a message is shown in the Status window, saying:

[11:04:44] Cannot edit this cell. Details: The query execution mechanism had problems with extracting ROWID's properly. This might be a bug in the application. You may want to report this.

When displaying column and row details tooltip in dataview (Configuration / Data browing) is checked, 3.1.0 does show info including rowID, 3.1.1 does not show anything.

Plugins loaded:
ScriptingTcl, SqlExport, MultiEditorTimePlugin, RegExpImport, MultiEditorDateTimePlugin, SqliteHighlighterPlugin, PopulateDictionary, HtmlExport, ConfigMigration, Printing, MultiEditorNumericPlugin, PopulateRandomText, MultiEditorHexPlugin, XmlExport, JavaScriptHighlighterPlugin, PopulateConstant, ScriptingQt, DbSqliteCipher, PopulateRandom, PopulateSequence, MultiEditorBoolPlugin, DbSqliteWx, PdfExport, SqlEnterpriseFormatter, MultiEditorTextPlugin, DbPluginSqlite3, ScriptingSql, JsonExport, CsvExport, MultiEditorDatePlugin, CsvImport, PopulateScript, DbSqlite2

Version:
3.1.1

Operating System:
MacOS X 10.11 El Capitan, 64bit

[pawelsalawa]

Originally created at: Sun Dec 11 11:12:45 2016

Ow, but now I discover that this behaviour was very buggy in 3.1.0. Committed changes turn up in wrong records in 3.1.0! Better not being able to commit changes than committing in wrong records.

[pawelsalawa]

Cannot reproduce the problem. Please provide database that this problem can be reproduced on (attach to the answer comment).