diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-12-05 00:31:05 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-12-05 00:31:05 -0800 |
| commit | b110132516158382e72a75a3c7b26dc538c2f23d (patch) | |
| tree | 2eb709d57dbae8f8a909008b1546cb395728d8fe /mysql-test/r/stat_tables.result | |
| parent | f8bfb65b132dae3472d3f4f88995e4cad7f72ebf (diff) | |
| download | mariadb-git-b110132516158382e72a75a3c7b26dc538c2f23d.tar.gz | |
Changed the names of the system tables for statistical data:
table_stat -> table_stats
column_stat -> column_stats
index_stat -> index_stats
to be in line with the names of innodb statistical tables
from mysql-5.6: innodb_table_stats and innodb_index_stats.
Diffstat (limited to 'mysql-test/r/stat_tables.result')
| -rw-r--r-- | mysql-test/r/stat_tables.result | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/r/stat_tables.result b/mysql-test/r/stat_tables.result index 169266fea25..6905725a6a2 100644 --- a/mysql-test/r/stat_tables.result +++ b/mysql-test/r/stat_tables.result @@ -11,7 +11,7 @@ CREATE DATABASE dbt3_s001; use dbt3_s001; set @save_optimizer_switch=@@optimizer_switch; set optimizer_switch='extended_keys=off'; -select * from mysql.table_stat; +select * from mysql.table_stats; db_name table_name cardinality dbt3_s001 customer 150 dbt3_s001 lineitem 6005 @@ -21,7 +21,7 @@ dbt3_s001 part 200 dbt3_s001 partsupp 700 dbt3_s001 region 5 dbt3_s001 supplier 10 -select * from mysql.index_stat; +select * from mysql.index_stats; db_name table_name index_name prefix_arity avg_frequency dbt3_s001 customer PRIMARY 1 1.0000 dbt3_s001 customer i_c_nationkey 1 6.0000 @@ -83,8 +83,8 @@ n_name revenue PERU 321915.8715 ARGENTINA 69817.1451 set optimizer_switch=@save_optimizer_switch; -delete from mysql.index_stat; -select * from mysql.table_stat; +delete from mysql.index_stats; +select * from mysql.table_stats; db_name table_name cardinality dbt3_s001 customer 150 dbt3_s001 lineitem 6005 @@ -94,7 +94,7 @@ dbt3_s001 part 200 dbt3_s001 partsupp 700 dbt3_s001 region 5 dbt3_s001 supplier 10 -select * from mysql.index_stat; +select * from mysql.index_stats; db_name table_name index_name prefix_arity avg_frequency dbt3_s001 customer PRIMARY 1 1.0000 dbt3_s001 customer i_c_nationkey 1 6.0000 @@ -124,24 +124,24 @@ dbt3_s001 partsupp i_ps_suppkey 1 70.0000 dbt3_s001 region PRIMARY 1 1.0000 dbt3_s001 supplier PRIMARY 1 1.0000 dbt3_s001 supplier i_s_nationkey 1 1.1111 -select * from mysql.table_stat where table_name='orders'; +select * from mysql.table_stats where table_name='orders'; db_name table_name cardinality dbt3_s001 orders 1500 -select * from mysql.index_stat where table_name='orders'; +select * from mysql.index_stats where table_name='orders'; db_name table_name index_name prefix_arity avg_frequency dbt3_s001 orders PRIMARY 1 1.0000 dbt3_s001 orders i_o_orderdate 1 1.3321 dbt3_s001 orders i_o_custkey 1 15.0000 -select (select cardinality from mysql.table_stat where table_name='orders') / -(select avg_frequency from mysql.index_stat +select (select cardinality from mysql.table_stats where table_name='orders') / +(select avg_frequency from mysql.index_stats where index_name='i_o_orderdate' and prefix_arity=1) as n_distinct; n_distinct 1126.0416 select count(distinct o_orderdate) from orders; count(distinct o_orderdate) 1126 -select (select cardinality from mysql.table_stat where table_name='orders') / -(select avg_frequency from mysql.index_stat +select (select cardinality from mysql.table_stats where table_name='orders') / +(select avg_frequency from mysql.index_stats where index_name='i_o_custkey' and prefix_arity=1) as n_distinct; n_distinct 100.0000 |