Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7441

Server audit: QUERY_DML + QUERY_DDL != QUERY, some queries aren't logged

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Not a Bug
        • Affects Version/s: N/A
        • Fix Version/s: 5.5.42
        • Component/s: Plugin - Audit
        • Labels:
          None

          Description

          The document about new 1.2.0 Audit features says "The option QUERY still can be used and is equal to using both QUERY_DML and QUERY_DDL."
          It is not so; some queries aren't logged either with QUERY_DML or QUERY_DDL, but are logged with QUERY. Just one example is ANALYZE TABLE t1; there are many more, including those that aren't related to tables (directly), e.g. SET @a=1.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                holyfoot Alexey Botchkov added a comment -

                documentation fixed.

                Show
                holyfoot Alexey Botchkov added a comment - documentation fixed.

                  People

                  • Assignee:
                    holyfoot Alexey Botchkov
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 hour
                      1h