summaryrefslogtreecommitdiff
path: root/mysql-test/t/federated.test
diff options
context:
space:
mode:
authordlenev@mysql.com <>2006-07-06 13:33:23 +0400
committerdlenev@mysql.com <>2006-07-06 13:33:23 +0400
commitd6f47c31b660e7ed955edb26ebc6c7816e82f34f (patch)
tree106d3c540b4c619c6b3f9ee22bd75d8562d25061 /mysql-test/t/federated.test
parenteb3ae6eb79f90e1d133a30fe52473de70077a772 (diff)
downloadmariadb-git-d6f47c31b660e7ed955edb26ebc6c7816e82f34f.tar.gz
After merge fixes for patch solving bug#18437 "Wrong values inserted with a
before update trigger on NDB table". Two main changes: - We use TABLE::read_set/write_set bitmaps for marking fields used by statement instead of Field::query_id in 5.1. - Now when we mark columns used by statement we take into account columns used by table's triggers instead of marking all columns as used if table has triggers.
Diffstat (limited to 'mysql-test/t/federated.test')
-rw-r--r--mysql-test/t/federated.test6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/federated.test b/mysql-test/t/federated.test
index 9144f2965df..5c464e1210f 100644
--- a/mysql-test/t/federated.test
+++ b/mysql-test/t/federated.test
@@ -1391,15 +1391,15 @@ insert into federated.t2 values (13, 17), (19, 23);
# Each of three statements should correctly set values for all three fields
# insert
insert into federated.t1 (a, b) values (1, 2), (3, 5), (7, 11);
-select * from federated.t1;
+select * from federated.t1 order by a;
delete from federated.t1;
# insert ... select
insert into federated.t1 (a, b) select * from federated.t2;
-select * from federated.t1;
+select * from federated.t1 order by a;
delete from federated.t1;
# load
load data infile '../std_data_ln/loaddata5.dat' into table federated.t1 fields terminated by '' enclosed by '' ignore 1 lines (a, b);
-select * from federated.t1;
+select * from federated.t1 order by a;
drop tables federated.t1, federated.t2;
connection slave;