Your message dated Fri, 28 Feb 2020 19:09:13 +0000
with message-id <[email protected]>
and subject line Bug#952744: fixed in libdbi-drivers 0.9.0-9
has caused the Debian Bug report #952744,
regarding MySQL tests fail
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
952744: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=952744
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Source: libdbi-drivers
Version: 0.9.0-8
Tags: patch
User: [email protected]
Usertags: origin-ubuntu focal ubuntu-patch

Hi,

I noticed that the test suite during the build is currently failing,
including on the Debian buildds, but this isn't causing the package
built to fail. Regardless, attached is the fix for the failures
themselves.
From ce4d5170dd8ebd179bfbb773b250667f15376e15 Mon Sep 17 00:00:00 2001
From: Robie Basak <[email protected]>
Date: Thu, 27 Feb 2020 15:49:16 +0000
Subject: [PATCH]   * d/p/test_mysql_date_tz.patch: fix MySQL test timezone
 inputs.

---
 debian/patches/series                   |  1 +
 debian/patches/test_mysql_date_tz.patch | 36 +++++++++++++++++++++++++
 2 files changed, 37 insertions(+)
 create mode 100644 debian/patches/test_mysql_date_tz.patch

diff --git a/debian/patches/series b/debian/patches/series
index 975fbf4..b3fb76c 100644
--- a/debian/patches/series
+++ b/debian/patches/series
@@ -8,3 +8,4 @@ freetds-1.0-fix.patch
 pgsql_precision.patch
 mysql-8.0.patch
 test_exception_failure.patch
