[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:
Relates
relates to FOLIO-2143 verify performance of RMB26 versions ... Closed
relates to FOLIO-2176 Address index warnings from perf test Closed
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 FOLIO-2143 Closed ).

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'))
Generated at Thu Feb 08 23:18:47 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.