1 files changed, 150 insertions, 0 deletions
diff --git a/common/query/basics/testscript b/common/query/basics/testscript
new file mode 100644
index 0000000..9086b66
--- /dev/null
+++ b/common/query/basics/testscript
@@ -0,0 +1,150 @@
+# file      : common/query/basics/testscript
+# license   : GNU GPL v2; see accompanying LICENSE file
+
+.include ../../../database-options.testscript
+
++cat <<EOI >=output
+  test 001
+  John Doe 30 married
+  Jane Doe 29 married
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+  test 002
+  Jane Doe 29 married
+  John Doe 30 married
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 003
+  John Doe 30 married
+
+  test 004
+  John Doe 30 married
+
+  test 005
+  John Doe 30 married
+
+  Joe Squeaky Dirt 31 single
+
+  test 006
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 007
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 008
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+
+  John Doe 30 married
+  Jane Doe 29 married
+
+  test 009
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  John Doe 30 married
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  test 010
+  Jane Doe 29 married
+
+  John Doe 30 married
+  Jane Doe 29 married
+  Joe Squeaky Dirt 31 single
+
+  Jane Doe 29 married
+
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  Jane Doe 29 married
+  John Doe 30 married
+
+  test 011
+  John Doe 30 married
+  Jane Doe 29 married
+
+  John Doe 30 married
+  Jane Doe 29 married
+  Joe Squeaky Dirt 31 single
+
+  test 012
+  Johansen J Johansen 32 single
+
+  test 013
+  Joe Squeaky Dirt 31 single
+
+  test 014
+  test 015
+  John Doe 30 married
+  Jane Doe 29 married
+
+  test 016
+  test 017
+  test 018
+  test 019
+  test 020
+  John Doe 30 married
+  Joe Squeaky Dirt 31 single
+  Johansen J Johansen 32 single
+
+  Jane Doe 29 married
+
+
+  Jane Doe 29 married
+
+  EOI
+
+test.redirects += >>>../output
+
+: mysql
+:
+if $mysql
+{
+  .include ../../../mysql.testscript
+
+  $create_schema;
+  $*
+}
+
+: sqlite
+:
+if $sqlite
+{
+  .include ../../../sqlite.testscript
+
+  $*
+}
+
+: pgsql
+:
+if $pgsql
+{
+  .include ../../../pgsql.testscript
+
+  $create_schema;
+  $*
+}