Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 1.2.4
-
Fix Version/s: 1.2.5
-
Component/s: PrimProc
-
Labels:None
-
Sprint:2019-06
Description
Consider the following table (from misc/bug3669)
create table stringtest (c1 char(10), c2 varchar(10), c3 varchar(6))engine=columnstore;
insert into stringtest values ('abc','cde','abc'), ('cde','abc','cde');
MariaDB [tpch1]> select * from stringtest where c1='abc';
|
+------+------+------+
|
| c1 | c2 | c3 |
|
+------+------+------+
|
| abc | cde | abc |
|
+------+------+------+
|
1 row in set (0.039 sec)
|
|
|
MariaDB [tpch1]> select * from stringtest where c2='abc';
|
Empty set (0.036 sec)
|
|
|
MariaDB [tpch1]> select * from stringtest where c3='abc';
|
+------+------+------+
|
| c1 | c2 | c3 |
|
+------+------+------+
|
| abc | cde | abc |
|
+------+------+------+
|
1 row in set (0.029 sec)
|
In the first, we're using a char field < 7 wide. In the third we're using a varchar field < 7 wide,
but the second is a varchar > 7 and returns nothing.
In Columnstore 1.1, we get:
MariaDB [dhall]> select * from stringtest where c2='abc';
|
+------+------+------+
|
| c1 | c2 | c3 |
|
+------+------+------+
|
| cde | abc | cde |
|
+------+------+------+
|
1 row in set (0.04 sec)
|
