Page 1 of 1

Potential SQL bug

PostPosted: Mon Dec 16, 2024 5:20 pm
by 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)

Re: Potential SQL bug

PostPosted: Tue Dec 17, 2024 8:06 am
by Flag_Hippo
Bracketing the expression like this works:

Example wrote:((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)

highfalutin