[FB3+] RPAD works incorectly in a connection with the charset NONE #7592
Open
Description
Hello,
When I use connection charset NONE, RPAD generates VARCHAR with length 65533 (==-3)
Is it OK?
FB4
SQL> SET SQLDA_DISPLAY ON;
SQL> show version;
ISQL Version: WI-V4.0.3.2937 Firebird 4.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V4.0.3.2937 Firebird 4.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V4.0.3.2937 Firebird 4.0/tcp (HOME4)/P17:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V4.0.3.2937 Firebird 4.0/tcp (HOME4)/P17:C"
on disk structure version 13.0
SQL> select RPAD('-',CHARACTER_LENGTH('a'),'a') from RDB$DATABASE;
INPUT message field count: 0
OUTPUT message field count: 1
01: sqltype: 448 VARYING scale: 0 subtype: 0 len: 65533 charset: 0 NONE
: name: RPAD alias: RPAD
: table: owner:
RPAD
....
FB3
d:\Program_Files\Firebird_3_0_x64>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect inet4://localhost:3060/d:/database/ram/FB30_PORT3060/ibp_test_fb30_d3.gdb USER 'GAMER' PASSWORD 'vermut';
Database: inet4://localhost:3060/d:/database/ram/FB30_PORT3060/ibp_test_fb30_d3.gdb, User: GAMER
SQL> SET SQLDA_DISPLAY ON;
SQL> show version;
ISQL Version: WI-V3.0.11.33637 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.11.33683 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.11.33683 Firebird 3.0/tcp (HOME4)/P15:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.11.33637 Firebird 3.0/tcp (HOME4)/P15:C"
on disk structure version 12.0
SQL> select RPAD('-',CHARACTER_LENGTH('a'),'a') from RDB$DATABASE;
INPUT message field count: 0
OUTPUT message field count: 1
01: sqltype: 448 VARYING scale: 0 subtype: 0 len: 65533 charset: 0 NONE
: name: RPAD alias: RPAD
: table: owner:
RPAD