On Mon, 7 Jan 2008, Patrick Weemeeuw wrote:
So, I don't know whether the find_or_new method should create an embryonic row
that satisfies the conditions of the where clause, or not. In the first case
the where-clause values are copied to the row, in the other case they are
not. And I am certainly not confident enough in SQL semantics to have much of
an opinion what should happen with an undef/NULL value in the where clause.
(I may have chopped too much there, but this was getting long).
There may be a DB where submitting NULL to a NOT NULL field which is
auto-inc does the required thing, but it's not sane, IMO.
Most prefer either "don't supply it" or want "DEFAULT" instead which is
saner and iirc standard.
If the system you are using does this on purpose, take it out and shoot
it.. or fix it.
Jess
_______________________________________________
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]
