Greetings, I have a table in an SQLite3 database:
create table if not exists a (
id integer primary key autoincrement,
a text not null,
b integer default 0,
c boolean default 0,
d integer default null
and I wanted to change the boolean field c to a text field default null and clicked modify, removed the "0" from the default value field and selected "null" in the dropdown field "null".
I expected all other fields to remain unchanged, I expected an ALTER TABLE call, instead sqlitemanager executed a create table statement - and changed data types of two other fields:
* the autoincrement attribute was lost on the field id
* the default value of the field b integer default 0 was changed to default null !
CREATE TABLE 'a' (
'id' INTEGER PRIMARY KEY ,
'a' TEXT NOT NULL ,
'b' INTEGER ,
'c' TEXT ,
Please fix. Thanks for the otherwise great software!
Log in to post a comment.