summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-11-28 18:00:42 +0100
committerunknown <serg@serg.mylan>2004-11-28 18:00:42 +0100
commit4c9c3f32de96fd9a35ee1a9337dab1da6f99fddb (patch)
treeb55d52f733dbdc505481362e8f37b353b9efd93c /mysql-test/r/view.result
parent63c3ab1e6cd763eb2829f6de037c1c7c62f8573e (diff)
downloadmariadb-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.result8
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;