[MDEV-34123] CONCAT Function Returns Unexpected Empty Set in Query - Jira

XML

Word

Printable

CREATE TABLE IF NOT EXISTS t0 (

    c0_1 VARCHAR(200),

    c0_2 TEXT

);

INSERT INTO t0 VALUES ('0.67882431850', '97966');

MariaDB [test]> select * from t0;

+---------------+-------+

| c0_1          | c0_2  |

+---------------+-------+

| 0.67882431850 | 97966 |

+---------------+-------+

1 row in set (0.002 sec)

Execute the query:

SELECT (CONCAT(t0.c0_1, t0.c0_2)) AS ref0 FROM t0 WHERE (CONCAT(t0.c0_1, t0.c0_2));

Expected Result:
The query should return a single row with the value 0.6788243185097966 in the ref0 column.

Actual Result:
The query returns an empty set.

is duplicated by

MDEV-34592 There are some problems with the keyword 'where if'

relates to

MDEV-35135 Assertion `!is_cond()' failed in Item_bool_func::val_int / do_select

MDEV-33999 Unexpected result when casting decimal in WHERE clause

MDEV-34114 Incorrect Query Result when Adding Columns

MDEV-34189 Unexpected error on `WHERE inet6col`

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.