If it has - (minus) value on the Broker SQL log parser, it can not parse right

Details

Description

08/01 17:16:38.393 (253230) set query timeout to 30 (from app)
08/01 17:16:38.393 (253230) execute_all srv_h_id 1       SELECT *  FROM test    WHERE testno = ?   limit 1
08/01 17:16:38.393 (253230) bind 1 : INT -6020
08/01 17:16:38.393 (253230) execute_all 0 tuple 1 time 0.001
08/01 17:16:38.393  auto_commit
08/01 17:16:38.394  auto_commit 0
08/01 17:16:38.394  *** elapsed time 0.001

  1. File
    CODE_REVIEW.creview
    01/Aug/12 10:58 PM
    55 kB
    付雷
  2. File
    datacp.sql
    23/Aug/12 8:45 AM
    4 kB
    高艳铭
  1. error result.PNG
    47 kB
    23/Aug/12 8:45 AM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Isaiah Choe added a comment -

If you parse it, it will be SELECT * FROM test WHERE testno = ? limit 1.
But it should be SELECT * FROM test WHERE testno = -6020 limit 1.

Show
Isaiah Choe added a comment - If you parse it, it will be SELECT * FROM test WHERE testno = ? limit 1. But it should be SELECT * FROM test WHERE testno = -6020 limit 1.
Hide
Permalink
付雷 (Inactive) added a comment -

Fixed
I think the best way to avoid this type of bug is get true online environment log which i can see directly whether there is others type of parameter pattern can't be supported ,it's really a hard work that can think all type of parameter pattern by mind

Show
付雷 (Inactive) added a comment - Fixed I think the best way to avoid this type of bug is get true online environment log which i can see directly whether there is others type of parameter pattern can't be supported ,it's really a hard work that can think all type of parameter pattern by mind
Hide
Permalink
高艳铭 added a comment -

When run the sql in attachment, the sql isn't right after analye the sql log.

Show
高艳铭 added a comment - When run the sql in attachment, the sql isn't right after analye the sql log.
Hide
Permalink
付雷 (Inactive) added a comment -

Copy log from console will get the new line delimiter

Show
付雷 (Inactive) added a comment - Copy log from console will get the new line delimiter
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.1.2257 and CQB8.4.1.2257

Show
高艳铭 added a comment - Fixed in CM8.4.1.2257 and CQB8.4.1.2257

People

  • Assignee:
    高艳铭
    Reporter:
    Isaiah Choe
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
Not Specified
Original Estimate - Not Specified
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
4h
Time Spent - 4 hours