Alexander Belyak created IGNITE-20762:
-----------------------------------------
Summary: 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
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)
