Stefan Häck created CASSANDRA-4390:
--------------------------------------
Summary: Query with WHERE statement delivers wrong results
Key: CASSANDRA-4390
URL: https://issues.apache.org/jira/browse/CASSANDRA-4390
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.1.1
Environment: Linux version 2.6.32-5-amd64 (Debian 2.6.32-45) |cqlsh
2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
Reporter: Stefan Häck
Data is written to cassandra via phpcassa ( https://github.com/thobbs/phpcassa
v1.0).
Inspection the records via cqlsh,the query with a WHERE statement doesn't
deliver all records.
http://imageshack.us/photo/my-images/820/cassandraqueryissue.png/
I'am working with a 2 node cluster and the effect is the same on both nodes.
Furthermore a nodetool repair, nodetool rebuild has no positive effect. The
data type for this column is varint.
******
DESCRIBE COLUMNFAMILY rm_advertisements
CREATE TABLE rm_advertisements (
KEY text PRIMARY KEY,
css text,
form text,
custom_field2 text,
vacancy_type text,
custom_field3 text,
active boolean,
vacancy_responsibles text,
job_site text,
vacancy_email_notification text,
custom_field4 text,
vacancy_name text,
startdate text,
vacancy_id varint,
custom_field5 text,
html text,
company_id varint,
ctime text,
title text,
expires text,
atime text,
custom_field1 text,
vacancy_language text,
tags text,
mtime text,
mailapply boolean,
vacancy_description text,
vacancy_function text,
shorthash text
) WITH
comment='Advertisements' AND
comparator=text AND
read_repair_chance=1.000000 AND
gc_grace_seconds=864000 AND
default_validation=text AND
min_compaction_threshold=4 AND
max_compaction_threshold=32 AND
replicate_on_write='true' AND
compaction_strategy_class='SizeTieredCompactionStrategy' AND
compression_parameters:sstable_compression='SnappyCompressor';
CREATE INDEX rm_advertisements_active ON rm_advertisements (active);
CREATE INDEX rm_advertisements_job_site ON rm_advertisements (job_site);
CREATE INDEX rm_advertisements_vacancy_id ON rm_advertisements (vacancy_id);
CREATE INDEX rm_advertisements_company_id ON rm_advertisements (company_id);
CREATE INDEX rm_advertisements_title ON rm_advertisements (title);
CREATE INDEX rm_advertisements_expires ON rm_advertisements (expires);
CREATE INDEX rm_advertisements_vacancy_language ON rm_advertisements
(vacancy_language);
CREATE INDEX rm_advertisements_mailapply ON rm_advertisements (mailapply);
CREATE INDEX rm_advertisements_shorthash ON rm_advertisements (shorthash);
--
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
