Potential SQL bug

[4StarGen]

If you make this as expression filter it doesn't filter for the active player, why?

Code: Select all

((cash_hand_summary.str_aggressors_p LIKE '8090%') OR (cash_hand_summary.str_aggressors_p LIKE '8080%') OR (cash_hand_summary.str_aggressors_p LIKE '8191%') OR (cash_hand_summary.str_aggressors_p LIKE '8181%') OR (cash_hand_summary.str_aggressors_p LIKE '8292%') OR (cash_hand_summary.str_aggressors_p LIKE '8282%') OR (cash_hand_summary.str_aggressors_p LIKE '8393%') OR (cash_hand_summary.str_aggressors_p LIKE '8383%') AND
        (cash_hand_player_statistics.position <= 3) AND
        (cash_hand_player_statistics.flg_p_4bet) AND
        cash_hand_summary.cnt_players > 2)

[Flag_Hippo]

Bracketing the expression like this works:

((cash_hand_summary.str_aggressors_p LIKE '8090%') OR (cash_hand_summary.str_aggressors_p LIKE '8080%') OR (cash_hand_summary.str_aggressors_p LIKE '8191%') OR (cash_hand_summary.str_aggressors_p LIKE '8181%') OR (cash_hand_summary.str_aggressors_p LIKE '8292%') OR (cash_hand_summary.str_aggressors_p LIKE '8282%') OR (cash_hand_summary.str_aggressors_p LIKE '8393%') OR (cash_hand_summary.str_aggressors_p LIKE '8383%')) AND
(cash_hand_player_statistics.position <= 3) AND
(cash_hand_player_statistics.flg_p_4bet) AND
(cash_hand_summary.cnt_players > 2)