Debian Codegraph @

mysql-test/suite/x/r/result_types.result

raw
1 CREATE SCHEMA xtest;
2 RUN USE xtest
3
4 0 rows affected
5 RUN CREATE TABLE test_float (f FLOAT, d DOUBLE)
6
7 0 rows affected
8 RUN INSERT INTO test_float VALUES (1.0/81, 1.0/81)
9
10 1 rows affected
11 RUN INSERT INTO test_float VALUES (1234567890.1234567890,1234567890.1234567890)
12
13 1 rows affected
14 RUN SELECT * FROM test_float
15 f d
16 0.0123457 0.012345679
17 1234570000 1234567890.1234567
18 0 rows affected
19 Mysqlx.Ok {
20 msg: "bye!"
21 }
22 ok
23 RUN USE xtest
24
25 0 rows affected
26 RUN CREATE TABLE test_unsigned (i INT UNSIGNED, b BIGINT UNSIGNED, t TINYINT UNSIGNED, s SMALLINT UNSIGNED, f FLOAT UNSIGNED, d DOUBLE UNSIGNED, de DECIMAL(10,2) UNSIGNED, dt DATETIME, ts TIMESTAMP)
27
28 0 rows affected
29 send Mysqlx.Sql.StmtExecute {
30 stmt: "SELECT * FROM test_unsigned"
31 }
32
33 Mysqlx.Resultset.ColumnMetaData {
34 type: UINT
35 name: "i"
36 original_name: "i"
37 table: "test_unsigned"
38 original_table: "test_unsigned"
39 schema: "xtest"
40 catalog: "def"
41 length: 10
42 }
43
44 Mysqlx.Resultset.ColumnMetaData {
45 type: UINT
46 name: "b"
47 original_name: "b"
48 table: "test_unsigned"
49 original_table: "test_unsigned"
50 schema: "xtest"
51 catalog: "def"
52 length: 20
53 }
54
55 Mysqlx.Resultset.ColumnMetaData {
56 type: UINT
57 name: "t"
58 original_name: "t"
59 table: "test_unsigned"
60 original_table: "test_unsigned"
61 schema: "xtest"
62 catalog: "def"
63 length: 3
64 }
65
66 Mysqlx.Resultset.ColumnMetaData {
67 type: UINT
68 name: "s"
69 original_name: "s"
70 table: "test_unsigned"
71 original_table: "test_unsigned"
72 schema: "xtest"
73 catalog: "def"
74 length: 5
75 }
76
77 Mysqlx.Resultset.ColumnMetaData {
78 type: FLOAT
79 name: "f"
80 original_name: "f"
81 table: "test_unsigned"
82 original_table: "test_unsigned"
83 schema: "xtest"
84 catalog: "def"
85 fractional_digits: 31
86 length: 12
87 flags: 1
88 }
89
90 Mysqlx.Resultset.ColumnMetaData {
91 type: DOUBLE
92 name: "d"
93 original_name: "d"
94 table: "test_unsigned"
95 original_table: "test_unsigned"
96 schema: "xtest"
97 catalog: "def"
98 fractional_digits: 31
99 length: 22
100 flags: 1
101 }
102
103 Mysqlx.Resultset.ColumnMetaData {
104 type: DECIMAL
105 name: "de"
106 original_name: "de"
107 table: "test_unsigned"
108 original_table: "test_unsigned"
109 schema: "xtest"
110 catalog: "def"
111 fractional_digits: 2
112 length: 11
113 flags: 1
114 }
115
116 Mysqlx.Resultset.ColumnMetaData {
117 type: DATETIME
118 name: "dt"
119 original_name: "dt"
120 table: "test_unsigned"
121 original_table: "test_unsigned"
122 schema: "xtest"
123 catalog: "def"
124 length: 19
125 content_type: 2
126 }
127
128 Mysqlx.Resultset.ColumnMetaData {
129 type: DATETIME
130 name: "ts"
131 original_name: "ts"
132 table: "test_unsigned"
133 original_table: "test_unsigned"
134 schema: "xtest"
135 catalog: "def"
136 length: 19
137 flags: 1
138 content_type: 2
139 }
140
141 Mysqlx.Resultset.FetchDone {
142 }
143
144 Mysqlx.Notice.Frame {
145 type: 3
146 scope: LOCAL
147 payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 0\n}\n }"
148 }
149
150 Mysqlx.Sql.StmtExecuteOk {
151 }
152
153 Mysqlx.Ok {
154 msg: "bye!"
155 }
156 ok
157 RUN USE xtest
158
159 0 rows affected
160 RUN CREATE TABLE test_set (s SET('one','two','three','four','five','six','seven','eight','nine','ten','eleven','twelve','thirteen','fourteen','fifteen','sixteen','seventeen','eightteen','nineteen','twenty','thirty','forty','fifty','sixty','seventy','eightty','ninety'))
161
162 0 rows affected
163 RUN INSERT INTO test_set VALUES ('one,two')
164
165 1 rows affected
166 RUN INSERT INTO test_set VALUES ('one,two,three,four,five,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fifteen,sixteen,seventeen,eightteen,nineteen')
167
168 1 rows affected
169 RUN INSERT INTO test_set VALUES ('one,two,three,four,five,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fifteen,sixteen,seventeen,eightteen,nineteen,twenty,thirty,forty,fifty,sixty,seventy,eightty,ninety')
170
171 1 rows affected
172 RUN SELECT * FROM test_set
173 s
174 one,two
175 eight,eightteen,eleven,fifteen,five,four,fourteen,nine,nineteen,one,seven,seventeen,six,sixteen,ten,thirteen,three,twelve,two
176 eight,eightteen,eightty,eleven,fifteen,fifty,five,forty,four,fourteen,nine,nineteen,ninety,one,seven,seventeen,seventy,six,sixteen,sixty,ten,thirteen,thirty,three,twelve,twenty,two
177 0 rows affected
178 Mysqlx.Ok {
179 msg: "bye!"
180 }
181 ok