[jira] [Commented] (CASSANDRA-4390) Query with WHERE statement delivers wrong results

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-4390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13403080#comment-13403080 ] 

Sylvain Lebresne commented on CASSANDRA-4390:
---------------------------------------------

Do you also get wrong result when using cassandra-cli or when using phpcassa to fetch the results, or is that a CQL thing only?
                
> 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
>         Attachments: Cassandra_Query_Issue.png
>
>
> 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.
> https://issues.apache.org/jira/secure/attachment/12533818/Cassandra_Query_Issue.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