Re: a crash bug

2011-02-28 Thread Roy Lyseng
Hi zhongtao, thank you for reporting this bug. It has been filed as http://bugs.mysql.com/bug.php?id=60279 Regards, Roy On 24.02.11 08.08, tanzhongt wrote: create table t1(a int); create table t2(b int); PREPAREstmt FROM "select sum(b) from t2 group by b having b in (select b from t1

a crash bug

2011-02-24 Thread tanzhongt
Hi: I find a crash bug, version is mysql 5.5.8 Just try: use test; drop table if exists t1,t2; create table t1(a int); create table t2(b int); PREPAREstmt FROM "select sum(b) from t2 group by b having b in (select b from t1)"; execute stmt;

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-29 Thread Sergei Golubchik
Hi! On Dec 29, Derek J wrote: > Hello, >First, Yes I can create repeatable test case, I still have live > server with the same problem. and another Dual opteron server, which i > created the same database there as a test to make sure there are no > hardware faliures casuing this probles, but i

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-29 Thread Derek J
Hello, First, Yes I can create repeatable test case, I still have live server with the same problem. and another Dual opteron server, which i created the same database there as a test to make sure there are no hardware faliures casuing this probles, but i still had the same problem there too. I

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-29 Thread Sergei Golubchik
Hi! On Dec 28, Derek J wrote: > Hello Every Body , > I have been facing a strange problem, that i assume its a mysql bug of > some sort. > > In my datadabase there are 2 tables, if i tried to add any index to them > ,any INSERT INTO request status will be - in show processlist- update > and will

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-28 Thread Derek J
I have enough disk space for indexes, the problem doesn't happen during adding an index. it happens after the index is added. On Sun, 2003-12-28 at 21:33, mos wrote: > At 06:28 PM 12/28/2003, you wrote: > >Hello Every Body , > >I have been facing a strange problem, that i assume its a mysql bug of

Re: ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-28 Thread mos
At 06:28 PM 12/28/2003, you wrote: Hello Every Body , I have been facing a strange problem, that i assume its a mysql bug of some sort. In my datadabase there are 2 tables, if i tried to add any index to them ,any INSERT INTO request status will be - in show processlist- update and will freeze like

ADDING INDEXES TO A TABLE LEADS TO MYSQL CRASH, BUG!!

2003-12-28 Thread Derek J
Hello Every Body , I have been facing a strange problem, that i assume its a mysql bug of some sort. In my datadabase there are 2 tables, if i tried to add any index to them ,any INSERT INTO request status will be - in show processlist- update and will freeze like this forever , and consequently

Re: crash bug with ORDER BY text

2002-03-01 Thread Christopher Thompson
For what it is worth, this does NOT cause 3.23.41 to crash. On Friday 01 March 2002 3:47 pm, Tony J. White wrote: > Using versions 3.23.47 or 3.23.49a on linux i386 precompiled binaries. > > Using ORDER BY on a column that is type text causes a crash. > > The following MySQL Query crashes it's My

crash bug with ORDER BY text

2002-03-01 Thread Tony J. White
Using versions 3.23.47 or 3.23.49a on linux i386 precompiled binaries. Using ORDER BY on a column that is type text causes a crash. The following MySQL Query crashes it's MySQL thread: create table test ( id int, note text); insert into test

Re: Crash bug

2002-02-04 Thread Sasha Pachev
On Monday 04 February 2002 07:33 pm, [EMAIL PROTECTED] wrote: > Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt one) > Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT indicies, > it will crash the mysqld daemon. Thanks for the

Crash bug

2002-02-04 Thread szii
Version: 4.0.1 binary distro(I have gcc 2.96, so I'm using your prebuilt one) Synopsis: Upon executing a query using the MATCH() clause with FULLTEXT indicies, it will crash the mysqld daemon. The query that does this is a "multi table" query, as such.. MATCH(table1.col1, tabl