Issue Details (XML | Word | Printable)

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

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

Preparation of erroneous DDL statement does not show the main command failed

Created: 26/Mar/14 04:52 PM   Updated: 11/Mar/16 04:20 PM
Component/s: None
Affects Version/s: 3.0 Alpha 1, 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

QA Status: Deferred
Test Details:
Wait for reply about issue of 24/Apr/15 04:34 PM.
On WI-T3.0.0.31855 output in STDERR is the same: has NO line
"-CREATE OR ALTER PROCEDURE SP_TEST1B failed"
which can be useful for the search of exact error place.

WI-T4.0.0.32393 Firebird 4.0 Unstable: still have no clue about why this ticket considered as fixed.
Name of unknown COLUMN - yes, it's shown; but name of _packaged_ procedure which tries to use it - no, and it was lost comparing to Alpha-2.

WI-T3.0.0.30809:
===
-RECREATE PACKAGE BODY PKG_TEST failed
-CREATE OR ALTER PROCEDURE SP_TEST1B failed <<<<<< THIS WAS LOST <<<
-Dynamic SQL Error
-SQL error code = -206
-Column unknown
===

WI-T4.0.0.32393:
===
-RECREATE PACKAGE BODY PKG_TEST failed
-Dynamic SQL Error
-SQL error code = -206
-Column unknown
-NON_EXISTENT_FIELD
===
Wait for reply on letter to dimitr, 11/mar/2016 19:13


 Description  « Hide
In Firebird 3, execution of erroneous DDL statement shows information about the main command. Exemple: CREATE PACKAGE NEW_PACKAGE failed.

However, this part of the error message is being not shown when the command fail at the prepare time.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes made changes - 26/Mar/14 04:52 PM
Field Original Value New Value
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Adriano dos Santos Fernandes made changes - 26/Mar/14 04:55 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 07/Jun/15 10:06 PM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details Wait for reply about issue of 24/Apr/15 04:34 PM.
On WI-T3.0.0.31855 output in STDERR is the same: has NO line
"-CREATE OR ALTER PROCEDURE SP_TEST1B failed"
which can be useful for the search of exact error place.
QA Status Deferred
Pavel Cisar made changes - 22/Sep/15 09:41 AM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 11/Mar/16 04:20 PM
Status Closed [ 6 ] Closed [ 6 ]
Test Details Wait for reply about issue of 24/Apr/15 04:34 PM.
On WI-T3.0.0.31855 output in STDERR is the same: has NO line
"-CREATE OR ALTER PROCEDURE SP_TEST1B failed"
which can be useful for the search of exact error place.
Wait for reply about issue of 24/Apr/15 04:34 PM.
On WI-T3.0.0.31855 output in STDERR is the same: has NO line
"-CREATE OR ALTER PROCEDURE SP_TEST1B failed"
which can be useful for the search of exact error place.

WI-T4.0.0.32393 Firebird 4.0 Unstable: still have no clue about why this ticket considered as fixed.
Name of unknown COLUMN - yes, it's shown; but name of _packaged_ procedure which tries to use it - no, and it was lost comparing to Alpha-2.

WI-T3.0.0.30809:
===
-RECREATE PACKAGE BODY PKG_TEST failed
-CREATE OR ALTER PROCEDURE SP_TEST1B failed <<<<<< THIS WAS LOST <<<
-Dynamic SQL Error
-SQL error code = -206
-Column unknown
===

WI-T4.0.0.32393:
===
-RECREATE PACKAGE BODY PKG_TEST failed
-Dynamic SQL Error
-SQL error code = -206
-Column unknown
-NON_EXISTENT_FIELD
===
Wait for reply on letter to dimitr, 11/mar/2016 19:13