Hi, If I run a simple query with a LIMIT clause, H2 throws a syntax error
E.g. : SELECT * FROM TRADING_MESSAGE LIMIT 50 Syntax error in SQL statement "SELECT * FROM TRADING_MESSAGE LIMIT[*] 50"; SQL statement: <http://10.188.75.45:8082/query.do?jsessionid=675ec9c0f7ca4066430def0417fa7b54#> I'm using the latest version 2.0.206 with a Spring Boot (2.5.6) project. I also use MODE=Oracle. The query is generated by Hibernate, so I have no control on how the limiting clause is implemented. Is there any fix / workaround for this? Thanks a lot. Pierre C. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/2ae01c85-e7c1-46ca-843e-3534317b5821n%40googlegroups.com.
