Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
23.10.0
-
None
-
None
Description
> CREATE TABLE number ( |
-> n INT, |
-> n2 BIGINT DEFAULT (n * n) |
-> ) 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. |
The above failt because the DEFAULT clause is not a constant value. This is supported by all engines, so my primary hope is that you can make it work with ColumnStore easily.
But if this isn't possible, I ask you to produce a more specific error message. That error can have too many causes, so it's not helpful.