Skip Menu |

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

Report information
The Basics
Id: 52277
Status: resolved
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: HMBRAND [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: (no value)
Fixed in: 0.11005



Subject: 'commit' is not being translated, but leads to error/crash
$ cat pg.sql create table foo ( c_foo bigint default 0 not null primary key, s_foo varchar (10) default '' ); commit; $ sqlt -f PostgreSQL -t Oracle <pg.sql ERROR (line 5): Invalid statement: Was expecting create, or comment on table, or comment on column, or comment on other, or comment, or alter, or grant, or revoke, or drop, or insert, or connect, or update, or set, or select, or copy, or readin symbol Error: translate: Error with parser 'SQL::Translator::Parser::PostgreSQL': Parse failed. Exit 255
On Mon Nov 30 09:27:42 2009, HMBRAND wrote: Show quoted text
> $ cat pg.sql > create table foo ( > c_foo bigint default 0 not null primary key, > s_foo varchar (10) default '' > ); > commit; > $ sqlt -f PostgreSQL -t Oracle <pg.sql > > ERROR (line 5): Invalid statement: Was expecting create, or > comment on > table, or comment on column, or comment on other, or > comment, or alter, or grant, or revoke, or drop, or > insert, or connect, or update, or set, or select, or > copy, or readin symbol > Error: translate: Error with parser > 'SQL::Translator::Parser::PostgreSQL': Parse failed. > Exit 255
Grammar fixed in trunk.