Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.2
-
None
-
2018-20, 2018-21, 2019-01, 2019-02, 2019-03, 2019-04, 2019-05, 2019-06
Description
The query
MariaDB [test]> set infinidb_vtable_mode=1;
Query OK, 0 rows affected (0.000 sec)
MariaDB [test]> select sum from cs2 where cs2.i not in ( select sum from cs3 );
--------
sum |
--------
66 |
--------
1 row in set (0.057 sec)
MariaDB [test]> set infinidb_vtable_mode=0;
Query OK, 0 rows affected (0.000 sec)
MariaDB [test]> select sum from cs2 where cs2.i not in ( select sum from cs3 );
ERROR 1815 (HY000): Internal error: IDB-1001: Function 'trigcond' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.
 |