[Koha-bugs] [Bug 24695] Improve SQL report validation

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Feb 21 06:28:13 CET 2020


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24695

--- Comment #3 from paxed <pasi.kallinen at koha-suomi.fi> ---
(In reply to Bernardo Gonzalez Kriegel from comment #2)
> (In reply to paxed from comment #1)
> > Created attachment 99305 [details] [review] [review]
> > Bug 24695: Improve SQL report validation
> 
> Works well, no errors, test pass, but...
> 
> > 5) Edit a save_sql in the database, changing it to eg.
> >    "drop borrowers", and try to execute it (fails)
> 
> ended with an empty borrowers table :(
> (I wrote 'delete from borrowers')
> 
> Works this for you?

update saved_sql set savedsql='DROP borrowers';

then try to run the report, it'll cause an error. Ideally, this should be
changed to produce an actual koha page with an explanation instead, but that is
outside the scope of this bug, and behaves the same as before this patch.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list