[Dbix-class] Fwd: Problem with DBIx::class

Roger Day c.roger.day at gmail.com
Thu Jan 23 08:39:32 GMT 2014


Hi,

I'm trying to build the tests on Redhat Centos 4. Downloaded all the
components via cpanm, and it fails at t/resultset/update_delete.t

Google turned up nothing for me.

Before I don the diving goggles, any clues as to where to start looking
would be much appreciated.

t/resultset/update_delete.t ......................... 1/?
#   Failed test 'Correct update-SQL with multicolumn in support'
#   at t/resultset/update_delete.t line 122.
# SQL expressions differ
#      got: UPDATE fourkeys SET read_count =3D read_count + 1 WHERE ( ( foo,
bar, hello, goodbye ) IN ( (SELECT me.foo, me.bar, me.hello, me.goodbye
FROM fourkeys me LEFT JOIN fourkeys_to_twokeys fourkeys_to_twokeys ON (
fourkeys_to_twokeys.f_bar =3D me.bar AND fourkeys_to_twokeys.f_foo =3D me.f=
oo
AND fourkeys_to_twokeys.f_goodbye =3D me.goodbye AND
fourkeys_to_twokeys.f_hello =3D me.hello ) WHERE ( (
fourkeys_to_twokeys.pilot_sequence !=3D ? AND ( ( bar =3D ? OR bar =3D ? ) =
AND (
foo =3D ? OR foo =3D ? ) AND ( goodbye =3D ? OR goodbye =3D ? ) AND ( hello=
 =3D ? OR
hello =3D ? ) AND sensors !=3D ? ) ) )) ) )
# expected: UPDATE fourkeys
#     SET read_count =3D read_count + 1
#     WHERE (
#       (foo, bar, hello, goodbye) IN (
#         SELECT me.foo, me.bar, me.hello, me.goodbye
#           FROM fourkeys me
#           LEFT JOIN fourkeys_to_twokeys fourkeys_to_twokeys ON
#                 fourkeys_to_twokeys.f_bar =3D me.bar
#             AND fourkeys_to_twokeys.f_foo =3D me.foo
#             AND fourkeys_to_twokeys.f_goodbye =3D me.goodbye
#             AND fourkeys_to_twokeys.f_hello =3D me.hello
#         WHERE fourkeys_to_twokeys.pilot_sequence !=3D ? AND ( bar =3D ? OR
bar =3D ? ) AND ( foo =3D ? OR foo =3D ? ) AND ( goodbye =3D ? OR goodbye =
=3D ? ) AND
( hello =3D ? OR hello =3D ? ) AND sensors !=3D ?
#       )
#     )
#
# differing in :
# OP [-PAREN] !=3D [SELECT] in
# left: ( SELECT me.foo, me.bar, me.hello, me.goodbye FROM fourkeys me LEFT
JOIN fourkeys_to_twokeys fourkeys_to_twokeys ON fourkeys_to_twokeys.f_bar =
=3D
me.bar AND fourkeys_to_twokeys.f_foo =3D me.foo AND
fourkeys_to_twokeys.f_goodbye =3D me.goodbye AND fourkeys_to_twokeys.f_hello
=3D me.hello WHERE fourkeys_to_twokeys.pilot_sequence !=3D ? AND ( bar =3D =
? OR
bar =3D ? ) AND ( foo =3D ? OR foo =3D ? ) AND ( goodbye =3D ? OR goodbye =
=3D ? ) AND
( hello =3D ? OR hello =3D ? ) AND sensors !=3D ? )
# right: SELECT me.foo, me.bar, me.hello, me.goodbye
#
# Looks like you failed 1 test of 32.
t/resultset/update_delete.t ......................... Dubious, test
returned 1 (wstat 256, 0x100)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20140123/a35=
857db/attachment.htm


More information about the DBIx-Class mailing list