yql/essentials/tests/sql/suites/expr/as_table_bad_columns_fail.sql


1
2
3
4
5
6
7
8
9
10

/* postgres can not */
/* custom error:Member not found: Value3. Did you mean Value1?*/

$data = AsList(
    AsStruct(1u AS Key, "v1" AS Value1, 100 AS Value2),
    AsStruct(2u AS Key, "v2" AS Value1, 200 AS Value2),
    AsStruct(3u AS Key, "v3" AS Value1, 300 AS Value2));

SELECT Key, Value3 FROM AS_TABLE($data);