diff options
| author | dlenev@jabberwock.localdomain <> | 2004-04-02 10:12:53 +0400 |
|---|---|---|
| committer | dlenev@jabberwock.localdomain <> | 2004-04-02 10:12:53 +0400 |
| commit | f6bff2e6c662d4778f86a919b6f7b731d2553f44 (patch) | |
| tree | 9a60588328f7225c26e34d7cf0ce3ae4875c3523 /mysql-test/r/show_check.result | |
| parent | 4533338075714e2be7d4cfc8b2825cb52917603f (diff) | |
| download | mariadb-git-f6bff2e6c662d4778f86a919b6f7b731d2553f44.tar.gz | |
WL#1266 "Separate auto-set logic from TIMESTAMP type."
Final version of patch.
Adds support for specifying of DEFAULT NOW() and/or ON UPDATE NOW()
clauses for TIMESTAMP field definition.
Current implementation allows only one such field per table and
uses several unireg types for storing info about this properties of
field. It should be replaced with better implementation when new
.frm format is introduced.
Diffstat (limited to 'mysql-test/r/show_check.result')
| -rw-r--r-- | mysql-test/r/show_check.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index 3693d92693f..5a5eb025353 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -225,7 +225,7 @@ t1 CREATE TABLE `t1` ( `empty_char` char(0) default NULL, `type_char` char(2) default NULL, `type_varchar` varchar(10) default NULL, - `type_timestamp` timestamp NOT NULL, + `type_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `type_date` date NOT NULL default '0000-00-00', `type_time` time NOT NULL default '00:00:00', `type_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |