Hello anonymous,
On 8/9/2011 10:57, Database System wrote:
> Have you tested on 5.0 or 5.1?
> I did test on both 5.0 and 5.1 (Windows) before I said that.
>
I duplicated my results using a 5.0 server, too.... maybe you need to
check your earlier test again, eh?
#### the server #####
110809 11:51:03 InnoDB: Started; log sequence number 0 45289
110809 11:51:03 [Note] mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community
Edition (GPL)
#### the client session #####
localhost.(none)>use test
Database changed
localhost.test>show tables;
Empty set (0.00 sec)
localhost.test>show global variables like '%version%';
+-------------------------+-------------------------------+
| Variable_name | Value |
+-------------------------+-------------------------------+
| protocol_version | 10 |
| version | 5.0.37-community-nt |
| version_comment | MySQL Community Edition (GPL) |
| version_compile_machine | ia32 |
| version_compile_os | Win32 |
+-------------------------+-------------------------------+
5 rows in set (0.00 sec)
localhost.test>create temporary table temp2(b int) engine=memory;
Query OK, 0 rows affected (0.02 sec)
localhost.test>show tables;
Empty set (0.00 sec)
localhost.test>insert temp2 (b) values (1),(2),(3);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
##### the .frm file ##############
C:\DOCUME~1\shawn\LOCALS~1\Temp>dir *.frm
Volume in drive C is System
Volume Serial Number is 325B-0199
Directory of C:\DOCUME~1\shawn\LOCALS~1\Temp
File Not Found
C:\DOCUME~1\shawn\LOCALS~1\Temp>dir *.frm
Volume in drive C is System
Volume Serial Number is 325B-0199
Directory of C:\DOCUME~1\shawn\LOCALS~1\Temp
08/09/2011 11:53 8,554 #sql1574_1_0.frm
1 File(s) 8,554 bytes
##########
I am sorry you decided to not post your test case for us to review. Is
there some kind of flaw in my demonstration that you might care to point
out?
Note: I took two directory listings. The first was to prove that the
same temporary table .frm file was not there from the last test. The
second was to show the presence from this test. The timestamp on the
new file indicates it was created AFTER I started the server. Unless I
come to your machine and show you myself, I cannot seem to make this
point any clearer:
** All MySQL tables will have a .frm file ***
You just need to know where to look. If you don't believe me, read the
source.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
