Hi,
I found a case where CSVREAD() present a rare behavior when used as
source of create table.
The first fieldname is created quoted by " , and the rest of fieldnames
don't.
CREATE TABLE IF NOT EXISTS TESTT as ( SELECT * FROM CSVREAD(
'~/test.csv' , null, 'UTF-8') );
select * from testt;
*"PAYROLLID" * EMPLOYEEID FULLNAME CENTRO_COSTOS_R3 PERCENT
1 000005 TOM JONES xy30006202 100.0
regards,
Dario
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
"PAYROLLID","EMPLOYEEID","FULLNAME","CENTRO_COSTOS_R3","PERCENT"
"1","000005","TOM JONES","xy30006202","100.0"
