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.

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, “JOIN Syntax”."

So follow to JOIN Syntax:

table_reference [, table_reference] ...

| join_table

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

Written By
October 04, 2011 06:52AM
November 10, 2011 09:45PM
Re: 5.0.92: USING table alias - fals
November 11, 2011 02:39AM
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.