[
https://issues.apache.org/jira/browse/IGNITE-23600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philipp Shergalis updated IGNITE-23600:
---------------------------------------
Description:
(Reporter: Pavel Polyakov)
We can have this edge case:
# Create a sequence with any name. It creates sequence and a table with schema
“system”, and dynamic name “seq_{{{}sequence_id{}}}”
# Create new table with “seq_{{{}sequence_id{}}}” name. We will have 2 tables
with same name, but different schemas
# Select system.LOCAL_PARTITION_STATES , all data for this tables is doubled
!image-2024-11-05-16-06-10-067.png|width=516,height=231!
What to do:
* Extend GLOBAL_PARTITION_STATES and LOCAL_PARTITION_STATES system views with
“schema_name” field
UPD: during discussion decided to also add "table_id" field
*What was done:* Added schema_name and table_id fields. CLI "partition states"
command output was also extended with this fields
was:
(Reporter: Pavel Polyakov)
We can have this edge case:
# Create a sequence with any name. It creates sequence and a table with schema
“system”, and dynamic name “seq_{{{}sequence_id{}}}”
# Create new table with “seq_{{{}sequence_id{}}}” name. We will have 2 tables
with same name, but different schemas
# Select system.LOCAL_PARTITION_STATES , all data for this tables is doubled
!image-2024-11-05-16-06-10-067.png|width=516,height=231!
What to do:
* Extend GLOBAL_PARTITION_STATES and LOCAL_PARTITION_STATES system views with
“schema_name” field
UPD: during discussion decided to also add "table_id" field
> Extend GLOBAL_PARTITION_STATES and LOCAL_PARTITION_STATES system views
> ----------------------------------------------------------------------
>
> Key: IGNITE-23600
> URL: https://issues.apache.org/jira/browse/IGNITE-23600
> Project: Ignite
> Issue Type: Improvement
> Reporter: Philipp Shergalis
> Assignee: Philipp Shergalis
> Priority: Major
> Labels: ignite-3
> Attachments: image-2024-11-05-16-06-02-919.png,
> image-2024-11-05-16-06-10-067.png
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> (Reporter: Pavel Polyakov)
> We can have this edge case:
> # Create a sequence with any name. It creates sequence and a table with
> schema “system”, and dynamic name “seq_{{{}sequence_id{}}}”
> # Create new table with “seq_{{{}sequence_id{}}}” name. We will have 2
> tables with same name, but different schemas
> # Select system.LOCAL_PARTITION_STATES , all data for this tables is doubled
> !image-2024-11-05-16-06-10-067.png|width=516,height=231!
> What to do:
> * Extend GLOBAL_PARTITION_STATES and LOCAL_PARTITION_STATES system views
> with “schema_name” field
> UPD: during discussion decided to also add "table_id" field
>
> *What was done:* Added schema_name and table_id fields. CLI "partition
> states" command output was also extended with this fields
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
