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

Query with reversed executable comments is altered in audit/general log (version is stripped))

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • N/A
    • N/A
    • Plugin - Audit
    • None
    • Not for Release Notes

    Description

      create table test.t1 (i int);
      PREPARE stmt FROM 'INSERT INTO test.t1 VALUES(1) /*!!999999 , (2)*/';
      EXECUTE stmt;
      drop table test.t1;
      

      while in audit log it is written as:

      TIME,HOSTNAME,root,localhost:PORT,ID,ID,QUERY,sa_db,'INSERT INTO test.t1 VALUES(1) /*!!       , (2)*/',0
      

      260422 18:13:04	     4 Query	CREATE TABLE t1(c1 INT)
      260422 18:13:07	     4 Query	PREPARE stmt FROM 'INSERT INTO t1 VALUES(1) /*!!999999 , (2)*/'
      		     4 Prepare	INSERT INTO t1 VALUES(1) /*!!       , (2)*/
      260422 18:13:11	     4 Query	execute stmt
      		     4 Execute	INSERT INTO t1 VALUES(1) /*!!       , (2)*/
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.