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: | |
| 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: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.
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: .