Lookups: fix mysql lookup returns for no-data "queries",

when the number of rows affected is returned.  Bug 2223

Broken-by: acec9514b1

Also enhance the testsuite mysql testcase to be standalone and move to standard-run set
and add a specific testcase for this bug.

Testcase working on Fedora at least - we'll see what happens on other platforms
where executable locaation may vary.

1 files changed, 48 insertions, 0 deletions

diff --git a/test/confs/2610 b/test/confs/2610
new file mode 100644
index 000000000..9e2217215
--- /dev/null
+++ b/test/confs/2610
@@ -0,0 +1,48 @@
+# Exim test configuration 2610
+
+.include DIR/aux-var/std_conf_prefix
+
+primary_hostname = myhost.test.ex
+
+# ----- Main settings -----
+
+domainlist local_domains = @
+hostlist   relay_hosts = net-mysql;select * from them where id='$sender_host_address'
+
+acl_smtp_rcpt = check_recipient
+
+mysql_servers = 127.0.0.1::PORT_N/test/root/
+
+
+# ----- ACL -----
+
+begin acl
+
+check_recipient:
+  accept  domains = +local_domains
+  accept  hosts = +relay_hosts
+  deny    message = relay not permitted
+
+
+# ----- Routers -----
+
+begin routers
+
+r1:
+  driver = accept
+  address_data = ${lookup mysql{select name from them where id='ph10'}}
+  transport = t1
+
+
+# ----- Transports -----
+
+begin transports
+
+t1:
+  driver = appendfile
+  file = DIR/test-mail/\
+    ${lookup mysql{select id from them where id='ph10'}{$value}fail}
+  user = CALLER
+
+
+# End