piotr pogorzelski wrote:
hi,
i've posted today attached mail to dbi-users list, but after
some more inspection i think that maybe this list is more
appropriate.
for query
SELECT me.customer_id, me.company_id, me.person_id, me.customer_position,
me.instance_id FROM customer me WHERE ( me.customer_id IS NULL )
ubuntu
DB<3> p $DBI::VERSION
1.609
DB<4> p $DBD::mysql::VERSION
4.012
DB<5> p $DBIx::Class::VERSION
0.08115
mysql Server version: 5.1.41-3ubuntu12.1-log (Ubuntu)
This is perl, v5.10.1 (*) built for i486-linux-gnu-thread-multi
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
Cheers
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
