[ https://issues.apache.org/jira/browse/SPARK-28296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Takeshi Yamamuro updated SPARK-28296: ------------------------------------- Parent Issue: SPARK-30375 (was: SPARK-27764) > Improved VALUES support > ----------------------- > > Key: SPARK-28296 > URL: https://issues.apache.org/jira/browse/SPARK-28296 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Peter Toth > Priority: Major > > These are valid queries in PostgreSQL, but they don't work in Spark SQL: > {noformat} > values ((select 1)); > values ((select c from test1)); > select (values(c)) from test10; > with cte(foo) as ( values(42) ) values((select foo from cte)); > {noformat} > where test1 and test10: > {noformat} > CREATE TABLE test1 (c INTEGER); > INSERT INTO test1 VALUES(1); > CREATE TABLE test10 (c INTEGER); > INSERT INTO test10 SELECT generate_sequence(1, 10); > {noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org