>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
