firebird
firebird copied to clipboard
FB3 and possibly others - isql.exe - metadata export - ALTER CHARACTER SET stands befor CREATE COLLATION
As a result, a situation arises when we use the COLLATION before it was created. Example:
"C:\Program Files\Firebird\Firebird3\isql.exe" -x -output ExampleDb.sql D:\Db\ExampleDb.FDB
ExampleDb.sql:
SET SQL DIALECT 3;
CREATE DATABASE 'D:\Db\ExampleDb.FDB' PAGE_SIZE 16384 DEFAULT CHARACTER SET ISO8859_1;
/* Character sets */
ALTER CHARACTER SET ISO8859_1 SET DEFAULT COLLATION BPS;
/* Collations */
CREATE COLLATION BPS FOR ISO8859_1 FROM EXTERNAL ('DE_DE') PAD SPACE CASE INSENSITIVE 'SPECIALS-FIRST=1';
As a result, by execute, we have an error: "C:\Program Files\Firebird\Firebird3\isql.exe" -i D:\Db\ExampleDb.sql ..... -ALTER CHARACTER SET ISO8859_1 failed -COLLATION BPS for CHARACTER SET ISO8859_1 is not defined After line 4 in file ExampleDb.sql
Exist in Firebird 3. Perhaps the bug exists in other versions too.