ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to
'RDB$[[:DIGIT:]]*'
-------------------------------------------------------------------------------------------
Key: CORE-4917
URL: http://tracker.firebirdsql.org/browse/CORE-4917
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC 1, 2.5.5
Reporter: Pavel Zotov
On empty database do:
Database: /3255:e25, User: SYSDBA
SQL> set list on;
SQL> set count on;
SQL> select rdb$field_name from rdb$fields where trim(rdb$field_name) SIMILAR
TO 'RDB$[[:DIGIT:]]*';
Records affected: 0
SQL> create domain rdb$1 int;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -637
-Implicit domain name RDB$1 not allowed in user created domain // OK, it's
expected
-- But using ALTER DOMAIN statement one may see that such domain CAN be created:
SQL> create domain foo int;
SQL> alter domain foo to rdb$1;
SQL> commit;
SQL> select rdb$field_name from rdb$fields where trim(rdb$field_name) SIMILAR
TO 'RDB$[[:DIGIT:]]*';
RDB$FIELD_NAME RDB$1
Records affected: 1
SQL> commit;
SQL> show domains;
There are no domains in this database
===
PS. Checked on: WI-V2.5.5.26916, WI-V3.0.0.32008
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
