Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Server    [ Add a report in this area ]  
Report #:  111118   Status: Closed
For select statement with field with RDB$ prefix error message not contain this prefix for field
Project:  InterBase Build #:  WI-V10.0.4.590
Version:    10.0 Submitted By:   Karol Bieniaszewski
Report Type:  Basic functionality failure Date Reported:  12/6/2012 4:03:56 AM
Severity:    Commonly encountered problem Last Updated: 4/1/2014 9:43:50 PM
Platform:    Windows 95/98/NT 4.0 on Intel Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : XE3 Update4
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
For select statement with field with RDB$ prefix error message not contain this prefix for field

See steps
Steps to Reproduce:
try on system tables e.g. in IBConsole

SELECT W.RDB$DB_KEY FROM RDB$DATABASE

you get error message


Error at line 1
Dynamic SQL Error
SQL error code = -206
Column unknown
W.DB_KEY <-- here is wrong field name
SQL - SELECT W.RDB$DB_KEY, aaa FROM RDB$DATABASE


now: we got wrong field name "W.DB_KEY"
exp: we got "W.RDB$DB_KEY"


---------------
The following query shows wrong data in IBConsole but shows the correct data when used with ISQL commandline tool: (connect to employee.gdb sample database)
select RDB$DB_KEY, emp_no from employee

Workarounds
None
Attachment
None
Comments

Sriram Balasubramanian at 1/2/2013 2:02:15 PM -
Logged internal in Bug reporting system as JIRA case INTB-1723

Server Response from: ETNACODE01