Debian Codegraph @

mysql-test/suite/federated/error_row_number.test

raw
1 --echo #
2 --echo # MDEV-26654 ROW_NUMBER is wrong upon INSERT into Federated table
3 --echo #
4
5 --source suite/federated/have_federatedx.inc
6 --source include/federated.inc
7 --connection master
8
9 create table t (pk int primary key);
10 --evalp create table tfed engine=FEDERATED connection='mysql://root@localhost:$MASTER_MYPORT/test/t'
11 --error ER_DUP_KEY
12 insert into tfed values (1),(2),(1);
13 get diagnostics condition 1 @val = row_number;
14 --echo # federated is doing bulk insert here, the exact row number is unknown
15 select @val;
16
17 drop table tfed, t;
18 --source include/federated_cleanup.inc