diff options
| author | msvensson@neptunus.(none) <> | 2005-06-20 12:09:00 +0200 |
|---|---|---|
| committer | msvensson@neptunus.(none) <> | 2005-06-20 12:09:00 +0200 |
| commit | 6282d89b0ac7c63d80e96652522454ebd35cd4f6 (patch) | |
| tree | ecb120195a20a720aad13a60b47ca0692b2cdb99 /mysql-test/t/update.test | |
| parent | 6674e1e12e33399cd1f73d868a1aa0fb8d843f11 (diff) | |
| download | mariadb-git-6282d89b0ac7c63d80e96652522454ebd35cd4f6.tar.gz | |
bug#10466: Datatype "timestamp" displays "YYYYMMDDHHMMSS" irrespective of display sizes.
- Print warning that says display width is not supported for datatype TIMESTAMP, if user tries to create a TIMESTAMP column with display width.
- Use display width for TIMESTAMP only in type_timestamp test to make sure warning is displayed correctly.
Diffstat (limited to 'mysql-test/t/update.test')
| -rw-r--r-- | mysql-test/t/update.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 6a90fb95760..21789a550b9 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -31,7 +31,7 @@ CREATE TABLE t1 clicks int(10) unsigned DEFAULT '0' NOT NULL, iclicks int(10) unsigned DEFAULT '0' NOT NULL, uclicks int(10) unsigned DEFAULT '0' NOT NULL, - ts timestamp(14), + ts timestamp, PRIMARY KEY (place_id,ts) ); @@ -52,7 +52,7 @@ CREATE TABLE t1 ( replyto varchar(255) NOT NULL default '', subject varchar(100) NOT NULL default '', timestamp int(10) unsigned NOT NULL default '0', - tstamp timestamp(14) NOT NULL, + tstamp timestamp NOT NULL, status int(3) NOT NULL default '0', type varchar(15) NOT NULL default '', assignment int(10) unsigned NOT NULL default '0', |