diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2016-12-31 23:30:09 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2016-12-31 23:30:09 +0300 |
commit | cfb59f3196aac1b41cdda79952031dcc64042914 (patch) | |
tree | 3833cd1f2f4f2360eb3a16bd7ae4606e8493dea8 /storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result | |
parent | ebfc4e6ad02b0cef34ec3f446007b98d85af9296 (diff) | |
download | mariadb-git-cfb59f3196aac1b41cdda79952031dcc64042914.tar.gz |
Copy of
commit f6ed777697db4ad7aee1e98c53243dced2b5891c
Author: Chenyu Yan <seayan@outlook.com>
Date: Thu Dec 29 16:10:25 2016 -0800
Fix BIG_TIMEOUT constant
Summary: Update the constant to reflect what the comments indicates.
Reviewed By: gunnarku
Differential Revision: D4374476
fbshipit-source-id: dd7f484
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result | 76 |
1 files changed, 0 insertions, 76 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result b/storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result index 7a7a5c7638c..7397ff64ab1 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result @@ -1,80 +1,4 @@ drop table if exists t1, t2; -# -# Check that DECIMAL PK -# -create table t0(a int); -insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); -# First, make the server to create a dataset in the old format: -set session debug= '+d,MYROCKS_FORMAT_VERSION_INITIAL'; -create table t1 ( -pk1 decimal(32,16), -pk2 decimal(32,16), -pk3 decimal(32,16), -a smallint not null, -primary key(pk1, pk2, pk3) -); -insert into t1 -select -A.a, B.a, C.a, 1234 -from t0 A, t0 B, t0 C; -# -# Looking at the table size, one can tell that the data is stored using -# old format: -# -set global rocksdb_force_flush_memtable_now=1; -# Check the format version: -select table_name,index_name,kv_format_version -from information_schema.ROCKSDB_DDL -where TABLE_SCHEMA=database() AND table_name='t1'; -table_name index_name kv_format_version -t1 PRIMARY 10 -flush tables; -set session debug= '-d,MYROCKS_FORMAT_VERSION_INITIAL'; -# Check that the new server reads the data in the old format: -select * from t1 order by pk1,pk2,pk3 limit 5; -pk1 pk2 pk3 a -0.0000000000000000 0.0000000000000000 0.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 1.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 2.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 3.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 4.0000000000000000 1234 -# -# Ok, now, enable the new data format: -# -create table t2 ( -pk1 decimal(32,16), -pk2 decimal(32,16), -pk3 decimal(32,16), -a smallint not null, -primary key(pk1, pk2, pk3) -); -insert into t2 -select -A.a, B.a, C.a, 1234 -from t0 A, t0 B, t0 C; -set global rocksdb_force_flush_memtable_now=1; -larger -1 -# This should show the new PK data fromat -select table_name,index_name,kv_format_version from information_schema.ROCKSDB_DDL -where TABLE_SCHEMA=database() AND table_name='t2'; -table_name index_name kv_format_version -t2 PRIMARY 11 -# -# Check that the server is able to read BOTH the old and the new formats: -# -select * from t2 limit 3; -pk1 pk2 pk3 a -0.0000000000000000 0.0000000000000000 0.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 1.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 2.0000000000000000 1234 -select * from t1 limit 3; -pk1 pk2 pk3 a -0.0000000000000000 0.0000000000000000 0.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 1.0000000000000000 1234 -0.0000000000000000 0.0000000000000000 2.0000000000000000 1234 -drop table t1,t2; -drop table t0; # # Check that DECIMAL datatype supports 'index-only' scans and is decoded correctly. # (Decoding happens from the mem-comparable image in the index, regardless |