Subject | null vs not null field syntax? |
---|---|
Author | rimovm |
Post date | 2002-02-28T12:53:56Z |
Platform: Firebird RC2
Hello all!
Been working to finally getting to the latest firebird, etc, and came
across some code in a code library that basically issued the
statement: (pseudocode)
CREATE TABLE(FieldName VARCHAR(80) not null, FieldName2 VARCHAR(30)
null);
Firebird was dying on the "not null" part of the statement. And
whoever put it into the code library had the note: "SQL-92 Standard?"
I started to look through the spec and just got glazed over rather
quickly and never found whether "not null" is part of the spec. So
what I'm asking is:
1 - Do any of your SQL-92 gurus know whether it is or it isn't?
2 - If it is, is it worthwhile to report it as a conformance bug?
Thanks!
-Mike
Hello all!
Been working to finally getting to the latest firebird, etc, and came
across some code in a code library that basically issued the
statement: (pseudocode)
CREATE TABLE(FieldName VARCHAR(80) not null, FieldName2 VARCHAR(30)
null);
Firebird was dying on the "not null" part of the statement. And
whoever put it into the code library had the note: "SQL-92 Standard?"
I started to look through the spec and just got glazed over rather
quickly and never found whether "not null" is part of the spec. So
what I'm asking is:
1 - Do any of your SQL-92 gurus know whether it is or it isn't?
2 - If it is, is it worthwhile to report it as a conformance bug?
Thanks!
-Mike