Boolean modifier creates mesh hole that Rigid Body Sim ignores

Question

I am trying to model a pool table where the balls would fall into holes during play. If I create the Passive table object with boolean modifiers Difference with cylinder the RB-active spheres (balls) do not fall through the holes, whereas if I Apply the boolean, all's well.

Because I may want to resize or move the holes, I don't want to Apply the boolean cylinder holes.

Is there a way to coax the boolean to work with Rigid Body World or is this some limitation ?

Example:

Answer 1

On your mesh with the boolean modifier, change the collision source to final.

If your boolean source changes, you will need to set the collision source to final every frame, I did that with python, the only way i managed to:

import bpy

# every frame change, this function is called.
def fixRB(scene):
    ob = bpy.data.objects.get("Cube.001")
    ob.rigid_body.mesh_source = 'FINAL'

bpy.app.handlers.frame_change_pre.append(fixRB)

Result:

When you animate your boolean source, you will see all spheres behave incorrectly:

A workaround i found is to let all boolean modifiers disabled for the first two frames, then enable them after, you will need to remove those first frames from your animation after rendering.

Edit:

If you don't deactivate boolean modifiers for the first two frames, blender will crash when rendering.

I doesn't even need to be deactivated in render, but for some reason the viewport option affects the render: