Notetracker filter causes sql error

[erdnase17]

I tried to create a note for the following sequence of actions on the flop: cbet flop, 3b shove over check raise.

The corresponding filter definition for Player causes a sql error which is transcribed below .

Code: Select all

Unable to execute query: SELECT (tourney_hand_player_statistics.id_player) as "__can__id_player" FROM             lookup_actions lookup_actions_f,    tourney_hand_player_statistics , tourney_hand_summary WHERE  (tourney_hand_summary.id_hand = tourney_hand_player_statistics.id_hand  AND tourney_hand_summary.id_blinds = tourney_hand_player_statistics.id_blinds)     AND lookup_actions_f.id_action = tourney_hand_player_statistics.id_action_f         AND ((tourney_hand_summary.id_hand=921415  AND (tourney_hand_player_statistics.id_player=1 OR tourney_hand_player_statistics.id_player=39056)))  AND ((tourney_hand_player_statistics.id_holecard > 0)AND (((((tourney_hand_player_statistics.flg_f_cbet)))))AND (((((tourney_hand_player_statistics.flg_f_has_position)))))AND (((((substring(lookup_actions_f.action from 1 for 1) = 'B'))AND ((substring(lookup_actions_f.action from 2 for 1) = 'R')))))AND ((((((tourney_hand_player_statistics.enum_face_allin = 'F' AND tourney_hand_player_statistics.enum_face_allin_action = 'R' OR tourney_hand_player_statistics.enum_allin = 'F')))))) ; Reason: Fatal Error (ERROR:  syntax error at end of input LINE 1: ...R' OR tourney_hand_player_statistics.enum_allin = 'F'))))))                                                                         ^ )Total time: 9ms Per Hand Avg: 0.0089ms

I created a ticket #123807 for this issue.

Thanks.

[WhiteRider]

Thanks - This is caused by the filter for Raise All-in on the Flop and is in our system to be fixed for the next release. I have linked your ticket so that you get a notification when the fix is released.