Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
None
Description
Build tested: develop branch
This issue is discovered while testing MCOL-5519, which sets the following in the columnstore.cnf file.
collation_server = utf8_general_ci
|
character_set_server = utf8
|
The following development regression test case failed:
working_tpch1_compareLogOnly/misc/bug4594.sql
MariaDB [tpch1]> create table if not exists bug4594(c1 char(5))engine=columnstore;
|
Query OK, 0 rows affected (0.330 sec)
|
|
|
MariaDB [tpch1]> insert into bug4594 values ('abc'), ('def');
|
Query OK, 2 rows affected (0.313 sec)
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [tpch1]> select * from bug4594;
|
+------+
|
| c1 |
|
+------+
|
| abc |
|
| def |
|
+------+
|
2 rows in set (0.044 sec)
|
|
|
MariaDB [tpch1]> select calshowpartitionsbyvalue('bug4594', 'c1', 'aa', 'zz') into @y;
|
ERROR 1815 (HY000): Internal error: MCS-1016: The column type CHAR(15) is currently not supported in calShowPartitionsByValue function.
|
The same test case worked fine when charset and collation are set to latin1.