Defect #10814
closedWhen submitting update with word 'VALUES', such as SQL statement, data is cut off
0%
Description
DB: MySQL 5.5.15
Redmine: 1.3.0
Rails: 2.3.14
Ruby 1.8.7
When submitting an update into a Redmine ticket that contains a VALUES, such as an SQL statement, like this one:
INSERT INTO TestDB (PAD_Dept, PAD_DeptName, PAD_Active, PAD_StartDate, PAD_EndDate)
VALUES
The data gets truncated so that it appears as
INSERT INTO TestDB (PAD_Dept, PAD_DeptName, PAD_Active, PAD_StartDate, PAD_EndDate)
VALUES
And the word VALUES has an underline that contains the values in the fields.
As shown in attached screenshot, you can see how the preview at the bottom does not include anything after the word VALUES. However, if I add a space between VALUES and the first parenthesis, it works, or if I put another word instead of VALUES it works, so it is treating the word VALUES special.
Files