[MDEV-3549] LP:801212 - Assertion with ST_INTERSECTION on NULL values in maria-5.3-gis Created: 2011-06-23  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug801212.xml    

 Description   

IF any of the arguments to ST_INTERSECTION is NULL for some reason, such as wrong WKT syntax, the server will assert as follows:

mysqld: item.cc:5907: virtual bool Item::send(Protocol*, String*): Assertion `!null_value' failed.

/lib/libc.so.6(__assert_fail+0xf8) [0x6b0d98]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(Item::send(Protocol*, String*)+0x91) [0x81db873]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(select_send::send_data(List<Item>&)+0x106) [0x8288f24]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(JOIN::exec()+0x3f4) [0x8325d74]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x3c2) [0x8328790]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x1cd) [0x832065b]
/home/philips/bzr/maria-5.3-gis/sql/mysqld() [0x82bbd8b]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(mysql_execute_command(THD*)+0x71e) [0x82b2b8f]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x26f) [0x82be3c7]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x8e3) [0x82b082b]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(do_command(THD*)+0x27d) [0x82afcb1]
/home/philips/bzr/maria-5.3-gis/sql/mysqld(handle_one_connection+0x170) [0x82acd2c]

test case:

SELECT ST_INTERSECTION ( NULL , NULL ) ;

bzr version-info
revision-id: <email address hidden>
date: 2011-06-20 00:21:41 +0500
build-date: 2011-06-23 18:34:56 +0300
revno: 2982
branch-nick: maria-5.3-gis



 Comments   
Comment by Alexey Botchkov [ 2011-07-04 ]

Re: Assertion with ST_INTERSECTION on NULL values in maria-5.3-gis
fix pushed into the 5.3-gis.

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 801212

Generated at Thu Feb 08 06:49:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.