ifnull on timestamp doesn't work
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Invalid
|
High
|
Jay Pipes |
Bug Description
find out why this was needed:
--- /home/stewart/
+++ /home/stewart/
@@ -437,7 +437,7 @@
2 -2 2 1825-12-14 a 2003-01-01 03:02:01 04:03:02binary data 02:00:00
drop table t1, t2;
create table t1 (a int, b int, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), j date, k timestamp, l datetime, m enum('a','b'), o char(10));
-create table t2 select ifnull(a,a), ifnull(b,b), ifnull(d,d), ifnull(e,e), ifnull(f,f), ifnull(g,g), ifnull(h,h), ifnull(j,j), ifnull(k,k), ifnull(l,l), ifnull(m,m), ifnull(o,o) from t1;
+create table t2 select ifnull(a,a), ifnull(b,b), ifnull(d,d), ifnull(e,e), ifnull(f,f), ifnull(g,g), ifnull(h,h), ifnull(j,j), ifnull(l,l), ifnull(m,m), ifnull(o,o) from t1;
show create table t2;
Table Create Table
t2 CREATE TABLE `t2` (
@@ -449,7 +449,6 @@
`ifnull(g,g)` double(4,3),
`ifnull(h,h)` decimal(5,4),
`ifnull(j,j)` date,
- `ifnull(k,k)` timestamp NOT NULL,
`ifnull(l,l)` datetime,
`ifnull(m,m)` varchar(1),
`ifnull(o,o)` varchar(10)
Changed in drizzle: | |
importance: | Undecided → High |
milestone: | none → cirrus |
status: | New → Confirmed |
Stewart, I'll take this since I am already reworking time handling in the server. See lp:~jaypipes/drizzle/temporal.