List:General Discussion« Previous MessageNext Message »
From:Anton Krasovsky Date:July 16 1999 3:05pm
Subject:HEAP tables & indexes troubles
View as plain text  
>Description:
	unable to perform selects from heap tables
	using < or > when key field is indexed

	mysql dumps core when removing index from 
	heap table 
	
>How-To-Repeat:

mysql> select id from active where id > 10;
+--------+
| id     |
+--------+
| 869751 |
| 736494 |
| 226312 |
| 802616 |
|  67585 |
| 451952 |
| 668080 |
| 806056 |
| 113455 |
| 773451 |
|  85834 |
+--------+
11 rows in set (0.01 sec)

mysql> alter table active add unique uniq_id(id);
Query OK, 11 rows affected (0.09 sec)
Records: 11  Duplicates: 0  Warnings: 0

mysql> select id from active where id > 10;
Empty set (0.01 sec)

mysql> alter table active drop index uniq_id;
ERROR 2013: Segmentation fault - core dumped
Lost connection to MySQL server during query

>Fix:
	unknown

>Submitter-Id:	<submitter ID>
>Originator:	Anton Krasovsky
>Organization:
 
>MySQL support: none
>Synopsis:	?
>Severity:	serious
>Priority:	medium
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.23.1-alpha (Source distribution)
>Server: /usr/local/mysql/bin/mysqladmin  Ver 7.11 Distrib 3.23.1-alpha, for
> unknown-freebsdelf3.2 on i386
TCX Datakonsult AB, by Monty

Server version		3.23.1-alpha-log
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			1 min 19 sec

Threads: 1  Questions: 5977  Slow queries: 0  Opens: 81  Flush tables: 1  Open tables: 16
>Environment:

System: FreeBSD rainbow.rime.com.ua 3.2-RELEASE FreeBSD 3.2-RELEASE #0: Tue May 18
04:05:08 GMT 1999     jkh@cathair:/usr/src/sys/compile/GENERIC  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: gcc version 2.7.2.1
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.005_03 built for i386-freebsd
Thread
HEAP tables & indexes troublesAnton Krasovsky16 Jul
  • HEAP tables & indexes troublesMichael Widenius31 Jul