[MDEV-7606] better support for nested dynamic columns Created: 2015-02-18  Updated: 2015-02-18

Status: Open
Project: MariaDB Server
Component/s: Dynamic Columns
Fix Version/s: None

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None


 Description   

Judging from questions on #maria channel, nested dynamic columns seem to be fairly popular. But editing a column value few levels deep is very awkward. Extracting is a bit better but still inconvenient.

It would be good to have COLUMN_GET and COLUMN_ADD variants for nested dynamic columns. For example

SELECT COLUMN_GET(blob, a, b, c AS type);

as an alternative to

SELECT COLUMN_GET(COLUMN_GET(COLUMN_GET(blob, a AS blob), b AS blob), c AS type);

And

SELECT COLUMN_ADD(blob, a, b, c, value);

as an alternative to

SELECT COLUMN_ADD(blob, a, COLUMN_ADD(COLUMN_GET(blob, a AS blob), b, COLUMN_ADD(COLUMN_GET(COLUMN_GET(blob, a AS blob), b AS blob), c, value)));

Note the syntax is just an example. It's probably not possible implement it as written above (might conflict with the existing COLUMN_ADD syntax).



 Comments   
Comment by Daniel Lopez [ 2015-02-18 ]

COLUMN_ADD & COLUMN_DELETE are quite cumbersome when the nest starts getting past 2 levels. Besides the lack of documentation for nested data. To wrap your head around the logic using COLUMN_GET to maneuver through the dynamic columns can get very complex, very quickly.

Generated at Thu Feb 08 07:20:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.