Bug 9148

Summary: Guided.pm - Allow mutiple selects and change the results limit
Product: Koha Reporter: Vitor Fernandes <vfernandes>
Component: ReportsAssignee: Vitor Fernandes <vfernandes>
Status: CLOSED INVALID QA Contact:
Severity: normal    
Priority: P2    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: Sponsored Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Vitor Fernandes 2012-11-26 15:33:03 UTC
Change:

$sql =~ s/\bSELECT\W+(?:\w+\W+){1,}?FROM\b|\bSELECT\W\*\WFROM\b/SELECT count(*) FROM /i;

to

$sql =~ s/\bSELECT\W+(?:\w+\W+){1,}?FROM\b|\bSELECT\W\*\WFROM\b/SELECT count(*) FROM /ig;



Change:

$limit  = 9999 unless $limit;

to

$limit  = 999999 unless $limit;