Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-351

logical or resolves to null for some negative cases

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Fixed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: Icebox
    • Component/s: DMLProc
    • Labels:
      None

      Description

      under certain circumstances seems to be based on negative input values, logical or returns null rather than a value, to repro:

      mcsmysql> create table test (i1 int) engine=columnstore;
      sh> seq -126 127 > numbers.txt
      sh> usr/local/mariadb/columnstore/bin/cpimport test test /home/david/numbers.txt
      mcsmysql> select i1, 126 | i1 from test;
      

      You'll see that for every other negative number the expression is null. In myisam it returns a large double number. This can be tested using similar table and an LDI to load the data:

       create table test_isam (i1 int);
      load data infile '/home/david/numbers.txt' into table test_isam;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              LinuxJedi Andrew Hutchings
              Reporter:
              dthompson David Thompson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: