Subject | Re: Odd listing in the DDL (FB 2.0, FlameRobin 0.7.6) |
---|---|
Author | red_october_canada |
Post date | 2007-03-09T14:46:56Z |
Hi Milan! Based on the domain declared in the previous post, the DDL
you asked for is:
CREATE TABLE ...
(
...
IS_ACV DOM_BOOLEAN DEFAULT 'Yes'
...
);
COMMIT;
I have declared many fields of type DOM_BOOLEAN through-out my DB and
the problem appears to be random. Some end up with the the extra 'T'
and some don't. It doesn't seem to matter if I don't declare an
'override' to the domain's default or not, example:
IS_ACV DOM_BOOLEAN /* Uss the domain's default of 'No'*/
IS_ACV DOM_BOOLEAN DEFAULT 'Yes' /* Override with a 'Yes' */
In either case, the extra T may or may not show up.
you asked for is:
CREATE TABLE ...
(
...
IS_ACV DOM_BOOLEAN DEFAULT 'Yes'
...
);
COMMIT;
I have declared many fields of type DOM_BOOLEAN through-out my DB and
the problem appears to be random. Some end up with the the extra 'T'
and some don't. It doesn't seem to matter if I don't declare an
'override' to the domain's default or not, example:
IS_ACV DOM_BOOLEAN /* Uss the domain's default of 'No'*/
IS_ACV DOM_BOOLEAN DEFAULT 'Yes' /* Override with a 'Yes' */
In either case, the extra T may or may not show up.
> Looks like a possible bug in FlameRobin, we'll look into it ASAP. Could
> you please show us the original DDL you used to create IS_ACV ?
>
> --
> Milan Babuskov
> http://www.flamerobin.org
>