Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: 5.5.25, 5.3.7
-
Component/s: None
-
Labels:None
Description
SELECT NOW(257);
|
+-----------------------+
|
| NOW(257) |
|
+-----------------------+
|
| 2012-08-07 04:07:25.8 |
|
+-----------------------+
|
1 row in set (0.01 sec)
|
Works the same way in MySQL 5.6. It seems harmless, just somewhat embarrassing, so unless it's a cool feature, maybe it makes sense to fix it some day.
With columns it's different though:
CREATE TABLE t (a DATETIME(257));
|
ERROR 1426 (42000): Too big precision 257 specified for 'a'. Maximum is 6.
|