Re: Quotation

H.Merijn Brand wrote:

Hi Merijn,

> I've hit a failure, which I am not about if it is my fault or that I
> have to blame something else
> 
>   $dbh->do ("drop table $_") for $dbh->tables ();
> 
> Now that DBI returns the tables quoted, I expect that to work.
> 
> DBD::CSV uses the current user name as schema name, so the table list
> looks like
> 
>   $VAR1 = [
>     '"merijn".testaa.csv',
>     '"merijn".testab',
>     '"merijn".testac',
>     '"merijn".testad.txt',
>     '"merijn".testae.csv',
>     ];
> 
> Execution ERROR: Cannot open output/?QI0?.testaa.csv: No such file or directory at /pro/lib/perl5/site_perl/5.10.0/i686-linux-64int/DBD/File.pm line 549
>  called from t/71_csv-ext.t at 72.
> 
> ?QIO?
> Where does that come from? SQL::Statement?
> 
> Should I overload the tables () function and strip the schema part?

I've detected a similar situation during my tests on SQL::Statement this
weekend. I believe it's an error which is coming from SQL::Parser.

I suggest you don't investigate to much finding this error and give me a
chance to finish S::S 1.21 before. I modified the parser a bit and applying
a patch may not as easy as it would otherwise.

/Jens