You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The behavior you observe is correct and in compliance with the SQL standard: once a table is given an alias, that alias is the only way to reference the table.
Submitted by: Anderson Franco (anderson.franco)
The folow query runs fine in Firebird 1.5.2 and 1.0.3:
select * from table t where http://table.ID = 1
When you define an alias for the table and you use the table name instead the alias, firebird returns a SQL error code -206: 'Column unkown'
If you don't define an alias or if you use the alias, everyting is ok:
select * from table t where http://t.ID = 1
or
select * from table where http://table.ID = 1
The text was updated successfully, but these errors were encountered: