On 02/10/2014 17:26, Thomas Steinmaurer wrote: > Hello, > > I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit. > > I have the following sequence of created domains in isql: > > SQL> create domain d_mydomain bigint; > SQL> commit; > SQL> create domain d_mydomain_1 bigint; > SQL> commit; > SQL> create domain d_mydomain_2 bigint; > SQL> create domain d_mydomain_3 bigint; > SQL> commit; > SQL> > > The following query: > > select f.rdb$field_name, rdb$default_source, rdb$validation_source > from rdb$fields f left outer join rdb$field_dimensions fd on > f.rdb$field_name = fd.rdb$field_name > where (f.rdb$system_flag = 0 or f.rdb$system_flag is null) and > f.rdb$field_name not like 'RDB$%' > order by f.rdb$field_name, fd.rdb$dimension > > returns: > > RDB$FIELD_NAME RDB$DEFAULT_SOURCE RDB$VALIDATION_SOURCE > ------------------------------------------------------------------------ > D_ACCOMMODATIONCATEGORY DEFAULT 0 CHECK (VALUE BETWEEN > 0 AND 5) > D_BOOLEAN > D_BOOLEAN_FALSE DEFAULT FALSE CHECK (VALUE BETWEEN > 0 AND 5) > D_BOOLEAN_NULL > D_BOOLEAN_TRUE DEFAULT TRUE CHECK (VALUE BETWEEN > 0 AND 5) > D_ID > D_IDREF DEFAULT TRUE CHECK (VALUE BETWEEN > 0 AND 5) > D_MYDOMAIN > D_MYDOMAIN_1 DEFAULT TRUE CHECK (VALUE BETWEEN > 0 AND 5) > D_MYDOMAIN_2 > D_MYDOMAIN_3 DEFAULT TRUE CHECK (VALUE BETWEEN > 0 AND 5) > > > Mind default source and validation_source for domains that have been > created without a default etc. > > Is it required to have the others object before to make this happen?
I tested with the objects you created and they're created correctly. Adriano ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
