[Dbix-class] Development version and DB2

[Peter Rabbitson]

Andreas Mock wrote:
> Hi all,
> 
> I'm new to DBIx::Class and took the current development version
> as I saw that there a some topics fixed since the last stable build.
> I ran the test scripts against a DB2 V9.1.
> 
> While all tests seem fine (if DB2 tests are skipped) I get an error
> when I want to test DB2 functionality.
> 
> I hope this is the right place to post the error and someone can give
> a hint to resolve that problem. At least someone is interested.
> 
> ---------------------------------8<--------------------------------------
> 
> t/745db2...........................................DBIx::Class::ResultSet::next(): DBI Exception: DBD::DB2::st execute failed: [IBM][CLI Driver][
> DB2/LINUXX8664] SQL0007N  The character "_" following "BEGIN-OF-STATEMENT" is not valid.  SQLSTATE=42601
>  [for Statement "_ROWNUMBEROVER SELECT ME.ARTISTID, ME.NAME, ME.RANK, ME.CHARFIELD FROM ARTIST ME (artistid) 3 0"] at t/745db2.t line 42
> # Looks like you planned 6 tests but ran 2.
> # Looks like your test exited with 2 just after 2.
> dubious
>         Test returned status 2 (wstat 512, 0x200)
> DIED. FAILED tests 3-6
>         Failed 4/6 tests, 33.33% okay
> 
> ---------------------------------8<--------------------------------------

Hi Andreas,

We are waiting for another DB2 user of ours to verify this error against
their database. Most likely someone will have ab answer for you tomorrow.
> 
> By the way: Which version of DBIx::Class should I take to start?
> The development or the last stable release?
> 

By all means use the latest dev release if you are just starting. It is
weeks away from entering the rc- cycle, and represents a substantial
improvement over the latest official release.