[
https://issues.apache.org/jira/browse/IGNITE-26449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-26449:
----------------------------------------
Component/s: sql ai3
> Improve error message when user specifies string over identifier
> ----------------------------------------------------------------
>
> Key: IGNITE-26449
> URL: https://issues.apache.org/jira/browse/IGNITE-26449
> Project: Ignite
> Issue Type: Task
> Components: sql ai3
> Reporter: Igor Gusev
> Priority: Major
> Labels: ignite-3
>
>
> When executing SQL and using the string name, the error can be confusing
> {code:java}
> sql-cli> CREATE TABLE Country (
> > Code VARCHAR PRIMARY KEY,
> > Name VARCHAR,
> > Continent VARCHAR,
> > Region VARCHAR,
> > SurfaceArea DECIMAL(10,2),
> > IndepYear SMALLINT,
> > Population INT,
> > LifeExpectancy DECIMAL(3,1),
> > GNP DECIMAL(10,2),
> > GNPOld DECIMAL(10,2),
> > LocalName VARCHAR,
> > GovernmentForm VARCHAR,
> > HeadOfState VARCHAR,
> > Capital INT,
> > Code2 VARCHAR
> > ) ZONE "storageZone" STORAGE PROFILE 'default';
> SQL query execution error
> Distribution zone with name 'storageZone' not found{code}
> It is not clear that the storageZone zone was created with an identifier. We
> should improve the error to direct users more
>
> Possible solutions:
> # Check if the object with the specified name exists and direct users to it.
> Something along the lines of
> {code:java}
> Distribution zone with name "storageZone" not found. Did you mean
> STORAGEZONE? {code}
> # Make the error more verbose to include possible cause
> {code:java}
> Distribution zone with name 'storageZone' not found. This could be caused by
> a naming mistake, or using a case-sensitive name instead of an
> identifier.{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
