Bug #41736 Connector/J throws on table alias
Submitted: 24 Dec 2008 19:29 Modified: 25 Dec 2008 9:49
Reporter: Paul van Rossem Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:5.1.7 OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: alias, Connector/J, SqlException

[24 Dec 2008 19:29] Paul van Rossem 
Description:
The following query is correctly executed by Connector/J:
SELECT M.Name, L.Name FROM MTable M, LTable L WHERE L.Name = M.Name

while the following query throws an SQLException:
SELECT M.Name FROM MTable M, LTable L WHERE L.Name = M.Name

using useOldAliasMetadataBehavior = true

How to repeat:
see description
[25 Dec 2008 6:42] Sveta Smirnova 
Thank you for the report.

Please provide example of Java code which throws exception
[25 Dec 2008 9:37] Paul van Rossem 
Sveta, thanks, good question. Creating a simple test case showed it to be bug in my code. Sorry.
[25 Dec 2008 9:49] Sveta Smirnova 
Paul,

thank you for the feedback. Closing report as "Not a Bug".