Project

General

Profile

Actions

Defect #10814

closed

When submitting update with word 'VALUES', such as SQL statement, data is cut off

Added by Allen S over 12 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

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

screenshot.png (27.5 KB) screenshot.png Allen S, 2012-05-02 15:11
example.txt (148 Bytes) example.txt Allen S, 2012-05-02 15:12
Actions #1

Updated by Allen S over 12 years ago

And you can even see it did it on this ticket. Please see the text file as the example text to add to a ticket whereby the values are not shown.

Actions #2

Updated by Mischa The Evil over 12 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid

This is caused by the used Textile formatting for acronyms. See RedmineTextFormatting.
As an alternative you can use the pre-tags to prevent parsing using Textile formatter:

INSERT INTO TestDB (PAD_Dept, PAD_DeptName, PAD_Active, PAD_StartDate, PAD_EndDate)
VALUES('04545', 'DesktopTeam', 1, '1968-01-01', '4712-12-31')
Actions

Also available in: Atom PDF