[
https://issues.apache.org/jira/browse/CASSANDRA-6137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795562#comment-13795562
]
Constance Eustace commented on CASSANDRA-6137:
----------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ID: 924d6742-31fd-11e3-97f7-001c42000009-CJOB !!NOMATCH!!:
[__CPSYS_name, subPropA:filttest:sdf, urn:bby:pcm:ingest:status,
urn@bby@pcm@job@ingest@content@complete@count] to
[__CPSYS_name, subPropA:filttest:sdf, urn:bby:pcm:ingest:status]
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select * from wayfair_submission.entity_job where e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' ;
RESULT:
e_entid | p_prop
| describes | dndcondition | e_entlinks
| e_entname | e_enttype |
ingeststatus | ingeststatusdetail | p_flags | p_propid
| p_proplinks | p_storage | p_subents | p_val | p_vallang |
p_vallinks | p_valtype | p_valunit | p_vars
| partnerid |
referenceid | size | sourceip | submitdate |
submitevent | userid | version
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_links | null | null |
[{"content":null,"href":"http://cupcake/wayfair/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB","rel":"parent-entity","type":"application/vnd.bestbuy.content.entity","hreflang":null,"title":"Up
to Parent
Entity","length":null,"otherAttributes":{}},{"content":null,"href":"http://cupcake/wayfair/entities/id/9222fbe1-31fd-11e3-97f7-001c42000009-CJOB/properties/type/DYNApropAA%3Asdjlk%3Asdfklj%3Afiltertest","rel":"up","type":"application/vnd.bestbuy.content.property","hreflang":null,"title":"Up
to Parent Entity Property","length":null,"otherAttributes":{}}] | null |
null | null | null | null |
null | null | null | null |
null | null | null | null | null |
null
| null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_name | null | null |
null | SUBENT-100 | null
| null | null | null |
null | null | null | null | null | null
| null | null | null |
null | null |
null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
__CPSYS_type | null | null |
null | null | urn:bby:pcm:job
| null | null | null |
null | null | null | null | null | null
| null | null | null |
null | null |
null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
subPropA:filttest:sdf | null | null |
null | null |
null | null | null | DVM |
924d6743-31fd-11e3-97f7-001c42000009 | [] | null | [] |
["subE","subI","subH"] | en_us | [] | text | m |
[{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}]
| null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn:bby:pcm:ingest:status | null | null |
null | null |
null | subC | null | S00 |
924d6744-31fd-11e3-97f7-001c42000009 | [] | null | [] |
null | null | [] | null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |
null | null | null | null | null |
null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn:bby:pcm:job:sourceparty:reference:id | null | null |
null |
null | null | null | null | S00 |
924d6745-31fd-11e3-97f7-001c42000009 | [] | null | [] |
null | null | [] | null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["cdc8911c-7092-4c71-a7a6-935331ff2c5c"],"links":[]}]
| null | cdc8911c-7092-4c71-a7a6-935331ff2c5c | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB |
urn@bby@pcm@job@ingest@content@complete@count | null | null |
null | null | null | null | null |
null | null | [] | null |
null | null | null | null | null | null
|
null | null | null |
null | null | null | null | null | null
TRACE:
DEBUG [Thrift:1] 2013-10-15 14:45:26,841 CassandraServer.java (line 1699)
execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:45:26,842 QueryProcessor.java (line 100) Process
org.apache.cassandra.cql3.statements.SelectStatement@7aacaaae @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:45:26,843 ReadCallback.java (line 67) Blockfor
is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:3] 2013-10-15 14:45:26,851 SSTableReader.java (line 756)
Adding cache entry for
KeyCacheKey(/Users/a999166/aaa-projects/apache-cassandra-1.2.8/z-serverfiles/data/wayfair_submission/entity_job/wayfair_submission-entity_job-ic-2,
39323464363734322d333166642d313165332d393766372d3030316334323030303030392d434a4f42)
-> org.apache.cassandra.db.RowIndexEntry@4017415d
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 0 of 10000: __CPSYS_links::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_links:e_entlinks:false:566@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,853 SliceQueryFilter.java (line 161)
collecting 2 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 2 of 10000: __CPSYS_type::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 3 of 10000: __CPSYS_type:e_enttype:false:15@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 3 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,854 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000:
subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 4 of 10000: urn\:bby\:pcm\:ingest\:status::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,855 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 5 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id::false:0@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_flags:false:3@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_propid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,856 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_subents:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:p_vars:false:102@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn\:bby\:pcm\:job\:sourceparty\:reference\:id:referenceid:false:36@1381445090517000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 6 of 10000:
urn@bby@pcm@job@ingest@content@complete@count::false:0@1381860857189000
TRACE [ReadStage:3] 2013-10-15 14:45:26,857 SliceQueryFilter.java (line 161)
collecting 7 of 10000:
urn@bby@pcm@job@ingest@content@complete@count:p_proplinks:false:2@1381860857189000
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * FROM wayfair_submission.entity_job WHERE e_entid =
'924d6742-31fd-11e3-97f7-001c42000009-CJOB' AND p_prop IN
('__CPSYS_name','urn:bby:pcm:ingest:status','subPropA:filttest:sdf','urn@bby@pcm@job@ingest@content@complete@count')
RESULT:
e_entid | p_prop |
describes | dndcondition | e_entlinks | e_entname | e_enttype | ingeststatus |
ingeststatusdetail | p_flags | p_propid |
p_proplinks | p_storage | p_subents | p_val | p_vallang |
p_vallinks | p_valtype | p_valunit | p_vars
| partnerid | referenceid | size |
sourceip | submitdate | submitevent | userid | version
924d6742-31fd-11e3-97f7-001c42000009-CJOB | __CPSYS_name |
null | null | null | SUBENT-100 | null | null |
null | null | null | null |
null | null | null | null | null |
null | null |
null | null | null | null | null |
null | null | null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB | subPropA:filttest:sdf |
null | null | null | null | null | null |
null | DVM | 924d6743-31fd-11e3-97f7-001c42000009 | [] |
null | [] | ["subE","subI","subH"] | en_us | [] |
text | m |
[{"type":"text","lang":"en_us","uom":"m","datas":["subE","subI","subH"],"links":[]}]
| null | null | null | null | null | null |
null | null
924d6742-31fd-11e3-97f7-001c42000009-CJOB | urn:bby:pcm:ingest:status |
null | null | null | null | null | subC |
null | S00 | 924d6744-31fd-11e3-97f7-001c42000009 | [] |
null | [] | null | null | [] |
null | null |
[{"type":"text","lang":"en_us","uom":"m","datas":["subC"],"links":[]}] |
null | null | null | null | null | null | null |
null
TRACE:
DEBUG [Thrift:1] 2013-10-15 14:48:39,115 CassandraServer.java (line 1699)
execute_cql3_query
TRACE [Thrift:1] 2013-10-15 14:48:39,116 QueryProcessor.java (line 100) Process
org.apache.cassandra.cql3.statements.SelectStatement@58053ef7 @CL.ONE
TRACE [Thrift:1] 2013-10-15 14:48:39,116 ReadCallback.java (line 67) Blockfor
is 1; setting up requests to /127.0.0.1
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 0 of 10000: __CPSYS_name::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 1 of 10000: __CPSYS_name:e_entname:false:10@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,117 SliceQueryFilter.java (line 161)
collecting 1 of 10000: subPropA\:filttest\:sdf::false:0@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_val:false:22@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_vallang:false:5@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_valtype:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,118 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
subPropA\:filttest\:sdf:p_valunit:false:1@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 2 of 10000: subPropA\:filttest\:sdf:p_vars:false:84@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 2 of 10000:
urn\:bby\:pcm\:ingest\:status:ingeststatus:false:4@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_flags:false:3@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_propid:false:36@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_proplinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_subents:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vallinks:false:2@1381445090517000
TRACE [ReadStage:33] 2013-10-15 14:48:39,119 SliceQueryFilter.java (line 161)
collecting 3 of 10000:
urn\:bby\:pcm\:ingest\:status:p_vars:false:70@1381445090517000
DEBUG [Thrift:1] 2013-10-15 14:48:39,120 Tracing.java (line 167) request
complete
> CQL3 SELECT IN CLAUSE inconsistent
> ----------------------------------
>
> Key: CASSANDRA-6137
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6137
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: Ubuntu AWS Cassandra 2.0.1 SINGLE NODE
> Reporter: Constance Eustace
> Fix For: 2.0.1
>
>
> We are encountering inconsistent results from CQL3 queries with column keys
> using IN clause in WHERE. This has been reproduced in cqlsh and the jdbc
> driver.
> Rowkey is e_entid
> Column key is p_prop
> This returns roughly 21 rows for 21 column keys that match p_prop.
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB';
> These three queries each return one row for the requested single column key
> in the IN clause:
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:complete:count');
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:all:count');
> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:fail:count');
> This query returns ONLY ONE ROW (one column key), not three as I would expect
> from the three-column-key IN clause:
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in
> ('urn:bby:pcm:job:ingest:content:complete:count','urn:bby:pcm:job:ingest:content:all:count','urn:bby:pcm:job:ingest:content:fail:count');
> This query does return two rows however for the requested two column keys:
> cqlsh> SELECT
> e_entid,e_entname,e_enttype,p_prop,p_flags,p_propid,e_entlinks,p_proplinks,p_subents,p_val,p_vallinks,p_vars
> FROM internal_submission.Entity_Job WHERE e_entid =
> '845b38f1-2b91-11e3-854d-126aad0075d4-CJOB' AND p_prop in (
>
> 'urn:bby:pcm:job:ingest:content:all:count','urn:bby:pcm:job:ingest:content:fail:count');
> cqlsh> describe table internal_submission.entity_job;
> CREATE TABLE entity_job (
> e_entid text,
> p_prop text,
> describes text,
> dndcondition text,
> e_entlinks text,
> e_entname text,
> e_enttype text,
> ingeststatus text,
> ingeststatusdetail text,
> p_flags text,
> p_propid text,
> p_proplinks text,
> p_storage text,
> p_subents text,
> p_val text,
> p_vallang text,
> p_vallinks text,
> p_valtype text,
> p_valunit text,
> p_vars text,
> partnerid text,
> referenceid text,
> size int,
> sourceip text,
> submitdate bigint,
> submitevent text,
> userid text,
> version text,
> PRIMARY KEY (e_entid, p_prop)
> ) WITH
> bloom_filter_fp_chance=0.010000 AND
> caching='KEYS_ONLY' AND
> comment='' AND
> dclocal_read_repair_chance=0.000000 AND
> gc_grace_seconds=864000 AND
> index_interval=128 AND
> read_repair_chance=0.100000 AND
> replicate_on_write='true' AND
> populate_io_cache_on_flush='false' AND
> default_time_to_live=0 AND
> speculative_retry='NONE' AND
> memtable_flush_period_in_ms=0 AND
> compaction={'class': 'SizeTieredCompactionStrategy'} AND
> compression={'sstable_compression': 'LZ4Compressor'};
> CREATE INDEX internal_submission__JobDescribesIDX ON entity_job (describes);
> CREATE INDEX internal_submission__JobDNDConditionIDX ON entity_job
> (dndcondition);
> CREATE INDEX internal_submission__JobIngestStatusIDX ON entity_job
> (ingeststatus);
> CREATE INDEX internal_submission__JobIngestStatusDetailIDX ON entity_job
> (ingeststatusdetail);
> CREATE INDEX internal_submission__JobReferenceIDIDX ON entity_job
> (referenceid);
> CREATE INDEX internal_submission__JobUserIDX ON entity_job (userid);
> CREATE INDEX internal_submission__JobVersionIDX ON entity_job (version);
> -------------------------------
> My suspicion is that the three-column-key IN Clause is translated (improperly
> or not) to a two-column key range with the assumption that the third column
> key is present in that range, but it isn't...
--
This message was sent by Atlassian JIRA
(v6.1#6144)
