1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
|
query : ****************************
sql : ----------------------------
UPDATE `mysql`.`db` SET `db`.`name`='new'
------------------------------------
query_type : MYX_QT_UPDATE
options(0) :
tables(1) :
-------------------------------
table "system"."mysql"."db" ()
fullname= "`mysql`.`db`"
charset= "utf8"
columns(15) :
column "Host", cs(utf8_bin) is pk
column "Db", cs(utf8_bin) is pk
column "User", cs(utf8_bin) is pk
column "Select_priv", cs(utf8_bin) is not pk
column "Insert_priv", cs(utf8_bin) is not pk
column "Update_priv", cs(utf8_bin) is not pk
column "Delete_priv", cs(utf8_bin) is not pk
column "Create_priv", cs(utf8_bin) is not pk
column "Drop_priv", cs(utf8_bin) is not pk
column "Grant_priv", cs(utf8_bin) is not pk
column "References_priv", cs(utf8_bin) is not pk
column "Index_priv", cs(utf8_bin) is not pk
column "Alter_priv", cs(utf8_bin) is not pk
column "Create_tmp_table_priv", cs(utf8_bin) is not pk
column "Lock_tables_priv", cs(utf8_bin) is not pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(0)
clauses(2)
clause (7,20) doesn't end with linebreak
clause_type MYX_QCT_UPDATE_CLAUSE
clause : -------------------------
`mysql`.`db`
------------------------------------
clause (24,41) doesn't end with linebreak
clause_type MYX_QCT_SET_CLAUSE
clause : -------------------------
`db`.`name`='new'
------------------------------------
subqueries(0)
params_num 0
query : ****************************
sql : ----------------------------
UPDATE `mysql`.`db` SET `db`.`name`='a' WHERE `db`.`host`='b'
------------------------------------
query_type : MYX_QT_UPDATE
options(0) :
tables(1) :
-------------------------------
table "system"."mysql"."db" ()
fullname= "`mysql`.`db`"
charset= "utf8"
columns(15) :
column "Host", cs(utf8_bin) is pk
column "Db", cs(utf8_bin) is pk
column "User", cs(utf8_bin) is pk
column "Select_priv", cs(utf8_bin) is not pk
column "Insert_priv", cs(utf8_bin) is not pk
column "Update_priv", cs(utf8_bin) is not pk
column "Delete_priv", cs(utf8_bin) is not pk
column "Create_priv", cs(utf8_bin) is not pk
column "Drop_priv", cs(utf8_bin) is not pk
column "Grant_priv", cs(utf8_bin) is not pk
column "References_priv", cs(utf8_bin) is not pk
column "Index_priv", cs(utf8_bin) is not pk
column "Alter_priv", cs(utf8_bin) is not pk
column "Create_tmp_table_priv", cs(utf8_bin) is not pk
column "Lock_tables_priv", cs(utf8_bin) is not pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(0)
clauses(3)
clause (7,20) doesn't end with linebreak
clause_type MYX_QCT_UPDATE_CLAUSE
clause : -------------------------
`mysql`.`db`
------------------------------------
clause (24,40) doesn't end with linebreak
clause_type MYX_QCT_SET_CLAUSE
clause : -------------------------
`db`.`name`='a'
------------------------------------
clause (46,61) doesn't end with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
`db`.`host`='b'
------------------------------------
subqueries(0)
params_num 0
query : ****************************
sql : ----------------------------
UPDATE `table with space` SET `table with space`.`name`='a' WHERE `table with space`.`host`='b'
------------------------------------
query_type : MYX_QT_UPDATE
options(0) :
tables(1) :
-------------------------------
table "def"."test"."table with space" ()
fullname= "`table with space`"
charset= "(null)"
columns(0) :
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(0)
clauses(3)
clause (7,26) doesn't end with linebreak
clause_type MYX_QCT_UPDATE_CLAUSE
clause : -------------------------
`table with space`
------------------------------------
clause (30,60) doesn't end with linebreak
clause_type MYX_QCT_SET_CLAUSE
clause : -------------------------
`table with space`.`name`='a'
------------------------------------
clause (66,95) doesn't end with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
`table with space`.`host`='b'
------------------------------------
subqueries(0)
params_num 0
query : ****************************
sql : ----------------------------
UPDATE `"` SET `"`.`name`='a' WHERE `"`.`host`='b'
------------------------------------
query_type : MYX_QT_UPDATE
options(0) :
tables(1) :
-------------------------------
table "def"."test".""" ()
fullname= "`"`"
charset= "(null)"
columns(0) :
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(0)
clauses(3)
clause (7,11) doesn't end with linebreak
clause_type MYX_QCT_UPDATE_CLAUSE
clause : -------------------------
`"`
------------------------------------
clause (15,30) doesn't end with linebreak
clause_type MYX_QCT_SET_CLAUSE
clause : -------------------------
`"`.`name`='a'
------------------------------------
clause (36,50) doesn't end with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
`"`.`host`='b'
------------------------------------
subqueries(0)
params_num 0
|
