cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cathy Daw (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-3367) data created before index is not returned in where query
Date Sat, 15 Oct 2011 21:48:11 GMT
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

        

Mime
View raw message