Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
The set of SQL functions for dynamic columns is missing a way to query the metadata of a dynamic column. Like, what type a particular column has, number of columns, and so on. There can also be a function to return both the value and a type as an SQL-compatible cast:
SELECT COLUMN_GET_SQL(dyncol, 'a') FROM t1;
|
+-------------------------------+
|
| COLUMN_GET_SQL(dyncol, 'a') |
|
+-------------------------------+
|
| CAST(123.45 AS DECIMAL(10,2)) |
|
+-------------------------------+
|
