Issue Details (XML | Word | Printable)

Key: CORE-1493
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Claudio Valderrama C.
Reporter: Claudio Valderrama C.
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

isql doesn't mangle blob filter and udf information with embedded quotes when extracting a script.

Created: 03/Oct/07 04:12 AM   Updated: 29/Dec/07 06:15 AM
Component/s: ISQL
Affects Version/s: 1.0.3, 1.5.2, 1.5.3, 2.0.0, 1.5.4, 2.0.1, 2.1 Alpha 1, 2.1 Beta 1, 2.0.2, 2.0.3, 2.1 Beta 2, 2.1 RC1, 2.1.0, 2.0.4, 3.0.0
Fix Version/s: 2.1 RC1

Time Tracking:
Original Estimate: 20 minutes
Original Estimate - 20 minutes
Remaining Estimate: 20 minutes
Remaining Estimate - 20 minutes
Time Spent: Not Specified
Remaining Estimate - 20 minutes

Environment: Platform independent.
Issue Links:
Relate
 


 Description  « Hide
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';



 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.