The issue seems to be unique not only to the use of JOINED inheritance and batch_size but also to the use of the legacy ID generation strategy (disabling normal generation using id.new_generator_mappings="falseā).