Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
MariaDB [test]> SHOW CREATE TABLE person; |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| Table | Create Table | |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
| person | CREATE TABLE `person` ( |
`name` varchar(100) NOT NULL, |
`surname` varchar(100) DEFAULT NULL |
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci | |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
1 row in set (0.001 sec) |
|
|
MariaDB [test]> SELECT * FROM person; |
+-------------+----------+ |
| name | surname | |
+-------------+----------+ |
| Warren Baby | NULL | |
| Charlie | Parker |
|
| Oscar | Peterson |
|
+-------------+----------+ |
3 rows in set (0.027 sec) |
|
|
MariaDB [test]> SELECT * FROM person WHERE surname <=> 1; |
ERROR 1815 (HY000): Internal error: MCS-2035: An internal error occurred. Check the error log file & contact support. |
Error (Code 1815): Internal error: MCS-2035: An internal error occurred. Check the error log file & contact support. |
Error (Code 1030): Got error 1815 "Unknown error 1815" from storage engine Columnstore |
Apparently the error appears because <=> (null-safe equal) is not supported. And actually other queries work. But if that's the case, I would expect a clear error message.