New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
LPAD failed returning Message length error (Encountered 2, expected 65538) [CORE5290] #5568
Comments
Modified by: @pavel-zotovAttachment: c5290-test.7z [ 12974 ] |
Commented by: @pavel-zotov On WI-V3.0.1.32539: 1) no problems when script contains 'set list ON' ISQL command; |
Commented by: Fabrice (fabinfo) Hello, Same problem with a new created database DIALECT 1. See in attchament : CREATE DOMAIN MON$SEC_DATABASE |
Modified by: Fabrice (fabinfo)Attachment: de0.7z [ 12975 ] |
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). |
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
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 |
Commented by: Fabrice (fabinfo) FBCLIENT.DLL = 3.0.0.32483 (32 bits) |
Submitted by: Fabrice (fabinfo)
Attachments:
c5290-test.7z
de0.7z
Script :
CREATE TABLE testlpad
(
t_key integer not null,
t_value integer,
primary key( t_key)
);
COMMIT;
insert into testlpad
(t_key,t_value)
values (0,1);
insert into testlpad
(t_key,t_value)
values (1,2);
insert into testlpad
(t_key,t_value)
values (2,3);
COMMIT;
This query will :
SELECT lpad('', t_value,'-')
from testlpad
failed with error "Message length error (Encountered 2, expected 65538)"
The text was updated successfully, but these errors were encountered: