Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-189

bugs in conversion time to string in prepared statements

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      Windows, Debug, 32 bit, compiled with VS2015

      Description

      Here is the output of func_time test

      perl mysql-test-run.pl func_time --ps-protocol

      There are 2 problems in this output:

      1. Junk after a string
      -02:30:01.100000 838:59:59.999999
      +02:30:01.100000 838:59:59.999999ýýýý

      2.Extraneous trailing zeros in fraction part, which are not present in mysqlclient

      -2005-05-04 1970-01-01 02:33:25 19700101023325.000000
      -2000-02-23 1970-01-01 02:33:20 19700101023320.000000
      +2005-05-04 1970-01-01 02:33:25.000000 19700101023325.000000
      +2000-02-23 1970-01-01 02:33:20.000000 19700101023320.000000

      The output of the test follows.

      CURRENT_TEST: main.func_time
      — D:/work/server/mysql-test/r/func_time.result 2016-06-02 13:06:36.110880600 +0000
      +++ D:\work\server\mysql-test\r\func_time.reject 2016-06-02 16:20:20.027071200 +0000
      @@ -33,7 +33,7 @@
      -02:30:01.1 -23001.10000 -23001.1 -23001
      select sec_to_time(90011e-1), sec_to_time(1234567890123e30);
      sec_to_time(90011e-1) sec_to_time(1234567890123e30)
      -02:30:01.100000 838:59:59.999999
      +02:30:01.100000 838:59:59.999999ýýýý
      Warnings:
      Warning 1292 Truncated incorrect time value: '1.234567890123e42'
      select sec_to_time(1234567890123), sec_to_time('99999999999999999999999999999');
      @@ -2106,8 +2106,8 @@
      INSERT INTO t1 VALUES ('2005-05-04'),('2000-02-23');
      SELECT a, FROM_UNIXTIME(CONCAT(a,'10')) AS f1, FROM_UNIXTIME(CONCAT(a,'10'))+0 AS f2 FROM t1;
      a f1 f2
      -2005-05-04 1970-01-01 02:33:25 19700101023325.000000
      -2000-02-23 1970-01-01 02:33:20 19700101023320.000000
      +2005-05-04 1970-01-01 02:33:25.000000 19700101023325.000000
      +2000-02-23 1970-01-01 02:33:20.000000 19700101023320.000000

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                georg Georg Richter
                Reporter:
                wlad Vladislav Vaintroub
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: