| Bug #40105 | Erroneous behavior in "Insert Tab" when enter comma values | ||
|---|---|---|---|
| Submitted: | 17 Oct 2008 11:56 | Modified: | 30 Mar 2012 3:11 |
| Reporter: | Rodrigo Olivares | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.0.26 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | comma, inserts tab, property tab, script generator | ||
[17 Oct 2008 11:59]
Rodrigo Olivares
Changing the title
[19 Oct 2008 18:54]
MySQL Verification Team
Thank you for the bug report.
[30 Mar 2012 3:11]
Philip Olson
Fixed as of ~5.2.31, and here's the changelog entry: Workbench would not detect invalid values while they were entered into the properties editor.
Description: Comma values out of the ' (quote) produce incorrect Insert text generation. How to repeat: Create a Table with N columns Go to Properties editor Go to Inserts tab and open the editor. Fill the cells with '1' to 'N' values. Select one of the 1-N cells and re-fill with the value 'bug', (with comma included) Click ok to save. If you show the inserts preview you could to apreciate the incorrect values. (a comma out of the ', used to split the values, produce the problem) Re-open the Inserts editor and you'll see your filled cells 1 column displaced, loosing the N value that you previously enter. Suggested fix: Expect the editor to detect incorrect values that can not be used in the fields, for example the use of coma or a single quote. - Restrict the use of problematic characters - To eliminate simple quotation to enter the cell and then add them when leave