Subject | FB201 sets RDB$NULL_FLAG differently than FB153? |
---|---|
Author | Glebas |
Post date | 2007-09-29T07:06:30Z |
Hello,
Here is the test case:
CREATE DOMAIN TID AS INTEGER NOT NULL;
CREATE TABLE ENTITY (ENTITYID TID, ALLOTHERFIELDS TID,
CONSTRAINT PK_ENTITY PRIMARY KEY (ENTITYID));
SELECT RDB$NULL_FLAG FROM RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = 'ENTITY' AND RDB$FIELD_NAME = 'ENTITYID'
Returns 'NULL' if executed on FB153 server and
Returns '1' if executed on FB201 server.
Why? Was that done intentionally?
Thanks,
Glebas
Here is the test case:
CREATE DOMAIN TID AS INTEGER NOT NULL;
CREATE TABLE ENTITY (ENTITYID TID, ALLOTHERFIELDS TID,
CONSTRAINT PK_ENTITY PRIMARY KEY (ENTITYID));
SELECT RDB$NULL_FLAG FROM RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = 'ENTITY' AND RDB$FIELD_NAME = 'ENTITYID'
Returns 'NULL' if executed on FB153 server and
Returns '1' if executed on FB201 server.
Why? Was that done intentionally?
Thanks,
Glebas