[RMB-436] Log both CQL and SQL within the missing index line Created: 19/Jul/19 Updated: 26/Jul/19 Resolved: 22/Jul/19 |
|
| Status: | Closed |
| Project: | RAML Module Builder |
| Components: | None |
| Affects versions: | None |
| Fix versions: | 26.3.0 |
| Type: | Task | Priority: | P3 |
| Reporter: | Hongwei Ji | Assignee: | Hongwei Ji |
| Resolution: | Done | Votes: | 0 |
| Labels: | platform-backlog | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Issue links: |
|
||||||||||||
| Sprint: | CP: sprint 68 | ||||||||||||
| Story Points: | 0.5 | ||||||||||||
| Development Team: | Core: Platform | ||||||||||||
| Description |
|
For log warning messages like below, it would great to log both CQL and SQL in the same line. (Jakub Skoczen suggested in
WARNING: Doing LIKE search without GIN index for service_point_user.jsonb->>'userId' |
| Comments |
| Comment by Hongwei Ji [ 22/Jul/19 ] |
|
New log message looks below. Fixed in RMB 26.2.2 release. WARNING: Doing LIKE search without GIN index for users.jsonb->>'active', CQL >>> SQL: active == true >>> lower(f_unaccent(users.jsonb->>'active')) LIKE lower(f_unaccent('true')) |