diff options
| author | Monty <monty@mariadb.org> | 2018-02-10 14:42:59 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2018-02-12 17:17:26 +0200 |
| commit | 54db0be3be5952de88074883b0aaaa749910566d (patch) | |
| tree | d4f6496405071d40491d57d2f3f15097a218f6bd /mysql-test/r/select_jcl6.result | |
| parent | 19dd14e648c56adb7dc7d14a4ea03d2b8ef147a5 (diff) | |
| download | mariadb-git-54db0be3be5952de88074883b0aaaa749910566d.tar.gz | |
Added Max_index_length and Temporary to SHOW TABLE STATUS
- Max_index_length is supported by MyISAM and Aria tables.
- Temporary is a placeholder to signal that a table is a
temporary table. For the moment this is always "N", except
"Y" for generated information_schema tables and NULL for
views. Full temporary table support will be done in another task.
(No reason to have to update a lot of result files twice in a row)
Diffstat (limited to 'mysql-test/r/select_jcl6.result')
| -rw-r--r-- | mysql-test/r/select_jcl6.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/select_jcl6.result b/mysql-test/r/select_jcl6.result index 92be057c62c..ffd1d4d5088 100644 --- a/mysql-test/r/select_jcl6.result +++ b/mysql-test/r/select_jcl6.result @@ -2666,9 +2666,9 @@ create table t1 (f1 int not null auto_increment primary key, f2 varchar(10)); create table t11 like t1; insert into t1 values(1,""),(2,""); show table status like 't1%'; -Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment -t1 MyISAM 10 Dynamic 2 20 X X X X X X X X latin1_swedish_ci NULL -t11 MyISAM 10 Dynamic 0 0 X X X X X X X X latin1_swedish_ci NULL +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +t1 MyISAM 10 Dynamic 2 20 X X X X X X X X latin1_swedish_ci NULL X N +t11 MyISAM 10 Dynamic 0 0 X X X X X X X X latin1_swedish_ci NULL X N select 123 as a from t1 where f1 is null; a drop table t1,t11; |