[MXS-1406] Expose more operations Created: 2017-09-12  Updated: 2017-09-13  Resolved: 2017-09-13

Status: Closed
Project: MariaDB MaxScale
Component/s: QueryClassifier
Affects Version/s: 2.1.7
Fix Version/s: 2.1.8, 2.2.0

Type: Task Priority: Major
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MXS-1407 Bind session to master after CALL. Closed
Relates
relates to MXS-1295 MaxScale's readwritesplit router does... Closed

 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.

 Comments   
Comment by Johan Wikman [ 2017-09-13 ]

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

Generated at Thu Feb 08 04:06:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.