Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.11
-
None
-
None
Description
CREATE TABLE IF NOT EXISTS t0 (
|
c0 FLOAT,
|
c0_1 DOUBLE,
|
c0_2 VARCHAR(100),
|
c1 VARCHAR(500) NULL
|
);
|
INSERT INTO t0 VALUES ('0.0171682', '0', '0.0171682', '0.028583989421476108');
|
 |
MariaDB [test]> SELECT * FROM T0;
|
+-----------+------+-----------+----------------------+
|
| c0 | c0_1 | c0_2 | c1 |
|
+-----------+------+-----------+----------------------+
|
| 0.0171682 | 0 | 0.0171682 | 0.028583989421476108 |
|
+-----------+------+-----------+----------------------+
|
Execute the query:
SELECT (t0.c0_1 + t0.c0_2) AS ref0 FROM t0 WHERE (t0.c0_1 + t0.c0_2); |
Expected Result:
The query should return a single row with the value 0.0171682 in the ref0 column.
Actual Result:
The query returns an empty set.
Attachments
Issue Links
- relates to
-
MDEV-34123 CONCAT Function Returns Unexpected Empty Set in Query
- Closed
-
MDEV-34189 Unexpected error on `WHERE inet6col`
- Open