"Fossies" - the Fresh Open Source Software Archive

Member "mariadb-10.4.10/storage/tokudb/mysql-test/tokudb_add_index/r/1522.result" (7 Nov 2019, 454 Bytes) of package /linux/misc/mariadb-10.4.10.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 SET DEFAULT_STORAGE_ENGINE='tokudb';
    2 DROP TABLE IF EXISTS t1;
    3 create table t1 (a int, b int) engine=tokudb;
    4 insert into t1 values (1,1),(1,2),(2,1),(2,2);
    5 select count(*) from t1 where b > 0;
    6 count(*)
    7 4
    8 alter table t1 add index b(b) clustering=yes;
    9 explain select count(*) from t1 where b > 0;
   10 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   11 1	SIMPLE	t1	NA	b	b	5	NA	NA	NA
   12 select count(*) from t1 where b > 0;
   13 count(*)
   14 4
   15 DROP TABLE t1;