Comparison

plugins/mod_storage_sql.lua @ 10925:73e95ecec733

mod_storage_sql: Fix incorrect results when fetching items before specific archive id Copy/paste error, introduced in deb68066c7aa
author Matthew Wild <mwild1@gmail.com>
date Fri, 12 Jun 2020 16:54:38 +0100
parent 10793:9ce67da45e54
child 10993:b5e7f4d533e2
comparison
equal deleted inserted replaced
10924:0c072dd69603 10925:73e95ecec733
389 where[#where+1] = '"sort_id" > ?'; 389 where[#where+1] = '"sort_id" > ?';
390 args[#args+1] = after_id; 390 args[#args+1] = after_id;
391 end 391 end
392 if query.before then 392 if query.before then
393 local before_id = nil; 393 local before_id = nil;
394 for row in engine:select(id_lookup_sql, query.after, args[1], args[2], args[3]) do 394 for row in engine:select(id_lookup_sql, query.before, args[1], args[2], args[3]) do
395 before_id = row[1]; 395 before_id = row[1];
396 end 396 end
397 if not before_id then 397 if not before_id then
398 return nil, "item-not-found"; 398 return nil, "item-not-found";
399 end 399 end