diff options
Diffstat (limited to 'test/scripts/2600-SQLite/2600')
-rw-r--r-- | test/scripts/2600-SQLite/2600 | 32 |
1 files changed, 32 insertions, 0 deletions
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';}} +**** |