From 0dfdc3e5dc012c1a2640ac2af22b1488cdfbd083 Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Tue, 7 May 2013 15:16:11 -0700 Subject: [PATCH] fix smart search for all-numeric strings --- FS/FS/cust_svc.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm index cab80a871..627410729 100644 --- a/FS/FS/cust_svc.pm +++ b/FS/FS/cust_svc.pm @@ -870,7 +870,7 @@ sub smart_search_param { FS::part_svc->svc_tables; if ( $string =~ /^(\d+)$/ ) { - unshift @or, "SELECT cust_svc.svcnum, NULL FROM cust_svc WHERE agent_svcid = $1"; + unshift @or, "SELECT cust_svc.svcnum, NULL as svcdb FROM cust_svc WHERE agent_svcid = $1"; } my $addl_from = " RIGHT JOIN (\n" . join("\nUNION\n", @or) . "\n) AS svc_all ". -- 2.11.0