diff options
author | unknown <monty@mysql.com> | 2003-12-15 17:58:15 +0200 |
---|---|---|
committer | unknown <monty@mysql.com> | 2003-12-15 17:58:15 +0200 |
commit | ec2e2c3af6f73b4d0a734510bc6ba74d2bb30e8c (patch) | |
tree | c239203a39c21349557d871ff1f29dd16ab0a5bc /mysql-test/t/create.test | |
parent | 8bc3575eebe7110466ef4fb0250fe7bffe48c9ee (diff) | |
download | mariadb-git-ec2e2c3af6f73b4d0a734510bc6ba74d2bb30e8c.tar.gz |
Added missing timeout function for named pipes and shared memory (fixes core dump on windows)
Signed auto_increment keys for HASH tables (like for MyISAM tables in 4.0)
nitialize system_charset_info() early. Fixes core dump when starting windows service
heap/hp_hash.c:
Signed auto_increment keys for HASH tables (like for MyISAM tables in 4.0)
mysql-test/r/create.result:
More test for type returned by if_null()
mysql-test/t/create.test:
More test for type returned by if_null()
sql/field.h:
Remove not needed functions
sql/item.cc:
Use normal field create function instead of special functions just made for tmp_table_field_from_field_type
sql/mysqld.cc:
Initialize system_charset_info() early. Fixes core dump when starting windows service
vio/vio.c:
Added missing timeouts for named pipes and shared memory (fixes core dump on windows)
vio/vio_priv.h:
Added missing timeout function for named pipes and shared memory (fixes core dump on windows)
vio/viosocket.c:
Added missing timeout function for named pipes and shared memory (fixes core dump on windows)
Diffstat (limited to 'mysql-test/t/create.test')
-rw-r--r-- | mysql-test/t/create.test | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index 54166c3b0dc..23d7cc8c347 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -318,11 +318,17 @@ select addtime(cast('1:0:0' as time),cast('1:0:0' as time)) as dd from t1; explain t2; - select * from t2; - drop table t1, t2; +create table t1 (a tinyint, b smallint, c mediumint, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), i year, j date, k timestamp, l datetime, m enum('a','b'), n set('a','b'), o char(10)); +create table t2 select ifnull(a,a), ifnull(b,b), ifnull(c,c), ifnull(d,d), ifnull(e,e), ifnull(f,f), ifnull(g,g), ifnull(h,h), ifnull(i,i), ifnull(j,j), ifnull(k,k), ifnull(l,l), ifnull(m,m), ifnull(n,n), ifnull(o,o) from t1; +show create table t2; +drop table t1,t2; + +# +# Test of default() +# create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default '10',rel double default '3.14'); insert into t1 values ('','',0,0.0); describe t1; |