TableQuery reports the following error when a data.csv file contains 'unique' as a column name. It appears that this is evaluated as an SQL command by the TableQuery.
near "REAL": syntax error
near "unique": syntax error
[SQL ERROR] no such table: input
Changing the column name 'unique' to something else fixes the issue.
NOTE: ocean.cdb dataset (which shows this issue) has been added to pycinema-testdata repository.
dhrogers
commented
9 months ago
TableQuery reports the following error when a data.csv file contains 'unique' as a column name. It appears that this is evaluated as an SQL command by the TableQuery.
near "REAL": syntax error near "unique": syntax error [SQL ERROR] no such table: input
Changing the column name 'unique' to something else fixes the issue.
NOTE: ocean.cdb dataset (which shows this issue) has been added to pycinema-testdata repository.