Re: returning incorrect results for select on mysql database

-------- Original Message  --------
Subject: returning incorrect results for select on mysql database
From: pp <[email protected]>
To: [email protected]
Date: Thu Jun 17 2010 09:11:04 GMT+0200 (CEST)

> hi,
> 
> below some trace output of perl script.
> just do not know whether the bug is in DBI, DBD::mysql, DBIx::Class or
> mysql.
> i appreciate  any suggestion if the problem should be reported elsewhere
> 
> issuing query on mysql client console - i got correct results.
> 

solved

combination of DBIx::Class and mysql features
as pointed me out on dbix-class mailing list

 >
 > Meet MySQL:
 > 
http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html#sysvar_sql_auto_is_null 

 >
 >
 > Now meet a saner MySQL:
 > 
http://search.cpan.org/~frew/DBIx-Class-0.08123/lib/DBIx/Class/Storage/DBI/mysql.pm#set_strict_mode 

 >

--
regards
piotr