Regression: list index does not support with columns #7147
Description
Is your feature request related to a problem or challenge?
Follow on to #6936
When we apply some kind of index to a list presented as a column, then one element is returned to us instead of the proper number.
Example:
❯ select column1, column2, column3 from slices;
+------------------------------------------+---------+---------+
| column1 | column2 | column3 |
+------------------------------------------+---------+---------+
| [, 2, 3, 4, 5, 6, 7, 8, 9, 10] | 1 | 1 |
| [11, 12, 13, 14, 15, 16, 17, 18, , 20] | 2 | -4 |
| [21, 22, 23, , 25, 26, 27, 28, 29, 30] | 0 | 0 |
| [31, 32, 33, 34, 35, , 37, 38, 39, 40] | -4 | -7 |
| | 4 | 5 |
| [41, 42, 43, 44, 45, 46, 47, 48, 49, 50] | | 6 |
| [51, 52, , 54, 55, 56, 57, 58, 59, 60] | 5 | |
+------------------------------------------+---------+---------+
❯ select column1[2] from slices;
+--------------------------+
| slices.column1[Int64(2)] |
+--------------------------+
| 2 |
+--------------------------+
Should be:
❯ select column1[2] from slices;
+-------------------+
| slices.column1[2] |
+-------------------+
| 2 |
| 12 |
| 22 |
| 32 |
| 42 |
| 52 |
+-------------------+
P.S. Struct still supports columns.
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response