I am getting an error when I am trying to use an IN with DBD-CSV. It used to work before, so I don't know what happened. Every since DBD-CSV was installed on a new machine, the statements no longer work.
I currently have version 0.1021 of SQL::Statement installed on Solaris.
That version of SQL::Statement doesn't support the IN predicate.
Below is the output of my test program when I set the trace to 2.
Should I reword this select statement using ORs instead of the IN clause?
Is this a version problem? Should I use SQL::Statement 1.005 or is the XS version okay with DBD::CSV?
The XS version is "okay" but has a different feature set. The pure perl version supports perhaps twice as many SQL features like some joins, IN, BETWEEN, MIN MAX, etc. See this page for a description of differences:
http://www.vpservices.com/jeff/programs/sql-compare.html
-- Jeff
