Default page

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
Dir : ~/www/server/mysql/mysql-test/suite/x/r/
View File Name : result_types.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 unsigneds (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)

0 rows affected
RUN create table test_d (f float, d double)

0 rows affected
RUN insert into test_d values (1.0/81, 1.0/81)

1 rows affected
RUN insert into test_d values (1234567890.1234567890,1234567890.1234567890)

1 rows affected
RUN select * from test_d
f	d
0.0123457	0.012345679
1234570000	1234567890.1234567
0 rows affected
send Mysqlx.Sql.StmtExecute {
  stmt: "select * from unsigneds"
}

Mysqlx.Resultset.ColumnMetaData {
  type: UINT
  name: "i"
  original_name: "i"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 0
  length: 10
  flags: 0
}

Mysqlx.Resultset.ColumnMetaData {
  type: UINT
  name: "b"
  original_name: "b"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 0
  length: 20
  flags: 0
}

Mysqlx.Resultset.ColumnMetaData {
  type: UINT
  name: "t"
  original_name: "t"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 0
  length: 3
  flags: 0
}

Mysqlx.Resultset.ColumnMetaData {
  type: UINT
  name: "s"
  original_name: "s"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 0
  length: 5
  flags: 0
}

Mysqlx.Resultset.ColumnMetaData {
  type: FLOAT
  name: "f"
  original_name: "f"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 31
  length: 12
  flags: 1
}

Mysqlx.Resultset.ColumnMetaData {
  type: DOUBLE
  name: "d"
  original_name: "d"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 31
  length: 22
  flags: 1
}

Mysqlx.Resultset.ColumnMetaData {
  type: DECIMAL
  name: "de"
  original_name: "de"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 2
  length: 11
  flags: 1
}

Mysqlx.Resultset.ColumnMetaData {
  type: DATETIME
  name: "dt"
  original_name: "dt"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 0
  length: 19
  flags: 0
}

Mysqlx.Resultset.ColumnMetaData {
  type: DATETIME
  name: "ts"
  original_name: "ts"
  table: "unsigneds"
  original_table: "unsigneds"
  schema: "xtest"
  catalog: "def"
  collation: 0
  fractional_digits: 0
  length: 19
  flags: 1
}

Mysqlx.Resultset.FetchDone {
}

Mysqlx.Notice.Frame {
  type: 3
  scope: LOCAL
  payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n  type: V_UINT\n  v_unsigned_int: 0\n}\n }"
}

Mysqlx.Sql.StmtExecuteOk {
}

Mysqlx.Ok {
  msg: "bye!"
}
ok
drop schema xtest;
uninstall plugin mysqlx;