Order by callingstation-Id, too. Fixes #786

[freeradius.git] / raddb / mods-config / sql / ippool-dhcp / mysql / queries.conf

diff --git a/raddb/mods-config/sql/ippool-dhcp/mysql/queries.conf b/raddb/mods-config/sql/ippool-dhcp/mysql/queries.conf
index 6cd3b6e..d4d390a 100644 (file)
--- a/raddb/mods-config/sql/ippool-dhcp/mysql/queries.conf
+++ b/raddb/mods-config/sql/ippool-dhcp/mysql/queries.conf
@@ -53,6 +53,7 @@ allocate_find = "\
        WHERE pool_name = '%{control:Pool-Name}' \
        AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') \
        ORDER BY \
+               (callingstationid <> '%{Calling-Station-Id}'), \
                expiry_time \
        LIMIT 1 \
        FOR UPDATE"