[IGNITE-8152] Forbid empty sql schema name

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.9
• Component/s: sql
• Labels: newbie
• Assignee: Alexey
• Reporter: Pavel Kuznetsov
• Created: 05/Apr/18 16:38
• Updated: 20/Mar/20 14:12
• Resolved: 20/Mar/20 14:12

Description

Currently we allow empty schema name (quoted) in cache configuration
org.apache.ignite.configuration.CacheConfiguration#setSqlSchema :

When sqlSchema is not specified, quoted cacheName is used instead.

sqlSchema could not be an empty string. Has to be "\"\"" instead.

Params:
sqlSchema - Schema name for current cache according to SQL ANSI-99. Should not be null.

Specifying schema \"\" results in empty string schema name.
No schema in sql query is treated as PUBLIC, but \"\" is regular schema name.

It's better to disallow usage of \"\" schema

Issue Links

• links to: GitHub Pull Request #7521