You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Todd Nine (JIRA)" <ji...@apache.org> on 2011/02/17 05:52:24 UTC
[jira] Created: (CASSANDRA-2179) Secondary indexing of columns with
duplicate values does not return all row keys
Secondary indexing of columns with duplicate values does not return all row keys
--------------------------------------------------------------------------------
Key: CASSANDRA-2179
URL: https://issues.apache.org/jira/browse/CASSANDRA-2179
Project: Cassandra
Issue Type: Bug
Components: Core
Affects Versions: 0.7.1
Environment: Java 1.6 64 bit Ubuntu
Reporter: Todd Nine
Create a CF test with a column "value" and "holder". Create an index on the Value column of type UTF8 and a Keys index. Insert the following values into the cf
new UUID():{ value: "test", holder: 0x00}
new UUID():{ value: "test", holder: 0x00}
new UUID():{ value: "test", holder: 0x00}
Query the secondary index where value EQ "test" and select column "holder"
You should be returned 3 rows. Instead you are returned one. It seems that the last row written with the column value is the only row that is returned when the column value contains duplicates. I'll attempt to create a python client test that demonstrates the issue.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CASSANDRA-2179) Secondary indexing of columns with
duplicate values does not return all row keys
Posted by "Todd Nine (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Todd Nine updated CASSANDRA-2179:
---------------------------------
Attachment: test.patch
Please ignore previous patch, was incorrect version.
> Secondary indexing of columns with duplicate values does not return all row keys
> --------------------------------------------------------------------------------
>
> Key: CASSANDRA-2179
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2179
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 0.7.1
> Environment: Java 1.6 64 bit Ubuntu
> Reporter: Todd Nine
> Attachments: test.patch, test.patch
>
>
> Create a CF test with a column "value" and "holder". Create an index on the Value column of type UTF8 and a Keys index. Insert the following values into the cf
> new UUID():{ value: "test", holder: 0x00}
> new UUID():{ value: "test", holder: 0x00}
> new UUID():{ value: "test", holder: 0x00}
> Query the secondary index where value EQ "test" and select column "holder"
> You should be returned 3 rows. Instead you are returned one. It seems that the last row written with the column value is the only row that is returned when the column value contains duplicates. I'll attempt to create a python client test that demonstrates the issue.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CASSANDRA-2179) Secondary indexing of columns with
duplicate values does not return all row keys
Posted by "Todd Nine (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Todd Nine updated CASSANDRA-2179:
---------------------------------
Attachment: test.patch
Patch for test case
> Secondary indexing of columns with duplicate values does not return all row keys
> --------------------------------------------------------------------------------
>
> Key: CASSANDRA-2179
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2179
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 0.7.1
> Environment: Java 1.6 64 bit Ubuntu
> Reporter: Todd Nine
> Attachments: test.patch
>
>
> Create a CF test with a column "value" and "holder". Create an index on the Value column of type UTF8 and a Keys index. Insert the following values into the cf
> new UUID():{ value: "test", holder: 0x00}
> new UUID():{ value: "test", holder: 0x00}
> new UUID():{ value: "test", holder: 0x00}
> Query the secondary index where value EQ "test" and select column "holder"
> You should be returned 3 rows. Instead you are returned one. It seems that the last row written with the column value is the only row that is returned when the column value contains duplicates. I'll attempt to create a python client test that demonstrates the issue.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Resolved: (CASSANDRA-2179) Secondary indexing of columns
with duplicate values does not return all row keys
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-2179.
---------------------------------------
Resolution: Cannot Reproduce
Latest on IRC is that it was a client-side problem, which is why it worked when attempted with Python.
> Secondary indexing of columns with duplicate values does not return all row keys
> --------------------------------------------------------------------------------
>
> Key: CASSANDRA-2179
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2179
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 0.7.1
> Environment: Java 1.6 64 bit Ubuntu
> Reporter: Todd Nine
> Attachments: test.patch, test.patch
>
>
> Create a CF test with a column "value" and "holder". Create an index on the Value column of type UTF8 and a Keys index. Insert the following values into the cf
> new UUID():{ value: "test", holder: 0x00}
> new UUID():{ value: "test", holder: 0x00}
> new UUID():{ value: "test", holder: 0x00}
> Query the secondary index where value EQ "test" and select column "holder"
> You should be returned 3 rows. Instead you are returned one. It seems that the last row written with the column value is the only row that is returned when the column value contains duplicates. I'll attempt to create a python client test that demonstrates the issue.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira