X-Git-Url: https://git.exim.org/users/heiko/exim.git/blobdiff_plain/59371ea735c941334861aa5b8e1e9a06facf044f..cf39dad3d551222a3e1f681995c287eb53e2596f:/test/scripts/2600-SQLite/2600?ds=sidebyside diff --git a/test/scripts/2600-SQLite/2600 b/test/scripts/2600-SQLite/2600 index f388b1ac1..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,10 +31,21 @@ rcpt to: rcpt to: quit **** -exim -odi -d userx +exim -DOPT=y -odi -d userx Test message . **** exim -d-all+lookup -be ${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';}} +****