我有如下代码：

fun <T> withTempTableTxn(
    ctx: DSLContext,
    tempTableSelectAs: org.jooq.Select<*>,
    txnBlock: (DSLContext, org.jooq.Name) -> T,
): T {
    val uuid = UUID.randomUUID().toString().replace("-", "_")

    val tempTableName = DSL.name("temp_table_$uuid")
    val createTempTable = DSL.createGlobalTemporaryTable(tempTableName).`as`(tempTableSelectAs)

    return ctx.transactionResult { txn ->
        txn.dsl().execute(createTempTable)
        val res = txnBlock(txn.dsl(), tempTableName)
        txn.dsl().execute(DSL.dropTemporaryTableIfExists(tempTableName))
        res
    }
}

private fun updateMutation(
    mutationRequest: MutationRequest,
    op: UpdateMutationOperation,
    ctx: DSLContext,
): MutationOperationResult {
    // The rows that the temporary table will be populated with
    val tempTableRows = DSL
        .selectFrom(DSL.table(DSL.name(op.table.value)))
        .where(/* ... */)

    return withTempTableTxn(ctx, tempTableRows) { txn, tempTableName ->
        // ...
    }
}

运行此命令时，似乎找不到临时表。

请注意，如果我用常规表替换temporaryTable，则一切正常

如果我把.also { println(ctx.render(it)) }加到createTempTable上，我们得到：

Creating temp table:
create temporary table `temp_table_e2fd79a5_4589_41df_9972_8ff9b216300a`
as
select *
from `Chinook`.`Artist`
where `Artist`.`Name` = 'foobar'

13:48:02 ERROR traceId=, parentId=, spanId=, sampled= [io.ha.ap.ExceptionHandler] (executor-thread-0) Uncaught exception: org.jooq.exception.DataAccessException: SQL [update `temp_table_e2fd79a5_4589_41df_9972_8ff9b216300a`
set
  `Name` = 'foobar new'
where `temp_table_e2fd79a5_4589_41df_9972_8ff9b216300a`.`Name` = 'foobar'];
Table 'Chinook.temp_table_e2fd79a5_4589_41df_9972_8ff9b216300a' doesn't exist