[
https://issues.apache.org/jira/browse/IGNITE-20762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich resolved IGNITE-20762.
----------------------------------------
Resolution: Not A Problem
It looks not a problem due to we uppercase (to have case-insensitive) all
identifiers in SQ.
so after create zone fz you have name FZ, but when you try to use the zone you
use quoted identifier, which not uppercases. So you should use or uppercased
quote identifier or don't use quotes.
> Unable to create table in a specific zone
> -----------------------------------------
>
> Key: IGNITE-20762
> URL: https://issues.apache.org/jira/browse/IGNITE-20762
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0
> Reporter: Alexander Belyak
> Priority: Major
> Labels: ignite-3
>
> Got exception
> [Code: 0, SQL State: 50000] Failed to validate query. Distribution zone with
> name 'fz' not found
> on creation a new table in any specific zone:
> {noformat}
> create zone fz engine aipersist;
> >> success
> create table testt3 (id integer not null, val varchar not null, id2 integer
> not null, primary key(id,id2) ) with primary_zone = 'fz';
> >> [Code: 0, SQL State: 50000] Failed to validate query. Distribution zone
> >> with name 'fz' not found
> create zone fz engine aipersist;
> >> [Code: 0, SQL State: 50000] Distribution zone already exists [zoneName=FZ]
> drop zone fz;
> >> success{noformat}
> Code from the example:
> [https://github.com/apache/ignite-3/blob/main/examples/src/main/java/org/apache/ignite/example/storage/StorageEngineExample.java]
> no matter if the first statement will use any region:
> {noformat}
> create zone fz2 engine aipersist with dataregion = 'asd';
> >> success
> create table testt3 (id integer not null, val varchar not null, id2 integer
> not null, primary key(id,id2) ) with primary_zone = 'fz2';
> >> [Code: 0, SQL State: 50000] Failed to validate query. Distribution zone
> >> with name 'fz2' not found{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
