summaryrefslogtreecommitdiff
path: root/storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2016-12-31 23:30:09 +0300
committerSergei Petrunia <psergey@askmonty.org>2016-12-31 23:30:09 +0300
commitcfb59f3196aac1b41cdda79952031dcc64042914 (patch)
tree3833cd1f2f4f2360eb3a16bd7ae4606e8493dea8 /storage/rocksdb/mysql-test/rocksdb/r/type_decimal.result
parentebfc4e6ad02b0cef34ec3f446007b98d85af9296 (diff)
downloadmariadb-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.result76
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