CREATE TABLE bug?

Last post 08-30-2010 5:28 PM by excelthoughts. 0 replies.

Page 1 of 1 (1 items)
	Sort Posts: Previous Next

Reply Contact

If I write a create table statement like this:

CREATE TABLE [Table] ([Field] INTEGER DEFAULT 1 NULL);

and use the Firefox SQLite extension 0.6.0, I get a nullable Field with default value of 1.

If I use version 1.0.65 of System.Data.SQLite provider, and run GetSchemaTable in C#, I get a default value of null and the 1 gets omitted.

Is this a bug?

Page 1 of 1 (1 items)