cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marko Denda (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-7020) Incorrect result of query WHERE token(key) < -9223372036854775808 when using Murmur3Partitioner
Date Sun, 14 Sep 2014 20:22:34 GMT

    [ 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)

Mime
View raw message