summaryrefslogtreecommitdiff
path: root/mysql-test/r/show_check.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2002-05-16 23:35:09 +0300
committerunknown <monty@hundin.mysql.fi>2002-05-16 23:35:09 +0300
commit66f426c0635d16f7f594f6bf867e13e5cba18500 (patch)
treecbcb80b627d5f9bc7c0b27150bbdef3cd36d22aa /mysql-test/r/show_check.result
parent4d094257dbb785d792785e610ab3cdf41eae9b8c (diff)
downloadmariadb-git-66f426c0635d16f7f594f6bf867e13e5cba18500.tar.gz
Fixed some compilation problems in last changeset
Docs/manual.texi: Small changes regarind user resources client/mysqlbinlog.cc: Applied patch to support --database mysql-test/r/func_isnull.result: New test results mysql-test/r/join.result: New test results mysql-test/r/show_check.result: New test results mysql-test/r/type_datetime.result: New test results mysql-test/r/type_decimal.result: New test results mysql-test/r/type_float.result: New test results mysys/my_gethostbyname.c: Fixed type on last push mysys/my_pthread.c: Fixed type on last push sql/sql_select.cc: Fixed bug in LIMIT handling
Diffstat (limited to 'mysql-test/r/show_check.result')
-rw-r--r--mysql-test/r/show_check.result25
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;