search

hannes / MonetDBLite

MonetDB reconfigured as a library
108 stars 11 forks source link

Clear sql errors #164

Closed hannes closed 7 years ago

hannes commented 7 years ago

Right now, errors from SQL are not correctly cleared

hannes commented 7 years ago 
dbWriteTable(con, "mtcars", mtcars)
write.csv("/tmp/mtcars", mtcars)
write.csv(mtcars, "/tmp/mtcars")
write.csv(mtcars, "/tmp/mtcars", row.names=F)
dbExecute(con, "copy into mtcars from '/tmp/mtcars' using delimiters ',' locked")
write.table(mtcars, "/tmp/mtcars", row.names=F, col.names=F, sep=",")
dbExecute(con, "copy into mtcars from '/tmp/mtcars' using delimiters ',' locked")

Server says 'ParseException:SQLparser:line 1 field mpg 'double' expected in '"mpg"''. but should work fine

hannes commented 7 years ago

should be fixed