From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sat, 13 Apr 2024 14:24:36 +0200
Subject: Adding upstream version 1:10.11.6.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 randgen/conf/maria_group_commit.yy | 181 +++++++++++++++++++++++++++++++++++++
 1 file changed, 181 insertions(+)
 create mode 100644 randgen/conf/maria_group_commit.yy

(limited to 'randgen')

diff --git a/randgen/conf/maria_group_commit.yy b/randgen/conf/maria_group_commit.yy
new file mode 100644
index 00000000..e136cbf7
--- /dev/null
+++ b/randgen/conf/maria_group_commit.yy
@@ -0,0 +1,181 @@
+# test of group commit switching
+
+query:
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  select | insert | update| delete |
+  change_group_commit | change_interval;
+
+
+select:
+	SELECT select_item FROM join where order_by limit;
+
+select_item:
+	* | X . _field ;
+
+join:
+	_table AS X |
+	_table AS X LEFT JOIN _table AS Y ON ( X . _field = Y . _field ) ;
+
+where:
+	|
+	WHERE X . _field < value |
+	WHERE X . _field > value |
+	WHERE X . _field = value ;
+
+where_delete:
+	|
+	WHERE _field < value |
+	WHERE _field > value |
+	WHERE _field = value ;
+
+order_by:
+	| ORDER BY X . _field ;
+
+limit:
+	| LIMIT _digit ;
+
+insert:
+	INSERT INTO _table ( _field , _field ) VALUES ( value , value ) ;
+
+update:
+	UPDATE _table AS X SET _field = value where order_by limit ;
+
+delete:
+	DELETE FROM _table where_delete LIMIT _digit ;
+
+value:
+	' _letter ' | _digit | _date | _datetime | _time | _english ;
+
+change_group_commit:
+        SET GLOBAL MARIA_GROUP_COMMIT=none_soft_hard;
+
+none_soft_hard:
+        NONE | SOFT | HARD;
+
+change_interval:
+     set_interval | set_interval | set_interval | set_interval |
+     drop_interval;
+
+set_interval:
+        SET GLOBAL MARIA_GROUP_COMMIT_INTERVAL=_tinyint_unsigned;
+
+drop_interval:
+        SET GLOBAL MARIA_GROUP_COMMIT_INTERVAL=0;
-- 
cgit v1.2.3