Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to specify new 32k page size [CORE6316] #6557

Closed
firebird-issue-importer opened this issue May 26, 2020 · 5 comments
Closed

Unable to specify new 32k page size [CORE6316] #6557

firebird-issue-importer opened this issue May 26, 2020 · 5 comments

Comments

@firebird-issue-importer

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

    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

Commits: 6ac7da4

====== Test Details ======

Some issues remain. Discussed with Alex, letters since 29.05.2020 12:28.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 26, 2020

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 26, 2020

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...

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 27, 2020

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 RC 1 [ 10930 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2020

Modified by: @pavel-zotov

status: 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.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants