[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
as an alternative to
And
as an alternative to
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. |