Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
23.10
-
None
-
None
Description
Declaring a column as SIGNED is not supported. However, by default columns are signed, and specifying them as UNSIGNED works as well. The problem is only the keyword.
MariaDB [test]> CREATE TABLE tab (x INT SIGNED) ENGINE COLUMNSTORE; |
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types. |
Proof that columns are signed by default (correct):
MariaDB [test]> CREATE TABLE tab (x INT) ENGINE COLUMNSTORE; |
Query OK, 0 rows affected (0.128 sec) |
|
|
MariaDB [test]> INSERT INTO tab VALUES (-1); |
Query OK, 1 row affected (0.102 sec)
|
|
|
MariaDB [test]> SELECT * FROM tab; |
+------+ |
| x |
|
+------+ |
| -1 |
|
+------+ |
1 row in set (0.057 sec) |
Proof that UNSIGNED works as expected:
MariaDB [test]> CREATE TABLE tab (x INT UNSIGNED) ENGINE COLUMNSTORE; |
Query OK, 0 rows affected (0.123 sec) |
|
|
MariaDB [test]> INSERT INTO tab VALUES (-1); |
ERROR 1264 (22003): Out of range value for column 'x' at row 1 |