[MXS-1406] Expose more operations - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 2.1.7
Fix Version/s: 2.1.8, 2.2.0
Component/s: QueryClassifier
Labels:
None

Description

The query classifier should expose more operations. For instance, the operation for the statement

call p1();

is reported as QUERY_OP_UNDEFINED. The true operation is known during the parsing process and could just as well be reported.

Attachments

Issue Links

blocks

MXS-1407 Bind session to master after CALL.

Closed

relates to

MXS-1295 MaxScale's readwritesplit router does not take into account the fact that stored procedure call may change the value of a user variable

Closed

Activity

Johan Wikman added a comment - 2017-09-13 07:35 - edited

The operation of a CALL statement is now reported as QUERY_OP_CALL

The relevant query classifier information for CALL p1(); is

qc_get_type_mask         : Ok : QUERY_TYPE_WRITE

qc_get_operation         : Ok : QUERY_OP_CALL

and for CALL p1(@var);

qc_get_type_mask         : Ok : QUERY_TYPE_WRITE|QUERY_TYPE_USERVAR_READ

qc_get_operation         : Ok : QUERY_OP_CALL

Johan Wikman added a comment - 2017-09-13 07:35 - edited The operation of a CALL statement is now reported as QUERY_OP_CALL The relevant query classifier information for CALL p1(); is qc_get_type_mask : Ok : QUERY_TYPE_WRITE qc_get_operation : Ok : QUERY_OP_CALL and for CALL p1(@var); qc_get_type_mask : Ok : QUERY_TYPE_WRITE|QUERY_TYPE_USERVAR_READ qc_get_operation : Ok : QUERY_OP_CALL

People

Assignee:: Johan Wikman

Reporter:: Johan Wikman

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2017-09-12 10:54

Updated:: 2017-09-13 07:36

Resolved:: 2017-09-13 07:35

Git Integration

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

MariaDB MaxScale