Entry is stored in ticket change table when whitespace change in text field

[Ryan J Ollos]

To reproduce:

• Change the value of any field, e.g. change milestone field from milestone1 to milestone2.
• Add whitespace to the value of a text field, e.g. change keyword field from kw1 → kw1 .

sqlite> SELECT oldvalue, newvalue FROM ticket_change WHERE time=1419227103370485;
kw1|kw1
milestone1|milestone2
9|

The value is not displayed in the ticket changelog because old == new is filtered out: tags/trac-1.0.2/trac/ticket/web_ui.py@:1829#L1783​. The change is not saved in the changelog unless another field is also changed because the changes are discarded if all props are unchanged: tags/trac-1.0.2/trac/ticket/model.py@:277-280#L260​.

[Ryan J Ollos]

Committed to 1.0-stable in [13553], merged to trunk in [13554].

[Ryan J Ollos]

Test case failures on MySQL should be fixed in [13558], merged in [13559].

[Jun Omae]

Replying to rjollos:

Test case failures on MySQL should be fixed in [13558], merged in [13559].

Unrelated to MySQL. I think it would be easy to use ORDER BY field for that case.