diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2018-08-28 08:23:44 +0000 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2018-08-28 08:23:44 +0000 |
commit | faa4d8f8c6c12c09541c4733773ac700c5e643cf (patch) | |
tree | e98b7393973b010f7307595a04ce4a46d4108754 /storage/rocksdb/mysql-test/rocksdb/r/cardinality.result | |
parent | 445e518bc7aa5f4bb48d98e798905c9c0b0ce673 (diff) | |
download | mariadb-git-faa4d8f8c6c12c09541c4733773ac700c5e643cf.tar.gz |
Copy of
commit de1e8c7bfe7c875ea284b55040e8f3cd3a56fcc2
Author: Abhinav Sharma <abhinavsharma@fb.com>
Date: Thu Aug 23 14:34:39 2018 -0700
Log updates to semi-sync whitelist in the error log
Summary:
Plugin variable changes are not logged in the error log even when
log_global_var_changes is enabled. Logging updates to whitelist will help in
debugging.
Reviewed By: guokeno0
Differential Revision: D9483807
fbshipit-source-id: e111cda773d
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/cardinality.result')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/cardinality.result | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/cardinality.result b/storage/rocksdb/mysql-test/rocksdb/r/cardinality.result index 94585af6cfc..029c68ae6b1 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/cardinality.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/cardinality.result @@ -82,4 +82,19 @@ t1 1 t1_5 2 c1 A 100000 NULL NULL YES LSMTREE SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE(); table_name table_rows t1 100000 -drop table t1; +CREATE TABLE t2 (a INT, b INT, c INT, d INT, e INT, f INT, g INT, +PRIMARY KEY (a), KEY (c, b, a, d, e, f, g)) +ENGINE=ROCKSDB; +SET GLOBAL rocksdb_force_flush_memtable_now = 1; +ANALYZE TABLE t2; +Table Op Msg_type Msg_text +test.t2 analyze status OK +cardinality of the columns after 'a' must be equal to the cardinality of column 'a' +SELECT CARDINALITY INTO @c FROM information_schema.statistics WHERE TABLE_NAME='t2' AND INDEX_NAME='c' AND COLUMN_NAME='a'; +SELECT COLUMN_NAME, CARDINALITY = @c FROM information_schema.statistics WHERE TABLE_NAME='t2' AND INDEX_NAME='c' AND SEQ_IN_INDEX > 3; +COLUMN_NAME CARDINALITY = @c +d 1 +e 1 +f 1 +g 1 +drop table t1, t2; |