[jira] [Commented] (IGNITE-12567) H2Tree goes into illegal state when non-indexed columns are dropped
[ 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
[ 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
[ 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
[ 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)