Hi Dmitry, Yes thank you it works :-)
Do you know if this is reliable to use Lucene in H2? I just had an exception this morning. (from a database created yesterday) [2017-03-01 10:10:41] [HY000][50000] General error: "java.lang.IllegalStateException: Chunk 5451 no longer exists [1.4.193/9]" [50000-193] [2017-03-01 10:10:41] java.lang.IllegalStateException: Chunk 5451 no longer exists [1.4.193/9] [2017-03-01 10:10:41] at org.h2.mvstore.DataUtils. newIllegalStateException(DataUtils.java:765) Best regards, Sylvain On Wed, Mar 1, 2017 at 12:37 PM, Дмитрий Моряков <[email protected]> wrote: > Sylvain, if you are using direct SQL query, you may try smth like that: > SELECT QUERY, SCORE FROM FTL_SEARCH('search string', 1000, 0) ORDER BY > SCORE DESC > where 1000 - number of rows to fetch, 0 - offset > > HTH > > Regards, > -- > Dmitry > > -- > 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 post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
