Commita3c9cce

Thomas G. Lockhart

committed

"select_implicit" is renamed from "junkfilter" test.

Move from last test in list up to other "select_xxx" tests.

1 parent511b368 commita3c9cceCopy full SHA for a3c9cce

File tree

+13

-4

lines changed

+13

-4

lines changed

Lines changed: 12 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,3 +1,11 @@`
	`1`	`+--`
	`2`	`+-- select_implicit.sql`
	`3`	`+--`
	`4`	`+-- Test cases for queries with ordering terms missing from the target list.`
	`5`	`+-- This used to be called "junkfilter.sql".`
	`6`	`+-- The parser uses the term "resjunk" to handle these cases.`
	`7`	`+-- - thomas 1998-07-09`
	`8`	`+`
`1`	`9`	`-- load test data`
`2`	`10`	`CREATETABLEtest_missing_target (aint, bint, cchar(8));`
`3`	`11`	`INSERT INTO test_missing_targetVALUES (0,1,'XXXX');`
`@@ -26,7 +34,8 @@ SELECT count(*) FROM test_missing_target GROUP BY a ORDER BY b;`
`26`	`34`	`SELECTcount(*)FROM test_missing_targetGROUP BY bORDER BY b;`
`27`	`35`
`28`	`36`	`-- w/ existing GROUP BY target using a relation name in target`
`29`		`-SELECTtest_missing_target.b,count(*)FROM test_missing_targetGROUP BY bORDER BY b;`
	`37`	`+SELECTtest_missing_target.b,count(*)`
	`38`	`+FROM test_missing_targetGROUP BY bORDER BY b;`
`30`	`39`
`31`	`40`	`-- w/o existing GROUP BY target`
`32`	`41`	`SELECT cFROM test_missing_targetORDER BY a;`
`@@ -69,6 +78,6 @@ FROM test_missing_target x, test_missing_target y`
`69`	`78`	`SELECT*FROM test_missing_target2;`
`70`	`79`
`71`	`80`	`-- Cleanup`
`72`		`-droptable test_missing_target;`
`73`		`-droptable test_missing_target2;`
	`81`	`+DROPTABLE test_missing_target;`
	`82`	`+DROPTABLE test_missing_target2;`
`74`	`83`

Lines changed: 1 addition & 1 deletion

Comments

(0)