Issue Details (XML | Word | Printable)

Key: CORE-6316
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Emil Totev
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Unable to specify new 32k page size

Created: 26/May/20 11:01 AM   Updated: 29/May/20 10:01 AM
Component/s: None
Affects Version/s: 4.0 Beta 2
Fix Version/s: 4.0 RC 1

QA Status: Done with caveats
Test Details: Some issues remain. Discussed with Alex, letters since 29.05.2020 12:28.


 Description  « Hide
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
=============
        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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Emil Totev added a comment - 26/May/20 11:48 AM
While at it.. Wouldn't it be nice if we had also an alternate syntax using 4K | 8K | 16K | 32K...