Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 2.2.22
-
Fix Version/s: 2.3.13
-
Component/s: qc_sqlite
-
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