-------- Original Message --------
Subject: returning incorrect results for select on mysql database
From: pp <p...@webtel.pl>
To: dbi-users@perl.org
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
