Attempt to create database with page_size >= 65536 makes DB with actual page size = 4k or 8k, but not 32k as it would be [CORE6503] #6733
Assignees
Comments
Modified by: @pavel-zotovsummary: Attempt to create database with page_size >= 65536 leads to createing DB with actual page size = 4k or 8k, but not 32k as it would be => Attempt to create database with page_size >= 65536 makes DB with actual page size = 4k or 8k, but not 32k as it would be |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoff |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0.0 [ 10931 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Covered by another test(s) Test Details: Issues are checked in the test for CORE6316 |
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: @pavel-zotov
Block progress on CORE6510
Ticker created after check results of test for CORE6316 on Linux (discussed with Alex).
Following script illustrates the problem:
# echo "create database '/var/tmp/tmp_page_size_32k.fdb' page_size 32767; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_32k.fdb
PAGE_SIZE 16384
(OK, expected)
# echo "create database '/var/tmp/tmp_page_size_32k.fdb' page_size 32768; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_32k.fdb
PAGE_SIZE 32768
(OK, expected)
# echo "create database '/var/tmp/tmp_page_size_32k.fdb' page_size 32769; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_32k.fdb
PAGE_SIZE 32768
(OK, expected)
# echo "create database '/var/tmp/tmp_page_size_64k.fdb' page_size 65535; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_64k.fdb
PAGE_SIZE 32768
(OK, expected)
################################################
# echo "create database '/var/tmp/tmp_page_size_64k.fdb' page_size 65536; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_64k.fdb
PAGE_SIZE 8192
# echo "create database '/var/tmp/tmp_page_size_64k.fdb' page_size 65537; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_64k.fdb
PAGE_SIZE 4096
# echo "create database '/var/tmp/tmp_page_size_2gb.fdb' page_size 2147483648; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_2gb.fdb
PAGE_SIZE 8192
# echo "create database '/var/tmp/tmp_page_size_2gb.fdb' page_size 2147483649; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_2gb.fdb
PAGE_SIZE 4096
# echo "create database '/var/tmp/tmp_page_size_4gb.fdb' page_size 4294967296; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_4gb.fdb
PAGE_SIZE 8192
# echo "create database '/var/tmp/tmp_page_size_4gb.fdb' page_size 4294967297; show database; drop database;" | /var/tmp/fb40tmp/bin/isql -q | grep -i "page_size"
Database: /var/tmp/tmp_page_size_4gb.fdb
PAGE_SIZE 4096
Commits: 86649a4
====== Test Details ======
Issues are checked in the test for CORE6316
The text was updated successfully, but these errors were encountered: