[Bug 1099741] New: perl-DBIx-Class-0.08250-3.fc21 FTBFS: failed test: t/resultset/update_delete.t: Correct update-SQL with multicolumn in support

[bugzilla at redhat.com]

https://bugzilla.redhat.com/show_bug.cgi?id=1099741

            Bug ID: 1099741
           Summary: perl-DBIx-Class-0.08250-3.fc21 FTBFS: failed test:
                    t/resultset/update_delete.t: Correct update-SQL with
                    multicolumn in support
           Product: Fedora
           Version: rawhide
         Component: perl-DBIx-Class
          Assignee: iarnell at gmail.com
          Reporter: ppisar at redhat.com
        QA Contact: extras-qa at fedoraproject.org
                CC: iarnell at gmail.com, mmaslano at redhat.com,
                    perl-devel at lists.fedoraproject.org



perl-DBIx-Class-0.08250-3.fc21 fails to build in F21 because of tests:

t/resultset/rowparser_internals.t ................... ok
#   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 = 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 = me.bar AND fourkeys_to_twokeys.f_foo = me.foo AND
fourkeys_to_twokeys.f_goodbye = me.goodbye AND fourkeys_to_twokeys.f_hello =
me.hello ) WHERE ( ( fourkeys_to_twokeys.pilot_sequence != ? AND ( ( bar = ? OR
bar = ? ) AND ( foo = ? OR foo = ? ) AND ( goodbye = ? OR goodbye = ? ) AND (
hello = ? OR hello = ? ) AND sensors != ? ) ) )) ) )
# expected: UPDATE fourkeys
#     SET read_count = 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 = me.bar
#             AND fourkeys_to_twokeys.f_foo = me.foo
#             AND fourkeys_to_twokeys.f_goodbye = me.goodbye
#             AND fourkeys_to_twokeys.f_hello = me.hello
#         WHERE fourkeys_to_twokeys.pilot_sequence != ? AND ( bar = ? OR bar =
? ) AND ( foo = ? OR foo = ? ) AND ( goodbye = ? OR goodbye = ? ) AND ( hello =
? OR hello = ? ) AND sensors != ?
#       )
#     )
#   
# differing in :
# OP [-PAREN] != [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 =
me.bar AND fourkeys_to_twokeys.f_foo = me.foo AND fourkeys_to_twokeys.f_goodbye
= me.goodbye AND fourkeys_to_twokeys.f_hello = me.hello WHERE
fourkeys_to_twokeys.pilot_sequence != ? AND ( bar = ? OR bar = ? ) AND ( foo =
? OR foo = ? ) AND ( goodbye = ? OR goodbye = ? ) AND ( hello = ? OR hello = ?
) AND sensors != ? )
# 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)
Failed 1/32 subtests 

This looks like yet another change in sqlite output (sqlite upgraded from
version 3.8.4.2 to 3.8.4.3).

-- 
You are receiving this mail because:
You are on the CC list for the bug.
Unsubscribe from this bug https://bugzilla.redhat.com/token.cgi?t=i4wNf28sNM&a=cc_unsubscribe