[Bacula-bugs] [bacula 0000178]: :List where a File is saved regardless of the directory: shows only 20 results

[<bac...@li...>]

The following bug has been SUBMITTED.
======================================================================
http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000178
======================================================================
Reported By:                mikeacar
Assigned To:                
======================================================================
Project:                    bacula
Bug ID:                     178
Category:                   bconsole
Reproducibility:            always
Severity:                   tweak
Priority:                   normal
Status:                     new
======================================================================
Date Submitted:             11-24-2004 10:15 PST
Last Modified:              11-24-2004 10:15 PST
======================================================================
Summary:                    :List where a File is saved regardless of the directory: shows only 20 results
Description: 
The "List where a File is saved regardless of the directory" query in
bacula-1.36.0/src/dird/query.sql ends with a "limit 20", which has obvious
problems. Additionally LIMIT isn't in SQL 99.

I'm not sure why there is a "distinct" on this, either.
======================================================================

Bug History
Date Modified  Username       Field                    Change              
======================================================================
11-24-04 10:15 mikeacar       New Bug                                      
======================================================================