1# Test different ways of syncing (mostly syntax)
2--source include/have_maria.inc
3
4--disable_warnings
5drop table if exists t1;
6--enable_warnings
7
8create table t1 (a int);
9
10SET GLOBAL aria_group_commit="NONE";
11SET GLOBAL aria_group_commit_interval= 0;
12--disable_query_log
13let $num = 5000;
14while ($num)
15{
16  insert into t1 values (1);
17  dec $num;
18}
19--enable_query_log
20SET GLOBAL aria_group_commit="NONE";
21SET GLOBAL aria_group_commit_interval= 100;
22--disable_query_log
23let $num = 5000;
24while ($num)
25{
26  insert into t1 values (1);
27  dec $num;
28}
29--enable_query_log
30SET GLOBAL aria_group_commit="HARD";
31SET GLOBAL aria_group_commit_interval= 0;
32--disable_query_log
33let $num = 5000;
34while ($num)
35{
36  insert into t1 values (1);
37  dec $num;
38}
39--enable_query_log
40SET GLOBAL aria_group_commit="HARD";
41SET GLOBAL aria_group_commit_interval= 100;
42--disable_query_log
43let $num = 5000;
44while ($num)
45{
46  insert into t1 values (1);
47  dec $num;
48}
49--enable_query_log
50SET GLOBAL aria_group_commit="SOFT";
51SET GLOBAL aria_group_commit_interval= 0;
52--disable_query_log
53let $num = 5000;
54while ($num)
55{
56  insert into t1 values (1);
57  dec $num;
58}
59--enable_query_log
60SET GLOBAL aria_group_commit="SOFT";
61SET GLOBAL aria_group_commit_interval= 100;
62--disable_query_log
63let $num = 5000;
64while ($num)
65{
66  insert into t1 values (1);
67  dec $num;
68}
69--enable_query_log
70SET GLOBAL aria_group_commit="NONE";
71SET GLOBAL aria_group_commit_interval= 0;
72drop table t1;
73