+test_mysql_date_tz.patch
diff --git a/debian/patches/test_mysql_date_tz.patch b/debian/patches/test_mysql_date_tz.patch
new file mode 100644
index 0000000..c50fcb5
--- /dev/null
+++ b/debian/patches/test_mysql_date_tz.patch
@@ -0,0 +1,36 @@
+Author: Robie Basak <[email protected]>
+Description: fix MySQL test timezone inputs
+ MySQL 8.0 requires the timezone field in a DATETIME input string to
+ have no leading spaces, and does not support a timezone field in the
+ TIME type. Adjust accordingly. The test input time is therefore
+ different as it is not offset by the timezone, so the expected output
+ is also adjusted to match.
+ .
+ It isn't clear if this also applies to older MySQL or MariaDB as the
+ previous test failures weren't failing the build.
+Last-Update: 2020-02-27
+
+--- a/tests/test_dbi.c
++++ b/tests/test_dbi.c
+@@ -253,7 +253,7 @@
+       {"the_binary_quoted_string", 4, 0, 6, 0, .expect_val.string_val = "", 0, ""}, /* string */
+       {"the_binary_escaped_string", 4, 0, 6, 0, .expect_val.string_val = "", 0, ""}, /* string */
+       {"the_datetime", 5, 3, 0, 0, .expect_val.uint_val = 1009843199, 1009843199, "2001-12-31 23:59:59"}, /* DBI_DATETIME_DATE|TIME */
+-      {"the_datetime_tz", 5, 3, 0, 0, .expect_val.uint_val = 1009843199, 1009843199, "2001-12-31 23:59:59"}, /* DBI_DATETIME_DATE|TIME */
++      {"the_datetime_tz", 5, 3, 0, 0, .expect_val.uint_val = 1009879199, 1009879199, "2001-12-31 23:59:59"}, /* DBI_DATETIME_DATE|TIME */
+       {"the_date", 5, 1, 0, 0, .expect_val.uint_val = 1009756800, 1009756800, "2001-12-31 00:00:00"}, /* DBI_DATETIME_DATE */
+       {"the_time", 5, 2, 0, 0, .expect_val.uint_val = 86399, 86399, "1970-01-01 23:59:59"}, /* DBI_DATETIME_TIME */
+       {"the_time_tz", 5, 2, 0, 0, .expect_val.uint_val = 86399, 86399, "1970-01-01 23:59:59"}, /* DBI_DATETIME_TIME */
+@@ -1567,10 +1567,10 @@
+             "'AB\\0C\\\'D',"
+             "'AB\\0C\\\'D',"
+             "'2001-12-31 23:59:59',"
+-            "'2001-12-31 23:59:59 -10:00',"
++            "'2001-12-31 23:59:59-10:00',"
+             "'2001-12-31',"
+             "'23:59:59',"
+-            "'23:59:59-10:00')",
++            "'23:59:59')",
+             numstring);
+    }
+    else if (!strcmp(ptr_cinfo->drivername, "pgsql")) {
-- 
2.25.0

Attachment: signature.asc
Description: PGP signature


--- End Message ---
--- Begin Message ---
Source: libdbi-drivers
Source-Version: 0.9.0-9
Done: Laszlo Boszormenyi (GCS) <[email protected]>

We believe that the bug you reported is fixed in the latest version of
libdbi-drivers, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Laszlo Boszormenyi (GCS) <[email protected]> (supplier of updated libdbi-drivers 
package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Format: 1.8
Date: Fri, 28 Feb 2020 17:08:27 +0000
Source: libdbi-drivers
Architecture: source
Version: 0.9.0-9
Distribution: unstable
Urgency: medium
Maintainer: Laszlo Boszormenyi (GCS) <[email protected]>
Changed-By: Laszlo Boszormenyi (GCS) <[email protected]>
Closes: 952743 952744
Changes:
 libdbi-drivers (0.9.0-9) unstable; urgency=medium
 .
   * Fix MariaDB test failure due to unsupported time zone literals
     (closes: #952744).
 .
   [ Robie Basak <[email protected]> ]
   * d/p/test_exception_failure.patch: make test exceptions fail the test
     suite and thus the build (closes: #952743).
Checksums-Sha1:
 849561a6ba22422d4e6d992653e67bbb4756bf24 2255 libdbi-drivers_0.9.0-9.dsc
 af6462e681c9f02cc78496ab7e04266a994a2c5f 13280 
libdbi-drivers_0.9.0-9.debian.tar.xz
Checksums-Sha256:
 ce1ece0d5b10cf1670450744899280542b1ea8246252b51308b08c28b1146ef5 2255 
libdbi-drivers_0.9.0-9.dsc
 dd773b3289a8a95be49f0e1aeb8c78625074b7cb76b209670265f8e96eee54d0 13280 
libdbi-drivers_0.9.0-9.debian.tar.xz
Files:
 7e70a776187bb9edf48fb001b9964119 2255 libs optional libdbi-drivers_0.9.0-9.dsc
 8903453ee0d341393124824ebdd6c66c 13280 libs optional 
libdbi-drivers_0.9.0-9.debian.tar.xz

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEfYh9yLp7u6e4NeO63OMQ54ZMyL8FAl5ZYPcACgkQ3OMQ54ZM
yL81zhAAozzD/u903irEcY49Gf+/jHuUHHEhm0c9Gvusi7781PI66zQgVu+gzKOo
+76FZO7cmJJwn7LZzN+Ae2/QYT6nS1x78WefHaCs6mCkmtJKfC5pbftszIWcHbwb
wW8AwzffEf5zDanwFoXIGukpenkSrx3w479A+b7pxmCKYibrbOoeFkiDJ3TXBIsT
8mwvkJl3TR59Z0uSWLamXYIkdZHldeidnTH5k0WusJG+jJRN7cczbiWGAM0FNtpm
teQwng4I0+AMJl5yeRy4LhOutVebACBsW/TfSkWPiRIp0xi/VZ6PJGWAM4yAaZtm
MVws5E4Mx/lsZ08R4/mNvLN43hblaPBRcwykv9yUxwLlRofiCZtc898OyOHZ+O7s
R+KY4MJRG5GAhFy/5+TdRK0QlSPKO6wBx/ry9dYw8dBqjPtlGkdcGyTGDMAuGMHf
j8yvq5mgcnbjUKVW+Zz3HbyvDQ/n0vPY2Lj22Iyo+9hxgT5wsQg92PqCUVTHBgiz
tk5Z4sGQQeSdOMsAP4sRo3KVHDhlvj0CbjcItGuNz9XqwD6p8hqJkmTvotXeB6En
Omrh7tHlRHRYPggkrdsnbmU7Fb36hW358tg7Si44S883STDctXxLpUWUsU3Gfla9
pgc58M+yLnapGosaF8yC49WBnkgN2yNsXlcZdnuy8wTPbgldXMM=
=oCBg
-----END PGP SIGNATURE-----

--- End Message ---

Reply via email to