Commit4b87403

committed

Back out ORDER BY addition to Inet, for Tom.

1 parentde97072 commit4b87403Copy full SHA for 4b87403

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -190,15 +190,15 @@ SELECT '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL;`
`190`	`190`	`-- check that index works correctly`
`191`	`191`	`CREATE INDEX inet_idx1 ON inet_tbl(i);`
`192`	`192`	`SET enable_seqscan TO off;`
`193`		`-SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr ORDER BY c,i;`
	`193`	`+SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr;`
`194`	`194`	`c \| i`
`195`	`195`	`----------------+------------------`
`196`	`196`	`192.168.1.0/24 \| 192.168.1.0/25`
`197`	`197`	`192.168.1.0/24 \| 192.168.1.255/25`
`198`	`198`	`192.168.1.0/24 \| 192.168.1.226`
`199`	`199`	`(3 rows)`
`200`	`200`
`201`		`-SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr ORDER BY c,i;`
	`201`	`+SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr;`
`202`	`202`	`c \| i`
`203`	`203`	`----------------+------------------`
`204`	`204`	`192.168.1.0/24 \| 192.168.1.0/24`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -56,8 +56,8 @@ SELECT '' AS ten, set_masklen(inet(text(i)), 24) FROM INET_TBL;`
`56`	`56`	`-- check that index works correctly`
`57`	`57`	`CREATEINDEXinet_idx1ON inet_tbl(i);`
`58`	`58`	`SET enable_seqscan TO off;`
`59`		`-SELECT*FROM inet_tblWHERE i<<'192.168.1.0/24'::cidrORDER BY c,i;`
`60`		`-SELECT*FROM inet_tblWHERE i<<='192.168.1.0/24'::cidrORDER BY c,i;`
	`59`	`+SELECT*FROM inet_tblWHERE i<<'192.168.1.0/24'::cidr;`
	`60`	`+SELECT*FROM inet_tblWHERE i<<='192.168.1.0/24'::cidr;`
`61`	`61`	`SET enable_seqscan TOon;`
`62`	`62`	`DROPINDEX inet_idx1;`
`63`	`63`

Comments

(0)