You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Denis Mekhanikov (JIRA)" <ji...@apache.org> on 2019/03/11 10:55:00 UTC

[jira] [Created] (IGNITE-11520) SQL schema is overwritten by static query entity configuration

Denis Mekhanikov created IGNITE-11520:
-----------------------------------------

             Summary: SQL schema is overwritten by static query entity configuration
                 Key: IGNITE-11520
                 URL: https://issues.apache.org/jira/browse/IGNITE-11520
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.7, 2.4
            Reporter: Denis Mekhanikov
             Fix For: 2.8


Steps to reproduce:
1. Start and restart a node with persistence enabled and the following cache configuration:
{code}
<property name="cacheConfiguration">
    <bean class="org.apache.ignite.configuration.CacheConfiguration">
        <property name="name" value="cache"/>
        <property name="queryEntities">
            <list>
                <bean class="org.apache.ignite.cache.QueryEntity">
                    <property name="keyType" value="java.lang.Long"/>
                    <property name="valueType" value="Person"/>

                    <property name="fields">
                        <map>
                            <entry key="id" value="java.lang.Long"/>
                            <entry key="firstName" value="java.lang.String"/>
                        </map>
                    </property>
                </bean>
            </list>
        </property>
    </bean>
</property>
{code}

2. Execute the following DDL statement:
{code}
ALTER TABLE "cache".Person ADD COLUMN lastName varchar;
{code}

3. Restart the node.

After the restart Person table contains only two columns



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)