When trying to filter a script result by using the “custom”-filter option on decimal values, the wrong results are returned.
Steps to reproduce the issue:
1. Run the following query:
WITH
t
AS
(SELECT cast ( 9999.40 AS DECIMAL ( 19, 2 ) ) AS BETRAG
UNION ALL
SELECT cast ( 999999.94 AS DECIMAL ( 19, 2 ) ) AS BETRAG
UNION ALL
SELECT cast ( 9999.70 AS DECIMAL ( 19, 2 ) ) AS BETRAG
UNION ALL
SELECT cast ( 9999.26 AS DECIMAL ( 19, 2 ) ) AS BETRAG
UNION ALL
SELECT cast ( 1001872.62 AS DECIMAL ( 19, 2 ) ) AS BETRAG
)
SELECT *
FROM t
2. Set the Custom Filter for the result set to 999000
3. the expected result values would be 999999.94 and 1001872.62 but Toad returns the following instead
9999.40
999999.94
9999.70
9999.26