From 7bfac8a581db95199b2ee3543ac4e77274e07519 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 26 Apr 2002 13:56:32 +0300 Subject: Don't change FLOAT(X+1,X) to FLOAT(X+2,X) Docs/manual.texi: ChangeLog mysql-test/r/show_check.result: Updated test for SHOW COLUMNS mysql-test/t/show_check.test: Updated test for SHOW COLUMNS --- mysql-test/t/show_check.test | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 0981b85c91e..e9c7ffa6bb8 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -73,3 +73,17 @@ drop table t1; create table t1 (a int not null, primary key (a)); show create table t1; 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; +drop table t1; + +# Check auto conversions of types + +create table t1 (c decimal, d double, f float, r real); +show columns from t1; +drop table t1; + +create table t1 (c decimal(3,3), d double(3,3), f float(3,3)); +show columns from t1; +drop table t1; -- cgit v1.2.1