Bug #12451 | ODBC error: [MySQL][ODBC 3.51 Driver] - Error in SQL syntax near INNER JOIN | ||
---|---|---|---|
Submitted: | 9 Aug 2005 4:57 | Modified: | 21 Mar 2007 10:41 |
Reporter: | Raffi T K | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
Version: | 3.51 | OS: | |
Assigned to: | CPU Architecture: | Any |
[9 Aug 2005 4:57]
Raffi T K
[21 Mar 2007 10:41]
Tonci Grgin
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ Explanation: Hi Raffi and thanks for your report. We appologize for the delay, somehow this report got neglected... Please upgrade to MyODBC 3.51.14: - MySQL server 5.0.38BK on WinXP Pro SP2 localhost - MyODBC 3.51.14GA - CR 11.0.0.895 --Test-- SELECT distinct t1.Artikl, t2.Datum FROM iradobra AS t1 INNER JOIN ira AS t2 ON t1.Ira = t2.Ira AND t1.Godina = t2.Godina AND t1.Tip = t2.Tip returning about 120000 rows with no problem.