From efcea3a80da7c4479d5fe168435ecc9fd06bdc72 Mon Sep 17 00:00:00 2001
From: John Turner <jturner.usa@gmail.com>
Date: Sun, 14 Sep 2025 00:16:10 -0400
Subject: Squashed 'subprojects/boost-sqlite/' content from commit 3378e35

git-subtree-dir: subprojects/boost-sqlite
git-subtree-split: 3378e353705271e569cf4ba15c467b840a39798c
---
 test/test-db.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 test/test-db.sql

(limited to 'test/test-db.sql')

diff --git a/test/test-db.sql b/test/test-db.sql
new file mode 100644
index 0000000..251313c
--- /dev/null
+++ b/test/test-db.sql
@@ -0,0 +1,29 @@
+--query_helper(R"(
+
+create table author (
+    id integer primary key autoincrement not null,
+    first_name text unique not null,
+    last_name text
+);
+
+insert into author (first_name, last_name) values
+                   ('vinnie', 'falco'),
+                   ('richard', 'hodges'),
+                   ('ruben', 'perez'),
+                   ('peter', 'dimov')
+;
+
+create table library(
+    id integer  primary key autoincrement,
+    name text unique,
+    author  integer references author(id)
+);
+
+insert into library ("name", author) values
+                    ('beast',    (select id from author where first_name = 'vinnie' and last_name = 'falco')),
+                    ('mysql',    (select id from author where first_name = 'ruben'  and last_name = 'perez')),
+                    ('mp11',     (select id from author where first_name = 'peter'  and last_name = 'dimov')),
+                    ('variant2', (select id from author where first_name = 'peter'  and last_name = 'dimov'))
+;
+
+--)")
\ No newline at end of file
-- 
cgit v1.2.3

