Bug #56860 now() and MD5 convered to string instead of function in forward engineering
Submitted: 19 Sep 2010 19:30 Modified: 21 Sep 2010 3:33
Reporter: Javier Ortiz Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.2.27 OS:Any
Assigned to: CPU Architecture:Any

[19 Sep 2010 19:30] Javier Ortiz 
Description:
Having standard inserts with now() and MD5 generates string instead of the actual function when generating forward engineering script.

now() => 'now()'
MD5('pass') => 'MD5(\'pass\')'

This was previously reported and verified by me. But is happening again.

How to repeat:
Use aached file and generate the forward engineering script. See daa for xinco_core_user for examples of the issue.
[19 Sep 2010 19:31] Javier Ortiz 
Database model

Attachment: Xinco.mwb (application/x-zip-compressed, text), 33.24 KiB.
[20 Sep 2010 12:38] Johannes Taxacher 
if you include functions as values for insert data you need to precede the value with 
  \func
to prevent WB from qouting it as string value

like i.e.: \func MD5('test')
[21 Sep 2010 3:33] Javier Ortiz 
Change to enhancement suggesting an easier way yo add functions like right click in the field for a drop down.