Create stream

[WladOd]

Hello,
It is not the issue actually but I wonder about REST API response in case of duplicated streams.
CREATE STREAM IF NOT EXISTS users (user_id BIGINT KEY,active BOOLEAN, email VARCHAR,email_confirmed BOOLEAN, first_name VARCHAR,last_name VARCHAR,role VARCHAR,password VARCHAR,created_at VARCHAR,updated_at VARCHAR) WITH (kafka_topic='users', value_format='json', partitions=1);
gives
{"@type":"statement_error","error_code":40001,"message":"Cannot add stream 'USERS': A stream with the same name already exists","statementText":"CREATE STREAM IF NOT EXISTS USERS (USER_ID BIGINT KEY, ACTIVE BOOLEAN, EMAIL STRING, EMAIL_CONFIRMED BOOLEAN, FIRST_NAME STRING, LAST_NAME STRING, ROLE STRING, PASSWORD STRING, CREATED_AT STRING, UPDATED_AT STRING) WITH (KAFKA_TOPIC='users', KEY_FORMAT='KAFKA', PARTITIONS=1, VALUE_FORMAT='JSON');","entities":[]}
but the documentation says
If the IF NOT EXISTS clause is present, the statement won't fail if a stream with the same name already exists.
Statement is not failing but request does. Seems very confusing.

[thmeitz]

Hi @WladOd,
you are right. I've tested it today and it fails.

There is an open issue.