Submitted by: Claudio Valderrama C. (robocop)

Assigned to: Claudio Valderrama C. (robocop)

First, we try to put the dimension after the character set. The server rejects the syntax, then we put the array indication before the character set and succeed:

F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'domain.fdb';
SQL> create domain d as char(1) character set iso8859_1[1:2];
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 51
-[
SQL> create domain d as char(1)[1:2] character set iso8859_1;
SQL> ^Z

But isql extracts the array dimensions after the character set, rendering the script not syntax compliant:

F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird\bin>isql -x DOMAIN.FDB
Database: DOMAIN.FDB

SET SQL DIALECT 3;

/* CREATE DATABASE 'DOMAIN.FDB' PAGE_SIZE 4096 DEFAULT CHARACTER SET NONE; */

/* Domain definitions */
CREATE DOMAIN D AS CHAR(1) CHARACTER SET ISO8859_1[2];

It seems the bug is rather ancient, but I only tested FB3, FB2.5 and FB2.0.

Commits: 6d1781b