search

google-code-export / sqlite-manager

Automatically exported from code.google.com/p/sqlite-manager
1 stars 0 forks source link

Add support for tables without ROWID #840

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
SQLite now supports tables without ROWID column. 
(https://www.sqlite.org/withoutrowid.html).

sqlite-manager does not support this so far. It does not allow creating tables 
without rowid. Here is the SQL to create table without rowid:

CREATE TABLE IF NOT EXISTS wordcount(
  word TEXT PRIMARY KEY,
  cnt INTEGER
) WITHOUT ROWID;

The query parsing fails, indicating error on WITHOUT keyword.

If a database has a table created without ROWID, the tool fails to open the 
database.

Original issue reported on code.google.com by vikl...@gmail.com on 11 Apr 2014 at 11:07