List:General Discussion« Previous MessageNext Message »
From:Anton Krasovsky Date:July 16 1999 2:05pm
Subject:Heap tables problems
View as plain text  
>Description:
	Heap tables is not gone after "drop database"
	Rows from heap tables is not deleted with "delete from <tablename>"
>How-To-Repeat:

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

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> select * from test;
+------+
| id   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)

--------------------------------------

mysql> delete from test;
Query OK, 0 rows affected (0.00 sec)

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


>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:			2 hours 11 min 0 sec

Threads: 4  Questions: 26738  Slow queries: 0  Opens: 175  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
Heap tables problemsAnton Krasovsky16 Jul