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

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?

sa-17 create-table sa-12

asked 08 Nov '18, 15:00

Terry Wilkinson
746●30●35●48
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

flat view

2 Answers:

active answers oldest answers newest answers popular answers

1	This looks like a bug. permanent link answered 08 Nov '18, 15:53 Mark Culp 24.8k●10●139●296 accept rate: 41% flat view

2	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 Keating 7.3k●48●121 accept rate: 31% flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

sa-12 ×438
sa-17 ×231
create-table ×5

question asked: 08 Nov '18, 15:00

question was seen: 1,247 times

last updated: 18 Jan '19, 11:28

SAP SQL Anywhere

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

Follow this question

Related questions