Last modified: 2013-01-18 21:49:21 UTC
In a big Special:Ask query, after offset 5000 or 5500, the first 500 results show up again (although there are still some left...)
Please describe the system environment (SMW/MW version) where this behaviour has been observed and if possible an accessible resource (wiki url, case study, sandbox example url etc.) to verify the described symptoms.
I suspect that $smwgQMaxLimit was set to 5000. However + for MWJames's Comment 1
I set up a demo system. Notice that the Query from 7001-7005 and all further querys (bigger offset) show same results as Query from 1 to 500. Latest source code, fresh installation. Query from 1 to 500: http://141.52.175.12/mediawiki-1.20.2/index.php?title=Special:Ask&offset=0&limit=500&q=%5B%5BCategory%3AContent+Source%5D%5D&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D%E2%80%A6-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FUrl%0A%3FModification+date%0A&eq=yes Query from 4001-4500: http://141.52.175.12/mediawiki-1.20.2/index.php?title=Special:Ask&offset=4000&limit=500&q=%5B%5BCategory%3AContent+Source%5D%5D&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D%E2%80%A6-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FUrl%0A%3FModification+date%0A&eq=yes Query from 7001-7500: http://141.52.175.12/mediawiki-1.20.2/index.php?title=Special:Ask&offset=7000&limit=500&q=%5B%5BCategory%3AContent+Source%5D%5D&p=format%3Dbroadtable%2Flink%3Dall%2Fheaders%3Dshow%2Fsearchlabel%3D%E2%80%A6-20further-20results%2Fclass%3Dsortable-20wikitable-20smwtable&po=%3FUrl%0A%3FModification+date%0A&eq=yes
This is not a bug, it's a feature. That's right, I said it :D You can increase your wikis configured limits. But beware that an offset of 10k will have your db go over 10k+ rows. You are probably better off using the ask API and continuation functionality it provides.