[
https://issues.apache.org/jira/browse/CASSANDRA-7105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14011636#comment-14011636
]
Tyler Hobbs commented on CASSANDRA-7105:
----------------------------------------
+1
> SELECT with IN on final column of composite and compound primary key fails
> --------------------------------------------------------------------------
>
> Key: CASSANDRA-7105
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7105
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: DataStax Cassandra 2.0.7
> Windows dual-core laptop
> Reporter: Bill Mitchell
> Assignee: Sylvain Lebresne
> Fix For: 1.2.17
>
> Attachments: 7105-v2.txt, 7105.txt
>
>
> I have a failing sequence where I specify an IN constraint on the final int
> column of the composite primary key and an IN constraint on the final String
> column of the compound primary key and no rows are returned, when rows should
> be returned.
> {noformat}
> CREATE TABLE IF NOT EXISTS sr2 (siteID TEXT, partition INT, listID BIGINT,
> emailAddr TEXT, emailCrypt TEXT, createDate TIMESTAMP, removeDate TIMESTAMP,
> removeImportID BIGINT, properties TEXT, PRIMARY KEY ((siteID, listID,
> partition), createDate, emailCrypt) ) WITH CLUSTERING ORDER BY (createDate
> DESC, emailCrypt DESC) AND compression = {'sstable_compression' :
> 'SnappyCompressor'} AND compaction = {'class' :
> 'SizeTieredCompactionStrategy'};
> insert into sr2 (siteID, listID, partition, emailAddr, emailCrypt,
> createDate) values ('4ca4f79e-3ab2-41c5-ae42-c7009736f1d5', 34, 1, 'xyzzy',
> '5fe7719229092cdde4526afbc65c900c', '2014-04-28T14:05:59.236-0500');
> insert into sr2 (siteID, listID, partition, emailAddr, emailCrypt,
> createDate) values ('4ca4f79e-3ab2-41c5-ae42-c7009736f1d5', 34, 2, 'noname',
> '97bf28af2ca9c498d6e47237bb8680bf', '2014-04-28T14:05:59.236-0500');
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition = 2 and
> createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt =
> '97bf28af2ca9c498d6e47237bb8680bf';
> emailcrypt | emailaddr
> ----------------------------------+-----------
> 97bf28af2ca9c498d6e47237bb8680bf | noname
> (1 rows)
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition = 1 and
> createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt =
> '5fe7719229092cdde4526afbc65c900c';
> emailcrypt | emailaddr
> ----------------------------------+-----------
> 5fe7719229092cdde4526afbc65c900c | xyzzy
> (1 rows)
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition IN (1,2)
> and createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('97bf28af2ca9c498d6e47237bb8680bf','5fe7719229092cdde4526afbc65c900c');
> (0 rows)
> cqlsh:test_multiple_in> select * from sr2;
> siteid | listid | partition | createdate
> | emailcrypt | emailaddr |
> properties | removedate | re
> moveimportid
> --------------------------------------+--------+-----------+------------------------------------------+------------+----------------------------------+------------+------------+---
> -------------
> 4ca4f79e-3ab2-41c5-ae42-c7009736f1d5 | 34 | 2 | 2014-04-28
> 14:05:59Central Daylight Time | noname | 97bf28af2ca9c498d6e47237bb8680bf
> | null | null |
> null
> 4ca4f79e-3ab2-41c5-ae42-c7009736f1d5 | 34 | 1 | 2014-04-28
> 14:05:59Central Daylight Time | xyzzy | 5fe7719229092cdde4526afbc65c900c
> | null | null |
> null
> (2 rows)
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition IN (1,2)
> and createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('97bf28af2ca9c498d6e47237bb8680bf','5fe7719229092cdde4526afbc65c900c');
> (0 rows)
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition = 1 and
> createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('97bf28af2ca9c498d6e47237bb8680bf','5fe7719229092cdde4526afbc65c900c');
> (0 rows)
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition = 2 and
> createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('97bf28af2ca9c498d6e47237bb8680bf','5fe7719229092cdde4526afbc65c900c');
> (0 rows)
> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition IN (1,2)
> and createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('97bf28af2ca9c498d6e47237bb8680bf','5fe7719229092cdde4526afbc65c900c');
> (0 rows)
> cqlsh:test_multiple_in> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition IN (1,2)
> and createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('97bf28af2ca9c498d6e47237bb8680bf');
> emailcrypt | emailaddr
> ----------------------------------+-----------
> 97bf28af2ca9c498d6e47237bb8680bf | noname
> (1 rows)
> cqlsh:test_multiple_in> select emailCrypt, emailAddr from sr2 where siteID =
> '4ca4f79e-3ab2-41c5-ae42-c7009736f1d5' and listID = 34 and partition IN (1,2)
> and createDate = '2014-04-28T14:05:59.236-0500' and emailCrypt IN
> ('5fe7719229092cdde4526afbc65c900c');
> emailcrypt | emailaddr
> ----------------------------------+-----------
> 5fe7719229092cdde4526afbc65c900c | xyzzy
> (1 rows)
> {noformat}
> As you can see, when I specify IN on the final primary column, no rows are
> returned, even when I specify equality on the partition column. If I use IN
> to constrain the partition column but simple equality on the final column,
> one row is returned for each of the possible values.
> This appears to be a variation on Cassandra-6327 but with a String as the
> final primary key column. I initially saw this with a blob as the final
> primary key column, so the issue is not exclusive to String. When I tried a
> real simple case with ints throughout, that worked fine.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
