This looks like a bug in the statement parser. It seems to use signed 16
bit int for this value, instead of an unsigned 16 bit int (or a signed
32 bit int). This does make me wonder about the test coverage for this
feature.
Could you create a bug in the tracker?
Mark
On 2020-05-26 08:57, Emil Totev wrote:
I am trying to create a database with 32k page - what am I doing
wrong? Also, is it OK to accept an invalid value and replace it
without even a warning?
ISQL Version: WI-T4.0.0.1963 Firebird 4.0 Beta 2
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'localhost:k:\db\test.fdb' PAGE_SIZE 32768
DEFAULT CHARACTER SET WIN1251;
Statement failed, SQLSTATE = 22003
Dynamic SQL Error
-SQL error code = -842
-Short integer expected
-At line 1, column 70
SQL> CREATE DATABASE 'localhost:k:\db\TEST.FDB' PAGE_SIZE 32767
DEFAULT CHARACTER SET WIN1251;
Server version:
WI-T4.0.0.1963 Firebird 4.0 Beta 2
WI-T4.0.0.1963 Firebird 4.0 Beta 2/tcp (SPOCK)/P16:C
WI-T4.0.0.1963 Firebird 4.0 Beta 2/tcp (SPOCK)/P16:C
SQL> select mon$page_size from mon$database;
MON$PAGE_SIZE
=============
16384
SQL> CREATE DATABASE 'localhost:k:\db\TEST-K.FDB' PAGE_SIZE 32K;
Server version:
WI-T4.0.0.1963 Firebird 4.0 Beta 2
WI-T4.0.0.1963 Firebird 4.0 Beta 2/tcp (SPOCK)/P16:C
WI-T4.0.0.1963 Firebird 4.0 Beta 2/tcp (SPOCK)/P16:C
SQL> select mon$page_size from mon$database;
MON$PAGE_SIZE
=============
4096
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel