From fdc6de263a58480519d683e67bb3dfa262d9b230 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Thu, 5 Aug 2021 23:30:09 +0100 Subject: Handle gtid and xid transaction events --- test/sql/simpleCreate.sql | 5 +++++ test/sql/simpleDelete.sql | 2 ++ test/sql/simpleDeleteSome.sql | 2 ++ test/sql/simpleInsert.sql | 1 + test/sql/simpleSelectAll.sql | 3 +++ test/sql/simpleUpdate.sql | 1 + test/sql/simpleUpdateAll.sql | 1 + 7 files changed, 15 insertions(+) create mode 100644 test/sql/simpleCreate.sql create mode 100644 test/sql/simpleDelete.sql create mode 100644 test/sql/simpleDeleteSome.sql create mode 100644 test/sql/simpleInsert.sql create mode 100644 test/sql/simpleSelectAll.sql create mode 100644 test/sql/simpleUpdate.sql create mode 100644 test/sql/simpleUpdateAll.sql (limited to 'test/sql') diff --git a/test/sql/simpleCreate.sql b/test/sql/simpleCreate.sql new file mode 100644 index 0000000..c2a89e9 --- /dev/null +++ b/test/sql/simpleCreate.sql @@ -0,0 +1,5 @@ +CREATE TABLE test( + id int auto_increment, + val varchar(20), + primary key(id) +) diff --git a/test/sql/simpleDelete.sql b/test/sql/simpleDelete.sql new file mode 100644 index 0000000..1c1bd85 --- /dev/null +++ b/test/sql/simpleDelete.sql @@ -0,0 +1,2 @@ +DELETE FROM test WHERE id = ? + diff --git a/test/sql/simpleDeleteSome.sql b/test/sql/simpleDeleteSome.sql new file mode 100644 index 0000000..ed69fa8 --- /dev/null +++ b/test/sql/simpleDeleteSome.sql @@ -0,0 +1,2 @@ +DELETE FROM test WHERE id < ? + diff --git a/test/sql/simpleInsert.sql b/test/sql/simpleInsert.sql new file mode 100644 index 0000000..f695332 --- /dev/null +++ b/test/sql/simpleInsert.sql @@ -0,0 +1 @@ +INSERT INTO test(val) VALUES(?) diff --git a/test/sql/simpleSelectAll.sql b/test/sql/simpleSelectAll.sql new file mode 100644 index 0000000..9fe07bc --- /dev/null +++ b/test/sql/simpleSelectAll.sql @@ -0,0 +1,3 @@ +SELECT id, val +FROM testout.test +ORDER BY id diff --git a/test/sql/simpleUpdate.sql b/test/sql/simpleUpdate.sql new file mode 100644 index 0000000..700f127 --- /dev/null +++ b/test/sql/simpleUpdate.sql @@ -0,0 +1 @@ +UPDATE test SET val = ? WHERE id = ? diff --git a/test/sql/simpleUpdateAll.sql b/test/sql/simpleUpdateAll.sql new file mode 100644 index 0000000..1ac2f13 --- /dev/null +++ b/test/sql/simpleUpdateAll.sql @@ -0,0 +1 @@ +UPDATE test SET val = ? -- cgit v1.2.3