Commit62d1d23

committed

If SELECT uses index (btree) then ordered results are returned.

1 parentfb100e6 commit62d1d23Copy full SHA for 62d1d23

File tree

+23

-23

lines changed

+23

-23

lines changed

Lines changed: 18 additions & 18 deletions

Original file line number	Diff line number	Diff line change
`@@ -90,26 +90,26 @@ QUERY: ALTER TABLE tenk1 RENAME TO ten_k;`
`90`	`90`	`QUERY: SELECT unique1 FROM ten_k WHERE unique1 < 20;`
`91`	`91`	`unique1`
`92`	`92`	`-------`
`93`		`- 18`
`94`		`- 15`
`95`		`- 4`
`96`		`- 2`
	`93`	`+ 0`
`97`	`94`	`1`
`98`		`- 6`
`99`		`- 14`
`100`		`- 9`
`101`		`- 8`
`102`		`- 5`
	`95`	`+ 2`
`103`	`96`	`3`
`104`		`- 13`
`105`		`- 12`
`106`		`- 19`
`107`		`- 17`
`108`		`- 11`
	`97`	`+ 4`
	`98`	`+ 5`
	`99`	`+ 6`
`109`	`100`	`7`
	`101`	`+ 8`
	`102`	`+ 9`
`110`	`103`	`10`
	`104`	`+ 11`
	`105`	`+ 12`
	`106`	`+ 13`
	`107`	`+ 14`
	`108`	`+ 15`
`111`	`109`	`16`
`112`		`- 0`
	`110`	`+ 17`
	`111`	`+ 18`
	`112`	`+ 19`
`113`	`113`	`(20 rows)`
`114`	`114`
`115`	`115`	`QUERY: SELECT unique2 FROM ten_k WHERE unique2 < 20;`
`@@ -246,10 +246,10 @@ QUERY: ALTER TABLE ten_k RENAME TO tenk1;`
`246`	`246`	`QUERY: SELECT unique1 FROM tenk1 WHERE unique1 < 5;`
`247`	`247`	`unique1`
`248`	`248`	`-------`
`249`		`- 4`
`250`		`- 2`
	`249`	`+ 0`
`251`	`250`	`1`
	`251`	`+ 2`
`252`	`252`	`3`
`253`		`-0`
	`253`	`+4`
`254`	`254`	`(5 rows)`
`255`	`255`

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,15 +1,15 @@`
`1`	`1`	`QUERY: SELECT onek.* WHERE onek.unique1 < 10;`
`2`	`2`	`unique1\|unique2\|two\|four\|ten\|twenty\|hundred\|thousand\|twothousand\|fivethous\|tenthous\|odd\|even\|stringu1\|stringu2\|string4`
`3`	`3`	`-------+-------+---+----+---+------+-------+--------+-----------+---------+--------+---+----+--------+--------+-------`
`4`		`- 6\| 978\| 0\| 2\| 6\| 6\| 6\| 6\| 6\| 6\| 6\| 12\| 13\|GAAAAA \|QLBAAA \|OOOOxx`
`5`	`4`	`0\| 998\| 0\| 0\| 0\| 0\| 0\| 0\| 0\| 0\| 0\| 0\| 1\|AAAAAA \|KMBAAA \|OOOOxx`
	`5`	`+ 1\| 214\| 1\| 1\| 1\| 1\| 1\| 1\| 1\| 1\| 1\| 2\| 3\|BAAAAA \|GIAAAA \|OOOOxx`
	`6`	`+ 2\| 326\| 0\| 2\| 2\| 2\| 2\| 2\| 2\| 2\| 2\| 4\| 5\|CAAAAA \|OMAAAA \|OOOOxx`
	`7`	`+ 3\| 431\| 1\| 3\| 3\| 3\| 3\| 3\| 3\| 3\| 3\| 6\| 7\|DAAAAA \|PQAAAA \|VVVVxx`
`6`	`8`	`4\| 833\| 0\| 0\| 4\| 4\| 4\| 4\| 4\| 4\| 4\| 8\| 9\|EAAAAA \|BGBAAA \|HHHHxx`
	`9`	`+ 5\| 541\| 1\| 1\| 5\| 5\| 5\| 5\| 5\| 5\| 5\| 10\| 11\|FAAAAA \|VUAAAA \|HHHHxx`
	`10`	`+ 6\| 978\| 0\| 2\| 6\| 6\| 6\| 6\| 6\| 6\| 6\| 12\| 13\|GAAAAA \|QLBAAA \|OOOOxx`
`7`	`11`	`7\| 647\| 1\| 3\| 7\| 7\| 7\| 7\| 7\| 7\| 7\| 14\| 15\|HAAAAA \|XYAAAA \|VVVVxx`
`8`	`12`	`8\| 653\| 0\| 0\| 8\| 8\| 8\| 8\| 8\| 8\| 8\| 16\| 17\|IAAAAA \|DZAAAA \|HHHHxx`
`9`		`- 5\| 541\| 1\| 1\| 5\| 5\| 5\| 5\| 5\| 5\| 5\| 10\| 11\|FAAAAA \|VUAAAA \|HHHHxx`
`10`		`- 3\| 431\| 1\| 3\| 3\| 3\| 3\| 3\| 3\| 3\| 3\| 6\| 7\|DAAAAA \|PQAAAA \|VVVVxx`
`11`		`- 2\| 326\| 0\| 2\| 2\| 2\| 2\| 2\| 2\| 2\| 2\| 4\| 5\|CAAAAA \|OMAAAA \|OOOOxx`
`12`		`- 1\| 214\| 1\| 1\| 1\| 1\| 1\| 1\| 1\| 1\| 1\| 2\| 3\|BAAAAA \|GIAAAA \|OOOOxx`
`13`	`13`	`9\| 49\| 1\| 1\| 9\| 9\| 9\| 9\| 9\| 9\| 9\| 18\| 19\|JAAAAA \|XBAAAA \|HHHHxx`
`14`	`14`	`(10 rows)`
`15`	`15`

Comments

(0)