[MXS-2673] Sys var and user var combined issue Created: 2019-09-12  Updated: 2020-01-08  Resolved: 2019-09-27

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.2.22
Fix Version/s: 2.3.13

Type: Bug Priority: Minor
Reporter: dapeng huang Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None


 Description   

SET @saved_cs_client= @@character_set_client; // route to master
SET character_set_client = @saved_cs_client; // route to all

So character_set_client will be null at slaves, then session command failed, close slave backends.

proposeļ¼š
1. QC parse 'SET @saved_cs_client= @@character_set_client;' as QUERY_TYPE_SYSVAR_READ | QUERY_TYPE_USERVAR_WRITE, current is QUERY_TYPE_UNKNOWN

2. route 'QUERY_TYPE_SYSVAR_READ | QUERY_TYPE_USERVAR_WRITE' to all nodes

 Comments   
Comment by Johan Wikman [ 2019-09-27 ]

In 2.3.13 (not yet released) they will be both classified as QUERY_TYPE_SESSION_WRITE, so they will both be sent to all nodes.

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