diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/numeric.out | 18 | ||||
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 3 |
2 files changed, 21 insertions, 0 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index d54282496ab..0898107ec30 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -2778,6 +2778,24 @@ select div(12345678901234567890, 123) * 123 + 12345678901234567890 % 123; 12345678901234567890 (1 row) +select 8e9000 - div(8e18000 - 1, 9e9000 - 1) * 9; + ?column? +---------- + 8 +(1 row) + +select 7328412092 - div(53705623790171816464 - 1, 7328412092); + ?column? +---------- + 1 +(1 row) + +select div(539913372912345678, 539913372912345678); + div +----- + 1 +(1 row) + -- -- Test some corner cases for square root -- diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index b508cba71dd..9da12c6b9eb 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -1225,6 +1225,9 @@ select 12345678901234567890 % 123; select 12345678901234567890 / 123; select div(12345678901234567890, 123); select div(12345678901234567890, 123) * 123 + 12345678901234567890 % 123; +select 8e9000 - div(8e18000 - 1, 9e9000 - 1) * 9; +select 7328412092 - div(53705623790171816464 - 1, 7328412092); +select div(539913372912345678, 539913372912345678); -- -- Test some corner cases for square root |