Subject | Odd listing in the DDL (FB 2.0, FlameRobin 0.7.6) |
---|---|
Author | red_october_canada |
Post date | 2007-03-08T14:25:41Z |
I have the following domain declared:
CREATE DOMAIN DOM_BOOLEAN
AS Varchar(3)
DEFAULT 'No'
NOT NULL
CHECK(VALUE IN ('No', 'Yes'))
COLLATE NONE;
Now look at the following output from FlameRobin
...
IS_MYL DOM_BOOLEAN DEFAULT 'No',
IS_RLP DOM_BOOLEAN DEFAULT 'No',
IS_ACV DOM_BOOLEAN DEFAULT T 'Yes',
IS_ATE DOM_BOOLEAN DEFAULT 'Yes',
...
In all fields that have a field "type" of this domain I get:
DOM_BOOLEAN
as expected, followed by the DEFAULT 'No' or 'Yes' as I had set it.
So what is going on with the third line? Where it says:
... DOM_BOOLEAN DEFAULT T 'Yes',
What is the "extra" letter "T" doing in there?
Should I get rid of this "T"? If so, how?
Thanks in advance.
CREATE DOMAIN DOM_BOOLEAN
AS Varchar(3)
DEFAULT 'No'
NOT NULL
CHECK(VALUE IN ('No', 'Yes'))
COLLATE NONE;
Now look at the following output from FlameRobin
...
IS_MYL DOM_BOOLEAN DEFAULT 'No',
IS_RLP DOM_BOOLEAN DEFAULT 'No',
IS_ACV DOM_BOOLEAN DEFAULT T 'Yes',
IS_ATE DOM_BOOLEAN DEFAULT 'Yes',
...
In all fields that have a field "type" of this domain I get:
DOM_BOOLEAN
as expected, followed by the DEFAULT 'No' or 'Yes' as I had set it.
So what is going on with the third line? Where it says:
... DOM_BOOLEAN DEFAULT T 'Yes',
What is the "extra" letter "T" doing in there?
Should I get rid of this "T"? If so, how?
Thanks in advance.