[
https://issues.apache.org/jira/browse/CASSANDRA-3367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13128293#comment-13128293
]
Jonathan Ellis commented on CASSANDRA-3367:
-------------------------------------------
Did you verify that the index had finished building first?
> data created before index is not returned in where query
> --------------------------------------------------------
>
> Key: CASSANDRA-3367
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3367
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.0.0
> Reporter: Cathy Daw
>
> *CQL version of bug*
> {code}
> // CREATE KS AND CF
> CREATE KEYSPACE ks1 with
> strategy_class =
> 'org.apache.cassandra.locator.SimpleStrategy'
> and strategy_options:replication_factor=1;
> use ks1;
> DROP COLUMNFAMILY users;
> CREATE COLUMNFAMILY users (
> KEY varchar PRIMARY KEY, password varchar, gender varchar,
> session_token varchar, state varchar, birth_year bigint);
> // INSERT DATA
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user1',
> 'ch@ngem3a', 'f', 'TX', '1968');
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user2',
> 'ch@ngem3b', 'm', 'CA', '1971');
> // CREATE INDEX
> CREATE INDEX gender_key ON users (gender);
> CREATE INDEX state_key ON users (state);
> CREATE INDEX birth_year_key ON users (birth_year);
> // INSERT DATA
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user3',
> 'ch@ngem3c', 'f', 'FL', '1978');
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user4',
> 'ch@ngem3d', 'm', 'TX', '1974');
> // VERIFY DATA
> cqlsh> select * from users;
> KEY | birth_year | gender | password | state |
> user1 | 1968 | f | ch@ngem3a | TX |
> user4 | 1974 | m | ch@ngem3d | TX |
> user3 | 1978 | f | ch@ngem3c | FL |
> user2 | 1971 | m | ch@ngem3b | CA |
> //BUG : missing row from user1, created before index was added
> cqlsh> select * from users where state='TX';
> KEY | birth_year | gender | password | state |
> user4 | 1974 | m | ch@ngem3d | TX |
> //BUG : missing row from user2, created before index was added
> cqlsh> select * from users where state='CA';
> {code}
> *CLI version of bug*
> {code}
> // CREATE KS AND CF
> CREATE keyspace ks1 with
> placement_strategy =
> 'org.apache.cassandra.locator.SimpleStrategy'
> and strategy_options = [{replication_factor:1}];
> use ks1;
> drop column family users;
> create column family users
> with comparator = UTF8Type
> and key_validation_class = UTF8Type
> and default_validation_class = UTF8Type
> and column_metadata = [{column_name: password,
> validation_class:UTF8Type}
> {column_name: gender, validation_class: UTF8Type},
> {column_name: session_token, validation_class: UTF8Type},
> {column_name: state, validation_class: UTF8Type},
> {column_name: birth_year, validation_class: LongType}];
> // INSERT DATA
> set users['user1']['password']='ch@ngem3a';
> set users['user1']['gender']='f';
> set users['user1']['state']='TX';
> set users['user1']['birth_year']='1968';
> set users['user2']['password']='ch@ngem3b';
> set users['user2']['gender']='m';
> set users['user2']['state']='CA';
> set users['user2']['birth_year']='1971';
> // ADD INDEX
> update column family users
> with comparator = UTF8Type
> and key_validation_class = UTF8Type
> and default_validation_class = UTF8Type
> and column_metadata = [{column_name: password,
> validation_class:UTF8Type}
> {column_name: gender, validation_class: UTF8Type, index_type: KEYS},
> {column_name: session_token, validation_class: UTF8Type},
> {column_name: state, validation_class: UTF8Type, index_type: KEYS},
> {column_name: birth_year, validation_class: LongType, index_type:
> KEYS}];
> // INSERT DATA
> set users['user3']['password']='ch@ngem3b';
> set users['user3']['gender']='f';
> set users['user3']['state']='FL';
> set users['user3']['birth_year']='1978';
> set users['user4']['password']='ch@ngem3c';
> set users['user4']['gender']='m';
> set users['user4']['state']='TX';
> set users['user4']['birth_year']='1974';
> // VERIFY DATA
> [default@cqldb] list users;
> Using default limit of 100
> -------------------
> RowKey: user1
> => (column=birth_year, value=1968, timestamp=1318714655921000)
> => (column=gender, value=f, timestamp=1318714655917000)
> => (column=password, value=ch@ngem3a, timestamp=1318714655908000)
> => (column=state, value=TX, timestamp=1318714655919000)
> -------------------
> RowKey: user4
> => (column=birth_year, value=1974, timestamp=1318714671608000)
> => (column=gender, value=m, timestamp=1318714670666000)
> => (column=password, value=ch@ngem3c, timestamp=1318714670665000)
> => (column=state, value=TX, timestamp=1318714670668000)
> -------------------
> RowKey: user3
> => (column=birth_year, value=1978, timestamp=1318714670662000)
> => (column=gender, value=f, timestamp=1318714670657000)
> => (column=password, value=ch@ngem3b, timestamp=1318714670654000)
> => (column=state, value=FL, timestamp=1318714670660000)
> -------------------
> RowKey: user2
> => (column=birth_year, value=1971, timestamp=1318714657353000)
> => (column=gender, value=m, timestamp=1318714655924000)
> => (column=password, value=ch@ngem3b, timestamp=1318714655923000)
> => (column=state, value=CA, timestamp=1318714655926000)
> 4 Rows Returned.
> //BUG : missing row from user1, created before index was added
> [default@cqldb] get users where state='TX';
> -------------------
> RowKey: user4
> => (column=birth_year, value=1974, timestamp=1318714671608000)
> => (column=gender, value=m, timestamp=1318714670666000)
> => (column=password, value=ch@ngem3c, timestamp=1318714670665000)
> => (column=state, value=TX, timestamp=1318714670668000)
> //BUG : missing row from user2, created before index was added
> [default@cqldb] get users where state='CA';
> 0 Row Returned.
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
