Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
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;
|
