[ https://issues.apache.org/jira/browse/CALCITE-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-5779: ------------------------------------ Labels: pull-request-available (was: ) > Implicit column alias for single-column table function should work > ------------------------------------------------------------------ > > Key: CALCITE-5779 > URL: https://issues.apache.org/jira/browse/CALCITE-5779 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.34.0 > Reporter: Dmitry Sysolyatin > Assignee: Dmitry Sysolyatin > Priority: Major > Labels: pull-request-available > > Implicit column alias for single-column table function works only for UNNEST > at the moment. But should work for every table function. > For example, PostgreSQL: > {code:java} > CREATE OR REPLACE FUNCTION fun() > RETURNS TABLE(col int) > AS > $$ > SELECT 1 > $$ LANGUAGE 'sql' VOLATILE; > SELECT f.col, f FROM fun() as f; > col | f > -----+--- > 1 | 1 > (1 row) > SELECT * FROM fun() as f; > col > ----- > 1 > (1 row) > SELECT f FROM fun() as f; > f > --- > 1 > (1 row){code} > > Calcite throws "Column 'i' not found in any table" exception for > {code:java} > SELECT i FROM table(generate_series(1,2)) as i > {code} > Where generate_series is user defined table function. -- This message was sent by Atlassian Jira (v8.20.10#820010)