ISQL is adding an unnecessary COMMIT WORK statement to the extracted metadata
script before starting the Stored functions headers/bodies statements
---------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6505
URL: http://tracker.firebirdsql.org/browse/CORE-6505
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0.8
Environment: Windows 10 20H2
Firebird 3.0.8.33420
Reporter: Luciano Mendes
Attachments: DDL.SQL
ACTUAL RESULT
- ISQL is adding an unnecessary COMMIT WORK statement to the extracted metadata
script before starting the Stored functions headers/bodies statements (lines 4
and 15 from DDL.SQL attached)
EXPECTEDT RESULT
- ISQL do not need to add an COMMIT WORK statement to the extracted metadata
script before starting the Stored functions headers/bodies statements (lines 4
and 15 from DDL.SQL attached)
STEPS TO REPRODUCE THIS ISSUE:
1- Create a new database and than just create a simple function:
SET TERM ^ ;
CREATE OR ALTER FUNCTION M_BINTODEC (BIN_NUMBER VARCHAR(63) CHARACTER SET
WIN1252)
RETURNS BIGINT
AS
BEGIN END^
SET TERM ; ^
2- Extract the Metadata script using the ISQL.exe and check all the
instructions (see lines 4 and 15 from DDL.SQL attached)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
