diff options
| author | monty@hundin.mysql.fi <> | 2002-05-16 18:20:49 +0300 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-05-16 18:20:49 +0300 |
| commit | f5ed8784a24f12262bd01be3df63d5c891adf306 (patch) | |
| tree | 12de711f3f9d8ad9eee9d28cf71e5487f17315d3 /mysql-test/t/show_check.test | |
| parent | 4ca4f4788b2a591d52cdb5e0fe69aee2b09975ac (diff) | |
| parent | f092818715de15211638b8fd0913f151417d3450 (diff) | |
| download | mariadb-git-f5ed8784a24f12262bd01be3df63d5c891adf306.tar.gz | |
merge with 3.23.51
Diffstat (limited to 'mysql-test/t/show_check.test')
| -rw-r--r-- | mysql-test/t/show_check.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index 2613fc17866..5e10ebf23a3 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -75,3 +75,17 @@ show create table t1; ALTER TABLE t1 AVG_ROW_LENGTH=0 CHECKSUM=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 PACK_KEYS=DEFAULT DELAY_KEY_WRITE=0 ROW_FORMAT=default; 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; |