Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the Test-DBIx-Class CPAN distribution.

Report information
The Basics
Id: 63660
Status: resolved
Priority: 0/
Queue: Test-DBIx-Class

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

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



Subject: ORA-00911: invalid character if keep_db disabled
Test::DBIx::Class::SchemaManager executes 'drop table $tablename;' if keep_db is disabled (which is the default). The trailing semicolon generates the following error on Oracle 10g: ORA-00911: invalid character (DBD ERROR: error possibly near <*> indicator at char 21 in 'drop table tablename<*>;') Removing the trailing semicolon fixes it for me and should be ok for every other RDBMS too.
Hi, I don't actually have access to Oracle, so wasn't able to really test this on that platform. Thanks for the bug report and I will check into it. I think this is being generated by SQLT so I might need to dig a bit. I also really need to spend some time looking at how this module is put together to try and improve cross DB support in general. I'll followup when I get some spare cycles (just right now helping the wife with finals) if you see a quick win you can patch the source is over at: https://github.com/jjn1056/Test-DBIx-Class I'm also seriously wondering of the drop table thing by default is really such a good idea. I realize is a bigger change but its a bit dangerous if you are not building a specific test db each time. Your thoughts appreciated! John On Mon Dec 06 08:00:03 2010, ABRAXXA wrote: Show quoted text
> Test::DBIx::Class::SchemaManager executes 'drop table $tablename;' if > keep_db is disabled (which is the default). > The trailing semicolon generates the following error on Oracle 10g: > ORA-00911: invalid character (DBD ERROR: error possibly near <*> > indicator at char 21 in 'drop table tablename<*>;') > > Removing the trailing semicolon fixes it for me and should be ok for > every other RDBMS too.
It's in SchemaManager.pm line 188.
On Mon Dec 06 11:58:04 2010, ABRAXXA wrote: Show quoted text
> It's in SchemaManager.pm line 188.
New release on CPAN, seems good. Please let me know if the bug can be closed.
Sorry for the late reply, it seems to be fixed.