DBD::CSV::db prepare failed when using IN with where clause

[Gino . Pannunzio]

Hi,

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.

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?

TIA

Gino

PS: I hope this is the right address.  First time user.

DBI::db=HASH(0x820adcc) trace level set to 2 in DBI 1.29-nothread
    -> prepare in DBD::File::db for DBD::CSV::db (DBI::db=HASH(0x82ace68)
~0x820a
dcc '
        select refcd, name
        from   user
        where  group in ('ACC', 'MCC', 'CCC')
        and    demo <> 1
        order by refcd
    ')
    <- FETCH= 'DBD::CSV::st' ('ImplementorClass' from cache) at File.pm
line 161
    -> DESTROY in DBD::File::st for DBD::CSV::st (DBI::st=HASH(0x820c50c)
~INNER)
    <- DESTROY= undef at File.pm line 188
    !! ERROR: 1 'Parse error near in ('ACC','MCC','CCC')
        and    demo <> 1
        order by refcd
     at /usr/local/lib/perl5/site_perl/5.6.1/DBD/File.pm line 174.
'
    <- prepare= undef at test.pl line 27
DBD::CSV::db prepare failed: Parse error near in ('ACC')
        and    demo <> 1
        order by refcd
     at /usr/local/lib/perl5/site_perl/5.6.1/DBD/File.pm line 174.
    -> DESTROY in DBD::File::db for DBD::CSV::db (DBI::db=HASH(0x820adcc)
~INNER)
    <- DESTROY= undef