Regression: CREATE DATABASE fails with 'Token unknown' error when DB name is
enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after DB name
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6517
URL: http://tracker.firebirdsql.org/browse/CORE-6517
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 RC 1, 3.0.7
Reporter: Pavel Zotov
Priority: Trivial
Script (CAUTION: do not keep any sensitive databases in C:\temp\, it can drop
some of them!)
=======
shell del c:\temp\1*.fdb 2>nul;
set list on;
set echo on;
create database "c:\temp\111.fdb" page_size 8192;
select mon$database_name as test_name_2 from mon$database;
commit;
create database "c:\temp\112.fdb" default character set utf8;
select mon$database_name as test_name_2 from mon$database;
commit;
show version;
=======
Output on 2.5.9.27152:
=======
TEST_NAME_1 C:\TEMP\111.FDB
TEST_NAME_2 C:\TEMP\112.FDB
=======
Output on 3.0.8.33426 and 4.0.0.2387:
=======
TEST_NAME_1 C:\TEMP\111.FDB
. . .
create database "c:\temp\112.fdb" default character set utf8;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 17
-"c:\temp\112.fdb"
=======
--
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
