###MY_VER_RANGE [5.0.11_beta,5.0.11_beta] diff -Naur mysql.orig/mysql-test/r/view.result mysql.new/mysql-test/r/view.result --- mysql.orig/mysql-test/r/view.result 2005-08-13 04:20:59.000000000 +0200 +++ mysql.new/mysql-test/r/view.result 2005-08-13 04:29:43.000000000 +0200 @@ -2021,17 +2021,6 @@ DROP PROCEDURE p1; DROP VIEW v1; DROP TABLE t1; -create table t1 (f1 tinyint(1), f2 char(1), f3 varchar(1), f4 geometry, f5 datetime); -create view v1 as select * from t1; -desc v1; -Field Type Null Key Default Extra -f1 tinyint(1) YES NULL -f2 char(1) YES NULL -f3 varchar(1) YES NULL -f4 geometry YES NULL -f5 datetime YES NULL -drop view v1; -drop table t1; create table t1(f1 datetime); insert into t1 values('2005.01.01 12:0:0'); create view v1 as select f1, subtime(f1, '1:1:1') as sb from t1; diff -Naur mysql.orig/mysql-test/t/gis-view.test mysql.new/mysql-test/t/gis-view.test --- mysql.orig/mysql-test/t/gis-view.test 1970-01-01 01:00:00.000000000 +0100 +++ mysql.new/mysql-test/t/gis-view.test 2005-08-13 04:27:30.000000000 +0200 @@ -0,0 +1,11 @@ +-- source include/have_geometry.inc + +# +# Bug #11335 View redefines column types +# +create table t1 (f1 tinyint(1), f2 char(1), f3 varchar(1), f4 geometry, f5 datetime); +create view v1 as select * from t1; +desc v1; +drop view v1; +drop table t1; + diff -Naur mysql.orig/mysql-test/t/view.test mysql.new/mysql-test/t/view.test --- mysql.orig/mysql-test/t/view.test 2005-08-13 04:20:44.000000000 +0200 +++ mysql.new/mysql-test/t/view.test 2005-08-13 04:28:53.000000000 +0200 @@ -1856,15 +1856,6 @@ DROP TABLE t1; # -# Bug #11335 View redefines column types -# -create table t1 (f1 tinyint(1), f2 char(1), f3 varchar(1), f4 geometry, f5 datetime); -create view v1 as select * from t1; -desc v1; -drop view v1; -drop table t1; - -# # Bug #11760 Typo in Item_func_add_time::print() results in NULLs returned # subtime() in view create table t1(f1 datetime); diff -Naur mysql.orig/mysql-test/r/gis-view.result mysql.new/mysql-test/r/gis-view.result --- mysql.orig/mysql-test/r/gis-view.result 1970-01-01 01:00:00.000000000 +0100 +++ mysql.new/mysql-test/r/gis-view.result 2005-08-15 19:11:19.000000000 +0200 @@ -0,0 +1,11 @@ +create table t1 (f1 tinyint(1), f2 char(1), f3 varchar(1), f4 geometry, f5 datetime); +create view v1 as select * from t1; +desc v1; +Field Type Null Key Default Extra +f1 tinyint(1) YES NULL +f2 char(1) YES NULL +f3 varchar(1) YES NULL +f4 geometry YES NULL +f5 datetime YES NULL +drop view v1; +drop table t1;