diff options
Diffstat (limited to '')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/index_file_map.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/index_file_map.result b/storage/rocksdb/mysql-test/rocksdb/r/index_file_map.result new file mode 100644 index 00000000..ad007d71 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/index_file_map.result @@ -0,0 +1,31 @@ +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +CREATE TABLE t1 (i INT PRIMARY KEY, j INT, INDEX(j)) ENGINE = ROCKSDB; +CREATE TABLE t2 (k INT PRIMARY KEY, l INT REFERENCES t1.i) ENGINE = ROCKSDB; +INSERT INTO t1 VALUES (1,2), (2,4), (3,6), (4,8), (5,10); +INSERT INTO t2 VALUES (100,1), (200,2), (300,3), (400,4); +COMMIT; +SET GLOBAL rocksdb_force_flush_memtable_now = 1; +SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP +WHERE INDEX_NUMBER = +(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.ROCKSDB_DDL +WHERE TABLE_NAME = 't1' AND INDEX_NAME = "PRIMARY"); +COLUMN_FAMILY INDEX_NUMBER SST_NAME NUM_ROWS DATA_SIZE ENTRY_DELETES ENTRY_SINGLEDELETES ENTRY_MERGES ENTRY_OTHERS DISTINCT_KEYS_PREFIX +# # SSTNAME 5 # # # # # 5 +SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP +WHERE INDEX_NUMBER = +(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.ROCKSDB_DDL +WHERE TABLE_NAME = 't1' AND INDEX_NAME = "j"); +COLUMN_FAMILY INDEX_NUMBER SST_NAME NUM_ROWS DATA_SIZE ENTRY_DELETES ENTRY_SINGLEDELETES ENTRY_MERGES ENTRY_OTHERS DISTINCT_KEYS_PREFIX +# # SSTNAME 5 # # # # # 5,5 +SELECT * FROM INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP +WHERE INDEX_NUMBER = +(SELECT INDEX_NUMBER FROM INFORMATION_SCHEMA.ROCKSDB_DDL +WHERE TABLE_NAME = 't2' AND INDEX_NAME = "PRIMARY"); +COLUMN_FAMILY INDEX_NUMBER SST_NAME NUM_ROWS DATA_SIZE ENTRY_DELETES ENTRY_SINGLEDELETES ENTRY_MERGES ENTRY_OTHERS DISTINCT_KEYS_PREFIX +# # SSTNAME 4 # # # # # 4 +select count(*) > 0 from information_schema.rocksdb_sst_props; +count(*) > 0 +1 +DROP TABLE t1; +DROP TABLE t2; |