On Fri, 26 May 2017 18:04:14 +0200 (CEST)
Eric wrote:
> Why should the INSERT return an error? It is quite OK to, when
> inserting a row, not specify a value for a NOT NULL column - as long
> as the DDL has specified some way of constructing a value.
The SQL in question is
>>> insert into test
On Thu, 25 May 2017 21:47:20 -0400, "James K. Lowden"
wrote:
> On Fri, 19 May 2017 12:47:32 -0600
> "Keith Medcalf" wrote:
>>On Thursday, 18 May, 2017 10:17, Paul Sanderson
>> wrote:
>>> Create table test (id integer not null primary key, data text);
>>> insert into test values (null, 'row1');
On Fri, 19 May 2017 12:47:32 -0600
"Keith Medcalf" wrote:
> > Create table test (id integer not null primary key, data text);
> > insert into test values (null, 'row1');
> > select * from test;
> > 1, row1
> Specifying NOT NULL on an INTEGER PRIMARY KEY (which is an alias for
> the RowID) is a r
On Thursday, 18 May, 2017 10:17, Paul Sanderson
wrote:
> Create table test (id integer not null primary key, data text);
> insert into test values (null, 'row1');
> select * from test;
> 1, row1
> I know that if you provide a NULL value to a column define as integer
> primary key that SQLite w
Ahh being dull and in a hurry
thanks
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo lic
> Le 18 mai 2017 à 18:16, Paul Sanderson a écrit
> :
>
> Is this a bug?
>
> Create table test (id integer not null primary key, data text);
> insert into test values (null, 'row1');
> select * from test;
> 1, row1
>
> I know that if you provide a NULL value to a column define as integer
> pri
Is this a bug?
Create table test (id integer not null primary key, data text);
insert into test values (null, 'row1');
select * from test;
1, row1
I know that if you provide a NULL value to a column define as integer
primary key that SQLite will provide a rowid, but should the not null
constraint
7 matches
Mail list logo