Changeset: b207f1995328 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b207f1995328 Modified Files: sql/test/BugTracker-2025/Tests/7637_str_to_decimal.test Branch: Mar2025 Log Message:
Add tests where the trailing or leading digit 0 is removed. Those tests succeed. diffs (49 lines): diff --git a/sql/test/BugTracker-2025/Tests/7637_str_to_decimal.test b/sql/test/BugTracker-2025/Tests/7637_str_to_decimal.test --- a/sql/test/BugTracker-2025/Tests/7637_str_to_decimal.test +++ b/sql/test/BugTracker-2025/Tests/7637_str_to_decimal.test @@ -5,6 +5,12 @@ select cast(9999999990999999999099999999 99999999909999999990999999999012345678 -99999999909999999990999999999012345678 +query TT +select cast(99999999909999999990999999999012345678. as decimal(38,0)) as val1, cast(-99999999909999999990999999999012345678. as decimal(38,0)) as val2 +---- +99999999909999999990999999999012345678 +-99999999909999999990999999999012345678 + -- decimal value with 38 digits after the decimal separator query TT select cast(0.99999999909999999990999999999012345678 as decimal(38,38)) as val1, cast(-0.99999999909999999990999999999012345678 as decimal(38,38)) as val2 @@ -12,6 +18,19 @@ select cast(0.99999999909999999990999999 0.99999999909999999990999999999012345678 -0.99999999909999999990999999999012345678 +query TT +select cast(.99999999909999999990999999999012345678 as decimal(38,38)) as val1, cast(-.99999999909999999990999999999012345678 as decimal(38,38)) as val2 +---- +0.99999999909999999990999999999012345678 +-0.99999999909999999990999999999012345678 + +query TT +select cast(cast(.99999999909999999990999999999012345678 as decimal(38,38)) as string) as val1, cast(cast(-.99999999909999999990999999999012345678 as decimal(38,38)) as string) as val2; +---- +0.99999999909999999990999999999012345678 +-0.99999999909999999990999999999012345678 + + -- hugeint value with 38 digits before the decimal separator query TT select cast(99999999909999999990999999999012345678.0 as hugeint) as val1, cast(-99999999909999999990999999999012345678.0 as hugeint) as val2 @@ -19,6 +38,12 @@ select cast(9999999990999999999099999999 99999999909999999990999999999012345678 -99999999909999999990999999999012345678 +query TT +select cast(99999999909999999990999999999012345678. as hugeint) as val1, cast(-99999999909999999990999999999012345678. as hugeint) as val2 +---- +99999999909999999990999999999012345678 +-99999999909999999990999999999012345678 + -- hugeint value with 38 digits without the decimal separator query TT select cast(99999999909999999990999999999012345678 as hugeint) as val1, cast(-99999999909999999990999999999012345678 as hugeint) as val2 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
