[ https://issues.apache.org/jira/browse/CASSANDRA-7105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-7105: ------------------------------------ Attachment: 7105.txt this fixes this exact issue, altho i'm not at all sure it's the correct fix. > 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 > Attachments: 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)