enum_face_allin

[ibyoar]

id_hand is unique per hand but occurs once per player per hand. Only (id_hand, id_player) is truly unique.

Thanks, it is clear now
Any idea about the other "problems"?

[kraada]

Can you export and attach one of those 288 hands to a support ticket? That would help us figure out what is going on in these cases.

[ibyoar]

I have created a ticket and attached one hand. ticket_id=128055
SELECT stat.id_hand,stat.amt_before,stat.amt_p_raise_facing FROM public.tourney_hand_player_statistics WHERE stat.enum_face_allin='P' AND stat.cnt_players>=4 AND stat.amt_p_raise_facing <stat.amt_before AND stat.amt_ante=0 AND stat.position<8
Description of the hand:
-6 players, active player in position 2, who openraises to 2bb(stack of 10bb),folded to SB who pushes 8.5bb.
amt_raise_facing is correct-->7bb,amt:before is correct-->10bb, so uppercase P isnt working well (or not covers just the cases when we face a raise for more than our stack)

[kraada]

Thanks, I'll make sure the appropriate developer takes a look.

[kraada]

Thanks to these hands we have identified an issue with the capitalization and a fix will be in the next Beta release. Once the fix is out you will need to reimport hands in order to have the proper data and all new hands going forward will work properly.

Thank you for working with us so that we could get this issue identified and fixed more quickly.

[ibyoar]

no problem
thanks