isql doesn't mangle blob filter and udf information with embedded quotes when extracting a script. [CORE1493] #1908
Labels
affect-version: 1.0.3
affect-version: 1.5.2
affect-version: 1.5.3
affect-version: 1.5.4
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.1 Alpha 1
affect-version: 2.1 Beta 1
affect-version: 2.1 Beta 2
affect-version: 2.1 RC1
affect-version: 2.1.0
affect-version: 3.0 RC2
component: isql
fix-version: 2.1 RC1
priority: minor
type: bug
Submitted by: Claudio Valderrama C. (robocop)
Assigned to: Claudio Valderrama C. (robocop)
Is related to QA191
It's funny that after 7 years we still have problems with quoted identifiers. Example below:
F:\fb2dev\fbbuild\firebird2\temp\debug\firebird\bin>fbserver -a
F:\fb2dev\fbbuild\firebird2\temp\debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'qi.fdb';
SQL> declare filter "xi""xa" input_type 0 output_type 1 entry_point 'dax''x' module_name 'my''mod';
SQL> declare external function "xe""xo" int returns int entry_point 'dox''x' module_name 'my''mod';
SQL> ^Z
F:\fb2dev\fbbuild\firebird2\temp\debug\firebird\bin>isql -x qi.fdb
Database: qi.fdb
SET SQL DIALECT 3;
/* CREATE DATABASE 'qi.fdb' DEFAULT CHARACTER SET NONE */
/* BLOB Filter declarations */
DECLARE FILTER xi"xa INPUT_TYPE 0 OUTPUT_TYPE 1
ENTRY_POINT 'dax'x' MODULE_NAME 'my'mod';
/* External Function declarations */
DECLARE EXTERNAL FUNCTION "xe""xo"
INTEGER
RETURNS INTEGER
ENTRY_POINT 'dox'x' MODULE_NAME 'my'mod';
The output should be instead, as expected:
/* BLOB Filter declarations */
DECLARE FILTER "xi""xa" INPUT_TYPE 0 OUTPUT_TYPE 1
ENTRY_POINT 'dax''x' MODULE_NAME 'my''mod';
/* External Function declarations */
DECLARE EXTERNAL FUNCTION "xe""xo"
INTEGER
RETURNS INTEGER
ENTRY_POINT 'dox''x' MODULE_NAME 'my''mod';
Commits: 16b18a9
The text was updated successfully, but these errors were encountered: