No error message with CREATE TABLE IF NOT EXISTS and invalid value for OWNER

[former_SQLA_member1694873]

In a database where there is NO user with the name TW, statement #1 gives the expected error User ID 'TW' does not exist but statement #2 does not produce any error at all.

Statement #1 CREATE TABLE "TW"."ONE_Table" ("ID" INTEGER)

Statement #2 CREATE TABLE IF NOT EXISTS "TW"."ONE_Table" ("ID" INTEGER)

I would expect them to both throw the expected error message.

Am I missing some subtlety or is this a bug?

[VolkerBarth]

but statement #2 does not produce any error at all

Just to clarify: It does not create the table, either.

[justin_willey]

reproducible in v16 as well

[MarkCulp · Accepted solution]

This looks like a bug.

[chris_keating]

This has been fixed as Engineering Case 818012 and will be provided in an upcoming software update 17.0 Build 4934 or newer.