default values for date columns are implicitly typecast to DATE in CREATE TABLE but not stored that way in table message
Bug #611097 reported by
Stewart Smith
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Low
|
Stewart Smith | ||
Dexter |
Fix Released
|
Low
|
Stewart Smith |
Bug Description
create table t1 (da date default '1962-03-03 23:33:34', dt datetime default '1962-03-03');
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`da` date DEFAULT '1962-03-03',
`dt` datetime DEFAULT '1962-03-03 00:00:00'
) ENGINE=DEFAULT COLLATE = utf8_general_ci
Related branches
lp:~stewart/drizzle/bug611097-default-values-for-date-typecast-in-table-message
- Brian Aker: Pending requested
- Drizzle Merge Team: Pending requested
-
Diff: 81 lines (+41/-2)2 files modifieddrizzled/table_proto_write.cc (+39/-0)
tests/r/data_dictionary_like_info.result (+2/-2)
To post a comment you must log in.