diff options
| author | unknown <dlenev@brandersnatch.localdomain> | 2004-08-06 12:15:40 +0400 |
|---|---|---|
| committer | unknown <dlenev@brandersnatch.localdomain> | 2004-08-06 12:15:40 +0400 |
| commit | 2d4c9c6247ed5626fa8335d05693907322b2cbc0 (patch) | |
| tree | 6d52fcb56e4dc192c20a75cd40e4b40e95f46d21 /mysql-test/r | |
| parent | e040eeb4a2b2ef1277bdbc2e31052d8258dde564 (diff) | |
| download | mariadb-git-2d4c9c6247ed5626fa8335d05693907322b2cbc0.tar.gz | |
Fix for bug #4491 "timestamp(19) doesn't work".
We should allow 19 as length of newly created TIMESTAMP fields.
mysql-test/r/type_timestamp.result:
Added test of TIMESTAMP(19) support.
mysql-test/t/type_timestamp.test:
Added test of TIMESTAMP(19) support.
sql/sql_parse.cc:
add_field_to_list(): TIMESTAMP columns should also support 19 as length since it is
length of 4.1 compatible representation.
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/type_timestamp.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/type_timestamp.result b/mysql-test/r/type_timestamp.result index cd45bcf911d..752a5045eb0 100644 --- a/mysql-test/r/type_timestamp.result +++ b/mysql-test/r/type_timestamp.result @@ -167,3 +167,15 @@ ts1 ts2 2001-09-09 04:46:40 0000-00-00 00:00:00 2001-09-09 04:46:40 0000-00-00 00:00:00 drop table t1; +create table t1 (ts timestamp(19)); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `ts` timestamp(19) NOT NULL +) TYPE=MyISAM +set TIMESTAMP=1000000000; +insert into t1 values (); +select * from t1; +ts +2001-09-09 04:46:40 +drop table t1; |