Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
5.5.25, 5.3.7
-
None
-
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.
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 5.5.26 [ 11100 ] | |
| Fix Version/s | 5.5.27 [ 11200 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 5.3.9 [ 11000 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | defaullt [ 13705 ] | MariaDB v2 [ 45168 ] |
| Workflow | MariaDB v2 [ 45168 ] | MariaDB v3 [ 65826 ] |
| Workflow | MariaDB v3 [ 65826 ] | MariaDB v4 [ 144913 ] |