1install plugin mysqlx soname "mysqlx.so"; 2call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key.."); 3call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed."); 4RUN create schema xtest 5 61 rows affected 7RUN use xtest 8 90 rows affected 10RUN CREATE TABLE t_tinyint (c1 TINYINT, c2 TINYINT UNSIGNED) 11 120 rows affected 13RUN INSERT INTO t_tinyint VALUES (-128, 0) 14 151 rows affected 16RUN INSERT INTO t_tinyint VALUES (-1, 1) 17 181 rows affected 19RUN INSERT INTO t_tinyint VALUES (0, 127) 20 211 rows affected 22RUN INSERT INTO t_tinyint VALUES (1, 200) 23 241 rows affected 25RUN INSERT INTO t_tinyint VALUES (127, 255) 26 271 rows affected 28RUN CREATE TABLE t_smallint (c1 SMALLINT, c2 SMALLINT UNSIGNED) 29 300 rows affected 31RUN INSERT INTO t_smallint VALUES (-32768, 0) 32 331 rows affected 34RUN INSERT INTO t_smallint VALUES (-1, 1) 35 361 rows affected 37RUN INSERT INTO t_smallint VALUES (0, 32767) 38 391 rows affected 40RUN INSERT INTO t_smallint VALUES (1, 65534) 41 421 rows affected 43RUN INSERT INTO t_smallint VALUES (32767, 65535) 44 451 rows affected 46RUN CREATE TABLE t_mediumint (c1 MEDIUMINT, c2 MEDIUMINT UNSIGNED) 47 480 rows affected 49RUN INSERT INTO t_mediumint VALUES (-8388608, 0) 50 511 rows affected 52RUN INSERT INTO t_mediumint VALUES (-1, 1) 53 541 rows affected 55RUN INSERT INTO t_mediumint VALUES (0, 8388607) 56 571 rows affected 58RUN INSERT INTO t_mediumint VALUES (1, 16777214) 59 601 rows affected 61RUN INSERT INTO t_mediumint VALUES (8388607, 16777215) 62 631 rows affected 64RUN CREATE TABLE t_int (c1 INT, c2 INT UNSIGNED) 65 660 rows affected 67RUN INSERT INTO t_int VALUES (-2147483648, 0) 68 691 rows affected 70RUN INSERT INTO t_int VALUES (-1, 1) 71 721 rows affected 73RUN INSERT INTO t_int VALUES (0, 2147483647) 74 751 rows affected 76RUN INSERT INTO t_int VALUES (1, 4294967294) 77 781 rows affected 79RUN INSERT INTO t_int VALUES (2147483647, 4294967295) 80 811 rows affected 82RUN CREATE TABLE t_integer (c1 INTEGER, c2 INTEGER UNSIGNED) 83 840 rows affected 85RUN INSERT INTO t_integer VALUES (-2147483648, 0) 86 871 rows affected 88RUN INSERT INTO t_integer VALUES (-1, 1) 89 901 rows affected 91RUN INSERT INTO t_integer VALUES (0, 2147483647) 92 931 rows affected 94RUN INSERT INTO t_integer VALUES (1, 4294967294) 95 961 rows affected 97RUN INSERT INTO t_integer VALUES (2147483647, 4294967295) 98 991 rows affected 100RUN CREATE TABLE t_bigint (c1 BIGINT, c2 BIGINT UNSIGNED) 101 1020 rows affected 103RUN INSERT INTO t_bigint VALUES (-9223372036854775808, 0) 104 1051 rows affected 106RUN INSERT INTO t_bigint VALUES (-1, 1) 107 1081 rows affected 109RUN INSERT INTO t_bigint VALUES (0, 9223372036854775807) 110 1111 rows affected 112RUN INSERT INTO t_bigint VALUES (1, 18446744073709551614) 113 1141 rows affected 115RUN INSERT INTO t_bigint VALUES (9223372036854775807, 18446744073709551615) 116 1171 rows affected 118RUN SELECT * FROM t_tinyint 119c1 c2 120-128 0 121-1 1 1220 127 1231 200 124127 255 1250 rows affected 126RUN SELECT * FROM t_smallint 127c1 c2 128-32768 0 129-1 1 1300 32767 1311 65534 13232767 65535 1330 rows affected 134RUN SELECT * FROM t_mediumint 135c1 c2 136-8388608 0 137-1 1 1380 8388607 1391 16777214 1408388607 16777215 1410 rows affected 142RUN SELECT * FROM t_int 143c1 c2 144-2147483648 0 145-1 1 1460 2147483647 1471 4294967294 1482147483647 4294967295 1490 rows affected 150RUN SELECT * FROM t_bigint 151c1 c2 152-9223372036854775808 0 153-1 1 1540 9223372036854775807 1551 18446744073709551614 1569223372036854775807 18446744073709551615 1570 rows affected 158RUN CREATE TABLE t_decimal1 (c1 DECIMAL(2,1), c2 DECIMAL(2,1) UNSIGNED) 159 1600 rows affected 161RUN INSERT INTO t_decimal1 VALUES (-1.1, 0.0) 162 1631 rows affected 164RUN INSERT INTO t_decimal1 VALUES (-9.9, 9.8) 165 1661 rows affected 167RUN INSERT INTO t_decimal1 VALUES (9.9, 9.9) 168 1691 rows affected 170RUN CREATE TABLE t_decimal2 (c1 DECIMAL(64,30), c2 DECIMAL(64,30) UNSIGNED) 171 1720 rows affected 173RUN INSERT INTO t_decimal2 VALUES (-1234567890123456789012345678901234.567890123456789012345678901234, 1234567890123456789012345678901234.567890123456789012345678901234) 174 1751 rows affected 176RUN INSERT INTO t_decimal2 VALUES (9234567890123456789012345678901234.567890123456789012345678901234, 9234567890123456789012345678901234.567890123456789012345678901234) 177 1781 rows affected 179RUN INSERT INTO t_decimal2 VALUES (0, 0) 180 1811 rows affected 182RUN CREATE TABLE t_numeric1 (c1 NUMERIC(2,1), c2 NUMERIC(2,1) UNSIGNED) 183 1840 rows affected 185RUN INSERT INTO t_numeric1 VALUES (-1.1, 0.0) 186 1871 rows affected 188RUN INSERT INTO t_numeric1 VALUES (-9.9, 9.8) 189 1901 rows affected 191RUN INSERT INTO t_numeric1 VALUES (9.9, 9.9) 192 1931 rows affected 194RUN CREATE TABLE t_numeric2 (c1 NUMERIC(64,30), c2 NUMERIC(64,30) UNSIGNED) 195 1960 rows affected 197RUN INSERT INTO t_numeric2 VALUES (-1234567890123456789012345678901234.567890123456789012345678901234, 1234567890123456789012345678901234.567890123456789012345678901234) 198 1991 rows affected 200RUN INSERT INTO t_numeric2 VALUES (9234567890123456789012345678901234.567890123456789012345678901234, 9234567890123456789012345678901234.567890123456789012345678901234) 201 2021 rows affected 203RUN INSERT INTO t_numeric2 VALUES (0, 0) 204 2051 rows affected 206RUN SELECT * FROM t_decimal1 207c1 c2 208-1.1 0.0 209-9.9 9.8 2109.9 9.9 2110 rows affected 212RUN SELECT * FROM t_decimal2 213c1 c2 214-1234567890123456789012345678901234.567890123456789012345678901234 1234567890123456789012345678901234.567890123456789012345678901234 2159234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234 2160.000000000000000000000000000000 0.000000000000000000000000000000 2170 rows affected 218RUN SELECT * FROM t_numeric1 219c1 c2 220-1.1 0.0 221-9.9 9.8 2229.9 9.9 2230 rows affected 224RUN SELECT * FROM t_numeric2 225c1 c2 226-1234567890123456789012345678901234.567890123456789012345678901234 1234567890123456789012345678901234.567890123456789012345678901234 2279234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234 2280.000000000000000000000000000000 0.000000000000000000000000000000 2290 rows affected 230RUN CREATE TABLE t_real (c1 REAL, c2 REAL UNSIGNED) 231 2320 rows affected 233RUN INSERT INTO t_real VALUES (-1220.001, 0) 234 2351 rows affected 236RUN INSERT INTO t_real VALUES (-1.01, 1.201) 237 2381 rows affected 239RUN INSERT INTO t_real VALUES (1235.67, 11235.67) 240 2411 rows affected 242RUN CREATE TABLE t_float (c1 FLOAT, c2 FLOAT UNSIGNED) 243 2440 rows affected 245RUN INSERT INTO t_float VALUES (-1220223.00221, 0.0001) 246 2471 rows affected 248RUN INSERT INTO t_float VALUES (-1.02323, 1.2333) 249 2501 rows affected 251RUN INSERT INTO t_float VALUES (123522.67, 112352.67) 252 2531 rows affected 254RUN CREATE TABLE t_double (c1 DOUBLE, c2 DOUBLE UNSIGNED) 255 2560 rows affected 257RUN INSERT INTO t_double VALUES (-122022323.0230221, 2320.0012301) 258 2591 rows affected 260RUN INSERT INTO t_double VALUES (-1.232023231, 1231231231.23331231) 261 2621 rows affected 263RUN INSERT INTO t_double VALUES (1235212322.6123123, 11235212312322.671) 264 2651 rows affected 266RUN SELECT * FROM t_real 267c1 c2 268-1220.001 0 269-1.01 1.201 2701235.67 11235.67 2710 rows affected 272RUN SELECT * FROM t_float 273c1 c2 274-1220220 0.0001 275-1.02323 1.2333 276123523 112353 2770 rows affected 278RUN SELECT * FROM t_double 279c1 c2 280-122022323.0230221 2320.0012301 281-1.232023231 1231231231.2333124 2821235212322.6123123 11235212312322.672 2830 rows affected 284RUN CREATE TABLE t_date (c1 DATE, c2 TIME, c3 TIMESTAMP, c4 DATETIME, c5 YEAR) 285 2860 rows affected 287RUN INSERT INTO t_date VALUES ('2015-07-23', '16:34:12', '2015-07-23 16:34:12', '2015-07-23 16:34:12', '2015') 288 2891 rows affected 290RUN INSERT INTO t_date VALUES ('0-1-1', '-1:0:0.12', '2000-1-1 0:0:2', '0-1-1', '1999') 291 2921 rows affected 293RUN SELECT * FROM t_date 294c1 c2 c3 c4 c5 2952015/07/23 00:00:00 16:34:12 2015/07/23 16:34:12 2015/07/23 16:34:12 2015 2960000/01/01 00:00:00 -01:00:00 2000/01/01 00:00:02 0000/01/01 00:00:00 1999 2970 rows affected 298RUN CREATE TABLE t_lob (c1 TINYBLOB, 299 c2 BLOB, 300 c3 MEDIUMBLOB, 301 c4 LONGBLOB, 302 c5 TINYTEXT, 303 c6 TEXT, 304 c7 MEDIUMTEXT, 305 c8 LONGTEXT, 306 c9 TINYTEXT BINARY, 307 c10 TEXT BINARY, 308 c11 MEDIUMTEXT BINARY, 309 c12 LONGTEXT BINARY) 310 3110 rows affected 312RUN INSERT INTO t_lob VALUES ('','','','','','','','','','','','') 313 3141 rows affected 315RUN INSERT INTO t_lob VALUES ('tinyblob-text readable','blob-text readable','mediumblob-text readable', 316 'longblob-text readable','tinytext','text','mediumtext','longtext', 317 'tinytext-binary\nnext line','text-binary\nnext line', 318 'mediumtext-binary\nnext line','longtext-binary \nnext line') 319 3201 rows affected 321RUN SELECT * FROM t_lob 322c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 323 324tinyblob-text readable blob-text readable mediumblob-text readable longblob-text readable tinytext text mediumtext longtext tinytext-binary 325next line text-binary 326next line mediumtext-binary 327next line longtext-binary 328next line 3290 rows affected 330RUN CREATE TABLE t_bit (c1 BIT(1), c2 BIT(64)) 331 3320 rows affected 333RUN INSERT INTO t_bit VALUES (b'0', b'0') 334 3351 rows affected 336RUN INSERT INTO t_bit VALUES (b'1', b'1') 337 3381 rows affected 339RUN INSERT INTO t_bit VALUES (b'1', b'1111111111111111111111111111111111111111111111111111111111111111') 340 3411 rows affected 342RUN CREATE TABLE t_enum (c1 ENUM('v1','v2','v3'), c2 ENUM('')) 343 3440 rows affected 345RUN INSERT INTO t_enum VALUES ('v1', '') 346 3471 rows affected 348RUN INSERT INTO t_enum VALUES ('v2', '') 349 3501 rows affected 351RUN CREATE TABLE t_set (c1 SET('v1','v2','v3'), c2 SET('')) 352 3530 rows affected 354RUN INSERT INTO t_set VALUES ('v1,v1,v2', '') 355 3561 rows affected 357RUN INSERT INTO t_set VALUES ('', '') 358 3591 rows affected 360RUN SELECT * FROM t_bit 361c1 c2 3620 0 3631 1 3641 18446744073709551615 3650 rows affected 366RUN SELECT * FROM t_enum 367c1 c2 368v1 369v2 3700 rows affected 371RUN SELECT * FROM t_set 372c1 c2 373v1,v2 374 3750 rows affected 376RUN drop schema if exists xtest 377 37818 rows affected 379Mysqlx.Ok { 380 msg: "bye!" 381} 382ok 383uninstall plugin mysqlx; 384