Commented by: @pavel-zotov

On WI-V3.0.1.32539:

1) no problems when script contains 'set list ON' ISQL command;
2) lines are padded to 65535 bytes when set list OFF - see attachment.

Commented by: Fabrice (fabinfo)

Hello,

Same problem with a new created database DIALECT 1.
Same problem with dialect 3.
=> Problem is with Default Character Set = NONE <=
because there no problem when
Default Character Set = UTF8

See in attchament :

CREATE DOMAIN MON$SEC_DATABASE
AS CHAR(7) CHARACTER SET ASCII
NOT NULL
COLLATE ASCII;
CREATE DOMAIN SEC$KEY
AS VARCHAR(10) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS;
CREATE DOMAIN SEC$NAME_PART
AS VARCHAR(10) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS;
CREATE DOMAIN SEC$USER_NAME
AS VARCHAR(10) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS;
CREATE DOMAIN SEC$VALUE
AS VARCHAR(85) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS;
/******************* PROCEDURES ******************/
/******************** TABLES **********************/
CREATE TABLE TESTLPAD
(
T_KEY INTEGER NOT NULL,
T_VALUE INTEGER,
CONSTRAINT INTEG_2 PRIMARY KEY (T_KEY)
);
/********************* VIEWS **********************/
/******************* EXCEPTIONS *******************/
/******************** TRIGGERS ********************/
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON TESTLPAD TO SYSDBA WITH GRANT OPTION;

Commented by: @dyemanov

What client library version is used? What tool is used to run the query? Did you try with ISQL?

Commented by: @dyemanov

AFAIU, the problem is that LPAD was described as VARCHAR(32767) in v2.x but now described as VARCHAR(65535) in v3.0. And this together with overhead overflows the old API message limit (64KB).

Commented by: Fabrice (fabinfo)

> What client library version is used? What tool is used to run the query? Did you try with ISQL?

1) With Flamerobin it's crash
2) On Delphi + IBDAC it give error "Message length error (Encountered 2, expected 65538)"

Commented by: Fabrice (fabinfo)

FBCLIENT.DLL = 3.0.0.32483 (32 bits)