Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.2.4
-
None
-
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)
|