select against TIME type broken
Bug #722773 reported by
Andrew Hutchings
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Drizzle |
Fix Released
|
High
|
Andrew Hutchings | ||
| 7.0 |
Fix Released
|
High
|
Andrew Hutchings | ||
Bug Description
drizzle> create table t4 (a int, b time);
Query OK, 0 rows affected (0.091008 sec)
drizzle> insert into t4 values (1, '01:01:01');
Query OK, 1 row affected (0.052351 sec)
drizzle> select * from t4 where b='01:01:01';
ERROR 1686 (HY000): Received an invalid datetime value '01:01:01'.
Related branches
lp://qastaging/~linuxjedi/drizzle/trunk-bug-722773
- Drizzle Developers: Pending requested
-
Diff: 82 lines (+40/-11)4 files modifieddrizzled/item/cmpfunc.cc (+22/-9)
drizzled/temporal.cc (+2/-2)
tests/suite/regression/r/722773.result (+7/-0)
tests/suite/regression/t/722773.test (+9/-0)
| Changed in drizzle: | |
| assignee: | nobody → Brian Aker (brianaker) |
| Changed in drizzle: | |
| status: | New → Confirmed |
| Changed in drizzle: | |
| assignee: | Brian Aker (brianaker) → Andrew Hutchings (linuxjedi) |
To post a comment you must log in.
