⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
x
/
r
/
View File Name :
fieldtypes_all.result
install plugin mysqlx soname "mysqlx.so"; call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key.."); call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed."); RUN create schema xtest 1 rows affected RUN use xtest 0 rows affected RUN CREATE TABLE t_tinyint (c1 TINYINT, c2 TINYINT UNSIGNED) 0 rows affected RUN INSERT INTO t_tinyint VALUES (-128, 0) 1 rows affected RUN INSERT INTO t_tinyint VALUES (-1, 1) 1 rows affected RUN INSERT INTO t_tinyint VALUES (0, 127) 1 rows affected RUN INSERT INTO t_tinyint VALUES (1, 200) 1 rows affected RUN INSERT INTO t_tinyint VALUES (127, 255) 1 rows affected RUN CREATE TABLE t_smallint (c1 SMALLINT, c2 SMALLINT UNSIGNED) 0 rows affected RUN INSERT INTO t_smallint VALUES (-32768, 0) 1 rows affected RUN INSERT INTO t_smallint VALUES (-1, 1) 1 rows affected RUN INSERT INTO t_smallint VALUES (0, 32767) 1 rows affected RUN INSERT INTO t_smallint VALUES (1, 65534) 1 rows affected RUN INSERT INTO t_smallint VALUES (32767, 65535) 1 rows affected RUN CREATE TABLE t_mediumint (c1 MEDIUMINT, c2 MEDIUMINT UNSIGNED) 0 rows affected RUN INSERT INTO t_mediumint VALUES (-8388608, 0) 1 rows affected RUN INSERT INTO t_mediumint VALUES (-1, 1) 1 rows affected RUN INSERT INTO t_mediumint VALUES (0, 8388607) 1 rows affected RUN INSERT INTO t_mediumint VALUES (1, 16777214) 1 rows affected RUN INSERT INTO t_mediumint VALUES (8388607, 16777215) 1 rows affected RUN CREATE TABLE t_int (c1 INT, c2 INT UNSIGNED) 0 rows affected RUN INSERT INTO t_int VALUES (-2147483648, 0) 1 rows affected RUN INSERT INTO t_int VALUES (-1, 1) 1 rows affected RUN INSERT INTO t_int VALUES (0, 2147483647) 1 rows affected RUN INSERT INTO t_int VALUES (1, 4294967294) 1 rows affected RUN INSERT INTO t_int VALUES (2147483647, 4294967295) 1 rows affected RUN CREATE TABLE t_integer (c1 INTEGER, c2 INTEGER UNSIGNED) 0 rows affected RUN INSERT INTO t_integer VALUES (-2147483648, 0) 1 rows affected RUN INSERT INTO t_integer VALUES (-1, 1) 1 rows affected RUN INSERT INTO t_integer VALUES (0, 2147483647) 1 rows affected RUN INSERT INTO t_integer VALUES (1, 4294967294) 1 rows affected RUN INSERT INTO t_integer VALUES (2147483647, 4294967295) 1 rows affected RUN CREATE TABLE t_bigint (c1 BIGINT, c2 BIGINT UNSIGNED) 0 rows affected RUN INSERT INTO t_bigint VALUES (-9223372036854775808, 0) 1 rows affected RUN INSERT INTO t_bigint VALUES (-1, 1) 1 rows affected RUN INSERT INTO t_bigint VALUES (0, 9223372036854775807) 1 rows affected RUN INSERT INTO t_bigint VALUES (1, 18446744073709551614) 1 rows affected RUN INSERT INTO t_bigint VALUES (9223372036854775807, 18446744073709551615) 1 rows affected RUN SELECT * FROM t_tinyint c1 c2 -128 0 -1 1 0 127 1 200 127 255 0 rows affected RUN SELECT * FROM t_smallint c1 c2 -32768 0 -1 1 0 32767 1 65534 32767 65535 0 rows affected RUN SELECT * FROM t_mediumint c1 c2 -8388608 0 -1 1 0 8388607 1 16777214 8388607 16777215 0 rows affected RUN SELECT * FROM t_int c1 c2 -2147483648 0 -1 1 0 2147483647 1 4294967294 2147483647 4294967295 0 rows affected RUN SELECT * FROM t_bigint c1 c2 -9223372036854775808 0 -1 1 0 9223372036854775807 1 18446744073709551614 9223372036854775807 18446744073709551615 0 rows affected RUN CREATE TABLE t_decimal1 (c1 DECIMAL(2,1), c2 DECIMAL(2,1) UNSIGNED) 0 rows affected RUN INSERT INTO t_decimal1 VALUES (-1.1, 0.0) 1 rows affected RUN INSERT INTO t_decimal1 VALUES (-9.9, 9.8) 1 rows affected RUN INSERT INTO t_decimal1 VALUES (9.9, 9.9) 1 rows affected RUN CREATE TABLE t_decimal2 (c1 DECIMAL(64,30), c2 DECIMAL(64,30) UNSIGNED) 0 rows affected RUN INSERT INTO t_decimal2 VALUES (-1234567890123456789012345678901234.567890123456789012345678901234, 1234567890123456789012345678901234.567890123456789012345678901234) 1 rows affected RUN INSERT INTO t_decimal2 VALUES (9234567890123456789012345678901234.567890123456789012345678901234, 9234567890123456789012345678901234.567890123456789012345678901234) 1 rows affected RUN INSERT INTO t_decimal2 VALUES (0, 0) 1 rows affected RUN CREATE TABLE t_numeric1 (c1 NUMERIC(2,1), c2 NUMERIC(2,1) UNSIGNED) 0 rows affected RUN INSERT INTO t_numeric1 VALUES (-1.1, 0.0) 1 rows affected RUN INSERT INTO t_numeric1 VALUES (-9.9, 9.8) 1 rows affected RUN INSERT INTO t_numeric1 VALUES (9.9, 9.9) 1 rows affected RUN CREATE TABLE t_numeric2 (c1 NUMERIC(64,30), c2 NUMERIC(64,30) UNSIGNED) 0 rows affected RUN INSERT INTO t_numeric2 VALUES (-1234567890123456789012345678901234.567890123456789012345678901234, 1234567890123456789012345678901234.567890123456789012345678901234) 1 rows affected RUN INSERT INTO t_numeric2 VALUES (9234567890123456789012345678901234.567890123456789012345678901234, 9234567890123456789012345678901234.567890123456789012345678901234) 1 rows affected RUN INSERT INTO t_numeric2 VALUES (0, 0) 1 rows affected RUN SELECT * FROM t_decimal1 c1 c2 -1.1 0.0 -9.9 9.8 9.9 9.9 0 rows affected RUN SELECT * FROM t_decimal2 c1 c2 -1234567890123456789012345678901234.567890123456789012345678901234 1234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234 0.000000000000000000000000000000 0.000000000000000000000000000000 0 rows affected RUN SELECT * FROM t_numeric1 c1 c2 -1.1 0.0 -9.9 9.8 9.9 9.9 0 rows affected RUN SELECT * FROM t_numeric2 c1 c2 -1234567890123456789012345678901234.567890123456789012345678901234 1234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234 9234567890123456789012345678901234.567890123456789012345678901234 0.000000000000000000000000000000 0.000000000000000000000000000000 0 rows affected RUN CREATE TABLE t_real (c1 REAL, c2 REAL UNSIGNED) 0 rows affected RUN INSERT INTO t_real VALUES (-1220.001, 0) 1 rows affected RUN INSERT INTO t_real VALUES (-1.01, 1.201) 1 rows affected RUN INSERT INTO t_real VALUES (1235.67, 11235.67) 1 rows affected RUN CREATE TABLE t_float (c1 FLOAT, c2 FLOAT UNSIGNED) 0 rows affected RUN INSERT INTO t_float VALUES (-1220223.00221, 0.0001) 1 rows affected RUN INSERT INTO t_float VALUES (-1.02323, 1.2333) 1 rows affected RUN INSERT INTO t_float VALUES (123522.67, 112352.67) 1 rows affected RUN CREATE TABLE t_double (c1 DOUBLE, c2 DOUBLE UNSIGNED) 0 rows affected RUN INSERT INTO t_double VALUES (-122022323.0230221, 2320.0012301) 1 rows affected RUN INSERT INTO t_double VALUES (-1.232023231, 1231231231.23331231) 1 rows affected RUN INSERT INTO t_double VALUES (1235212322.6123123, 11235212312322.671) 1 rows affected RUN SELECT * FROM t_real c1 c2 -1220.001 0 -1.01 1.201 1235.67 11235.67 0 rows affected RUN SELECT * FROM t_float c1 c2 -1220220 0.0001 -1.02323 1.2333 123523 112353 0 rows affected RUN SELECT * FROM t_double c1 c2 -122022323.0230221 2320.0012301 -1.232023231 1231231231.2333124 1235212322.6123123 11235212312322.672 0 rows affected RUN CREATE TABLE t_date (c1 DATE, c2 TIME, c3 TIMESTAMP, c4 DATETIME, c5 YEAR) 0 rows affected RUN INSERT INTO t_date VALUES ('2015-07-23', '16:34:12', '2015-07-23 16:34:12', '2015-07-23 16:34:12', '2015') 1 rows affected RUN INSERT INTO t_date VALUES ('0-1-1', '-1:0:0.12', '2000-1-1 0:0:2', '0-1-1', '1999') 1 rows affected RUN SELECT * FROM t_date c1 c2 c3 c4 c5 2015/07/23 00:00:00 16:34:12 2015/07/23 16:34:12 2015/07/23 16:34:12 2015 0000/01/01 00:00:00 -01:00:00 2000/01/01 00:00:02 0000/01/01 00:00:00 1999 0 rows affected RUN CREATE TABLE t_lob (c1 TINYBLOB, c2 BLOB, c3 MEDIUMBLOB, c4 LONGBLOB, c5 TINYTEXT, c6 TEXT, c7 MEDIUMTEXT, c8 LONGTEXT, c9 TINYTEXT BINARY, c10 TEXT BINARY, c11 MEDIUMTEXT BINARY, c12 LONGTEXT BINARY) 0 rows affected RUN INSERT INTO t_lob VALUES ('','','','','','','','','','','','') 1 rows affected RUN INSERT INTO t_lob VALUES ('tinyblob-text readable','blob-text readable','mediumblob-text readable', 'longblob-text readable','tinytext','text','mediumtext','longtext', 'tinytext-binary\nnext line','text-binary\nnext line', 'mediumtext-binary\nnext line','longtext-binary \nnext line') 1 rows affected RUN SELECT * FROM t_lob c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 tinyblob-text readable blob-text readable mediumblob-text readable longblob-text readable tinytext text mediumtext longtext tinytext-binary next line text-binary next line mediumtext-binary next line longtext-binary next line 0 rows affected RUN CREATE TABLE t_bit (c1 BIT(1), c2 BIT(64)) 0 rows affected RUN INSERT INTO t_bit VALUES (b'0', b'0') 1 rows affected RUN INSERT INTO t_bit VALUES (b'1', b'1') 1 rows affected RUN INSERT INTO t_bit VALUES (b'1', b'1111111111111111111111111111111111111111111111111111111111111111') 1 rows affected RUN CREATE TABLE t_enum (c1 ENUM('v1','v2','v3'), c2 ENUM('')) 0 rows affected RUN INSERT INTO t_enum VALUES ('v1', '') 1 rows affected RUN INSERT INTO t_enum VALUES ('v2', '') 1 rows affected RUN CREATE TABLE t_set (c1 SET('v1','v2','v3'), c2 SET('')) 0 rows affected RUN INSERT INTO t_set VALUES ('v1,v1,v2', '') 1 rows affected RUN INSERT INTO t_set VALUES ('', '') 1 rows affected RUN SELECT * FROM t_bit c1 c2 0 0 1 1 1 18446744073709551615 0 rows affected RUN SELECT * FROM t_enum c1 c2 v1 v2 0 rows affected RUN SELECT * FROM t_set c1 c2 v1,v2 0 rows affected RUN drop schema if exists xtest 18 rows affected Mysqlx.Ok { msg: "bye!" } ok uninstall plugin mysqlx;