FB craches when attempt to create index with key length > 3375 bytes (charset =
NONE) when database page_size = 16384
---------------------------------------------------------------------------------------------------------------------
Key: CORE-4416
URL: http://tracker.firebirdsql.org/browse/CORE-4416
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 Alpha 2
Reporter: Pavel Zotov
Script ('longkeys.sql'):
================
create database '192.168.0.220/3333:/var/db/fb30/tmpidxtest.fdb' page_size
16384;
commit;
connect '192.168.0.220/3333:/var/db/fb30/tmpidxtest.fdb';
recreate table t(id int primary key, s04 varchar(3375)); -- ok:3000; 3250;
fails: 3500; 3375;
commit;
recreate sequence g;
commit;
create index t_s04 on t(s04);
commit;
show version;
select current_timestamp from rdb$database;
set stat on;
insert into t select i, left(s, 3375) from (select gen_id(g,1) i, rpad('',
4000, uuid_to_char(gen_uuid())) s from rdb$types, rdb$types,(select 1 i from
rdb$types rows 10));
set stat off;
select current_timestamp from rdb$database;
set stat on;
set echo on;
commit;
Test:
====
isql -i longkeys.sql 2>longkeys.err
Result:
######
1. Console:
=========
ISQL Version: WI-V2.5.3.26730 Firebird 2.5
Server version:
Firebird/linux AMD64 (access method), version "LI-T3.0.0.31082 Firebird 3.0
Alpha 2"
Firebird/linux AMD64 (remote server), version "LI-T3.0.0.31082 Firebird 3.0
Alpha 2/tcp (oel64)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.3.26730 Firebird
2.5/tcp (csprog)/P12"
on disk structure version 12.0
CURRENT_TIMESTAMP
=========================
2014-05-02 14:13:18.0310
Current memory = 5332562684358320
Delta memory = 5332553788549464
Max memory = 5332476777132512
Elapsed time= 218.33 sec
Buffers = 268543402
Reads = 39125124850654756
Writes 1152940647276085121
Fetches = 39180031719488332
2. File longkeys.err:
================
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
After line 16 in file longkeys.sql
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "192.168.0.220".
-Error writing data to the connection.
After line 18 in file longkeys.sql
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "192.168.0.220".
-Error writing data to the connection.
After line 21 in file longkeys.sql
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "192.168.0.220".
-Error writing data to the connection.
After line 22 in file longkeys.sql
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "192.168.0.220".
-Error writing data to the connection.
After line 22 in file longkeys.sql
Stacktrace see in attach.
--
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
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
