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.
|
|