Debian Codegraph @

mysql-test/suite/x/t/crud_resultset_charset.test

raw
1 ## X protocol always coverts resulset to utf8mb4
2
3 ## Preamble
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 ## Test starts here
8 --write_file $MYSQL_TMP_DIR/crud_resultset_charset.xpl
9
10 -->title =Xproto resultset conversion (sql stmt)
11
12 -->sql
13 select * from xtest.city;
14 -->endsql
15
16 -->title =Xproto resultset conversion (crud/table stmt)
17 Mysqlx.Crud.Find {
18 collection {
19 name: "city"
20 schema: "xtest"
21 }
22 data_model: TABLE
23 }
24 -->recvresult
25
26 -->title =Xproto resultset conversion (crud/doc stmt)
27 Mysqlx.Crud.Find {
28 collection {
29 name: "city"
30 schema: "xtest"
31 }
32 data_model: DOCUMENT
33 projection {
34 alias: "Name"
35 source {
36 type: IDENT identifier { name: "Name" }
37 }
38 }
39 projection {
40 alias: "District"
41 source {
42 type: IDENT identifier { name: "District" }
43 }
44 }
45 }
46 -->recvresult
47 EOF
48
49 CREATE SCHEMA xtest;
50 CREATE TABLE xtest.city (
51 `Name` CHAR(35) NOT NULL DEFAULT '',
52 `District` CHAR(20) NOT NULL DEFAULT ''
53 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54
55 INSERT INTO xtest.city VALUES (X'4B6F9A696365', X'56FD63686F646EE920536C6F76656E736B6F' ),
56 (X'476F7468656E62757267205B47F67465626F72675D', X'576573742047F674616E6D61616E206CE46E' ),
57 (X'4D616C6DF6', X'536BE56E65206CE46E' ),
58 (X'55707073616C61', X'55707073616C61206CE46E' ),
59 (X'4C696E6BF670696E67', X'456173742047F674616E6D61616E206CE46E' ),
60 (X'56E473746572E573', X'56E473746D616E6C616E6473206CE46E' ),
61 (X'D6726562726F', X'D6726562726F73206CE46E' ),
62 (X'4E6F72726BF670696E67', X'456173742047F674616E6D61616E206CE46E' ),
63 (X'48656C73696E67626F7267', X'536BE56E65206CE46E' ),
64 (X'4AF66E6BF670696E67', X'4AF66E6BF670696E6773206CE46E' ),
65 (X'556D65E5', X'56E473746572626F7474656E73206CE46E' ),
66 (X'4C756E64', X'536BE56E65206CE46E' ),
67 (X'426F72E573', X'576573742047F674616E6D61616E206CE46E' ),
68 (X'53756E647376616C6C', X'56E4737465726E6F72726C616E6473206CE46E'),
69 (X'47E4766C65', X'47E4766C65626F726773206CE46E' );
70
71 echo Classic resultset conversion;
72 echo ============================;
73 SELECT * FROM xtest.city;
74
75 exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/crud_resultset_charset.xpl 2>&1;
76
77 ## Cleanup
78 --source ../include/xplugin_cleanup.inc