MySQL Forums
Forum List  »  Quality Assurance

Re: 5.0.92: USING table alias - fals
Posted by: Nick Baryshnikov
Date: November 11, 2011 02:39AM

But it must be, according to the manual.

http://dev.mysql.com/doc/refman/5.0/en/delete.html

Here we can see
"USING table_references"
, and
"The table_references clause lists the tables involved in the join. Its syntax is described in Section 12.2.8.2, “JOIN Syntax”."

So follow to JOIN Syntax:
http://dev.mysql.com/doc/refman/5.0/en/join.html

"table_references:
table_reference [, table_reference] ...

table_reference:
table_factor
| join_table

table_factor:
tbl_name [[AS] alias] [index_hint]"


So, manual is wrong. Or implementation is wrong. It needs to change smth. Manual or code.


Right now I'm bypass this using Query rewrite technique similar to query rewrite plugin from 5.6. It's an ugly error fix (it just set full table name to all columns in query, if it see USING section), but this error is still present.

Options: ReplyQuote


Subject
Views
Written By
Posted
3455
October 04, 2011 06:52AM
1377
November 10, 2011 09:45PM
Re: 5.0.92: USING table alias - fals
1648
November 11, 2011 02:39AM
1118
November 17, 2011 08:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.