1064 Syntax Error AFTER query results are returned
Hello,
Since today i get strange behaviour on MySQL (after operating flawlessly for 4 years!).
I get the 'ERROR 1064 (42000): You have an error in your SQL syntax;' after the results are returned. The query is generated by hibernate and uses table aliasses. If i remove the table alias the query works fine.
Actually there are 3 outcomes:
Without table alias - records returned;
With table alias and with spacing like 'WHERE table_alias.column = value' - records returned + 1064 error;
With table alias and withoud spacing like 'WHERE table_alias.column=value' (how Hibernate generates it) - no records returned only 1064 error.
The specific column is int(2) type and it occurs on two servers with both MySQL 4.1.7. I did an analyz table with OK result (actually it contains only 2000 records).
I will upgrade to 4.1.9 on one machine, but does anybody has an explanation (solution??) for this problem? (lol and not like: 'rewrite the query without alias')
Jaap
Subject
Written By
Posted
1064 Syntax Error AFTER query results are returned
February 15, 2005 05:13AM
February 15, 2005 05:29AM
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.