Bug sortkey

Result set too big

With MySQL 4.2 the query returns a result set which contains too many elements; executing the same DPL statement on MySQL 5 yields the correct result.

<dpl>
debug=3
  namespace=
  headingmode=H4
  ordermethod=category,lastedit
  addcategories=true
  addeditdate=true
  titlematch=%ma%
</dpl>

Extension:DynamicPageList (DPL), version 3.2.1: Warning: Skipping bad option 'H4' for parameter 'headingmode'.

• 2007-12-17 18:28:20 Test matrix2
• 2008-01-28 14:52:20 Email
• 2008-02-16 18:52:03 Semantic MediaWiki with Property Clusters (print version)
• 2008-02-26 07:09:21 Semantic MediaWiki with Property Clusters 1
• 2008-02-29 14:10:40 Semantic MediaWiki with Property Clusters
• 2008-02-29 14:28:04 Semantic MediaWiki with Property Clusters 2
• 2008-02-29 14:32:03 Semantic MediaWiki with Property Clusters 3
• 2008-03-22 18:01:57 Holzmaden
• 2008-03-22 20:44:35 Semantic MediaWiki with Property Clusters 4
• 2007-01-20 15:32:01 Somalia . . Categories: African Union member states | Arab League | Divided regions | East Africa | Pages with broken file links | Somalia
• 2007-09-25 19:22:38 2007-09-28 my birthday; send me many gifts! . . Categories: Calendar Templates | Events
• 2008-02-29 22:59:38 Class Freshman . . Categories: Class
• 2009-03-09 21:14:28 DPL Example 007 main page 1 . . Categories: DPL Example 007 main cat | Fictitious country
• 2009-03-09 21:15:38 DPL Example 007 main page 2 . . Categories: DPL Example 007 main cat
• 2007-01-21 19:40:50 Somango . . Categories: English-speaking countries | Fictitious country
• 2007-05-01 21:39:50 2007/05/07 take wife out for movie -- Spiderman? . . Categories: Events
• 2007-05-29 12:58:59 2007/06/05 Evenement maintenance . . Categories: Events
• 2007-05-30 12:22:21 2007/05/31 Bladadadmam . . Categories: Events
• 2007-10-10 07:45:20 YYYY-10-03 National Holiday in Germany . . Categories: Events | Holiday
• 2007-10-10 08:14:52 YYYY-12-24 Christmas Eve . . Categories: Events
• 2007-12-09 00:18:06 2007-12-25 Xmas Day . . Categories: Events
• 2007-11-23 11:45:18 Germany . . Categories: Location
• 2007-02-25 23:48:16 Buloma . . Categories: Place
• 2007-02-26 12:47:18 Test date formatting . . Categories: Test
• 2007-03-04 09:43:20 Test matches . . Categories: Test
• 2007-07-18 07:11:17 Test includematch . . Categories: Test
• 2007-12-17 18:27:44 Test matrix . . Categories: Test
• 2008-05-05 18:53:48 Test imagecontainer . . Categories: Test