diff options
author | unknown <serg@serg.mylan> | 2004-11-28 18:00:42 +0100 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2004-11-28 18:00:42 +0100 |
commit | 4c9c3f32de96fd9a35ee1a9337dab1da6f99fddb (patch) | |
tree | b55d52f733dbdc505481362e8f37b353b9efd93c /mysql-test/r/view.result | |
parent | 63c3ab1e6cd763eb2829f6de037c1c7c62f8573e (diff) | |
download | mariadb-git-4c9c3f32de96fd9a35ee1a9337dab1da6f99fddb.tar.gz |
view.test:
more max_rows for show table status
comment spellchecking...
mysql-test/r/view.result:
more max_rows for show table status
mysql-test/t/view.test:
more max_rows for show table status
comment spellchecking...
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r-- | mysql-test/r/view.result | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 4783085dec9..f4430ae1004 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -1213,18 +1213,14 @@ select * from v1; drop view v1; drop table t1; create function x1 () returns int return 5; -create table t1 (s1 int); +create table t1 (s1 int) max_rows=1000000; create view v1 as select x1() from t1; drop function x1; select * from v1; ERROR 42000: FUNCTION test.x1 does not exist show table status; 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 9 Fixed 0 0 0 21474836479 1024 0 NULL # # NULL latin1_swedish_ci NULL -v1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL FUNCTION test.x1 does not exist -show table status; -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 9 Fixed 0 0 0 21474836479 1024 0 NULL # # NULL latin1_swedish_ci NULL +t1 MyISAM 9 Fixed 0 0 0 83886079 1024 0 NULL # # NULL latin1_swedish_ci NULL max_rows=1000000 v1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # # NULL NULL NULL NULL FUNCTION test.x1 does not exist drop view v1; drop table t1; |