[
https://issues.apache.org/jira/browse/CASSANDRA-19573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Himanshu sahu Ksolve NiFi Expert reassigned CASSANDRA-19573:
-------------------------------------------------------------
Assignee: Himanshu sahu Ksolve NiFi Expert
> incorrect queries showing up in queries virtual table
> -----------------------------------------------------
>
> Key: CASSANDRA-19573
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19573
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/Virtual Tables
> Reporter: Jon Haddad
> Assignee: Himanshu sahu Ksolve NiFi Expert
> Priority: Normal
> Fix For: 4.1.x, 5.0.x, 5.x
>
>
> While running an easy-cass-stress workload I queried system_views.queries and
> got this (edited for sanity):
>
> {noformat}
> thread_id | queued_micros | running_micros | task
> -----------------+---------------+----------------+----
> MutationStage-2 | 0 | 0 |
> Mutation(keyspace='easy_cass_stress', key='3030312e302e3937363535',
> modifications=[\n [easy_cass_stress.random_access] key=001.0.97655
> partition_deletion=deletedAt=-9223372036854775808, localDeletion=2147483647
> columns=[[] | [value]]\n Row[info=[ts=1713501354789139] ]: row_id=291 |
> [value=SXFNPWZDYFHTUSBWMUQCTTRAHQWXMGYOHASTGDFYLILWMOSFQWZGKUAIPUUGCLTADKFFXZRQGKIJJLXNOQKMAIOVSSVMVSFSFAVPABIIHGQSGRPACFWCKYMZMSNZZARSBFVDASTMCRHAVAYHKQDZWFCHRUPDWZJVTEVIWKPMKLAOZGBUDFJVOPSAHLAIWOGNXZHCBVK
> ts=1713501354789139]\n])
> ReadStage-4 | 0 | 6216 | SELECT * FROM
> easy_cass_stress.random_access WHERE partition_id = '001.0.18474' AND row_id
> = 746 LIMIT 5000 ALLOW FILTERING
> {noformat}
> What's interesting is that I supply neither a LIMIT or ALLOW FILTERING when I
> prepared the query. I assume the limit is coming from the driver, and while
> it's technically correct from the standpoint of what it does, it's not what I
> prepared so it's a little weird to see it there.
> The ALLOW FILTERING, on the other hand, was definitely not prepared.
> {noformat}
> session.prepare("SELECT * from random_access WHERE partition_id = ? and
> row_id = ?")
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
