X-Git-Url: https://git.exim.org/users/jgh/exim.git/blobdiff_plain/54c5ebb14ead7439af300e9d7d9d7d2ba29ff32e..59371ea735c941334861aa5b8e1e9a06facf044f:/test/scripts/2600-SQLite/2600

diff --git a/test/scripts/2600-SQLite/2600 b/test/scripts/2600-SQLite/2600
new file mode 100644
index 000000000..f388b1ac1
--- /dev/null
+++ b/test/scripts/2600-SQLite/2600
@@ -0,0 +1,32 @@
+# sqlite lookups
+exim -d-all+lookup -be
+${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='xxxx';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='nothing';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select id,name from them where id='nothing';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='quote2';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='newline';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='tab';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where id='its';}}
+${lookup sqlite{DIR/aux-fixed/sqlitedb select * from them where name='${quote_sqlite:it's}';}}
+****
+exim -d -bh 10.0.0.0
+mail from:<a@b>
+rcpt to:<c@d>
+rcpt to:<c@d>
+quit
+****
+exim -d -bh 10.10.10.10
+mail from:<a@b>
+rcpt to:<c@d>
+rcpt to:<c@d>
+quit
+****
+exim -odi -d userx
+Test message
+.
+****
+exim -d-all+lookup -be
+${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}}
+****