Issue Details (XML | Word | Printable)

Key: CORE-4137
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Adriano dos Santos Fernandes
Reporter: hamacker
Votes: 0
Watchers: 1
Operations

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

Wrong metadata output script generate by isql / CHARACTER SETISO8859_1 sintaxe error.

Created: 02/Jul/13 06:54 PM   Updated: 22/Sep/15 09:34 AM
Component/s: ISQL
Affects Version/s: 2.5.2, 2.5.2 Update 1
Fix Version/s: 3.0 Alpha 1, 2.5.3

File Attachments: 1. File sesmt-wrong-metadata-on-procedures.sql (97 kB)

Environment: Windows XP, Windows 2008 R2 (64bits)

QA Status: Done successfully


 Description  « Hide
Try :
isql.exe" 'C:\SESMT\DADOS\SESMT.FDB' -U "SYSDBA" -P "masterkey" -x -now -o "c:\temp\sesmt.sql"
to extract metadata from semst database and output to a file c:\temp\sesmt.sql;
But some errors appear inside c:\temp\sesmt.sql script at create/alter procedures (all of them).
all char/varchar declarations like
declare variable test char(1) = 'A';
or
create procedure test(param char(10) output pout varchar(30))

will be transfomed to :
declare variable test char(1) = 'A' CHARACTER SETISO8859_1 ;
create procedure test(param char(10) CHARACTER SETISO8859_1
output pout varchar(30) CHARACTER SETISO8859_1 )

I believe that missed space from SET<SPACE>ISO8859_1.

I do some tests like recreate a fresh new database from script generate by ibexpert (100% done well) and generate again with 'isql' and ever with same bug result.
None bugs happens with others types, even domain. This error only appear with char or varchar declarations.

thx

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
There are no comments yet on this issue.