| Server IP : 49.212.180.16 / Your IP : 3.138.101.237 Web Server : Apache System : FreeBSD www2606.sakura.ne.jp 13.0-RELEASE-p14 FreeBSD 13.0-RELEASE-p14 #2: Mon Dec 9 13:54:55 JST 2024 root@www5301.sakura.ne.jp:/usr/obj/usr/src/amd64.amd64/sys/GENERIC amd64 User : utannto ( 1076) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/rs/mysql/5.1/mysql-test/suite/rpl_ndb/r/ |
Upload File : |
include/master-slave.inc [connection master] create table t1 (a int, unique(a)) engine=ndbcluster; create table t2 (a int, unique(a)) engine=innodb; begin; insert into t1 values(1); insert into t2 values(1); rollback; select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 select count(*) from t1; count(*) 0 select count(*) from t2; count(*) 0 begin; load data infile '../../../std_data/rpl_loaddata.dat' into table t2; Warnings: Warning 1262 Row 1 was truncated; it contained more data than there were input columns Warning 1262 Row 2 was truncated; it contained more data than there were input columns load data infile '../../../std_data/rpl_loaddata.dat' into table t1; Warnings: Warning 1262 Row 1 was truncated; it contained more data than there were input columns Warning 1262 Row 2 was truncated; it contained more data than there were input columns rollback; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back select count(*) from t1; count(*) 2 select count(*) from t2; count(*) 0 select count(*) from t1; count(*) 2 select count(*) from t2; count(*) 0 delete from t1; delete from t2; begin; load data infile '../../../std_data/rpl_loaddata.dat' into table t2; Warnings: Warning 1262 Row 1 was truncated; it contained more data than there were input columns Warning 1262 Row 2 was truncated; it contained more data than there were input columns load data infile '../../../std_data/rpl_loaddata.dat' into table t1; Warnings: Warning 1262 Row 1 was truncated; it contained more data than there were input columns Warning 1262 Row 2 was truncated; it contained more data than there were input columns rollback; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back select count(*) from t1; count(*) 2 select count(*) from t2; count(*) 0 select count(*) from t1; count(*) 2 select count(*) from t2; count(*) 0 delete from t1; delete from t2; begin; insert into t2 values(3),(4); insert into t1 values(3),(4); load data infile '../../../std_data/rpl_loaddata.dat' into table t2; Warnings: Warning 1262 Row 1 was truncated; it contained more data than there were input columns Warning 1262 Row 2 was truncated; it contained more data than there were input columns load data infile '../../../std_data/rpl_loaddata.dat' into table t1; Warnings: Warning 1262 Row 1 was truncated; it contained more data than there were input columns Warning 1262 Row 2 was truncated; it contained more data than there were input columns rollback; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back select count(*) from t1; count(*) 4 select count(*) from t2; count(*) 0 select count(*) from t1; count(*) 4 select count(*) from t2; count(*) 0 drop table t1,t2; include/rpl_end.inc