[
https://issues.apache.org/jira/browse/CASSANDRA-7020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14133370#comment-14133370
]
Marko Denda commented on CASSANDRA-7020:
----------------------------------------
Hi,
I don't see reason why is this classified as error.
During execution of execute_cql3_query select * from test where token("key")
< -9223372036854775808 with tracing on we see following output:
key | value
-----+---------
5 | jjjjkkk
50 | rr
10 | aaaabbb
25 | c
(4 rows)
Tracing session: 5e9ad790-3c4a-11e4-bc20-d7d1fe420dc4
activity
| timestamp | source | source_elapsed
-------------------------------------------------------------------------------------------------+--------------+-----------+----------------
execute_cql3_query | 22:04:44,042 | 127.0.0.1 | 0
Parsing select * from test where token("key") <
-9223372036854775808; | 22:04:44,042 | 127.0.0.1 | 121
Preparing statement | 22:04:44,043 | 127.0.0.1 | 605
Determining
replicas to query | 22:04:44,043 | 127.0.0.1 | 966
Executing seq scan across 1 sstables for (min(-9223372036854775808),
min(-9223372036854775808)] | 22:04:44,057 | 127.0.0.1 | 15008
Read 1 live and 0
tombstoned cells | 22:04:44,059 | 127.0.0.1 | 16339
Read 1 live and 0
tombstoned cells | 22:04:44,059 | 127.0.0.1 | 16583
Read 1 live and 0
tombstoned cells | 22:04:44,059 | 127.0.0.1 | 16816
Read 1 live and 0
tombstoned cells | 22:04:44,059 | 127.0.0.1 | 17009
Scanned 4
rows and matched 4 | 22:04:44,059 | 127.0.0.1 | 17202
Request complete | 22:04:44,059 | 127.0.0.1 | 17798
which is the same as select * from test;
cqlsh:sample> select * from test;
key | value
-----+---------
5 | jjjjkkk
50 | rr
10 | aaaabbb
25 | c
(4 rows)
Tracing session: 16f5c710-3c4a-11e4-bc20-d7d1fe420dc4
activity
| timestamp | source | source_elapsed
-------------------------------------------------------------------------------------------------+--------------+-----------+----------------
execute_cql3_query | 22:02:43,842 | 127.0.0.1 | 0
Parsing select * from
test LIMIT 10000; | 22:02:43,842 | 127.0.0.1 | 115
Preparing statement | 22:02:43,843 | 127.0.0.1 | 468
Determining
replicas to query | 22:02:43,843 | 127.0.0.1 | 843
Executing seq scan across 1 sstables for [min(-9223372036854775808),
min(-9223372036854775808)] | 22:02:43,861 | 127.0.0.1 | 19150
Seeking to partition
beginning in data file | 22:02:43,862 | 127.0.0.1 | 19957
Read 1 live and 0
tombstoned cells | 22:02:43,863 | 127.0.0.1 | 20425
Seeking to partition
beginning in data file | 22:02:43,863 | 127.0.0.1 | 20574
Read 1 live and 0
tombstoned cells | 22:02:43,863 | 127.0.0.1 | 20741
Seeking to partition
beginning in data file | 22:02:43,863 | 127.0.0.1 | 20869
Read 1 live and 0
tombstoned cells | 22:02:43,863 | 127.0.0.1 | 21033
Seeking to partition
beginning in data file | 22:02:43,863 | 127.0.0.1 | 21126
Read 1 live and 0
tombstoned cells | 22:02:43,864 | 127.0.0.1 | 21287
Scanned 4
rows and matched 4 | 22:02:43,864 | 127.0.0.1 | 21489
Request complete | 22:02:43,864 | 127.0.0.1 | 22199
-9223372036854775808 is min value for ssmtable scanned so putting it in where
clause of select statement behaves as select * from test. I don't think this is
an error , certainly not major one.
Tested on cassandra-2.0.6 and cassandra-2.0.7 branch.
Anyone else to comment on this?
Regards,
Marko
> Incorrect result of query WHERE token(key) < -9223372036854775808 when using
> Murmur3Partitioner
> -----------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-7020
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7020
> Project: Cassandra
> Issue Type: Bug
> Environment: cassandra 2.0.6-snapshot
> Reporter: Piotr Kołaczkowski
> Assignee: Marko Denda
>
> {noformat}
> cqlsh:test1> select * from test where token("key") < -9223372036854775807;
> (0 rows)
> cqlsh:test1> select * from test where token("key") < -9223372036854775808;
> key | value
> -----+----------
> 5 | eeeeee
> 10 | j
> 1 | aaaa
> 8 | hhhhhhhh
> 2 | bbb
> 4 | dd
> 7 | gggg
> 6 | fff
> 9 | iiii
> 3 | ccccc
> {noformat}
> Expected: empty result.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
