Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
SELECT
|
CAST(JSON_EXTRACT('{"x":true}', '$.x') AS DOUBLE) AS cf, |
CAST(JSON_EXTRACT('{"x":true}', '$.x') AS DECIMAL) AS cd; |
+------+------+
|
| cf | cd |
|
+------+------+
|
| 1 | 0 |
|
+------+------+
|
1 row in set, 1 warning (0.012 sec)
|
Attachments
Issue Links
- blocks
-
MDEV-21445 Strange/inconsistent behavior of IN condition when mixing numbers and strings
- Closed
- relates to
-
MDEV-15905 select json_value('{"b":true}','$.b')=1 --> false with "Truncated incorrect DOUBLE value: 'true'"
- Closed