[Firebird-devel] [FB-Tracker] Created: (CORE-6503) 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

[Pavel Zotov (JIRA)]

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

                 Key: CORE-6503
                 URL: http://tracker.firebirdsql.org/browse/CORE-6503
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 4.0 RC 1
         Environment: Linux only. No problem on Windows
            Reporter: Pavel Zotov
            Priority: Minor


Ticker created after check results of test for CORE-6316 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






-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel