[Sqlite] render SQL, limit ? offset ?

[Pay Liu]

Hi,

I'm using jooq 3.1.0. to render SQL, the code is as below,

when I use limit (offset, numberOfRow) or offest(), 

the output SQL have params mark "?", 

Is it normal behavior? 
I expect to get the sql is "select * from zmenu limit 1 offset 0" 

Thanks!



DSLContext create = DSL.using(SQLDialect.SQLITE);
> String  sql = create.select(ZMENU.VERSION)
> .from(ZMENU)
> .limit(1)
> .getSQL();


sql: 
> select zmenu.version from zmenu limit ? offset ?


-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jooq-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.