Re: Can calcite translate Oracle SQL to MySQL

[Julian Hyde]

In general, yes. But I don't think there's any code to handle Oracle's
ROWNUM system column. Please log a jira case requesting to translate
ROWNUM.

Cases https://issues.apache.org/jira/browse/CALCITE-5723 and
https://issues.apache.org/jira/browse/CALCITE-1786 are related, but
not what you are asking for.

On Fri, Nov 24, 2023 at 12:40 AM Louis Hust <louis.h...@gmail.com> wrote:
>
> Hi all,
>
> Can calcite translate oracle sql to mysql ?
>
> Such as oracle: select * from t1 whre rownum < 10
> To  mysql: select * from t1 limit 9;