[
https://issues.apache.org/jira/browse/CASSANDRA-13111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Nabatchikov updated CASSANDRA-13111:
----------------------------------------------
Description:
I have table like this:
create table test_table
(
pkey1 int,
pkey2 int,
pkey3 int,
ccol1 int,
ccol2 int,
col int,
PRIMARY KEY ((pkey1,pkey2,pkey3), ccol1, ccol2)
);
And this CQL won't work:
SELECT * FROM test_table WHERE pkey1 = ? AND pkey2 = ? AND pkey3 = ? AND ccol1
= ? AND col = ? ALLOW FILTERING;
It throws message: Unsupported unset value for column col.
But if execute just: "SELECT * FROM test_table WHERE col = ? ALLOW FILTERING;"
all is OK.
P.S reproduces only with prepared statements
was:
I have table like this:
create table test_table
(
pkey1 int,
pkey2 int,
pkey3 int,
ccol1 int,
ccol2 int,
col int
) PRIMARY KEY ((pkey1,pkey2,pkey3), ccol1, ccol2);
And this CQL won't work:
SELECT * FROM test_table WHERE pkey1 = ? AND pkey2 = ? AND pkey3 = ? AND ccol1
= ? AND col = ? ALLOW FILTERING;
It throws message: Unsupported unset value for column col.
But if execute just: "SELECT * FROM test_table WHERE col = ? ALLOW FILTERING;"
all is OK.
P.S reproduces only with prepared statements
> Unsupported unset value for column
> ----------------------------------
>
> Key: CASSANDRA-13111
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13111
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Environment: Ubuntu 16.04
> Reporter: Alexander Nabatchikov
> Priority: Minor
>
> I have table like this:
> create table test_table
> (
> pkey1 int,
> pkey2 int,
> pkey3 int,
> ccol1 int,
> ccol2 int,
> col int,
> PRIMARY KEY ((pkey1,pkey2,pkey3), ccol1, ccol2)
> );
> And this CQL won't work:
> SELECT * FROM test_table WHERE pkey1 = ? AND pkey2 = ? AND pkey3 = ? AND
> ccol1 = ? AND col = ? ALLOW FILTERING;
> It throws message: Unsupported unset value for column col.
> But if execute just: "SELECT * FROM test_table WHERE col = ? ALLOW
> FILTERING;" all is OK.
> P.S reproduces only with prepared statements
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
