-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: distsql does not support labeled tuples #26627
Copy link
Copy link
Closed
Labels
A-sql-executionRelating to SQL execution.Relating to SQL execution.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Description
Found while investigating #26621. Ultimately needed for #16971.
> CREATE TABLE t (a INT, b STRING)
> SELECT (x).a, (x).b
FROM (SELECT (ROW(a, b) AS a, b) AS x FROM t)
ORDER BY 1
LIMIT 1Fails with setting up flow: ("$0").a: type tuple{int, string} is not composite with distribution enabled, succeeds with local execution.
This is related to, but not identical to, #26624. The two issues must be addressed concurrently to ensure labeled tuples are fully supported.
There is a logic test introduced by #26621/#26628 in the tuples logic test that currently force-disables distsql to work. When this issue is addressed, the test must be reenabled (and checked).
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-executionRelating to SQL execution.Relating to SQL execution.C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.