diff options
author | Sylvain Munaut <246tnt@gmail.com> | 2009-12-21 01:09:57 +0100 |
---|---|---|
committer | Harald Welte <laforge@gnumonks.org> | 2009-12-21 01:09:57 +0100 |
commit | d5778fc4c7497e1b7310811c881f8cb21b742ec8 (patch) | |
tree | 06b4fcb9300b80b102e79bcca3fc23c5697766d0 /openbsc/src/chan_alloc.c | |
parent | a4e2d04b35095d059218ab05ffcd5b69e18edf70 (diff) |
[db] Fix queries for unsent SMS
- Need to use sms.id for the ORDER BY since 'subscriber' also has 'id'
- Need to add the join clause between 'SMS' and 'subscriber'
- Add a LIMIT 1 (probably no impact for the db size we're dealing with
here, but with large DB and mysql/postgresql this can help the planner)
- (fix a wrong comment in passing ...)
Signed-off-by: Sylvain Munaut <tnt@246tNt.com>
Diffstat (limited to 'openbsc/src/chan_alloc.c')
0 files changed, 0 insertions, 0 deletions