diff options
| author | Daniel Gustafsson <dgustafsson@postgresql.org> | 2022-09-12 12:59:06 +0200 |
|---|---|---|
| committer | Daniel Gustafsson <dgustafsson@postgresql.org> | 2022-09-12 12:59:06 +0200 |
| commit | 8cb2a22bbb2cf4212482ac15021ceaa2e9c52209 (patch) | |
| tree | b6881a0046c905ad671e0b43d60a42a119f4a3d4 /src/test | |
| parent | 07d8af5e5e0cf5d5187353809920f344a5d20684 (diff) | |
Fix NaN comparison in circle_same test
Commit c4c340088 changed geometric operators to use float4 and float8
functions, and handle NaN's in a better way. The circle sameness test
had a typo in the code which resulted in all comparisons with the left
circle having a NaN radius considered same.
postgres=# select '<(0,0),NaN>'::circle ~= '<(0,0),1>'::circle;
?column?
----------
t
(1 row)
This fixes the sameness test to consider the radius of both the left
and right circle.
Backpatch to v12 where this was introduced.
Author: Ranier Vilela <ranier.vf@gmail.com>
Discussion: https://postgr.es/m/CAEudQAo8dK=yctg2ZzjJuzV4zgOPBxRU5+Kb+yatFiddtQk6Rw@mail.gmail.com
Backpatch-through: v12
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/geometry.out | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/src/test/regress/expected/geometry.out b/src/test/regress/expected/geometry.out index 3b364d1e3be..b50103b2165 100644 --- a/src/test/regress/expected/geometry.out +++ b/src/test/regress/expected/geometry.out @@ -4380,9 +4380,8 @@ SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 ~= c2.f1; <(100,200),10> | <(100,200),10> <(100,1),115> | <(100,1),115> <(3,5),0> | <(3,5),0> - <(3,5),NaN> | <(3,5),0> <(3,5),NaN> | <(3,5),NaN> -(9 rows) +(8 rows) -- Overlap with circle SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 && c2.f1; |