[ 
https://issues.apache.org/jira/browse/IGNITE-11520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denis Mekhanikov resolved IGNITE-11520.
---------------------------------------
    Resolution: Duplicate

> 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.4, 2.7
>            Reporter: Denis Mekhanikov
>            Priority: Major
>             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)

Reply via email to