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
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
,
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
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
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
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