[ODBC-77] Execution of 'ANALYZE TABLE' statement would invalidate the statement and connection handles. - Jira

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;
}

Yuriy Vasylchenko created issue - 2017-01-05 20:23

Lawrin Novitsky made changes - 2017-02-03 13:14

Lawrin Novitsky made changes - 2017-02-03 13:27

Fix Version/s

3.0.1 [ 22511 ]

Sergei Golubchik made changes - 2017-11-23 16:24

Workflow

MariaDB connectors [ 79110 ]

MariaDB v3 [ 84045 ]

Sergei Golubchik made changes - 2021-12-06 21:28

Workflow

MariaDB v3 [ 84045 ]

MariaDB v4 [ 135422 ]

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

MariaDB Connector/ODBC