Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL)
-
RHEL 6
Description
Given the following server options:
explicit_defaults_for_timestamp
|
sql_mode=ANSI,NO_ZERO_DATE
|
and the following table creation code:
create table test ( |
a int, |
ts timestamp not null |
);
|
The server throws the following error:
SQL Error (1067): Invalid default value for 'ts'
Why can't we create a table with TIMESTAMP field like a normal data type, where we force the user to specify a value, but without providing a default?
(Remove the part about INSERT statement, since it seems to cause some confusion)