[
https://issues.apache.org/jira/browse/IGNITE-6287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16195020#comment-16195020
]
Denis Magda commented on IGNITE-6287:
-------------------------------------
As per the verbal discussion, do the following:
* Add a checkbox "Use as default schema" under the caches name.
* The checkbox is unchecked by default (might need to switch it on for the demo
mode though).
* If the checkbox is checked is the current approach you use to send queries.
* If the checkbox is unchecked send a query as is via the API used by JDBC and
ODBC drivers.
[~pkonstantinov], please check that you can copy and paste from this getting
started [1] w/o any modification. That should be a part of the feature
acceptance criteria.
[1] https://apacheignite-sql.readme.io/docs/getting-started
> DDL Support for WebConsole
> --------------------------
>
> Key: IGNITE-6287
> URL: https://issues.apache.org/jira/browse/IGNITE-6287
> Project: Ignite
> Issue Type: New Feature
> Reporter: Denis Magda
> Assignee: Pavel Konstantinov
> Priority: Critical
> Labels: usability
> Fix For: 2.3
>
> Attachments: screenshot-1.png
>
>
> DDL queries like CREATE TABLE don't work in Web Console.
> First, if Ignite cluster is started with zero caches deployed then "Execute"
> button will be disabled and there is now way to execute CREATE TABLE in
> general.
> Second, if to create a dummy cache on cluster startup and execute this
> {code}
> CREATE TABLE City (
> id LONG PRIMARY KEY, name VARCHAR)
> WITH "template=replicated";
> {code}
> Then the console will generate the exception
> {code}
> Error: class org.apache.ignite.internal.processors.query.IgniteSQLException:
> CREATE TABLE can only be executed on PUBLIC schema.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
