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

bugs in conversion time to string in prepared statements

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • None
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.