[jira] [Commented] (IGNITE-18223) Document same SQL table value_type for CDC.

["Ignite TC Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-18223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17722174#comment-17722174 ] 

Ignite TC Bot commented on IGNITE-18223:
----------------------------------------

{panel:title=Branch: [pull/10713/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/10713/head] Base: [master] : No new tests found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}{panel}
[TeamCity *--> Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=7172237&buildTypeId=IgniteTests24Java8_RunAll]

> Document same SQL table value_type for CDC.
> -------------------------------------------
>
>                 Key: IGNITE-18223
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18223
>             Project: Ignite
>          Issue Type: Improvement
>          Components: documentation
>            Reporter: Vladimir Steshin
>            Assignee: Vladimir Steshin
>            Priority: Major
>              Labels: ise
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> To replicate data through CDC, SQL/CDC documentation should mention that both SQL tables on the source and destination nodes have to have the same 'value_type' like:
> {code:sql}
> CREATE TABLE Person (id int primary key, varchar name) with cache_name='Person', value_type='SQL_PERSON_TABLE_TYPE'
> {code}
> Otherwise, successfully replicated data is not seen by SQL queries on the receiver node. This happens because the recipient node has its own generated binary type name for its related table. Replication of schema or any settings aren't supported yet.
> Binary type name is randomly generated for SQL table because we do not delete binary types at all. Type name based only on table name/schema can breake: 
> {code:sql}
> sql("create table tst(id int)");
> sql("insert into tst values (1)");
> sql("drop table tst");
> sql("create table tst(id varchar)");
> sql("insert into tst values ('1')");
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)