diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
| commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
| tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/sysschema/r/v_session.result | |
| parent | Initial commit. (diff) | |
| download | mariadb-upstream.tar.xz mariadb-upstream.zip | |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/sysschema/r/v_session.result')
| -rw-r--r-- | mysql-test/suite/sysschema/r/v_session.result | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/r/v_session.result b/mysql-test/suite/sysschema/r/v_session.result new file mode 100644 index 00000000..fd88b8f1 --- /dev/null +++ b/mysql-test/suite/sysschema/r/v_session.result @@ -0,0 +1,62 @@ +DESC sys.session; +Field Type Null Key Default Extra +thd_id bigint(20) unsigned NO NULL +conn_id bigint(20) unsigned YES NULL +user varchar(384) YES NULL +db varchar(64) YES NULL +command varchar(16) YES NULL +state varchar(64) YES NULL +time bigint(20) YES NULL +current_statement longtext YES NULL +statement_latency mediumtext YES NULL +progress decimal(26,2) YES NULL +lock_latency text YES NULL +rows_examined bigint(20) unsigned YES NULL +rows_sent bigint(20) unsigned YES NULL +rows_affected bigint(20) unsigned YES NULL +tmp_tables bigint(20) unsigned YES NULL +tmp_disk_tables bigint(20) unsigned YES NULL +full_scan varchar(3) YES NULL +last_statement longtext YES NULL +last_statement_latency mediumtext YES NULL +current_memory text YES NULL +last_wait varchar(128) YES NULL +last_wait_latency mediumtext YES NULL +source varchar(64) YES NULL +trx_latency text YES NULL +trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL +trx_autocommit enum('YES','NO') YES NULL +pid varchar(1024) YES NULL +program_name varchar(1024) YES NULL +SELECT * FROM sys.session; +DESC sys.x$session; +Field Type Null Key Default Extra +thd_id bigint(20) unsigned NO NULL +conn_id bigint(20) unsigned YES NULL +user varchar(384) YES NULL +db varchar(64) YES NULL +command varchar(16) YES NULL +state varchar(64) YES NULL +time bigint(20) YES NULL +current_statement longtext YES NULL +statement_latency bigint(20) unsigned YES NULL +progress decimal(26,2) YES NULL +lock_latency bigint(20) unsigned YES NULL +rows_examined bigint(20) unsigned YES NULL +rows_sent bigint(20) unsigned YES NULL +rows_affected bigint(20) unsigned YES NULL +tmp_tables bigint(20) unsigned YES NULL +tmp_disk_tables bigint(20) unsigned YES NULL +full_scan varchar(3) YES NULL +last_statement longtext YES NULL +last_statement_latency bigint(20) unsigned YES NULL +current_memory decimal(41,0) YES NULL +last_wait varchar(128) YES NULL +last_wait_latency varchar(20) YES NULL +source varchar(64) YES NULL +trx_latency bigint(20) unsigned YES NULL +trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL +trx_autocommit enum('YES','NO') YES NULL +pid varchar(1024) YES NULL +program_name varchar(1024) YES NULL +SELECT * FROM sys.x$session; |