Bug #30955 geomfromtext() crasher

Submitted: 11 Sep 2007 15:32 Modified: 8 Nov 2007 23:41
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Data Types Severity:S1 (Critical)
Version:5.1.23BK, 5.0.50BK OS:Any
Assigned to: Alexey Botchkov CPU Architecture:Any
Tags: geomfromtext, gis, spatial

[11 Sep 2007 15:32] Shane Bester
Description:
Got a crash on 5.0.48-enterprise today:
Stack trace (shortened):

!Gis_read_stream::get_next_word  Line 47
!Geometry::create_from_wkt  Line 171
!Item_func_geometry_from_text::val_str  Line 67
!Item::send  Line 4865
!select_send::send_data  Line 1025
!end_send Line 11377
!evaluate_join_record Line 10670
!sub_select  Line 10554
!do_select Line 10317
!JOIN::exec  Line 2069
!mysql_select  Line 2249
!handle_select  Line 255
!mysql_execute_command  Line 2666
!mysql_parse  Line 6092
!dispatch_command  Line 1812
!do_command  Line 1586
!handle_one_connection  Line 1197
!pthread_start  Line 62
!_threadstart Line 196

How to repeat:
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` ( `col9` set('a'), `col89` date) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `t1` VALUES ('','0000-00-00');
select geomfromtext(col9,col89) as a from t1;

Suggested fix:
.
[11 Sep 2007 15:40] Shane Bester
better stack traces for 5.0.48 and 5.1.23BK

Attachment: bug30955_stack_traces.txt (text/plain), 5.54 KiB.

[3 Oct 2007 9:42] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/34815

ChangeSet@1.2684, 2007-10-03 13:35:35+05:00, holyfoot@mysql.com +3 -0
  Bug #30955 geomfromtext() crasher.
  
  end-of-line check missed in Gis_read_stream::get_next_word,
  what can lead to crashes (expecially with NULL strings).
  
  End-of-line check added
[3 Oct 2007 10:18] Alexander Barkov
The patch http://lists.mysql.com/commits/34815 is ok to push
[29 Oct 2007 8:40] Bugs System
Pushed into 4.1.24
[29 Oct 2007 8:42] Bugs System
Pushed into 5.0.52
[29 Oct 2007 8:46] Bugs System
Pushed into 5.1.23-beta
[29 Oct 2007 8:49] Bugs System
Pushed into 6.0.4-alpha
[8 Nov 2007 23:41] Paul DuBois
Noted in 4.1.24, 5.0.52, 5.1.23, 6.0.4 changelogs.

The GeomFromText() function could cause a server crash if the first
argument was NULL or the empty string.

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

Page generated in 0.043 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.