这个答案是否普遍正确，我不知道，但是我通过稍微更改查询来解决了这个问题.

Whether this answer is universally true or not, I don't know, but I solved this by altering my query slightly.

我将选择查询更改为创建临时表，而不是将选择查询连接到表并对其进行处理.然后，我将该临时表用于实际表，并且一切正常.

Rather than joining a select query to a table and processing it, I changed the select query to create a temporary table. I then used that temporary table to the real table and it all worked perfectly.