Commit8076c8c

committed

Come to think of it, we should check that commutator pairs have the same

merges/hashes property settings.

1 parentb259924 commit8076c8cCopy full SHA for 8076c8c

File tree

+18

-0

lines changed

+18

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -382,6 +382,16 @@ WHERE (p1.oprcanmerge OR p1.oprcanhash) AND NOT`
`382`	`382`	`-----+---------`
`383`	`383`	`(0 rows)`
`384`	`384`
	`385`	`+-- What's more, the commutator had better be mergejoinable/hashjoinable too.`
	`386`	`+SELECT p1.oid, p1.oprname, p2.oid, p2.oprname`
	`387`	`+FROM pg_operator AS p1, pg_operator AS p2`
	`388`	`+WHERE p1.oprcom = p2.oid AND`
	`389`	`+ (p1.oprcanmerge != p2.oprcanmerge OR`
	`390`	`+ p1.oprcanhash != p2.oprcanhash);`
	`391`	`+ oid \| oprname \| oid \| oprname`
	`392`	`+-----+---------+-----+---------`
	`393`	`+(0 rows)`
	`394`	`+`
`385`	`395`	`-- Mergejoinable operators should appear as equality members of btree index`
`386`	`396`	`-- opfamilies.`
`387`	`397`	`SELECT p1.oid, p1.oprname`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -315,6 +315,14 @@ SELECT p1.oid, p1.oprname FROM pg_operator AS p1`
`315`	`315`	`WHERE (p1.oprcanmergeORp1.oprcanhash)AND NOT`
`316`	`316`	`(p1.oprkind='b'ANDp1.oprresult='bool'::regtypeANDp1.oprcom!=0);`
`317`	`317`
	`318`	`+-- What's more, the commutator had better be mergejoinable/hashjoinable too.`
	`319`	`+`
	`320`	`+SELECTp1.oid,p1.oprname,p2.oid,p2.oprname`
	`321`	`+FROM pg_operatorAS p1, pg_operatorAS p2`
	`322`	`+WHEREp1.oprcom=p2.oidAND`
	`323`	`+ (p1.oprcanmerge!=p2.oprcanmergeOR`
	`324`	`+p1.oprcanhash!=p2.oprcanhash);`
	`325`	`+`
`318`	`326`	`-- Mergejoinable operators should appear as equality members of btree index`
`319`	`327`	`-- opfamilies.`
`320`	`328`

Comments

(0)