[jira] [Commented] (IGNITE-12567) H2Tree goes into illegal state when non-indexed columns are dropped

2020-01-22 Thread Konstantin Orlov (Jira) 


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

Konstantin Orlov commented on IGNITE-12567:
---

The problem with in-memory state, so possible work around is a rebooting the 
node.

> H2Tree goes into illegal state when non-indexed columns are dropped
> ---
>
> Key: IGNITE-12567
> URL: https://issues.apache.org/jira/browse/IGNITE-12567
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
>
> *How to reproduce:*
> * {{CREATE TABLE tbl (f0 INT, f1 INT, f2 INT, f3 INT, f4 INT, PRIMARY KEY 
> (f3, f4))}}
> * populate table with some data
> * {{ALTER TABLE tbl DROP COLUMN f1, f2}}
> * try to execute query which will use pk index: {{SELECT * FROM tbl WHERE f3 
> = 1 AND f4 = 1}} 
> *Expected*:
> * Query returns result set
> *Actual*:
> * Query fails with {{General error: 
> "java.lang.ArrayIndexOutOfBoundsException: 5";}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Commented] (IGNITE-12567) H2Tree goes into illegal state when non-indexed columns are dropped

2020-01-22 Thread Konstantin Orlov (Jira) 


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

Konstantin Orlov commented on IGNITE-12567:
---

[~ipavlukhin], please review the patch. TC visa is in progress.

> H2Tree goes into illegal state when non-indexed columns are dropped
> ---
>
> Key: IGNITE-12567
> URL: https://issues.apache.org/jira/browse/IGNITE-12567
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> *How to reproduce:*
> * {{CREATE TABLE tbl (f0 INT, f1 INT, f2 INT, f3 INT, f4 INT, PRIMARY KEY 
> (f3, f4))}}
> * populate table with some data
> * {{ALTER TABLE tbl DROP COLUMN f1, f2}}
> * try to execute query which will use pk index: {{SELECT * FROM tbl WHERE f3 
> = 1 AND f4 = 1}} 
> *Expected*:
> * Query returns result set
> *Actual*:
> * Query fails with {{General error: 
> "java.lang.ArrayIndexOutOfBoundsException: 5";}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Commented] (IGNITE-12567) H2Tree goes into illegal state when non-indexed columns are dropped

2020-01-22 Thread Ivan Pavlukhin (Jira) 


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

Ivan Pavlukhin commented on IGNITE-12567:
-

[~korlov], LGTM. I will merged it once visa is ready.

> H2Tree goes into illegal state when non-indexed columns are dropped
> ---
>
> Key: IGNITE-12567
> URL: https://issues.apache.org/jira/browse/IGNITE-12567
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> *How to reproduce:*
> * {{CREATE TABLE tbl (f0 INT, f1 INT, f2 INT, f3 INT, f4 INT, PRIMARY KEY 
> (f3, f4))}}
> * populate table with some data
> * {{ALTER TABLE tbl DROP COLUMN f1, f2}}
> * try to execute query which will use pk index: {{SELECT * FROM tbl WHERE f3 
> = 1 AND f4 = 1}} 
> *Expected*:
> * Query returns result set
> *Actual*:
> * Query fails with {{General error: 
> "java.lang.ArrayIndexOutOfBoundsException: 5";}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Commented] (IGNITE-12567) H2Tree goes into illegal state when non-indexed columns are dropped

2020-01-23 Thread Ignite TC Bot (Jira) 


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

Ignite TC Bot commented on IGNITE-12567:


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

> H2Tree goes into illegal state when non-indexed columns are dropped
> ---
>
> Key: IGNITE-12567
> URL: https://issues.apache.org/jira/browse/IGNITE-12567
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Konstantin Orlov
>Assignee: Konstantin Orlov
>Priority: Major
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> *How to reproduce:*
> * {{CREATE TABLE tbl (f0 INT, f1 INT, f2 INT, f3 INT, f4 INT, PRIMARY KEY 
> (f3, f4))}}
> * populate table with some data
> * {{ALTER TABLE tbl DROP COLUMN f1, f2}}
> * try to execute query which will use pk index: {{SELECT * FROM tbl WHERE f3 
> = 1 AND f4 = 1}} 
> *Expected*:
> * Query returns result set
> *Actual*:
> * Query fails with {{General error: 
> "java.lang.ArrayIndexOutOfBoundsException: 5";}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)