Ticket Hash: | bc7dc46b0be80319e9789693b06577880f22ac89 | |||
Title: | DeclareTable returning "not and error" for WITHOUT ROWID virtual tables | |||
Status: | Deferred | Type: | Feature_Request | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Virtual_Table | Resolution: | Under_Review | |
Last Modified: | 2017-06-09 22:38:56 | |||
Version Found In: | 1.0.105.1 | |||
User Comments: | ||||
anonymous added on 2017-06-07 06:17:48:
I'm creating a module for a virtual table in SQLite and it is working fine. Great work, guys! However, now I need to add a virtual table for which I can't map a ROWID. And I'm getting a "not an error" from DeclareTable. This declaration works fine:
But all the following ones fails with a "not an error" error (I tried them all): "CREATE TABLE x(AlbumId integer NOT NULL PRIMARY KEY,Title nvarchar NOT NULL,ArtistId integer NOT NULL) WITHOUT ROWID"
"CREATE TABLE x(AlbumId integer PRIMARY KEY,Title nvarchar NOT NULL,ArtistId integer NOT NULL) WITHOUT ROWID"
I suspect the problem could be that the module is always declared with the Is this a bug? There is a way to declare a module in mistachkin added on 2017-06-09 22:29:27: The WITHOUT ROWID feature was added to the SQLite core library after this class was added to System.Data.SQLite and is not yet supported by the virtual table subsystem of System.Data.SQLite. |