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, Technical Yahoo - Yahoo Finance Desk: (408) 328-7878 Fax: (408) 530-5454 Cell: (408) 439-9951