[#MXS-220] LAST_INSERT_ID() query is redirect to slave if function call is in where clause

If a query contains LAST_INSERT_ID() it should be redirected to master, even if it is in WHERE clause.

Also another syntax is not redirected to the master: SELECT @id:=LAST_INSERT_ID(); - please let me know if you need a test case for this as well.

MariaDB [mariadb_test]> create table a (id serial, primary key(id));

Query OK, 0 rows affected (0.02 sec)

MariaDB [mariadb_test]> insert into a values(null);

Query OK, 1 row affected (0.00 sec)

MariaDB [mariadb_test]> select @@hostname from a WHERE id=last_insert_id();

Empty set (0.00 sec)

michaeldg [5:44 PM]

MariaDB [mariadb_test]> select @@hostname from a WHERE id=last_insert_id() or id=1;

+------------------------+

| @@hostname             |

+------------------------+

| 203.local |

+------------------------+

1 row in set (0.00 sec)

MariaDB [mariadb_test]> select @@hostname, last_insert_id() FROM a WHERE id=last_insert_id();

+------------------------+------------------+

| @@hostname             | last_insert_id() |

+------------------------+------------------+

| 201.local |                1 |

+------------------------+------------------+

1 row in set (0.00 sec)

Please change it so all queries with LAST_INSERT_ID() function call get redirected to master.

[MXS-220] LAST_INSERT_ID() query is redirect to slave if function call is in where clause Created: 2015-06-24 Updated: 2015-08-20 Resolved: 2015-07-20
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	readwritesplit
Affects Version/s:	1.1.1, 1.2.0
Fix Version/s:	1.3.0