Unable to specify new 32k page size [CORE6316] #6557
Assignees
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
|
Commented by: Emil Totev (emilt) While at it.. Wouldn't it be nice if we had also an alternate syntax using 4K | 8K | 16K | 32K... |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done with caveats Test Details: Some issues remain. Discussed with Alex, letters since 29.05.2020 12:28. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Emil Totev (emilt)
Not sure if it's only ISQL problem - specifying 32k page size in Fb 4 beta 2 produces an error. Also invalid values for page size seem to be silently ignored.
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
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
Commits: 6ac7da4
====== Test Details ======
Some issues remain. Discussed with Alex, letters since 29.05.2020 12:28.
The text was updated successfully, but these errors were encountered: