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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.