[MDEV-3690] LP:776285 - Crash when updating multiple equality const-ness during constant table optimization in make_join_statistics Created: 2011-05-03  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: Timour Katchaounov (Inactive) Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug776285.xml    

 Description   

The following test case extracted from the test for LP BUG#715759
results in a crash (NULL pointer):

CREATE TABLE t1 (a1 int, a2 int) ;
INSERT INTO t1 VALUES (1, 2);
INSERT INTO t1 VALUES (3, 4);

CREATE TABLE t2 (b1 int, b2 int) ;
INSERT INTO t2 VALUES (1, 2);

SELECT b1 FROM t2 WHERE b1 = b2;

 Comments   
Comment by Timour Katchaounov (Inactive) [ 2011-05-03 ]

Re: Crash when updating multiple equality const-ness during constant table optimization in make_join_statistics
The stack trace is:

#0 0x000000000060b4e5 in Item_func::Item_func (this=0x44b5870, a=0x44b4ac0, b=0x0) at item_func.h:82
#1 0x000000000060b5db in Item_int_func::Item_int_func (this=0x44b5870, a=0x44b4ac0, b=0x0) at item_func.h:402
#2 0x000000000060be35 in Item_bool_func2::Item_bool_func2 (this=0x44b5870, a=0x44b4ac0, b=0x0) at item_cmpfunc.h:356
#3 0x000000000060c0d9 in Item_bool_rowready_func2::Item_bool_rowready_func2 (this=0x44b5870, a=0x44b4ac0, b=0x0) at item_cmpfunc.h:389
#4 0x000000000060c3a7 in Item_func_eq::Item_func_eq (this=0x44b5870, a=0x44b4ac0, b=0x0) at item_cmpfunc.h:494
#5 0x000000000060a434 in Item_equal::add_const (this=0x44b4ee0, c=0x44b4ac0, f=0x0) at item_cmpfunc.cc:5621
#6 0x000000000060a6c1 in Item_equal::update_const (this=0x44b4ee0) at item_cmpfunc.cc:5750
#7 0x000000000073f9dc in update_const_equal_items (cond=0x44b4ee0, tab=0x44b5108) at sql_select.cc:10349
#8 0x0000000000749a9f in join_read_const_table (tab=0x44b5108, pos=0x44ca028) at sql_select.cc:14374
#9 0x000000000072dd4f in make_join_statistics (join=0x44c7100, tables_arg=0x44b4620, conds=0x44b4ee0, keyuse_array=0x44cd098) at sql_select.cc:3023
#10 0x0000000000726c23 in JOIN::optimize (this=0x44c7100) at sql_select.cc:992

Comment by Timour Katchaounov (Inactive) [ 2011-05-03 ]

Re: Crash when updating multiple equality const-ness during constant table optimization in make_join_statistics
The bug is reproducible in 5.3 with the following tip:

revno: 2977
committer: Vladislav Vaintroub <wlad@montyprogram.com>
branch nick: 5.3
timestamp: Mon 2011-05-02 13:02:36 +0200
message:
Shoot in the dark - try to fight build environment based on cygwin, where
presumably neither TMP nor TEMP environment variable are set.

Comment by Philip Stoev (Inactive) [ 2011-05-03 ]

Re: Crash when updating multiple equality const-ness during constant table optimization in make_join_statistics
see bug https://bugs.launchpad.net/maria/+bug/776274

Comment by Igor Babaev [ 2011-05-03 ]

Re: Crash when updating multiple equality const-ness during constant table optimization in make_join_statistics
This is an exact duplicate of LP bug #776274

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

Launchpad bug id: 776285

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