sms db: don't attempt to query pending SMS for unset MSISDN
When the subscriber has no MSISDN, we might construct an invalid SQL statement
such as
... AND dest_addr= AND ...
Instead, don't even query for empty MSISDNs.
Related: OS#2706
Change-Id: I7d6169d774b2da04b3051957e364fe620feed51e
diff --git a/src/libmsc/db.c b/src/libmsc/db.c
index 4e4477b..ca27b6a 100644
--- a/src/libmsc/db.c
+++ b/src/libmsc/db.c
@@ -840,6 +840,10 @@
if (!vsub->lu_complete)
return NULL;
+ /* A subscriber having no phone number cannot possibly receive SMS. */
+ if (*vsub->msisdn == '\0')
+ return NULL;
+
result = dbi_conn_queryf(conn,
"SELECT * FROM SMS"
" WHERE sent IS NULL"