|
2019-09-02
| ||
| 22:14 | • Fixed ticket [29f635e0]: IS NULL unexpectedly evaluates to TRUE plus 7 other changes (artifact: 781749e7 user: drh) | |
| 02:22 | • Fixed ticket [2841e99d]: Different rounding when converting TEXT to REAL plus 6 other changes (artifact: 59028a40 user: drh) | |
| 02:21 | When applying the IN_INDEX_NOOP optimization and the LHS has REAL affinity, also apply REAL affinity to each element of the RHS. Ticket [2841e99d104c6436]. (check-in: 88833a9c user: drh tags: trunk) | |
|
2019-09-01
| ||
| 18:44 | • New ticket [2841e99d] Different rounding when converting TEXT to REAL. (artifact: 08df019d user: mrigger) | |
| Ticket Hash: | 2841e99d104c6436c267f233c0ad2204fa151079 | |||
| Title: | Different rounding when converting TEXT to REAL | |||
| Status: | Fixed | Type: | Code_Defect | |
| Severity: | Important | Priority: | Immediate | |
| Subsystem: | Unknown | Resolution: | Fixed | |
| Last Modified: | 2019-09-02 02:22:07 | |||
| Version Found In: | 3.29.0 | |||
| User Comments: | ||||
|
mrigger added on 2019-09-01 18:44:32:
In the test case below, a row is unexpectedly fetched.
CREATE TABLE t0(c0 REAL UNIQUE);
INSERT INTO t0(c0) VALUES(2.07093491255203046E18);
SELECT * FROM t0 WHERE c0 IN ('2070934912552030444'); -- unexpected: row is fetched
This is surprising, since the following evaluates to FALSE:
SELECT c0 IN ('2070934912552030444') FROM t0; -- FALSE
| ||||