[h2] CSVREAD wrongly names columns

2019-09-18 Thread George Ivanov
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 A2 A3 I think, there is a bug in makeColumnNamesUnique() function of Csv.java -- You received this message because you are subscribed to the

[h2] Re: CSVREAD looses column (1.4.196)

2019-09-18 Thread George Ivanov
OK, the problem is that when readValue() does: while (true) { int ch = readChar(); it gets first ch == fieldSeparatorRead ... I think, the right way of fixing would be somehow escaping "empty" values with "" before that point. So, that when you read buffer, it would read ,

[h2] Re: Can CSVREAD use direct data as argument?

2019-09-18 Thread Evgenij Ryazanov
That's not supported. You can create an own user-defined function and use Csv.read(Reader, String[]) in it as a workaround, but if you'll do so, you will need to check compatibility of your code with next versions of H2 before an upgrade. -- You received this message because you are

[h2] Re: CSVREAD looses column (1.4.196)

2019-09-18 Thread Evgenij Ryazanov
Sorry, it isn't fixed yet. Of course, you may submit a pull request with a fix if you wish. The relevant code is in org.h2.tools.Csv. -- 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

[h2] Can CSVREAD use direct data as argument?

2019-09-18 Thread George Ivanov
Hi All, is there a way to feed CSV string data to CSVREAD function directly (i.e. without using any files)? George -- 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

[h2] Re: CSVREAD looses column (1.4.196)

2019-09-18 Thread George Ivanov
Hi Evgenij, could you confirm which version of H2 will have this bug fixed, please? Thank you! George On Thursday, August 8, 2019 at 7:46:00 PM UTC+3, George Ivanov wrote: > > Is the same bug present in the latest H2 release? > > On Thursday, August 8, 2019 at 7:01:48 PM UTC+3, George Ivanov