[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-12 Thread Evgenij Ryazanov
I meant caseSensitiveColumnNames=true, of course. -- 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 h2-database+unsubscr...@googlegroups.com. To view this

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-12 Thread George Ivanov
Thank you! On Thursday, September 12, 2019 at 6:34:03 PM UTC+3, Evgenij Ryazanov wrote: > > No, it's not a bug. > > Such behavior is documented, but in obscure way: > https://h2database.com/html/functions.html#csvread > > Use caseSensitiveColumnNames option if you want to preserve case of >

[h2] Re: CSVREAD creates uppercased column names for single word names

2019-09-12 Thread Evgenij Ryazanov
No, it's not a bug. Such behavior is documented, but in obscure way: https://h2database.com/html/functions.html#csvread Use caseSensitiveColumnNames option if you want to preserve case of column names unconditionally. CSVREAD('filename.csv', NULL, 'caseSensitiveColumnNames=false') -- You

[h2] CSVREAD creates uppercased column names for single word names

2019-09-12 Thread George Ivanov
If you use CSVREAD function for the following CSV source: "Col_A","Col B" valA,valB H2 will create the following table: [image: Col_A gets uppercased.png] Why would "Col_A" become "COL_A"? Is that a bug? -- You received this message because you are subscribed to the Google Groups "H2