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
C:\Program Files\Firebird\Firebird_3_0>chcp 1257
Active code page: 1257
C:\Program Files\Firebird\Firebird_3_0>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names none;
SQL> create database 'c:\test\testdb.fdb' user 'SYSDBA' password 'masterkey' default character set none;
SQL> commit;
SQL> connect 'localhost/3060:c:\test\testdb.fdb' user 'SYSDBA' password 'masterkey';
Database: 'localhost/3060:c:\test\testdb.fdb', User: SYSDBA
SQL> create exception ex_1 'Üldse ei tööta!';
SQL> create exception ex_2 '@1';
SQL> commit;
SQL> set term !;
// bug - when exception with message override
// this works as expected (=we get the override message instead of "Malformed string") in v2.5.7
SQL> execute block
CON> as
CON> begin
CON> exception ex_1 'Nägin vaeva küll aga välja kukkus nagu tavaliselt!';
CON> end!
Statement failed, SQLSTATE = 22000
Malformed string
-At block line: 4, col: 1
// works - when original exception message
SQL> execute block
CON> as
CON> begin
CON> exception ex_1;
CON> end!
Statement failed, SQLSTATE = HY000
exception 1
-EX_1
-Üldse ei tööta!
-At block line: 4, col: 1
// works - when using new exception parameter
// probably because this specific case was fixed by Adriano in CORE4160
SQL> execute block
CON> as
CON> begin
CON> exception ex_2 using ('Täitsa nagu toimiks?');
CON> end!
Statement failed, SQLSTATE = HY000
exception 2
-EX_2
-Täitsa nagu toimiks?
-At block line: 4, col: 1
SQL>quit!
The text was updated successfully, but these errors were encountered:
Submitted by: Lauri Zoova (lz)
C:\Program Files\Firebird\Firebird_3_0>chcp 1257
Active code page: 1257
C:\Program Files\Firebird\Firebird_3_0>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> set names none;
SQL> create database 'c:\test\testdb.fdb' user 'SYSDBA' password 'masterkey' default character set none;
SQL> commit;
SQL> connect 'localhost/3060:c:\test\testdb.fdb' user 'SYSDBA' password 'masterkey';
Database: 'localhost/3060:c:\test\testdb.fdb', User: SYSDBA
SQL> create exception ex_1 'Üldse ei tööta!';
SQL> create exception ex_2 '@1';
SQL> commit;
SQL> set term !;
// bug - when exception with message override
// this works as expected (=we get the override message instead of "Malformed string") in v2.5.7
SQL> execute block
CON> as
CON> begin
CON> exception ex_1 'Nägin vaeva küll aga välja kukkus nagu tavaliselt!';
CON> end!
Statement failed, SQLSTATE = 22000
Malformed string
-At block line: 4, col: 1
// works - when original exception message
SQL> execute block
CON> as
CON> begin
CON> exception ex_1;
CON> end!
Statement failed, SQLSTATE = HY000
exception 1
-EX_1
-Üldse ei tööta!
-At block line: 4, col: 1
// works - when using new exception parameter
// probably because this specific case was fixed by Adriano in CORE4160
SQL> execute block
CON> as
CON> begin
CON> exception ex_2 using ('Täitsa nagu toimiks?');
CON> end!
Statement failed, SQLSTATE = HY000
exception 2
-EX_2
-Täitsa nagu toimiks?
-At block line: 4, col: 1
SQL>quit!
The text was updated successfully, but these errors were encountered: