also test dash table

Rong Rong · Rong Rong · commit ef93fbcd8444 · 2023-10-04T09:24:05.000-07:00
diff --git a/pinot-query-runtime/src/test/resources/queries/SpecialSyntax.json b/pinot-query-runtime/src/test/resources/queries/SpecialSyntax.json
@@ -104,7 +104,7 @@
       },
       {
         "description": "test explicit escape column name used after the with table and sub query",
-        "sql": "WITH \"table\" AS (SELECT * FROM {tbl3} WHERE \"dash-column\" != 'foo') SELECT \"table\".\"dash-column\", COUNT(*) FROM {tbl3} AS tbl LEFT JOIN \"table\" ON tbl.\"dot.column\" = \"table\".\"dot.column\" GROUP BY 1 ORDER BY SUM(\"table\".\"dot.column\")",
+        "sql": "WITH \"t-a-b-l-e\" AS (SELECT * FROM {tbl3} WHERE \"dash-column\" != 'foo') SELECT \"t-a-b-l-e\".\"dash-column\", COUNT(*) FROM {tbl3} AS tbl LEFT JOIN \"t-a-b-l-e\" ON tbl.\"dot.column\" = \"t-a-b-l-e\".\"dot.column\" GROUP BY 1 ORDER BY SUM(\"t-a-b-l-e\".\"dot.column\")",
         "outputs": [
           ["bar", 1],
           [null, 1]

Original file line number	Diff line number	Diff line change
`@@ -104,7 +104,7 @@`
`104`	`104`	`},`
`105`	`105`	`{`
`106`	`106`	`"description": "test explicit escape column name used after the with table and sub query",`
`107`		`- "sql": "WITH \"table\" AS (SELECT * FROM {tbl3} WHERE \"dash-column\" != 'foo') SELECT \"table\".\"dash-column\", COUNT(*) FROM {tbl3} AS tbl LEFT JOIN \"table\" ON tbl.\"dot.column\" = \"table\".\"dot.column\" GROUP BY 1 ORDER BY SUM(\"table\".\"dot.column\")",`
	`107`	`+ "sql": "WITH \"t-a-b-l-e\" AS (SELECT * FROM {tbl3} WHERE \"dash-column\" != 'foo') SELECT \"t-a-b-l-e\".\"dash-column\", COUNT(*) FROM {tbl3} AS tbl LEFT JOIN \"t-a-b-l-e\" ON tbl.\"dot.column\" = \"t-a-b-l-e\".\"dot.column\" GROUP BY 1 ORDER BY SUM(\"t-a-b-l-e\".\"dot.column\")",`
`108`	`108`	`"outputs": [`
`109`	`109`	`["bar", 1],`
`110`	`110`	`[null, 1]`