Page 1 of 1

tables not matching

PostPosted: Sun Feb 13, 2011 6:03 pm
by pasita
Why would I get count of 1883 when I run
Code: Select all
select count(*) from
holdem_hand_player_detail
where id_player = 5


but count of 1515 with

Code: Select all
select count(*) from
holdem_hand_player_combinations
where id_player = 5


5 is my id on a small test db, so it shouldn't be a matter of known holecards. Under what circumstaces the combinations table doesn't get data?

Re: tables not matching

PostPosted: Sun Feb 13, 2011 6:15 pm
by WhiteRider
holdem_hand_player_combinations is only populated when there is a flop.

Re: tables not matching

PostPosted: Sun Feb 13, 2011 6:19 pm
by pasita
First I thought of that too, but I had less flops seen than the 1515 number and I got confused... but yeah makes sense now, any flop is good whether I saw it or not. Thanks.

Re: tables not matching

PostPosted: Mon Feb 14, 2011 4:50 am
by WhiteRider
Yes, that's right - the combinations table is populated whenever there is a flop, regardless of whether you saw it or not.