Details
-
Type:
Bug
-
Status: Closed (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;
|