List:General Discussion« Previous MessageNext Message »
From:Anton Krasovsky Date:July 18 1999 8:50am
Subject:bug: Heap tables problems updated
View as plain text  
>Description:
        Heap tables is not gone after "drop database"

>How-To-Repeat:
mysql> create database t;
Query OK, 1 row affected (0.04 sec)

mysql> use t;
Database changed

mysql> create table test (id int) TYPE = HEAP;
Query OK, 0 rows affected (0.02 sec)

mysql> insert  into test (id) values(1);
Query OK, 1 row affected (0.00 sec)

mysql> insert  into test (id) values(2);
Query OK, 1 row affected (0.01 sec)

mysql> select * from test;
+------+
| id   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)

drop database t;
Query OK, 0 rows affected (0.02 sec)

mysql> create database t;
Query OK, 1 row affected (0.03 sec)

mysql> use t;
Database changed

mysql> create table test (id int) TYPE = HEAP;
Query OK, 0 rows affected (0.02 sec)

mysql> select * from test;
+------+
| id   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)

>Fix:
	??

>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:			38 min 39 sec

Threads: 1  Questions: 15  Slow queries: 0  Opens: 10  Flush tables: 1  Open tables: 3
>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
bug: Heap tables problems updatedAnton Krasovsky18 Jul