Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | Tools - ER Modeler |
| Version | 17.0 |
Currently you are unable to set a column's default value to functions as the value is quoted when the sql is generated.
For example, in MySql I may have a column type of Timestamp(6) and should be able to specify the default value as NOW(6) but in the sql it ends up as 'NOW(6)'.
@jason: In ADS v17 now() is not quoted for default value in mysql when date type datatypes is used. See attached screenshot. I will check with the Developer on the difference between now() and now(6)
In mySQL version 5.6 certain date & time functions where enhanced to excepted a numeric value between 0-6 representing fractional seconds. Code enhanced to work with the methods when it fractional seconds.
Revision 48867
In mySQL version 5.6 certain date & time functions where enhanced to excepted a numeric value between 0-6 representing fractional seconds. Code enhanced to work with the methods when it fractional seconds.
Revision 48867
Issue #14315 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v17.0.3-6 |
| No time estimate |
@jason: In ADS v17 now() is not quoted for default value in mysql when date type datatypes is used. See attached screenshot. I will check with the Developer on the difference between now() and now(6)