diff options
| author | Mathew Heard <splitice@users.noreply.github.com> | 2022-02-08 08:57:24 +1100 |
|---|---|---|
| committer | Daniel Black <daniel@mariadb.org> | 2022-06-10 11:36:59 +1000 |
| commit | b59bc629c8cef1e3e07529007dca2948b812e8fb (patch) | |
| tree | 28b95b38972ac32397ff835def37a44c922b60b7 /storage/connect/mysql-test/connect/r/mysql.result | |
| parent | ace2e0301e5d0f8c5acf02e671b6a1f3dd7fb374 (diff) | |
| download | mariadb-git-b59bc629c8cef1e3e07529007dca2948b812e8fb.tar.gz | |
MDEV-27766: connect engine; INSERT ignore option, was ignored
Test prior to this change:
CURRENT_TEST: connect.mysql
mysqltest: At line 485: query 'INSERT IGNORE INTO t3 VALUES (5),(10),(30)' failed: ER_GET_ERRMSG (1296): Got error 122 '(1062) Duplicate entry '10' for key 'PRIMARY' [INSERT INTO `t1` (`a`) VALUES (10)]' from CONNECT
So the ignore table option wasn't getting passed to the remove server.
Closes #2008
Diffstat (limited to 'storage/connect/mysql-test/connect/r/mysql.result')
| -rw-r--r-- | storage/connect/mysql-test/connect/r/mysql.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/storage/connect/mysql-test/connect/r/mysql.result b/storage/connect/mysql-test/connect/r/mysql.result index 3ac23394cbc..4377d2ad014 100644 --- a/storage/connect/mysql-test/connect/r/mysql.result +++ b/storage/connect/mysql-test/connect/r/mysql.result @@ -294,3 +294,15 @@ a 30 DROP TABLE t2; DROP TABLE t1; +# +# MDEV-27766 CONNECT Engine Support for INSERT IGNORE with Mysql Table type +# +CREATE TABLE t1 (a INT PRIMARY KEY); +INSERT INTO t1 VALUES (10),(20),(30); +CREATE TABLE t2 ENGINE=CONNECT TABLE_TYPE=MYSQL CONNECTION='mysql://root@localhost:PORT/test/t1' OPTION_LIST="Delayed=1,Ignored=1"; +INSERT INTO t2 VALUES (10),(20),(30),(40); +DROP TABLE t2; +DROP TABLE t1; +# +# End of 10.3 tests +# |