Bug #12435 Geometry column type is silently changed
Submitted: 8 Aug 2005 13:19 Modified: 11 Aug 2005 14:47
Reporter: Joerg Bruehe Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.11 OS:64 bit: AIX 5.2; Solaris 8,9,10
Assigned to: Assigned Account CPU Architecture:Any

[8 Aug 2005 13:19] Joerg Bruehe
Description:
Build of 5.0.11, based on ChangeSet
  1.1950.1.1 05/08/06 03:10:35 kent@mysql.com +1 -0
  make_win_src_distribution.sh:
    Added missing backslashes

Test failure:
-------------------------------------------------------
*** r/view.result
--- r/view.reject
***************
*** 2028,2034
  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;
--- 2028,2034
  f1    tinyint(1)      YES             NULL
  f2    char(1) YES             NULL
  f3    varchar(1)      YES             NULL
! f4    point   YES             NULL
  f5    datetime        YES             NULL
  drop view v1;
  drop table t1;
-------------------------------------------------------

This is a "view description" output following the command sequence
   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;
so column f4 got a different type than demanded.

Occurs in all 5 products (debug, standard, max, pro, and cluster)
in both default and PS-protocol tests
on aix52-64bit, butch-64bit, sol10-sparc-a-64bit, and sunfire100a-64bit.

How to repeat:
Build + test
[11 Aug 2005 14:46] Evgeny Potemkin
Fixed by fix for bug #12281