Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
13.2
-
None
-
Unexpected results
Description
Issue:
---------
With federated_pushdown=ON , query throws syntax error
Note: With OFF , query executes fine.
MariaDB [m8]> UPDATE D AS OUTR1, D AS OUTR2 SET OUTR1.a=NULL WHERE OUTR1.a BETWEEN NULL AND NULL;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<cache>(NULL) and <cache>(NULL)' at line 1
Version used:
----------------
Debug build
Branch : 13.2-MDEV-41243-fedx-pushdown-assert-for-upd-del-prepared-stmts
commit: e7d83013b31c4cc97a0003a0e58b707d94cba042
Version : 13.1.0
How to repeat:
----------------
Slave:
create table D( a date); |
Master: Start server with federated engine enabled
create table D(a date) ENGINE="FEDERATED" CONNECTION='mysql://u3@127.0.0.1:3306/m8/D'; |
 |
set global federated_pushdown=ON; |
UPDATE D AS OUTR1, D AS OUTR2 SET OUTR1.a=NULL WHERE OUTR1.a BETWEEN NULL AND NULL; |
Attachments
Issue Links
- is caused by
-
MDEV-39226 Direct multi-table update/delete interface and FederatedX implementation
-
- In Testing
-