[GitHub] [spark] peter-toth commented on pull request #34693: [SPARK-37259][SQL] Support CTE queries with MSSQL JDBC

2021-11-24 Thread GitBox
peter-toth commented on pull request #34693: URL: https://github.com/apache/spark/pull/34693#issuecomment-977671500 > > This change also seem to work with MSSQL's temp table syntax: > > ``` > > val withClause = "(SELECT * INTO #TempTable FROM (SELECT * FROM tbl WHERE x > 10) t)" >

[GitHub] [spark] peter-toth commented on pull request #34693: [SPARK-37259][SQL] Support CTE queries with MSSQL JDBC

2021-11-23 Thread GitBox
peter-toth commented on pull request #34693: URL: https://github.com/apache/spark/pull/34693#issuecomment-976828400 Hmm, failures in `ExpressionsSchemaSuite` look unrelated... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub a

[GitHub] [spark] peter-toth commented on pull request #34693: [SPARK-37259][SQL] Support CTE queries with MSSQL JDBC

2021-11-23 Thread GitBox
peter-toth commented on pull request #34693: URL: https://github.com/apache/spark/pull/34693#issuecomment-97672 This change also seem to work with MSSQL's temp table syntax: ``` val withClause = "(SELECT * INTO #TempTable FROM (SELECT * FROM tbl) t)" val query = "SELECT * FROM #