X-Git-Url: https://git.exim.org/exim.git/blobdiff_plain/298849d8ea217fd104d167f5233bd11240b3ddae..65fe780259d0009354b5dfc9a4f1b48ad6513db2:/test/scripts/2600-SQLite/2600?ds=inline diff --git a/test/scripts/2600-SQLite/2600 b/test/scripts/2600-SQLite/2600 index 2a557a46a..a11d46ef1 100644 --- a/test/scripts/2600-SQLite/2600 +++ b/test/scripts/2600-SQLite/2600 @@ -1,15 +1,23 @@ # sqlite lookups exim -d-all+lookup -be +${lookup sqlite,file=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='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}';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='userx';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{ select name from them where id='xxxx';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select name from them where id='nothing';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select id,name from them where id='nothing';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb {select * from them where id='quote2';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='newline';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='tab';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where id='its';}} +${lookup sqlite,file=DIR/aux-fixed/sqlitedb{select * from them where name='${quote_sqlite:it's}';}} +**** +exim -d -DOPT=y -bh 10.0.0.0 +mail from: +rcpt to: +rcpt to: +quit **** exim -d -bh 10.0.0.0 mail from: @@ -23,7 +31,7 @@ rcpt to: rcpt to: quit **** -exim -odi -d userx +exim -DOPT=y -odi -d userx Test message . **** @@ -35,3 +43,9 @@ ${lookup sqlite{DIR/aux-fixed/sqlitedb select name from them where id='userx';}} exim -DDATA=DIR/aux-fixed/sqlitedb -d-all+lookup -be ${lookup sqlite{select name from them where id='userx';}} **** +exim -DDATA=nonabsolute_filename -d-all+lookup -be +${lookup sqlite{select name from them where id='userx';}} +**** +exim -DDATA=DIR/missingfile -d-all+lookup -be +${lookup sqlite{select name from them where id='userx';}} +****