Issue Details (XML | Word | Printable)

Key: CORE-3690
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

Wrong warning message for ambiguous query

Created: 05/Dec/11 01:00 PM   Updated: 23/Apr/13 01:28 PM
Component/s: Engine
Affects Version/s: 3.0 Initial
Fix Version/s: 2.1.5, 2.5.2, 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
Run ambiguous query :

1. at database in 3rd dialect

SQL> select id from t1, t2;
Statement failed, SQLSTATE = 42702
Dynamic SQL Error
-SQL error code = -204
-Ambiguous field name between table T1 and table T2
-ID


2. at database in 1st sql dialect

SQL> select id from t1, t2;
SQL warning code = 204
-<Missing arg #1 - possibly status vector overflow>
-Ambiguous field name between table T1 and table T2

Warning message is obviously wrong.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 05/Dec/11 01:17 PM
The bug was not visible before v3 but wrong code exists in prior versions too