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 '18, 15:00

Terry%20Wilkinson's gravatar image

Terry Wilkinson
746303548
accept rate: 25%

but statement #2 does not produce any error at all

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

(09 Nov '18, 03:25) Volker Barth

reproducible in v16 as well

(09 Nov '18, 08:27) Justin Willey

This looks like a bug.

permanent link

answered 08 Nov '18, 15:53

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

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

permanent link

answered 18 Jan '19, 11:28

Chris%20Keating's gravatar image

Chris Keating
7.8k49128
accept rate: 32%

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:

×438
×243
×5

question asked: 08 Nov '18, 15:00

question was seen: 1,402 times

last updated: 18 Jan '19, 11:28