On Mon, Aug 02, 2004 at 09:40:17PM -0700, Jonathan Leffler wrote:
DBD::Informix 0.95 introduced the internal tables function; no-one
should still be using any earlier versions of DBD::Informix than
1.00.PC1, so the 'sad hack' can go - especially since it actually
doesn't work reliably for Informix anyway.
DBD::Informix 0.95 introduced the internal tables function; no-one
should still be using any earlier versions of DBD::Informix than
1.00.PC1, so the 'sad hack' can go - especially since it actually
doesn't work reliably for Informix anyway.
the confirmation.
I note that the DBI (v1.42 RC1, but I don't think it changed) version
does not handle schema names containing quotes:
CREATE TABLE """""".blanketyblank (...);
This is a valid table called blanketyblank owned by (belonging to
schema) double-quote, double-quote in an ISO-compliant SQL database.
Granted, that's kinda esoteric, but if you're worrying about quoting
stuff just in case, hadn't you better worry about all the cases that
might just occur?
Of course, and it seems to work just fine:does not handle schema names containing quotes:
CREATE TABLE """""".blanketyblank (...);
This is a valid table called blanketyblank owned by (belonging to
schema) double-quote, double-quote in an ISO-compliant SQL database.
Granted, that's kinda esoteric, but if you're worrying about quoting
stuff just in case, hadn't you better worry about all the cases that
might just occur?
$ perl -w -MDBI -e 'warn DBI->connect("dbi:NullP:")->quote_identifier(undef, q{""}, "blanketyblank")'
""""""."blanketyblank" at -e line 1.
Tim.
