Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1174956: pt-query-digest and pt-fingerprint don't strip some multi-line comments

Description

**Reported in Launchpad by roberto spadim last update 18-07-2013 15:38:49

[beto@friganso ~]# pt-fingerprint --query "/* – S++ SU ABORTABLE – spd_user: rspadim */SELECT SQL_SMALL_RESULT SQL_CACHE DISTINCT centro_atividade FROM est_dia WHERE unidade_id=1001 AND item_id=67 AND item_id_red=573"
/*
[beto@friganso ~]# pt-fingerprint --version
pt-fingerprint 2.2.2

what should result?

[beto@friganso ~]# pt-fingerprint --query "/* – S++ SU ABORTABLE – spd_user: rspadim */SELECT SQL_SMALL_RESULT SQL_CACHE DISTINCT centro_atividade FROM est_dia WHERE unidade_id=1001 AND item_id=67 AND item_id_red=573"

SELECT DISTINCT centro_atividade FROM est_dia WHERE unidade_id=? AND item_id=? AND item_id_red=?

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 5:26 PM

**Comment from Launchpad by: roberto spadim on: 30-04-2013 21:54:41

the problem is the "--" of commentary
check:
WRONG!
[beto@friganso ~]# pt-fingerprint --query "/* – S SU ABORTABLE – spd_user: rspadim */SELECT SQL_SMALL_RESULT SQL_CACHE DISTINCT centro_atividade FROM est_dia WHERE unidade_id=1001 AND item_id=67 AND item_id_red=573"
/*

RIGHT!
[beto@friganso ~]# pt-fingerprint --query "/* S SU ABORTABLE spd_user: rspadim */SELECT SQL_SMALL_RESULT SQL_CACHE DISTINCT centro_atividade FROM est_dia WHERE unidade_id=1001 AND item_id=67 AND item_id_red=573"
select sql_small_result sql_cache distinct centro_atividade from est_dia where unidade_id=? and item_id=? and item_id_red=?

Done

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 5:26 PM
Updated January 24, 2018 at 5:26 PM
Resolved January 24, 2018 at 5:26 PM