ISQL -X (from FB 3.0) creates invalid command related to grant usage of domain
when database is restored from FB 2.5 where this domain was created
--------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5207
URL: http://tracker.firebirdsql.org/browse/CORE-5207
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.0, 4.0 Initial
Reporter: Pavel Zotov
1. Create script:
===
set term ^;
execute block as
begin
execute statement 'drop domain dm_int';
when any do begin end
end
^
set term ;^
commit;
create domain dm_int as int;
commit;
===
2. Create empty database on FB 2.5 and apply this script
3. Make gbak of this database (i.e. use gbak from FB 2.5)
4. Make restore using FB 3.0, let target file will be 'e30.fdb'
5. Run %FB_30_HOME%\isql -X host/port path/e30.fdb
Check final script:
===
SET SQL DIALECT 3;
/* CREATE DATABASE '/:C:\MIX\firebird\QA\fbt-repo\tmp\E40TMP.FDB' PAGE_SIZE
4096 DEFAULT CHARACTER SET NONE; */
/* Domain definitions */
CREATE DOMAIN DM_INT AS INTEGER;
COMMIT WORK;
/* Grant permissions for this database */
GRANT USAGE ON DOMAIN DM_INT TO PUBLIC;
===
Last statement (GRANT USAGE ON DOMAIN ... ) can not be compiled:
===
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 16
-DOMAIN
===
--
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
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
