siena icon indicating copy to clipboard operation
siena copied to clipboard

throw MySQLSyntaxErrorException, when execute query join

Open s90198123 opened this issue 14 years ago • 1 comments

Exception Detail

SienaException occured : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 2147483647 OFFSET 0' at line 1

Code

when execute query join

Model.all(Event.class).join("type").fetch()

it throw MySQLSyntaxErrorException and...

Model.all(Event.class).join("type").fetch(10)
Model.all(Event.class).join("type").fetch(0, 10)

wont fix the problem too

ENV Version

MySQL 5.1.49 siena 2.0.5 play 1.2.3

s90198123 avatar Sep 17 '11 07:09 s90198123

Sorry I had forgotten this issue! I'll consider it asap! Thanks Pascal

mandubian avatar Oct 25 '11 15:10 mandubian