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

            Bug ID: 37307
           Summary: Update And Run SQL function appends report ID to
                    savedsql
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Reports
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]

Use of the Update And Run SQL button causes koha to append the report ID to the
end of the query. It's commented out, so it doesn't break the query, but it's
adding useless characters.

To recreate:
 - save and run this report:
SELECT id, savedsql
FROM saved_sql
WHERE savedsql like "%saved_sql.id: %"

- see your report returns itself
- click Edit
- click Update and Run SQL without changing anything in your report
- click Update and Run SQL again
- look at your report results, notice that the saved query is now repeating "/*
saved_sql.id: 1334 */" at the end

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to