I ran following command multiple times and I saw that it always returns https status code
200. Whether it’s creating a NEW database or not. I am assuming when database already exists, it skips all the processing and simply return http status code
200 for existing database.
curl -XPOST 'http://localhost:8086/query' --data-urlencode 'q=CREATE DATABASE "mydb"'
Please let me know if my assumption is right.