Subject | FB 2.1.2.18118 bug in system table? |
---|---|
Author | jerzyha@o2.pl |
Post date | 2009-12-15T19:27:54Z |
Hellou
I defined the domain of the NOT NULL condition:
CREATE DOMAIN AS D_PRIMARY_KEY
INTEGER NOT NULL;
I'm using it on the table in this way:
CREATE TABLE ZDARZENIA_GOSPODARCZE (
ID_ZDARZENIA D_PRIMARY_KEY,
....
However, the system table RDB$RELATION_FIELDS in the column
RDB$NULL_FLAG this item is NULL, not 1!
If the declaration will add NOT NULL:
CREATE TABLE ZDARZENIA_GOSPODARCZE (
ID_ZDARZENIA D_PRIMARY_KEY NOT NULL,
...
then the column RDB$NULL_FLAG has a valid value (1).
Does the definition of a domain should not include NOT NULL?
Is this a mistake?
ps. sorry for my poor english ;-)
--
Pozdrowienia,
Jerzy
I defined the domain of the NOT NULL condition:
CREATE DOMAIN AS D_PRIMARY_KEY
INTEGER NOT NULL;
I'm using it on the table in this way:
CREATE TABLE ZDARZENIA_GOSPODARCZE (
ID_ZDARZENIA D_PRIMARY_KEY,
....
However, the system table RDB$RELATION_FIELDS in the column
RDB$NULL_FLAG this item is NULL, not 1!
If the declaration will add NOT NULL:
CREATE TABLE ZDARZENIA_GOSPODARCZE (
ID_ZDARZENIA D_PRIMARY_KEY NOT NULL,
...
then the column RDB$NULL_FLAG has a valid value (1).
Does the definition of a domain should not include NOT NULL?
Is this a mistake?
ps. sorry for my poor english ;-)
--
Pozdrowienia,
Jerzy