[MDEV-2786] LP:693935 - Assert failure for a query with a single row subquery Created: 2010-12-23  Updated: 2012-10-04  Resolved: 2012-10-04

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

Type: Bug Priority: Critical
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug693935.xml    

 Description   

The following query triggers an assert failure in the current mariadb 5.1 tree:

select * from t2 where a=(select a from t1) and a='x';

To reproduce the failure create and populate t1,t2 with these commands:
create table t1 (a char(1) charset utf8);
insert into t1 values ('a'), ('b');
create table t2 (a binary(1));
insert into t2 values ('x'), ('y');

The failure looks like this (e.g in gdb):
Version: '5.1.54-MariaDB-debug' socket: '/tmp/mysql.sock' port: 3307 Source distribution
[New Thread 0x8ce62b90 (LWP 15193)]
mysqld: item_strfunc.cc:2755: virtual String* Item_func_conv_charset::val_str(String*): Assertion `fixed == 1' failed.

Program received signal SIGABRT, Aborted.



 Comments   
Comment by Igor Babaev [ 2010-12-23 ]

Re: Assert failure for a query with a single row subquery
Quite a similar bug was reported for the current tree of mysql-5.1:
MySQL Bugs: #58727: jump to invalid code in Arg_comparator::compare
bugs.mysql.com/bug.php?id=58727

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

Launchpad bug id: 693935

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