Commit7d8e477

committed

Slightly improved tests

1 parentfc75d07 commit7d8e477Copy full SHA for 7d8e477

File tree

+19

-7

lines changed

+19

-7

lines changed

Lines changed: 6 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,10 +3,10 @@ SET enable_seqscan = OFF;`
`3`	`3`	`SET enable_bitmapscan = OFF;`
`4`	`4`	`SET enable_indexonlyscan = ON;`
`5`	`5`	`EXPLAIN (COSTS OFF) SELECT count(*) FROM spheretmp1b WHERE p <@ scircle '<(1,1),0.3>';`
`6`		`- QUERY PLAN`
`7`		`--------------------------------------------------------`
	`6`	`+QUERY PLAN`
	`7`	`+--------------------------------------------------------`
`8`	`8`	`Aggregate`
`9`		`- -> Index Scan using spoint3_idx on spheretmp1b`
	`9`	`+ -> IndexOnlyScan using spoint3_idx on spheretmp1b`
`10`	`10`	`Index Cond: (p <@ '<(1 , 1) , 0.3>'::scircle)`
`11`	`11`	`(3 rows)`
`12`	`12`
`@@ -17,10 +17,10 @@ EXPLAIN (COSTS OFF) SELECT count(*) FROM spheretmp1b WHERE p <@ scircle '<(1,1),`
`17`	`17`	`(1 row)`
`18`	`18`
`19`	`19`	`EXPLAIN (COSTS OFF) SELECT count(*) FROM spheretmp1b WHERE p = spoint '(3.09 , 1.25)';`
`20`		`- QUERY PLAN`
`21`		`----------------------------------------------------`
	`20`	`+QUERY PLAN`
	`21`	`+--------------------------------------------------------`
`22`	`22`	`Aggregate`
`23`		`- -> Index Scan using spoint3_idx on spheretmp1b`
	`23`	`+ -> IndexOnlyScan using spoint3_idx on spheretmp1b`
`24`	`24`	`Index Cond: (p = '(3.09 , 1.25)'::spoint)`
`25`	`25`	`(3 rows)`
`26`	`26`

Lines changed: 11 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -6,12 +6,22 @@ EXPLAIN (costs off) SELECT p <-> spoint (0.2, 0.3) FROM points ORDER BY 1 LIMIT`
`6`	`6`	`QUERY PLAN`
`7`	`7`	`-------------------------------------------------`
`8`	`8`	`Limit`
`9`		`- -> Index Scan using i on points`
	`9`	`+ -> IndexOnlyScan using i on points`
`10`	`10`	`Order By: (p <-> '(0.2 , 0.3)'::spoint)`
`11`	`11`	`(3 rows)`
`12`	`12`
`13`	`13`	`UPDATE points SET pos = n FROM (SELECT id, row_number() OVER (ORDER BY p <-> spoint (0.2, 0.3)) n FROM points ORDER BY p <-> spoint (0.2, 0.3) LIMIT 10) sel WHERE points.id = sel.id;`
`14`	`14`	`SET enable_indexscan = false;`
	`15`	`+SET enable_indexonlyscan = false;`
	`16`	`+EXPLAIN (costs off) SELECT p <-> spoint (0.2, 0.3) FROM points ORDER BY 1 LIMIT 10;`
	`17`	`+ QUERY PLAN`
	`18`	`+---------------------------------------------------`
	`19`	`+ Limit`
	`20`	`+ -> Sort`
	`21`	`+ Sort Key: ((p <-> '(0.2 , 0.3)'::spoint))`
	`22`	`+ -> Seq Scan on points`
	`23`	`+(4 rows)`
	`24`	`+`
`15`	`25`	`SELECT pos, row_number() OVER (ORDER BY p <-> spoint (0.2, 0.3)) n FROM points ORDER BY p <-> spoint (0.2, 0.3) LIMIT 10;`
`16`	`26`	`pos \| n`
`17`	`27`	`-----+----`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,6 +5,8 @@ SET enable_indexscan = true;`
`5`	`5`	`EXPLAIN (costs off)SELECT p<-> spoint (0.2,0.3)FROM pointsORDER BY1LIMIT10;`
`6`	`6`	`UPDATE pointsSET pos= nFROM (SELECT id, row_number() OVER (ORDER BY p<-> spoint (0.2,0.3)) nFROM pointsORDER BY p<-> spoint (0.2,0.3)LIMIT10) selWHEREpoints.id=sel.id;`
`7`	`7`	`SET enable_indexscan= false;`
	`8`	`+SET enable_indexonlyscan= false;`
	`9`	`+EXPLAIN (costs off)SELECT p<-> spoint (0.2,0.3)FROM pointsORDER BY1LIMIT10;`
`8`	`10`	`SELECT pos, row_number() OVER (ORDER BY p<-> spoint (0.2,0.3)) nFROM pointsORDER BY p<-> spoint (0.2,0.3)LIMIT10;`
`9`	`11`	`DROPTABLE points;`
`10`	`12`

Comments

(0)