Changeset: 6f34fa2d20f6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6f34fa2d20f6 Added Files: sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Aug2024 Log Message:
Add test for regression issue #7593 diffs (222 lines): diff --git a/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test b/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test @@ -0,0 +1,207 @@ +-- certain doubles (ending with a 0 and (> 9999 or < -9990)) are converted to scientific notation by the server, which is undesired. +-- this started with Aug2024, older servers didn't do this, so a regression issue. + +query T +select cast(cast(202909 as double) as varchar) as "expect 202909" +---- +202909 + +query T +select cast(cast(202910 as double) as varchar) as "expect 202910" +---- +202910 + +query T +select cast(cast(202911 as double) as varchar) as "expect 202911" +---- +202911 + +query T +select cast(cast(20290 as double) as varchar) as "expect 20290" +---- +20290 + +query T +select cast(cast(2020 as double) as varchar) as "expect 2020" +---- +2020 + +query T +select cast(cast(20900 as double) as varchar) as "expect 20900" +---- +20900 + +query T +select cast(cast(202900 as double) as varchar) as "expect 202900" +---- +202900 + +query T +select cast(cast(202990 as double) as varchar) as "expect 202990" +---- +202990 + +query T +select cast(cast(2029900 as double) as varchar) as "expect 2029900" +---- +2029900 + +query T +select cast(cast(2029980 as double) as varchar) as "expect 2029980" +---- +2029980 + +query T +select cast(cast(2029981 as double) as varchar) as "expect 2029981" +---- +2029981 + +query T +select cast(cast(value as double) as varchar) from generate_series(9985, 10133) where value % 10 in (9,0,1) +---- +9989 +9990 +9991 +9999 +10000 +10001 +10009 +10010 +10011 +10019 +10020 +10021 +10029 +10030 +10031 +10039 +10040 +10041 +10049 +10050 +10051 +10059 +10060 +10061 +10069 +10070 +10071 +10079 +10080 +10081 +10089 +10090 +10091 +10099 +10100 +10101 +10109 +10110 +10111 +10119 +10120 +10121 +10129 +10130 +10131 + +-- idem for reals +query T +select cast(cast(value as real) as varchar) from generate_series(9985, 10133) where value % 10 in (9,0,1) +---- +9989 +9990 +9991 +9999 +10000 +10001 +10009 +10010 +10011 +10019 +10020 +10021 +10029 +10030 +10031 +10039 +10040 +10041 +10049 +10050 +10051 +10059 +10060 +10061 +10069 +10070 +10071 +10079 +10080 +10081 +10089 +10090 +10091 +10099 +10100 +10101 +10109 +10110 +10111 +10119 +10120 +10121 +10129 +10130 +10131 + +-- idem for negative doubles +query T +select cast(cast(value as double) as varchar) from generate_series(-10131, -9985) where value % 10 in (-9,0,-1) +---- +-10131 +-10130 +-10129 +-10121 +-10120 +-10119 +-10111 +-10110 +-10109 +-10101 +-10100 +-10099 +-10091 +-10090 +-10089 +-10081 +-10080 +-10079 +-10071 +-10070 +-10069 +-10061 +-10060 +-10059 +-10051 +-10050 +-10049 +-10041 +-10040 +-10039 +-10031 +-10030 +-10029 +-10021 +-10020 +-10019 +-10011 +-10010 +-10009 +-10001 +-10000 +-9999 +-9991 +-9990 +-9989 + diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -94,5 +94,6 @@ 7580-date-diff 7582-ddl-exists 7587-rejectmismatch 7591-logical-expr +7593-double-as-text-notation-issue KNOWNFAIL?7598-foreign_key_match_options KNOWNFAIL?7598-foreign_key_match_options_dump _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
