NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commita45272b

committed

Extend the geometric regression test cases a little.

Add another edge-case value to "point_tbl", and add a test forthe line(point, point) function.Some of the behaviors exposed here are wrong, but the idea ofcommitting this separately is to memorialize what we were getting,and to allow easier inspection of the behavior changes caused byupcoming patches.Kyotaro Horiguchi (line() test added by me)Discussion:https://postgr.es/m/CAGf+fX70rWFOk5cd00uMfa__0yP+vtQg5ck7c2Onb-Yczp0URA@mail.gmail.com

1 parent878f3a1 commita45272bCopy full SHA for a45272b

File tree

5 files changed

+453

-83

lines changed

src/test/regress
- expected
- sql
  - geometry.sql
  - point.sql

5 files changed

+453

-83

lines changed

`‎src/test/regress/expected/create_index.out`

Lines changed: 13 additions & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -157,7 +157,7 @@ SELECT count(*) FROM point_tbl p WHERE p.f1 << '(0.0, 0.0)';`
`157`	`157`	`SELECT count(*) FROM point_tbl p WHERE p.f1 >> '(0.0, 0.0)';`
`158`	`158`	`count`
`159`	`159`	`-------`
`160`		`-3`
	`160`	`+4`
`161`	`161`	`(1 row)`
`162`	`162`
`163`	`163`	`SELECT count(*) FROM point_tbl p WHERE p.f1 <^ '(0.0, 0.0)';`
`@@ -169,7 +169,7 @@ SELECT count(*) FROM point_tbl p WHERE p.f1 <^ '(0.0, 0.0)';`
`169`	`169`	`SELECT count(*) FROM point_tbl p WHERE p.f1 >^ '(0.0, 0.0)';`
`170`	`170`	`count`
`171`	`171`	`-------`
`172`		`-4`
	`172`	`+5`
`173`	`173`	`(1 row)`
`174`	`174`
`175`	`175`	`SELECT count(*) FROM point_tbl p WHERE p.f1 ~= '(-5, -12)';`
`@@ -188,10 +188,11 @@ SELECT * FROM point_tbl ORDER BY f1 <-> '0,1';`
`188`	`188`	`(10,10)`
`189`	`189`	`(-5,-12)`
`190`	`190`	`(5.1,34.5)`
	`191`	`+ (Infinity,1e+300)`
`191`	`192`	`(1e+300,Infinity)`
`192`	`193`	`(NaN,NaN)`
`193`	`194`
`194`		`-(10 rows)`
	`195`	`+(11 rows)`
`195`	`196`
`196`	`197`	`SELECT * FROM point_tbl WHERE f1 IS NULL;`
`197`	`198`	`f1`
`@@ -202,16 +203,17 @@ SELECT * FROM point_tbl WHERE f1 IS NULL;`
`202`	`203`	`SELECT * FROM point_tbl WHERE f1 IS NOT NULL ORDER BY f1 <-> '0,1';`
`203`	`204`	`f1`
`204`	`205`	`-------------------`
`205`		`- (1e-300,-1e-300)`
`206`	`206`	`(0,0)`
	`207`	`+ (1e-300,-1e-300)`
`207`	`208`	`(-3,4)`
`208`	`209`	`(-10,0)`
`209`	`210`	`(10,10)`
`210`	`211`	`(-5,-12)`
`211`	`212`	`(5.1,34.5)`
`212`	`213`	`(1e+300,Infinity)`
	`214`	`+ (Infinity,1e+300)`
`213`	`215`	`(NaN,NaN)`
`214`		`-(9 rows)`
	`216`	`+(10 rows)`
`215`	`217`
`216`	`218`	`SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';`
`217`	`219`	`f1`
`@@ -464,7 +466,7 @@ SELECT count(*) FROM point_tbl p WHERE p.f1 >> '(0.0, 0.0)';`
`464`	`466`	`SELECT count(*) FROM point_tbl p WHERE p.f1 >> '(0.0, 0.0)';`
`465`	`467`	`count`
`466`	`468`	`-------`
`467`		`-3`
	`469`	`+4`
`468`	`470`	`(1 row)`
`469`	`471`
`470`	`472`	`EXPLAIN (COSTS OFF)`
`@@ -494,7 +496,7 @@ SELECT count(*) FROM point_tbl p WHERE p.f1 >^ '(0.0, 0.0)';`
`494`	`496`	`SELECT count(*) FROM point_tbl p WHERE p.f1 >^ '(0.0, 0.0)';`
`495`	`497`	`count`
`496`	`498`	`-------`
`497`		`-4`
	`499`	`+5`
`498`	`500`	`(1 row)`
`499`	`501`
`500`	`502`	`EXPLAIN (COSTS OFF)`
`@@ -530,10 +532,11 @@ SELECT * FROM point_tbl ORDER BY f1 <-> '0,1';`
`530`	`532`	`(10,10)`
`531`	`533`	`(-5,-12)`
`532`	`534`	`(5.1,34.5)`
	`535`	`+ (Infinity,1e+300)`
`533`	`536`	`(1e+300,Infinity)`
`534`	`537`	`(NaN,NaN)`
`535`	`538`
`536`		`-(10 rows)`
	`539`	`+(11 rows)`
`537`	`540`
`538`	`541`	`EXPLAIN (COSTS OFF)`
`539`	`542`	`SELECT * FROM point_tbl WHERE f1 IS NULL;`
`@@ -568,9 +571,10 @@ SELECT * FROM point_tbl WHERE f1 IS NOT NULL ORDER BY f1 <-> '0,1';`
`568`	`571`	`(10,10)`
`569`	`572`	`(-5,-12)`
`570`	`573`	`(5.1,34.5)`
	`574`	`+ (Infinity,1e+300)`
`571`	`575`	`(1e+300,Infinity)`
`572`	`576`	`(NaN,NaN)`
`573`		`-(9 rows)`
	`577`	`+(10 rows)`
`574`	`578`
`575`	`579`	`EXPLAIN (COSTS OFF)`
`576`	`580`	`SELECT * FROM point_tbl WHERE f1 <@ '(-10,-10),(10,10)':: box ORDER BY f1 <-> '0,1';`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commita45272b

File tree

5 files changed

5 files changed

`‎src/test/regress/expected/create_index.out`

0 commit comments