Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-5295

SET NAMES UTF8MB4,autocommit=0 is not detected correctly

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 21.06
    • 21.06.18
    • qc_sqlite
    • None
    • MXS-SPRINT-218

    Description

      The order in which the two arguments are given affects the transaction type mask.

      [markusjm@monolith test]$ ./compare -v3 -0 qc_sqlite -s "SET  names UTF8MB4,autocommit=0"
      (0): SET  names UTF8MB4,autocommit=0
      qc_parse                 : Ok : QC_QUERY_PARSED
      qc_get_type_mask         : Ok : QUERY_TYPE_SESSION_WRITE
      qc_get_operation         : Ok : QUERY_OP_SET
      qc_get_created_table_name: Ok : NULL
      qc_is_drop_table_query   : Ok : 0
      qc_get_table_names       : Ok : 
      qc_get_table_names(full) : Ok : 
      qc_query_has_clause      : Ok : 0
      qc_get_database_names    : Ok : 
      qc_get_prepare_name      : Ok : NULL
      qc_get_field_info        : Ok : 
      qc_get_function_info     : Ok : 
      Statements: 1
      Errors    : 0
      1st classifier: 0.37289
      2nd classifier: 0.21472
      [markusjm@monolith test]$ ./compare -v3 -0 qc_sqlite -s "SET  autocommit=0,names UTF8MB4"
      (0): SET  autocommit=0,names UTF8MB4
      qc_parse                 : Ok : QC_QUERY_PARSED
      qc_get_type_mask         : Ok : QUERY_TYPE_SESSION_WRITE|QUERY_TYPE_GSYSVAR_WRITE|QUERY_TYPE_BEGIN_TRX|QUERY_TYPE_DISABLE_AUTOCOMMIT
      qc_get_operation         : Ok : QUERY_OP_SET
      qc_get_created_table_name: Ok : NULL
      qc_is_drop_table_query   : Ok : 0
      qc_get_table_names       : Ok : 
      qc_get_table_names(full) : Ok : 
      qc_query_has_clause      : Ok : 0
      qc_get_database_names    : Ok : 
      qc_get_prepare_name      : Ok : NULL
      qc_get_field_info        : Ok : 
      qc_get_function_info     : Ok : 
      Statements: 1
      Errors    : 0
      1st classifier: 0.41361
      2nd classifier: 0.20513
      

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.