Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 19573
Status: resolved
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: simon [...] simon-cozens.org
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 0.07
Fixed in: (no value)

History Show all quoted text
  Mon May 29 11:24:08 2006 Guest - Ticket created
Subject: Semicolon doesn't *always* end a statement
% echo 'INSERT INTO foo ("bar; baz");' | sqlt -f MySQL -t SQLite ERROR (line 1): Invalid statement: Was expecting comment, or use, or set, or drop, or create, or alter, or insert Error: translate: Error with parser 'SQL::Translator::Parser::MySQL': no results at /usr/local/bin/sqlt line 290, <STDIN> line 1. It thinks that " baz" is the start of a new statement. (It's wrong.) Simon
  Fri Jun 09 10:05:47 2006 cpan [...] desert-island.me.uk - Status changed from 'new' to 'resolved'
  Fri Jun 09 10:07:38 2006 cpan [...] desert-island.me.uk - Correspondence added
I've fixed this in CVS, strictly speaking we don't parse insert statements, but since it's trying to skip them, it's nice if the parser doesnt fall over.. Also applies to trigger body statements, which we do parse, so fixed those too.
  Fri Jun 09 10:07:39 2006 The RT System itself - Status changed from 'resolved' to 'open'
  Wed Jun 14 11:35:34 2006 tom+cpan [...] iplod.net - Correspondence added
FYI, The fix in CVS resolves this bug for me.
  Mon Jul 24 02:55:31 2006 cpan [...] desert-island.me.uk - Status changed from 'open' to 'resolved'