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
 
 -