Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
2.3.6
-
None
Description
The default value for the qlafilter newline replacement is `" "` (two quotes separated by a space). This was not always so and changed in commit 013dfa7. Before 013dfa7 the default behavior was a simple space: ` ` and implemented with relation to ticket MXS-1511.
But the current default behavior leads to wrong quoted queries.
# Executed query
|
SELECT
|
c.id,
|
c.name |
FROM
|
car AS c |
WHERE
|
c.type = 'porsche' |
# with default behavior `" "` as newline replacement |
SELECT" " c.id," " c.name" "FROM" " car AS c" "WHERE" " c.type = 'porsche' |
# with previous behavior ` ` as newline replacement |
SELECT c.id, c.name FROM car AS c WHERE c.type = 'porsche' |
This seems to be a bug but can be easily prevented by adding newline_replacement=" ".
@markus. I also have a question before I implement this config change. What was the intention of the change in 013dfa7, the behavior before that seemed already the right one. Is there some detail I am missing?
Attachments
Issue Links
- relates to
-
MXS-1511 Escape newlines in qlafilter output
- Closed