summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <tsmith/tim@siva.hindu.god>2006-12-14 13:01:08 -0700
committerunknown <tsmith/tim@siva.hindu.god>2006-12-14 13:01:08 -0700
commitc21dfe323f261f0d0fef3faf68bc74b394d957d2 (patch)
tree2ce2946bd51a4c34cdea4b0ba145056924ec6e76
parent931dcc8a8328698397e7bd194eb1a7041e0d1970 (diff)
parent833b235b1804714fa3ef7bb58157eb3fec003dfe (diff)
downloadmariadb-git-c21dfe323f261f0d0fef3faf68bc74b394d957d2.tar.gz
Merge siva.hindu.god:/usr/home/tim/m/bk/41
into siva.hindu.god:/usr/home/tim/m/bk/50 mysql-test/t/myisam.test: Auto merged mysql-test/r/myisam.result: SCCS merged
-rw-r--r--mysql-test/r/myisam.result21
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result
index b9e656de6be..02bfe60e4a3 100644
--- a/mysql-test/r/myisam.result
+++ b/mysql-test/r/myisam.result
@@ -922,6 +922,27 @@ SET @@myisam_repair_threads=1;
SHOW VARIABLES LIKE 'myisam_repair%';
Variable_name Value
myisam_repair_threads 1
+show create table t1;
+Table Create Table
+t1 CREATE TEMPORARY TABLE `t1` (
+ `a` int(11) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQL_TEST_DIR/var/log/'
+show create table t1;
+Table Create Table
+t1 CREATE TEMPORARY TABLE `t1` (
+ `a` int(11) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='MYSQL_TEST_DIR/var/log/'
+create table t1 (a int) engine=myisam select 42 a;
+select * from t1;
+a
+9
+select * from t1;
+a
+99
+select * from t1;
+a
+42
+drop table t1;
set storage_engine=MyISAM;
drop table if exists t1,t2,t3;
--- Testing varchar ---