Description
Issue a prepared statement:
go_cbq> prepare temp1 from select COUNT(tasks_points.task1), tasks_points.task1 AS task from default where join_day>=$join_day and join_mo>=$1 GROUP BY tasks_points.task1 HAVING COUNT(tasks_points.task1) <$2 AND (MIN(join_day)=$3 OR MAX(join_yr=$4));
The text and condition in output of above statement contain unicode characters instead of >= and <.
"text": "prepare temp1 from select COUNT(tasks_points.task1), tasks_points.task1 AS task from default where join_day\u003e=$join_day and join_mo\u003e$1 GROUP BY tasks_points.task1 HAVING COUNT(tasks_points.task1) \u003e $2 AND (MIN(join_day)=$3 OR MAX(join_yr=$4))"
When I copy the text and paste in cbq or go_cbq,hit enter.
The output is:
"msg": "syntax error - at u003e"
It should have evaluated the unicode characters in the text.
Attachments
Issue Links
- blocks
-
MB-20290 4.6.0 Point Release
- Closed
For Gerrit Dashboard: MB-18722 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
67494,4 | MB-18722 copying and pasting prepared text errors out on < & > | master | go_json | Status: MERGED | +2 | +1 |
67495,3 | MB-19230 fix \n and like MB-18722 fix prepare and explain text with < & > | master | query | Status: MERGED | +2 | +1 |
68185,2 | MB-18722 copying and pasting prepared text errors out on < & > | watson | go_json | Status: MERGED | +2 | +1 |