Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.2.3
-
None
-
2019-03
Description
Build tested: 1.2.3-1
MariaDB [mytest]> create table t3 (c char(10)) engine=columnstore;
Query OK, 0 rows affected (0.169 sec)
MariaDB [mytest]> insert into t3 values ('aaaaaaaaaa');
Query OK, 1 row affected (0.165 sec)
MariaDB [mytest]> select c, SUBSTRING_INDEX(c,'a', -3) from t3;
--------------------------------------+
c | SUBSTRING_INDEX(c,'a', -3) |
--------------------------------------+
aaaaaaaaaa | aaaaaaaaaa |
--------------------------------------+
1 row in set (0.061 sec)
The query should return 'aa' instead.
Attachments
Issue Links
- is caused by
-
MCOL-1822 Change the default to use double when overflow occurs in SUM() and AVG()
- Closed