incorrect calculation of byte-length for view columns (as in CORE-5049)
-----------------------------------------------------------------------
Key: CORE-6380
URL: http://tracker.firebirdsql.org/browse/CORE-6380
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.6
Environment: Win Server 2016 x64 Firebird 3.0.6.33328-0_x64
Reporter: Artem Anufriev
C:\>isql.exe -ch utf8 -user SYSDBA -pass masterkey
create database '127.0.0.1:c:\TEST_BUG.FDB' page_size 16384 default character
set win1251; commit;
connect '127.0.0.1:c:\TEST_BUG.FDB' user 'SYSDBA' password 'masterkey';
create table test_table(
test_code bigint
, test_name varchar(2048)
);
create or alter view test_view as
select distinct
'[' || test_code || ']' || coalesce(test_name, '') as test_field1
, '[' || test_code || ']' || coalesce(test_name, '') as test_field2
, '[' || test_code || ']' || coalesce(test_name, '') as test_field3
, '[' || test_code || ']' || coalesce(test_name, '') as test_field4
, '[' || test_code || ']' || coalesce(test_name, '') as test_field5
, '[' || test_code || ']' || coalesce(test_name, '') as test_field6
, '[' || test_code || ']' || coalesce(test_name, '') as test_field7
, '[' || test_code || ']' || coalesce(test_name, '') as test_field8
from test_table;
Statement failed, SQLSTATE = 54000
unsuccessful metadata update
-new record size of 66260 bytes is too big
-TABLE TEST_VIEW
--
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
