FB crashes on attempt to create table with number of fields greater than 5460. [CORE6411] #6649
Submitted by: @pavel-zotov
Following batch creates .sql which, in turn, attempts to create table with huge number of fields - more than 5000.
When total number of "user" fields ("F1", "F2", ...) exceeds 'magic number' = 5459 then FB crashes.
if exist !dbnm! del !dbnm!
echo create database 'localhost:!dbnm!'; | !fbc!\isql -q -z
echo recreate table tdata(id bigint primary key > !tmpsql!
echo !date! !time! point before create table
echo update or insert into tdata values( 1 >!tmpsql!
echo !date! !time! point before update or insert
The text was updated successfully, but these errors were encountered:
Modified by: @pavel-zotov
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: No test => Done with caveats
Test Details: One issue (with same origin as the source bug) remains unresolved: when we create table with COMPUTED-BY field which expression contains lot of terms.
Discussed with dimitr, 29-sep-2020 15:43.