On Tue, Jan 13, 2004 at 10:13:44AM -0800, Randal L. Schwartz wrote: > > Tim> On Mon, Jan 12, 2004 at 04:00:28PM -0800, Randal L. Schwartz wrote: > >> > >> Is there any way to enter a "/" that's part of the SQL, > >> and not taken as a delimiter? > >> > >> I'm staring at the parsing of the command string, and it appears > >> to accept "\/", except it doesn't rip that \ out, so then I end > >> up with SQL that looks like \/, which the SQL parser doesn't like. > >> > >> Am I just not seeing something, or is this a bug? > > Tim> Sounds like a bug. Are you using the DBI::Shell that comes with the DBI > Tim> or the (much improved) one from CPAN? > > I'm using: > > cpan> m DBI::Shell > Module id = DBI::Shell > CPAN_USERID TLOWERY (Thomas A. Lowery <[EMAIL PROTECTED]>) > CPAN_VERSION 11.93 > CPAN_FILE T/TL/TLOWERY/DBI-Shell-11.93.tar.gz > MANPAGE DBI::Shell - Interactive command shell for the DBI > INST_FILE /opt/perl/snap/lib/site_perl/5.8.3/DBI/Shell.pm > INST_VERSION 11.93 > > It looks like there's code in there that *tries* to get > the slashing right, by permitting a backslash, but I haven't > traced down why it's not doing the right thing. It seems to keep > handing the backslash to the SQL parser, which is wrong. > > I post here because I want to know if anyone else has seen this behavior, > or if it's just me. :)
I guess slashes in SQL are rare. You know how the story goes from here: send a patch... Tim.
