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, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
