You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Mikhail Stepura (JIRA)" <ji...@apache.org> on 2014/05/10 23:57:32 UTC
[jira] [Comment Edited] (CASSANDRA-7196) "Select" query with "IN"
restriction times out in CQLSH
[ https://issues.apache.org/jira/browse/CASSANDRA-7196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13993790#comment-13993790 ]
Mikhail Stepura edited comment on CASSANDRA-7196 at 5/9/14 6:24 PM:
--------------------------------------------------------------------
The query doesn't timeout, but still doesn't return correct values. Those "cells" must be "empty" not "nulls"
{code}
{cqlsh:test> select intcol, bigintcol, varintcol from has_all_types where num in (0, 1, 2, 3, 4);
intcol | bigintcol | varintcol
-------------+----------------------+-----------------------------
-12 | 1234567890123456789 | 10000000000000000000000000
2147483647 | 9223372036854775807 | 9
0 | 0 | 0
-2147483648 | -9223372036854775808 | -10000000000000000000000000
null | null | null
(5 rows)
{code}
was (Author: mishail):
The query doesn't timeout, but still doesn't return correct values. Those "cells" must be "empty" not "nulls"
{code}
{cqlsh:test> select intcol, bigintcol, varintcol from has_all_types where num in (0, 1, 2, 3, 4);
intcol | bigintcol | varintcol
-------------+----------------------+-----------------------------
-12 | 1234567890123456789 | 10000000000000000000000000
2147483647 | 9223372036854775807 | 9
0 | 0 | 0
-2147483648 | -9223372036854775808 | -10000000000000000000000000
null | null | null
(5 rows)
> "Select" query with "IN" restriction times out in CQLSH
> -------------------------------------------------------
>
> Key: CASSANDRA-7196
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7196
> Project: Cassandra
> Issue Type: Bug
> Reporter: Mikhail Stepura
> Assignee: T Jake Luciani
> Labels: regression
> Fix For: 2.1 rc1
>
> Attachments: 7196-v2.txt, 7196-v3.txt, 7196.txt, init_bug.cql
>
>
> I've noticed that {{pylib.cqlshlib.test.test_cqlsh_output.TestCqlshOutput#test_numeric_output}} tests fails on the current 2.1 branch, which wasn't the case before.
> Here are the steps to reproduce. I'm attaching the script to populate schema.
> {code}
> mstepura-mac:cassandra mikhail$ bin/cqlsh -f <path_to>/init_bug.cql
> mstepura-mac:cassandra mikhail$ bin/cqlsh
> Connected to Test Cluster at 127.0.0.1:9042.
> [cqlsh 5.0.0 | Cassandra 2.1.0-beta2-SNAPSHOT | CQL spec 3.1.6 | Native protocol v2]
> Use HELP for help.
> cqlsh> use test;
> cqlsh:test> select intcol, bigintcol, varintcol from has_all_types where num in (0, 1, 2, 3, 4);
> errors={}, last_host=127.0.0.1
> cqlsh:test>
> {code}
> That works perfectly on 2.0 branch. And there are no errors in the logs.
--
This message was sent by Atlassian JIRA
(v6.2#6252)