[Koha-bugs] [Bug 10606] MySQLism in GetUpcomingDueIssues

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10606

Galen Charlton <gmcharlt at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Passed QA                   |Failed QA

--- Comment #10 from Galen Charlton <gmcharlt at gmail.com> ---
The bug 10719 tests do not passed when using MariaDB:

#   Failed test 'Bug 9362: Only one item due in more than 2 days (3 days in
advance)'
#   at t/db_dependent/Circulation.t line 321.
#          got: '0'
#     expected: '1'
not ok 35 - Bug 9362: Only one item due in more than 2 days (4 days in advance)

#   Failed test 'Bug 9362: Only one item due in more than 2 days (4 days in
advance)'
#   at t/db_dependent/Circulation.t line 321.
#          got: '0'
#     expected: '1'
not ok 36 - Bug 9362: Only one item due in more than 2 days (5 days in advance)

#   Failed test 'Bug 9362: Only one item due in more than 2 days (5 days in
advance)'
#   at t/db_dependent/Circulation.t line 321.
#          got: '0'
#     expected: '1'
# Looks like you failed 3 tests of 36.

The DATE() function returns a date, but it looks like DATEDIFF(DATE( date_due
),DATE( NOW() )) works but " DATE( date_due )-DATE( NOW() )" does not.

-- 
You are receiving this mail because:
You are watching all bug changes.