You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Following batch creates .sql which, in turn, attempts to create table with huge number of fields - more than 5000.
Table contains field ID (primary key) plus other ("user") fields with names start with 'F'.
When total number of "user" fields ("F1", "F2", ...) exceeds 'magic number' = 5459 then FB crashes.
Checked on WI-V3.0.7.33365, WI-V4.0.0.2204.
======= @echo off
setlocal enabledelayedexpansion enableextensions
set tmpsql=%~dpn0.sql.tmp
set fbc=C:\FB\30SS
set dbnm=c:\temp\tmp4test.fdb
set ISC_USER=SYSDBA
set ISC_PASSWORD=masterkey @Rem theshold for FB 3.x and FB 4.x: set FLD_COUNT=5460 -- crashes since this value
set FLD_COUNT=5459
if exist !dbnm! del !dbnm!
if exist !dbnm!.delta del !dbnm!.delta
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.
Apropriate code will be added to .fbt after fix for this will appear.
Ticket must NOT be closed until this.
Discussed with dimitr, 29-sep-2020 15:43.
The text was updated successfully, but these errors were encountered:
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.
Apropriate code will be added to .fbt after fix for this will appear.
Ticket must NOT be closed until this.
Submitted by: @pavel-zotov
Following batch creates .sql which, in turn, attempts to create table with huge number of fields - more than 5000.
Table contains field ID (primary key) plus other ("user") fields with names start with 'F'.
When total number of "user" fields ("F1", "F2", ...) exceeds 'magic number' = 5459 then FB crashes.
Checked on WI-V3.0.7.33365, WI-V4.0.0.2204.
=======
@echo off
setlocal enabledelayedexpansion enableextensions
set tmpsql=%~dpn0.sql.tmp
set fbc=C:\FB\30SS
set dbnm=c:\temp\tmp4test.fdb
set ISC_USER=SYSDBA
set ISC_PASSWORD=masterkey
@Rem theshold for FB 3.x and FB 4.x: set FLD_COUNT=5460 -- crashes since this value
set FLD_COUNT=5459
if exist !dbnm! del !dbnm!
if exist !dbnm!.delta del !dbnm!.delta
echo create database 'localhost:!dbnm!'; | !fbc!\isql -q -z
!fbc!\gfix -w async !dbnm!
echo recreate table tdata(id bigint primary key > !tmpsql!
(
for /l %%i in (1 1 !FLD_COUNT!) do (
echo ,f%%i bigint
)
) >>!tmpsql!
echo ^); >>!tmpsql!
echo commit; >>!tmpsql!
echo !date! !time! point before create table
!fbc!\isql localhost:!dbnm! -i !tmpsql!
echo !date! !time! point after create table
echo update or insert into tdata values( 1 >!tmpsql!
(
for /l %%i in (1 1 !FLD_COUNT!) do (
echo ,%%i
)
) >>!tmpsql!
echo ^) matching(id^); >>!tmpsql!
echo commit; >>!tmpsql!
echo !date! !time! point before update or insert
!fbc!\isql localhost:!dbnm! -i !tmpsql!
echo !date! !time! point after update or insert
Commits: 92830d4 c7548da
====== 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.
Apropriate code will be added to .fbt after fix for this will appear.
Ticket must NOT be closed until this.
Discussed with dimitr, 29-sep-2020 15:43.
The text was updated successfully, but these errors were encountered: