15.6 Implementation of the X Protocol by the X Plugin

Topics in this section:

• Mysqlx.Sql::StmtExecute

• Collations

The X Plugin implements the X Protocol for the MySQL Server.

Mysqlx.Sql::StmtExecute

StmtExecute implements several namespaces:

sql

The SQL interface which expects:

• .stmt to be a string that the MySQL SQL parser understands

Note

As the SQL parser for non prepared statements doesn't understand wildcards, setting .args will result in an error.

xplugin

The xplugin-plugin has internal commands:

• .stmt is the name of the internal command

• .args replaces wild-cards in .stmt if any exist

Collations

The X Plugin defines a mapping from collation_id as used in:

• ColumnMetaData

• Scalar

to character sets and collations:

id	character_set_name	collation_name
1	big5	big5_chinese_ci
2	latin2	latin2_czech_cs
3	dec8	dec8_swedish_ci
4	cp850	cp850_general_ci
5	latin1	latin1_german1_ci
6	hp8	hp8_english_ci
7	koi8r	koi8r_general_ci
8	latin1	latin1_swedish_ci
9	latin2	latin2_general_ci
10	swe7	swe7_swedish_ci
11	ascii	ascii_general_ci
12	ujis	ujis_japanese_ci
13	sjis	sjis_japanese_ci
14	cp1251	cp1251_bulgarian_ci
15	latin1	latin1_danish_ci
16	hebrew	hebrew_general_ci
18	tis620	tis620_thai_ci
19	euckr	euckr_korean_ci
20	latin7	latin7_estonian_cs
21	latin2	latin2_hungarian_ci
22	koi8u	koi8u_general_ci
23	cp1251	cp1251_ukrainian_ci
24	gb2312	gb2312_chinese_ci
25	greek	greek_general_ci
26	cp1250	cp1250_general_ci
27	latin2	latin2_croatian_ci
28	gbk	gbk_chinese_ci
29	cp1257	cp1257_lithuanian_ci
30	latin5	latin5_turkish_ci
31	latin1	latin1_german2_ci
32	armscii8	armscii8_general_ci
33	utf8	utf8_general_ci
34	cp1250	cp1250_czech_cs
35	ucs2	ucs2_general_ci
36	cp866	cp866_general_ci
37	keybcs2	keybcs2_general_ci
38	macce	macce_general_ci
39	macroman	macroman_general_ci
40	cp852	cp852_general_ci
41	latin7	latin7_general_ci
42	latin7	latin7_general_cs
43	macce	macce_bin
44	cp1250	cp1250_croatian_ci
45	utf8mb4	utf8mb4_general_ci
46	utf8mb4	utf8mb4_bin
47	latin1	latin1_bin
48	latin1	latin1_general_ci
49	latin1	latin1_general_cs
50	cp1251	cp1251_bin
51	cp1251	cp1251_general_ci
52	cp1251	cp1251_general_cs
53	macroman	macroman_bin
54	utf16	utf16_general_ci
55	utf16	utf16_bin
56	utf16le	utf16le_general_ci
57	cp1256	cp1256_general_ci
58	cp1257	cp1257_bin
59	cp1257	cp1257_general_ci
60	utf32	utf32_general_ci
61	utf32	utf32_bin
62	utf16le	utf16le_bin
63	binary	binary
64	armscii8	armscii8_bin
65	ascii	ascii_bin
66	cp1250	cp1250_bin
67	cp1256	cp1256_bin
68	cp866	cp866_bin
69	dec8	dec8_bin
70	greek	greek_bin
71	hebrew	hebrew_bin
72	hp8	hp8_bin
73	keybcs2	keybcs2_bin
74	koi8r	koi8r_bin
75	koi8u	koi8u_bin
77	latin2	latin2_bin
78	latin5	latin5_bin
79	latin7	latin7_bin
80	cp850	cp850_bin
81	cp852	cp852_bin
82	swe7	swe7_bin
83	utf8	utf8_bin
84	big5	big5_bin
85	euckr	euckr_bin
86	gb2312	gb2312_bin
87	gbk	gbk_bin
88	sjis	sjis_bin
89	tis620	tis620_bin
90	ucs2	ucs2_bin
91	ujis	ujis_bin
92	geostd8	geostd8_general_ci
93	geostd8	geostd8_bin
94	latin1	latin1_spanish_ci
95	cp932	cp932_japanese_ci
96	cp932	cp932_bin
97	eucjpms	eucjpms_japanese_ci
98	eucjpms	eucjpms_bin
99	cp1250	cp1250_polish_ci
101	utf16	utf16_unicode_ci
102	utf16	utf16_icelandic_ci
103	utf16	utf16_latvian_ci
104	utf16	utf16_romanian_ci
105	utf16	utf16_slovenian_ci
106	utf16	utf16_polish_ci
107	utf16	utf16_estonian_ci
108	utf16	utf16_spanish_ci
109	utf16	utf16_swedish_ci
110	utf16	utf16_turkish_ci
111	utf16	utf16_czech_ci
112	utf16	utf16_danish_ci
113	utf16	utf16_lithuanian_ci
114	utf16	utf16_slovak_ci
115	utf16	utf16_spanish2_ci
116	utf16	utf16_roman_ci
117	utf16	utf16_persian_ci
118	utf16	utf16_esperanto_ci
119	utf16	utf16_hungarian_ci
120	utf16	utf16_sinhala_ci
121	utf16	utf16_german2_ci
122	utf16	utf16_croatian_ci
123	utf16	utf16_unicode_520_ci
124	utf16	utf16_vietnamese_ci
128	ucs2	ucs2_unicode_ci
129	ucs2	ucs2_icelandic_ci
130	ucs2	ucs2_latvian_ci
131	ucs2	ucs2_romanian_ci
132	ucs2	ucs2_slovenian_ci
133	ucs2	ucs2_polish_ci
134	ucs2	ucs2_estonian_ci
135	ucs2	ucs2_spanish_ci
136	ucs2	ucs2_swedish_ci
137	ucs2	ucs2_turkish_ci
138	ucs2	ucs2_czech_ci
139	ucs2	ucs2_danish_ci
140	ucs2	ucs2_lithuanian_ci
141	ucs2	ucs2_slovak_ci
142	ucs2	ucs2_spanish2_ci
143	ucs2	ucs2_roman_ci
144	ucs2	ucs2_persian_ci
145	ucs2	ucs2_esperanto_ci
146	ucs2	ucs2_hungarian_ci
147	ucs2	ucs2_sinhala_ci
148	ucs2	ucs2_german2_ci
149	ucs2	ucs2_croatian_ci
150	ucs2	ucs2_unicode_520_ci
151	ucs2	ucs2_vietnamese_ci
159	ucs2	ucs2_general_mysql500_ci
160	utf32	utf32_unicode_ci
161	utf32	utf32_icelandic_ci
162	utf32	utf32_latvian_ci
163	utf32	utf32_romanian_ci
164	utf32	utf32_slovenian_ci
165	utf32	utf32_polish_ci
166	utf32	utf32_estonian_ci
167	utf32	utf32_spanish_ci
168	utf32	utf32_swedish_ci
169	utf32	utf32_turkish_ci
170	utf32	utf32_czech_ci
171	utf32	utf32_danish_ci
172	utf32	utf32_lithuanian_ci
173	utf32	utf32_slovak_ci
174	utf32	utf32_spanish2_ci
175	utf32	utf32_roman_ci
176	utf32	utf32_persian_ci
177	utf32	utf32_esperanto_ci
178	utf32	utf32_hungarian_ci
179	utf32	utf32_sinhala_ci
180	utf32	utf32_german2_ci
181	utf32	utf32_croatian_ci
182	utf32	utf32_unicode_520_ci
183	utf32	utf32_vietnamese_ci
192	utf8	utf8_unicode_ci
193	utf8	utf8_icelandic_ci
194	utf8	utf8_latvian_ci
195	utf8	utf8_romanian_ci
196	utf8	utf8_slovenian_ci
197	utf8	utf8_polish_ci
198	utf8	utf8_estonian_ci
199	utf8	utf8_spanish_ci
200	utf8	utf8_swedish_ci
201	utf8	utf8_turkish_ci
202	utf8	utf8_czech_ci
203	utf8	utf8_danish_ci
204	utf8	utf8_lithuanian_ci
205	utf8	utf8_slovak_ci
206	utf8	utf8_spanish2_ci
207	utf8	utf8_roman_ci
208	utf8	utf8_persian_ci
209	utf8	utf8_esperanto_ci
210	utf8	utf8_hungarian_ci
211	utf8	utf8_sinhala_ci
212	utf8	utf8_german2_ci
213	utf8	utf8_croatian_ci
214	utf8	utf8_unicode_520_ci
215	utf8	utf8_vietnamese_ci
223	utf8	utf8_general_mysql500_ci
224	utf8mb4	utf8mb4_unicode_ci
225	utf8mb4	utf8mb4_icelandic_ci
226	utf8mb4	utf8mb4_latvian_ci
227	utf8mb4	utf8mb4_romanian_ci
228	utf8mb4	utf8mb4_slovenian_ci
229	utf8mb4	utf8mb4_polish_ci
230	utf8mb4	utf8mb4_estonian_ci
231	utf8mb4	utf8mb4_spanish_ci
232	utf8mb4	utf8mb4_swedish_ci
233	utf8mb4	utf8mb4_turkish_ci
234	utf8mb4	utf8mb4_czech_ci
235	utf8mb4	utf8mb4_danish_ci
236	utf8mb4	utf8mb4_lithuanian_ci
237	utf8mb4	utf8mb4_slovak_ci
238	utf8mb4	utf8mb4_spanish2_ci
239	utf8mb4	utf8mb4_roman_ci
240	utf8mb4	utf8mb4_persian_ci
241	utf8mb4	utf8mb4_esperanto_ci
242	utf8mb4	utf8mb4_hungarian_ci
243	utf8mb4	utf8mb4_sinhala_ci
244	utf8mb4	utf8mb4_german2_ci
245	utf8mb4	utf8mb4_croatian_ci
246	utf8mb4	utf8mb4_unicode_520_ci
247	utf8mb4	utf8mb4_vietnamese_ci
248	gb18030	gb18030_chinese_ci
249	gb18030	gb18030_bin
250	gb18030	gb18030_unicode_520_ci

Note

This list append-only:

• new entries may be added

• none of the existing entries may be changed

Note

Even though list currently matches

SELECT
    id,
    character_set_name,
    collation_name
FROM information_schema.collations
ORDER BY id

of MySQL 5.7.8 it may diverge from it in the future if the MySQL Server runtime doesn't follow the "append-only" rule for some reason.