[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-15 Thread Evgenij Ryazanov
Hello. I cannot reproduce this issue with Lucene 7.7.1 and Lucene 8.0.0. I can test 7.7.2 and 8.2.0 too, but I don't think that results will be different. You need to click on the error message to see the complete stack trace, it could describe the situation better. Most likely you don't

[h2] Re: Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-15 Thread Bengui Xie
and if call FTL_CREATE_INDEX with NULL, then got CALL FTL_CREATE_INDEX('PUBLIC', 'TEST',NULL); Error creating or initializing trigger "FTL_TEST" object, class "org.h2.fulltext.FullTextLucene$FullTextTrigger", cause: "java.lang.reflect.InvocationTargetException"; see root cause for details; SQL

[h2] Can't create full text index (H2: v1.4.200 , lucene: v7.7.2 or v8.2.0)

2019-10-15 Thread Bengui Xie
Run scripts below in H2 Console: CREATE ALIAS IF NOT EXISTS FTL_INIT FOR "org.h2.fulltext.FullTextLucene.init"; CALL FTL_INIT(); DROP TABLE IF EXISTS TEST; CREATE TABLE TEST(ID INT PRIMARY KEY, FIRST_NAME VARCHAR, LAST_NAME VARCHAR); CALL FTL_CREATE_INDEX('PUBLIC', 'TEST',

[h2] Re: CSVREAD wrongly names columns

2019-10-15 Thread George Ivanov
Hi Evgenij, could this be fixed please? Thank you! On Wednesday, September 18, 2019 at 7:37:24 PM UTC+3, George Ivanov wrote: > > if you create a table from the following csv using CSVREAD: > > a,a,a,a > ,,, > > The table column names will be > AA1 A11 A111 > > instead of > > A0 A1