Imran/Malic
07/14/2021, 8:24 AM0.32.1
?
previously, when I would execute
exec("EXEC sp_msforeachtable @command1 = \"ALTER TABLE ? NOCHECK CONSTRAINT all\";")
in the case that there is no ResultSet it doesn't blow up, but now it does - in the case that the ResultSet is empty or non-existent.
it fails with:
WARN -Transaction attempt #1 failed: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.. Statement(s): EXEC sp_msforeachtable @command1 = "ALTER TABLE ? NOCHECK CONSTRAINT all"; org.jetbrains.exposed.exceptions.ExposedSQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:62)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:135)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:121)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:97)
at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:83)
at org.jetbrains.exposed.sql.Transaction.exec$default(Transaction.kt:82)