diff options
author | monty@hundin.mysql.fi <> | 2002-05-16 23:35:09 +0300 |
---|---|---|
committer | monty@hundin.mysql.fi <> | 2002-05-16 23:35:09 +0300 |
commit | 0c5c517db61c8d1e0753a310ec38d0c6b41827b2 (patch) | |
tree | cbcb80b627d5f9bc7c0b27150bbdef3cd36d22aa /mysql-test/r/show_check.result | |
parent | f5ed8784a24f12262bd01be3df63d5c891adf306 (diff) | |
download | mariadb-git-0c5c517db61c8d1e0753a310ec38d0c6b41827b2.tar.gz |
Fixed some compilation problems in last changeset
Diffstat (limited to 'mysql-test/r/show_check.result')
-rw-r--r-- | mysql-test/r/show_check.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index 50d910564d0..2c32d766a38 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -146,3 +146,28 @@ t1 CREATE TABLE `t1` ( KEY `b` (`b`) ) TYPE=MyISAM drop table t1; +create table t1 (a decimal(9,2), b decimal (9,0), e double(9,2), f double(5,0), h float(3,2), i float(3,0)); +show columns from t1; +Field Type Null Key Default Extra +a decimal(9,2) YES NULL +b decimal(9,0) YES NULL +e double(9,2) YES NULL +f double(5,0) YES NULL +h float(3,2) YES NULL +i float(3,0) YES NULL +drop table t1; +create table t1 (c decimal, d double, f float, r real); +show columns from t1; +Field Type Null Key Default Extra +c decimal(10,0) YES NULL +d double YES NULL +f float YES NULL +r double YES NULL +drop table t1; +create table t1 (c decimal(3,3), d double(3,3), f float(3,3)); +show columns from t1; +Field Type Null Key Default Extra +c decimal(4,3) YES NULL +d double(4,3) YES NULL +f float(4,3) YES NULL +drop table t1; |