From: Jeremy D . Zawodny
Date: March 26 2001 6:01am
Subject: Re: Signal 11 on Innobase table range queries
List-Archive: http://lists.mysql.com/mysql/69481
Message-Id: <20010325220137.A80301@yahoo-inc.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote:
>
> I've got a reproducable signal 11 death in mysqld using Innobase
> tables and range queries (at least reproducable on my machine,
> Redhat 6.2, mysql 3.23.35).
> 
> Here's how it manifests itself: Create a table with at least 32
> columns.  Then load a row or two into the table and try to do any
> query using a range (>, <, between, in) on the primary key and i get
> this:
> 
> mysql> select * from foo where id > 1 limit 1;

[snip]

> Let me know if anyone can reproduce this, as it's quite the
> nuisance...

Yep. I've got a similar result here.

To reproduce you only need one row in the table:

---snip---

create table in_crash (

  a    int  primary key,
  b    int,
  c    int,
  d    int,
  e    int,
  f    int,
  g    int,
  h    int,
  i    int,
  j    int,
  k    int,
  l    int,
  m    int,
  n    int,
  o    int,
  p    int,
  q    int,
  r    int,
  s    int,
  t    int,
  u    int,
  v    int,
  w    int,
  x    int,
  y    int,
  z    int,
  a1   int,
  a2   int,
  a3   int,
  a4   int,
  a5   int,
  a6   int,
  a7   int,
  a8   int,
  a9   int,
  b1   int,
  b2   int,
  b3   int,
  b4   int,
  b5   int,
  b6   int

) type = Innobase;

insert into in_crash values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

explain select * from in_crash where a > 0 and a < 50;

*boom*

---snip---

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951