Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.0.4
    • ExeMgr
    • None
    • 2016-19

    Description

      There is a bug in this test COT(0) is not valid in MariaDB.

      I'm unsure what the original test is testing for so don't know the best way to alter this.

      Attachments

        Issue Links

          Activity

            LinuxJedi Is the test suite fixed ? If not let us fix it and close it

            dshjoshi Dipti Joshi (Inactive) added a comment - LinuxJedi Is the test suite fixed ? If not let us fix it and close it

            not yet, it was flagged in my MCOL-25 test as something that needed fixing too

            LinuxJedi Andrew Hutchings (Inactive) added a comment - not yet, it was flagged in my MCOL-25 test as something that needed fixing too

            With infinidb: 5.1.73-log InfiniDB 4.6.7-1 cot(0) gets mapped to null regardless of storage engine.

            With latest build columnstore: 10.1.17-MariaDB Columnstore 1.0.4-1, innodb returns an out of range error:
            MariaDB [test]> select id, cot(id) from testi;
            ERROR 1690 (22003): DOUBLE value is out of range in 'cot(`test`.`testi`.`id`)'
            MariaDB [test]>

            While columnstore continues to return null.

            cot(0) is invalid as it is basically a divide by zero so this should also return an error in column store.

            dthompson David Thompson (Inactive) added a comment - With infinidb: 5.1.73-log InfiniDB 4.6.7-1 cot(0) gets mapped to null regardless of storage engine. With latest build columnstore: 10.1.17-MariaDB Columnstore 1.0.4-1, innodb returns an out of range error: MariaDB [test] > select id, cot(id) from testi; ERROR 1690 (22003): DOUBLE value is out of range in 'cot(`test`.`testi`.`id`)' MariaDB [test] > While columnstore continues to return null. cot(0) is invalid as it is basically a divide by zero so this should also return an error in column store.

            Good catch. If you explicitly use '0' (as the test did) it errors. If it is a column value it returns NULL.

            LinuxJedi Andrew Hutchings (Inactive) added a comment - Good catch. If you explicitly use '0' (as the test did) it errors. If it is a column value it returns NULL.

            This one will probably need a test which isn't in test001 (because the error will cause a test failure).

            Note: the COT(0) test has been remove from bug2954.sql as it wasn't using ColumnStore's COT() function.

            LinuxJedi Andrew Hutchings (Inactive) added a comment - This one will probably need a test which isn't in test001 (because the error will cause a test failure). Note: the COT(0) test has been remove from bug2954.sql as it wasn't using ColumnStore's COT() function.

            Build verified: a1.0.4-1
            Name : mariadb-columnstore-platform
            Version : 1.0.4
            Release : 1
            Architecture: x86_64
            Install Date: Tue 04 Oct 2016 01:38:36 PM CDT
            Group : Applications/Databases
            Size : 11506458
            License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
            Signature : (none)
            Source RPM : mariadb-columnstore-platform-1.0.4-1.src.rpm
            Build Date : Fri 30 Sep 2016 01:02:40 PM CDT

            MariaDB [mytest]> select cinteger, cot(cinteger), cdecimal4_2,cot(cdecimal4_2) from datatypetestm;
            -------------------------------------------------------------+

            cinteger cot(cinteger) cdecimal4_2 cot(cdecimal4_2)

            -------------------------------------------------------------+

            -7483646 0.020422500667387287 -9.99 -1.5766699751727788
            -7483645 -1.489606558993944 -9.98 -1.6120884706877217
            -7483644 2.3084757344691176 -9.97 -1.6486676714540076
            -7483643 0.16344485736121295 -9.96 -1.6864732712600456
            -7483642 -1.1111255449286084 -9.95 -1.7255759518954368
            7483643 -0.16344485736121295 9.95 1.7255759518954368
            7483644 -2.3084757344691176 9.96 1.6864732712600456
            7483645 1.489606558993944 9.97 1.6486676714540076
            7483646 -0.020422500667387287 9.98 1.6120884706877217
            7483647 -1.6296635659290382 9.99 1.5766699751727788
            0 NULL 0.00 NULL

            -------------------------------------------------------------+
            11 rows in set (0.04 sec)

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: a1.0.4-1 Name : mariadb-columnstore-platform Version : 1.0.4 Release : 1 Architecture: x86_64 Install Date: Tue 04 Oct 2016 01:38:36 PM CDT Group : Applications/Databases Size : 11506458 License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details. Signature : (none) Source RPM : mariadb-columnstore-platform-1.0.4-1.src.rpm Build Date : Fri 30 Sep 2016 01:02:40 PM CDT MariaDB [mytest] > select cinteger, cot(cinteger), cdecimal4_2,cot(cdecimal4_2) from datatypetestm; --------- --------------------- ----------- --------------------+ cinteger cot(cinteger) cdecimal4_2 cot(cdecimal4_2) --------- --------------------- ----------- --------------------+ -7483646 0.020422500667387287 -9.99 -1.5766699751727788 -7483645 -1.489606558993944 -9.98 -1.6120884706877217 -7483644 2.3084757344691176 -9.97 -1.6486676714540076 -7483643 0.16344485736121295 -9.96 -1.6864732712600456 -7483642 -1.1111255449286084 -9.95 -1.7255759518954368 7483643 -0.16344485736121295 9.95 1.7255759518954368 7483644 -2.3084757344691176 9.96 1.6864732712600456 7483645 1.489606558993944 9.97 1.6486676714540076 7483646 -0.020422500667387287 9.98 1.6120884706877217 7483647 -1.6296635659290382 9.99 1.5766699751727788 0 NULL 0.00 NULL --------- --------------------- ----------- --------------------+ 11 rows in set (0.04 sec)

            People

              dleeyh Daniel Lee (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.