Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-77

Execution of 'ANALYZE TABLE' statement would invalidate the statement and connection handles.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.13
    • 2.0.14, 3.0.1
    • None
    • None
    • MariaDB 5.5.53 and MySQL 5.5.28, Linux

    Description

      Consequent execution of a statement would return error:
      08S01:#:2013:[ma-2.0.13][5.5.53-MariaDB]Lost connection to MySQL server during query

      The driver does not expect any results returned whether the server returns one row with four columns.

      Suggested fix

      --- ./ma_parse.h.ori    2017-01-04 18:48:39.481680000 -0800
      +++ ./ma_parse.h        2017-01-04 19:34:12.473327000 -0800
      @@ -27,7 +27,8 @@
                                   MADB_QUERY_DELETE= SQL_DELETE,
                                   MADB_QUERY_SELECT,
                                   MADB_QUERY_SHOW,
      -                            MADB_QUERY_CALL
      +                            MADB_QUERY_CALL,
      +                            MADB_QUERY_ANALYZE
                                 };
       
       #define QUERY_DOESNT_RETURN_RESULT(query_type) ((query_type) < MADB_QUERY_SELECT)
      --- ./ma_parse.c.ori    2016-10-30 08:49:31.000000000 -0700
      +++ ./ma_parse.c        2017-01-04 18:49:59.273705000 -0800
      @@ -163,6 +163,10 @@
         {
           return MADB_QUERY_SHOW;
         }
      +  if (_strnicmp(Stmt->StmtString, "ANALYZE", 7) == 0)
      +  {
      +    return MADB_QUERY_ANALYZE;
      +  }
       
         return MADB_QUERY_NO_RESULT;
       }
      

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            yv Yuriy Vasylchenko
            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.