The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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?

asked 08 Nov, 15:00

Terry%20Wilkinson's gravatar image

Terry Wilkinson
551212337
accept rate: 28%

but statement #2 does not produce any error at all

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

(09 Nov, 03:25) Volker Barth

reproducible in v16 as well

(09 Nov, 08:27) Justin Willey

This looks like a bug.

permanent link

answered 08 Nov, 15:53

Mark%20Culp's gravatar image

Mark Culp
23.8k9134279
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×425
×111
×5

question asked: 08 Nov, 15:00

question was seen: 39 times

last updated: 09 Nov, 08:27