Fred DERNBACH
2013-01-17 12:42:41 UTC
Fred DERNBACH [https://community.jboss.org/people/fdernb] created the discussion
"Re: Problem with Human Task query TasksAssignedAsPotentialOwnerByStatus"
To view the discussion, visit: https://community.jboss.org/message/792579#792579
--------------------------------------------------------------
I confirm the issue. Oracle does not receive proper binding variable for status list. below is the Oracle trace of the hibernate query. See in *bold*.
SQL_IDÂ 1fnn7qr6kqp5y, child number 1
-------------------------------------
select user2_.id as id175_0_, user1_.id as id175_1_, task0_.id as col_0_0_,
task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_,
descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_,
task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as
col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_,
task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer
join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join
OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText
subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on
task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on
task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0
)and((organizati6_.id=:1 )or(organi
Plan hash value: 2720357931
---------------------------------------------------------------------------------------------------------
| Id | Operation                | Name                       | Rows | Bytes | Cost (%CPU)| Time    |
---------------------------------------------------------------------------------------------------------
|Â Â 0 | SELECT STATEMENTÂ Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â 40 (100)|Â Â Â Â Â Â Â Â Â |
|*Â 1 |Â FILTERÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|*Â 2 |Â Â HASH JOIN OUTERÂ Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 7594 |Â Â Â 40Â Â (5)| 00:00:04 |
|*Â 3 |Â Â Â HASH JOIN OUTERÂ Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 5450 |Â Â Â 33Â Â (7)| 00:00:04 |
|*Â 4 |Â Â Â Â HASH JOIN OUTERÂ Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 3306 |Â Â Â 25Â Â (4)| 00:00:03 |
|Â Â 5 |Â Â Â Â Â NESTED LOOPSÂ Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 1162 |Â Â Â 18Â Â (6)| 00:00:02 |
|*Â 6 |Â Â Â Â Â Â HASH JOINÂ Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 1033 |Â Â Â 17Â Â (6)| 00:00:02 |
|Â Â 7 |Â Â Â Â Â Â Â NESTED LOOPS OUTER |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 891 |Â Â Â Â 9Â Â (0)| 00:00:01 |
|Â Â 8 |Â Â Â Â Â Â Â Â NESTED LOOPS OUTER|Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 762 |Â Â Â Â 8Â Â (0)| 00:00:01 |
|*Â 9 |Â Â Â Â Â Â Â Â Â TABLE ACCESS FULL| TASKÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 633 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|* 10 |Â Â Â Â Â Â Â Â Â INDEX UNIQUE SCAN| SYS_C00144479Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 129 |Â Â Â Â 1Â Â (0)| 00:00:01 |
|* 11 |Â Â Â Â Â Â Â Â INDEX UNIQUE SCAN | SYS_C00144479Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 129 |Â Â Â Â 1Â Â (0)| 00:00:01 |
|Â 12 |Â Â Â Â Â Â Â SORT UNIQUEÂ Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 10 |Â 1420 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|* 13 |Â Â Â Â Â Â Â Â TABLE ACCESS FULL | PEOPLEASSIGNMENTS_POTOWNERS |Â Â Â 10 |Â 1420 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|* 14 |Â Â Â Â Â Â INDEX UNIQUE SCANÂ Â | SYS_C00144479Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 129 |Â Â Â Â 1Â Â (0)| 00:00:01 |
|Â 15 |Â Â Â Â Â TABLE ACCESS FULLÂ Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 30 | 64320 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 16 |Â Â Â Â TABLE ACCESS FULLÂ Â Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 30 | 64320 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 17 |Â Â Â TABLE ACCESS FULLÂ Â Â Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 30 | 64320 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 18 |Â Â SORT AGGREGATEÂ Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|* 19 |Â Â Â TABLE ACCESS FULLÂ Â Â Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 20 |Â Â Â Â SORT AGGREGATEÂ Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|* 21 |Â Â Â Â Â TABLE ACCESS FULLÂ Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 22 |Â Â Â Â Â Â SORT AGGREGATEÂ Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|* 23 |Â Â Â Â Â Â Â TABLE ACCESS FULLÂ | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â 7Â Â (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
  1 - SEL$1B69B172
  9 - SEL$1B69B172 / ***@SEL$2
 10 - SEL$1B69B172 / ***@SEL$3
 11 - SEL$1B69B172 / ***@SEL$1
 13 - SEL$1B69B172 / ***@SEL$12
 14 - SEL$1B69B172 / ***@SEL$11
 15 - SEL$1B69B172 / ***@SEL$9
 16 - SEL$1B69B172 / ***@SEL$7
 17 - SEL$1B69B172 / ***@SEL$5
 18 - SEL$13    Â
 19 - SEL$13      / ***@SEL$13
 20 - SEL$14    Â
 21 - SEL$14      / ***@SEL$14
 22 - SEL$15    Â
 23 - SEL$15      / ***@SEL$15
Outline Data
-------------
 /*+
     BEGIN_OUTLINE_DATA
     IGNORE_OPTIM_EMBEDDED_HINTS
     OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
     OPT_PARAM('_optimizer_connect_by_cost_based' 'false')
     OPT_PARAM('star_transformation_enabled' 'temp_disable')
     OPT_PARAM('optimizer_index_caching' 50)
     ALL_ROWS
     OUTLINE_LEAF(@"SEL$13")
     OUTLINE_LEAF(@"SEL$14")
     OUTLINE_LEAF(@"SEL$15")
     OUTLINE_LEAF(@"SEL$1B69B172")
     UNNEST(@"SEL$12")
     OUTLINE(@"SEL$13")
     OUTLINE(@"SEL$14")
     OUTLINE(@"SEL$15")
     OUTLINE(@"SEL$48266A83")
     MERGE(@"SEL$B97648DD")
     OUTLINE(@"SEL$12")
     OUTLINE(@"SEL$11")
     OUTLINE(@"SEL$B97648DD")
     MERGE(@"SEL$096E5AED")
     MERGE(@"SEL$9")
     OUTLINE(@"SEL$10")
     OUTLINE(@"SEL$096E5AED")
     MERGE(@"SEL$15E987C1")
     MERGE(@"SEL$7")
     OUTLINE(@"SEL$9")
     OUTLINE(@"SEL$8")
     OUTLINE(@"SEL$15E987C1")
     MERGE(@"SEL$5")
     MERGE(@"SEL$7237DA6D")
     OUTLINE(@"SEL$7")
     OUTLINE(@"SEL$6")
     OUTLINE(@"SEL$5")
     OUTLINE(@"SEL$7237DA6D")
     MERGE(@"SEL$3")
     MERGE(@"SEL$58A6D7F6")
     OUTLINE(@"SEL$4")
     OUTLINE(@"SEL$3")
     OUTLINE(@"SEL$58A6D7F6")
     MERGE(@"SEL$1")
     OUTLINE(@"SEL$2")
     OUTLINE(@"SEL$1")
     FULL(@"SEL$1B69B172" "TASK0_"@"SEL$2")
     INDEX(@"SEL$1B69B172" "USER2_"@"SEL$3" ("ORGANIZATIONALENTITY"."ID"))
     INDEX(@"SEL$1B69B172" "USER1_"@"SEL$1" ("ORGANIZATIONALENTITY"."ID"))
     FULL(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")
     INDEX(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11" ("ORGANIZATIONALENTITY"."ID"))
     FULL(@"SEL$1B69B172" "NAMES5_"@"SEL$9")
     FULL(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")
     FULL(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")
     LEADING(@"SEL$1B69B172" "TASK0_"@"SEL$2" "USER2_"@"SEL$3" "USER1_"@"SEL$1"
             "POTENTIALO7_"@"SEL$12" "ORGANIZATI6_"@"SEL$11" "NAMES5_"@"SEL$9" "DESCRIPTIO4_"@"SEL$7"
             "SUBJECTS3_"@"SEL$5")
     USE_NL(@"SEL$1B69B172" "USER2_"@"SEL$3")
     USE_NL(@"SEL$1B69B172" "USER1_"@"SEL$1")
     USE_HASH(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")
     USE_NL(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11")
     USE_HASH(@"SEL$1B69B172" "NAMES5_"@"SEL$9")
     USE_HASH(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")
     USE_HASH(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")
     FULL(@"SEL$15" "DESCRIPTIO10_"@"SEL$15")
     FULL(@"SEL$14" "SUBJECTS9_"@"SEL$14")
     FULL(@"SEL$13" "NAMES8_"@"SEL$13")
     END_OUTLINE_DATA
 */
Peeked Binds (identified by position):
--------------------------------------
  1 - :1 (VARCHAR2(30), CSID=46): 'ITCH'
  2 - :2 (VARCHAR2(30), CSID=46): 'SECURITY_GLOBAL'
  3 - :3 (VARCHAR2(30), CSID=46): 'SECURITY_AUTHORITY'
*Â Â 7 - :7 (RAW(30)): aced00057e7200146f72672e6a62706d2e7461736b2e537461747573000000000000000012000078720*
*Â Â Â Â Â Â 00e6a6176612e6c616e672e456e756d000000000000000012000078707400055265616479*
Predicate Information (identified by operation id):
---------------------------------------------------
  1 - filter((("NAMES5_"."LANGUAGE"=:4 OR =0) AND ("SUBJECTS3_"."LANGUAGE"=:5 OR =0) AND
             ("DESCRIPTIO4_"."LANGUAGE"=:6 OR =0)))
  2 - access("TASK0_"."ID"="SUBJECTS3_"."TASK_SUBJECTS_ID")
  3 - access("TASK0_"."ID"="DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID")
  4 - access("TASK0_"."ID"="NAMES5_"."TASK_NAMES_ID")
  6 - access("TASK0_"."ID"="POTENTIALO7_"."TASK_ID")
  9 - filter(("TASK0_"."EXPIRATIONTIME" IS NULL AND "TASK0_"."ARCHIVED"=0 AND
             "TASK0_"."STATUS"=RAWTOHEX(:7)))
 10 - access("TASK0_"."ACTUALOWNER_ID"="USER2_"."ID")
 11 - access("TASK0_"."CREATEDBY_ID"="USER1_"."ID")
 13 - filter(("POTENTIALO7_"."ENTITY_ID"=:1 OR "POTENTIALO7_"."ENTITY_ID"=:2 OR
             "POTENTIALO7_"."ENTITY_ID"=:3))
 14 - access("ORGANIZATI6_"."ID"="POTENTIALO7_"."ENTITY_ID")
      filter(("ORGANIZATI6_"."ID"=:1 OR "ORGANIZATI6_"."ID"=:2 OR "ORGANIZATI6_"."ID"=:3))
 19 - filter("NAMES8_"."TASK_NAMES_ID"=:B1)
 21 - filter("SUBJECTS9_"."TASK_SUBJECTS_ID"=:B1)
 23 - filter("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"=:B1)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
  1 - "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000], "NAMES5_"."TEXT"[LOB,4000],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255],
      "SUBJECTS3_"."TEXT"[LOB,4000]
  2 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000],
      "NAMES5_"."TEXT"[LOB,4000], "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255],
      "NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255],
      "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000]
  3 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22],
      "NAMES5_"."TEXT"[LOB,4000], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22],
      "ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
      "NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255],
      "DESCRIPTIO4_"."TEXT"[LOB,4000]
  4 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22],
      "ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
      "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000]
  5 - "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
      "ORGANIZATI6_"."ID"[VARCHAR2,255]
  6 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
  7 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "USER1_"."ID"[VARCHAR2,255]
  8 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]
  9 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255]
 10 - "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]
 11 - "USER1_".ROWID[ROWID,10], "USER1_"."ID"[VARCHAR2,255]
 12 - (#keys=2) "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
 13 - "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
 14 - "ORGANIZATI6_".ROWID[ROWID,10], "ORGANIZATI6_"."ID"[VARCHAR2,255]
 15 - "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000],
      "NAMES5_"."TASK_NAMES_ID"[NUMBER,22]
 16 - "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."TEXT"[LOB,4000],
      "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]
 17 - "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000],
      "SUBJECTS3_"."TASK_SUBJECTS_ID"[NUMBER,22]
 18 - (#keys=0) COUNT("NAMES8_"."TASK_NAMES_ID")[22]
 19 - "NAMES8_"."TASK_NAMES_ID"[NUMBER,22]
 20 - (#keys=0) COUNT("SUBJECTS9_"."TASK_SUBJECTS_ID")[22]
 21 - "SUBJECTS9_"."TASK_SUBJECTS_ID"[NUMBER,22]
 22 - (#keys=0) COUNT("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID")[22]
 23 - "DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]
Note
-----
  - dynamic sampling used for this statement
   Subject
   Requete Task
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/792579#792579]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
"Re: Problem with Human Task query TasksAssignedAsPotentialOwnerByStatus"
To view the discussion, visit: https://community.jboss.org/message/792579#792579
--------------------------------------------------------------
I confirm the issue. Oracle does not receive proper binding variable for status list. below is the Oracle trace of the hibernate query. See in *bold*.
SQL_IDÂ 1fnn7qr6kqp5y, child number 1
-------------------------------------
select user2_.id as id175_0_, user1_.id as id175_1_, task0_.id as col_0_0_,
task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_,
descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_,
task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as
col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_,
task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer
join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join
OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText
subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on
task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on
task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0
)and((organizati6_.id=:1 )or(organi
Plan hash value: 2720357931
---------------------------------------------------------------------------------------------------------
| Id | Operation                | Name                       | Rows | Bytes | Cost (%CPU)| Time    |
---------------------------------------------------------------------------------------------------------
|Â Â 0 | SELECT STATEMENTÂ Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â 40 (100)|Â Â Â Â Â Â Â Â Â |
|*Â 1 |Â FILTERÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|*Â 2 |Â Â HASH JOIN OUTERÂ Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 7594 |Â Â Â 40Â Â (5)| 00:00:04 |
|*Â 3 |Â Â Â HASH JOIN OUTERÂ Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 5450 |Â Â Â 33Â Â (7)| 00:00:04 |
|*Â 4 |Â Â Â Â HASH JOIN OUTERÂ Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 3306 |Â Â Â 25Â Â (4)| 00:00:03 |
|Â Â 5 |Â Â Â Â Â NESTED LOOPSÂ Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 1162 |Â Â Â 18Â Â (6)| 00:00:02 |
|*Â 6 |Â Â Â Â Â Â HASH JOINÂ Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â 1033 |Â Â Â 17Â Â (6)| 00:00:02 |
|Â Â 7 |Â Â Â Â Â Â Â NESTED LOOPS OUTER |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 891 |Â Â Â Â 9Â Â (0)| 00:00:01 |
|Â Â 8 |Â Â Â Â Â Â Â Â NESTED LOOPS OUTER|Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 762 |Â Â Â Â 8Â Â (0)| 00:00:01 |
|*Â 9 |Â Â Â Â Â Â Â Â Â TABLE ACCESS FULL| TASKÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 633 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|* 10 |Â Â Â Â Â Â Â Â Â INDEX UNIQUE SCAN| SYS_C00144479Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 129 |Â Â Â Â 1Â Â (0)| 00:00:01 |
|* 11 |Â Â Â Â Â Â Â Â INDEX UNIQUE SCAN | SYS_C00144479Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 129 |Â Â Â Â 1Â Â (0)| 00:00:01 |
|Â 12 |Â Â Â Â Â Â Â SORT UNIQUEÂ Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 10 |Â 1420 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|* 13 |Â Â Â Â Â Â Â Â TABLE ACCESS FULL | PEOPLEASSIGNMENTS_POTOWNERS |Â Â Â 10 |Â 1420 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|* 14 |Â Â Â Â Â Â INDEX UNIQUE SCANÂ Â | SYS_C00144479Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â 129 |Â Â Â Â 1Â Â (0)| 00:00:01 |
|Â 15 |Â Â Â Â Â TABLE ACCESS FULLÂ Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 30 | 64320 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 16 |Â Â Â Â TABLE ACCESS FULLÂ Â Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 30 | 64320 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 17 |Â Â Â TABLE ACCESS FULLÂ Â Â Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â 30 | 64320 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 18 |Â Â SORT AGGREGATEÂ Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|* 19 |Â Â Â TABLE ACCESS FULLÂ Â Â Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 20 |Â Â Â Â SORT AGGREGATEÂ Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|* 21 |Â Â Â Â Â TABLE ACCESS FULLÂ Â Â | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â 7Â Â (0)| 00:00:01 |
|Â 22 |Â Â Â Â Â Â SORT AGGREGATEÂ Â Â Â Â |Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â Â Â Â Â Â |
|* 23 |Â Â Â Â Â Â Â TABLE ACCESS FULLÂ | I18NTEXTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |Â Â Â Â 1 |Â Â Â 13 |Â Â Â Â 7Â Â (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
  1 - SEL$1B69B172
  9 - SEL$1B69B172 / ***@SEL$2
 10 - SEL$1B69B172 / ***@SEL$3
 11 - SEL$1B69B172 / ***@SEL$1
 13 - SEL$1B69B172 / ***@SEL$12
 14 - SEL$1B69B172 / ***@SEL$11
 15 - SEL$1B69B172 / ***@SEL$9
 16 - SEL$1B69B172 / ***@SEL$7
 17 - SEL$1B69B172 / ***@SEL$5
 18 - SEL$13    Â
 19 - SEL$13      / ***@SEL$13
 20 - SEL$14    Â
 21 - SEL$14      / ***@SEL$14
 22 - SEL$15    Â
 23 - SEL$15      / ***@SEL$15
Outline Data
-------------
 /*+
     BEGIN_OUTLINE_DATA
     IGNORE_OPTIM_EMBEDDED_HINTS
     OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
     OPT_PARAM('_optimizer_connect_by_cost_based' 'false')
     OPT_PARAM('star_transformation_enabled' 'temp_disable')
     OPT_PARAM('optimizer_index_caching' 50)
     ALL_ROWS
     OUTLINE_LEAF(@"SEL$13")
     OUTLINE_LEAF(@"SEL$14")
     OUTLINE_LEAF(@"SEL$15")
     OUTLINE_LEAF(@"SEL$1B69B172")
     UNNEST(@"SEL$12")
     OUTLINE(@"SEL$13")
     OUTLINE(@"SEL$14")
     OUTLINE(@"SEL$15")
     OUTLINE(@"SEL$48266A83")
     MERGE(@"SEL$B97648DD")
     OUTLINE(@"SEL$12")
     OUTLINE(@"SEL$11")
     OUTLINE(@"SEL$B97648DD")
     MERGE(@"SEL$096E5AED")
     MERGE(@"SEL$9")
     OUTLINE(@"SEL$10")
     OUTLINE(@"SEL$096E5AED")
     MERGE(@"SEL$15E987C1")
     MERGE(@"SEL$7")
     OUTLINE(@"SEL$9")
     OUTLINE(@"SEL$8")
     OUTLINE(@"SEL$15E987C1")
     MERGE(@"SEL$5")
     MERGE(@"SEL$7237DA6D")
     OUTLINE(@"SEL$7")
     OUTLINE(@"SEL$6")
     OUTLINE(@"SEL$5")
     OUTLINE(@"SEL$7237DA6D")
     MERGE(@"SEL$3")
     MERGE(@"SEL$58A6D7F6")
     OUTLINE(@"SEL$4")
     OUTLINE(@"SEL$3")
     OUTLINE(@"SEL$58A6D7F6")
     MERGE(@"SEL$1")
     OUTLINE(@"SEL$2")
     OUTLINE(@"SEL$1")
     FULL(@"SEL$1B69B172" "TASK0_"@"SEL$2")
     INDEX(@"SEL$1B69B172" "USER2_"@"SEL$3" ("ORGANIZATIONALENTITY"."ID"))
     INDEX(@"SEL$1B69B172" "USER1_"@"SEL$1" ("ORGANIZATIONALENTITY"."ID"))
     FULL(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")
     INDEX(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11" ("ORGANIZATIONALENTITY"."ID"))
     FULL(@"SEL$1B69B172" "NAMES5_"@"SEL$9")
     FULL(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")
     FULL(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")
     LEADING(@"SEL$1B69B172" "TASK0_"@"SEL$2" "USER2_"@"SEL$3" "USER1_"@"SEL$1"
             "POTENTIALO7_"@"SEL$12" "ORGANIZATI6_"@"SEL$11" "NAMES5_"@"SEL$9" "DESCRIPTIO4_"@"SEL$7"
             "SUBJECTS3_"@"SEL$5")
     USE_NL(@"SEL$1B69B172" "USER2_"@"SEL$3")
     USE_NL(@"SEL$1B69B172" "USER1_"@"SEL$1")
     USE_HASH(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")
     USE_NL(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11")
     USE_HASH(@"SEL$1B69B172" "NAMES5_"@"SEL$9")
     USE_HASH(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")
     USE_HASH(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")
     FULL(@"SEL$15" "DESCRIPTIO10_"@"SEL$15")
     FULL(@"SEL$14" "SUBJECTS9_"@"SEL$14")
     FULL(@"SEL$13" "NAMES8_"@"SEL$13")
     END_OUTLINE_DATA
 */
Peeked Binds (identified by position):
--------------------------------------
  1 - :1 (VARCHAR2(30), CSID=46): 'ITCH'
  2 - :2 (VARCHAR2(30), CSID=46): 'SECURITY_GLOBAL'
  3 - :3 (VARCHAR2(30), CSID=46): 'SECURITY_AUTHORITY'
*Â Â 7 - :7 (RAW(30)): aced00057e7200146f72672e6a62706d2e7461736b2e537461747573000000000000000012000078720*
*Â Â Â Â Â Â 00e6a6176612e6c616e672e456e756d000000000000000012000078707400055265616479*
Predicate Information (identified by operation id):
---------------------------------------------------
  1 - filter((("NAMES5_"."LANGUAGE"=:4 OR =0) AND ("SUBJECTS3_"."LANGUAGE"=:5 OR =0) AND
             ("DESCRIPTIO4_"."LANGUAGE"=:6 OR =0)))
  2 - access("TASK0_"."ID"="SUBJECTS3_"."TASK_SUBJECTS_ID")
  3 - access("TASK0_"."ID"="DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID")
  4 - access("TASK0_"."ID"="NAMES5_"."TASK_NAMES_ID")
  6 - access("TASK0_"."ID"="POTENTIALO7_"."TASK_ID")
  9 - filter(("TASK0_"."EXPIRATIONTIME" IS NULL AND "TASK0_"."ARCHIVED"=0 AND
             "TASK0_"."STATUS"=RAWTOHEX(:7)))
 10 - access("TASK0_"."ACTUALOWNER_ID"="USER2_"."ID")
 11 - access("TASK0_"."CREATEDBY_ID"="USER1_"."ID")
 13 - filter(("POTENTIALO7_"."ENTITY_ID"=:1 OR "POTENTIALO7_"."ENTITY_ID"=:2 OR
             "POTENTIALO7_"."ENTITY_ID"=:3))
 14 - access("ORGANIZATI6_"."ID"="POTENTIALO7_"."ENTITY_ID")
      filter(("ORGANIZATI6_"."ID"=:1 OR "ORGANIZATI6_"."ID"=:2 OR "ORGANIZATI6_"."ID"=:3))
 19 - filter("NAMES8_"."TASK_NAMES_ID"=:B1)
 21 - filter("SUBJECTS9_"."TASK_SUBJECTS_ID"=:B1)
 23 - filter("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"=:B1)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
  1 - "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000], "NAMES5_"."TEXT"[LOB,4000],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255],
      "SUBJECTS3_"."TEXT"[LOB,4000]
  2 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000],
      "NAMES5_"."TEXT"[LOB,4000], "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255],
      "NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255],
      "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000]
  3 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22],
      "NAMES5_"."TEXT"[LOB,4000], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22],
      "ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
      "NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255],
      "DESCRIPTIO4_"."TEXT"[LOB,4000]
  4 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22],
      "ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
      "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000]
  5 - "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
      "ORGANIZATI6_"."ID"[VARCHAR2,255]
  6 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
      "USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
  7 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
      "USER1_"."ID"[VARCHAR2,255]
  8 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
      "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]
  9 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
      "TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
      "TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
      "TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
      "TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
      "TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255]
 10 - "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]
 11 - "USER1_".ROWID[ROWID,10], "USER1_"."ID"[VARCHAR2,255]
 12 - (#keys=2) "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
 13 - "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
 14 - "ORGANIZATI6_".ROWID[ROWID,10], "ORGANIZATI6_"."ID"[VARCHAR2,255]
 15 - "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000],
      "NAMES5_"."TASK_NAMES_ID"[NUMBER,22]
 16 - "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."TEXT"[LOB,4000],
      "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]
 17 - "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000],
      "SUBJECTS3_"."TASK_SUBJECTS_ID"[NUMBER,22]
 18 - (#keys=0) COUNT("NAMES8_"."TASK_NAMES_ID")[22]
 19 - "NAMES8_"."TASK_NAMES_ID"[NUMBER,22]
 20 - (#keys=0) COUNT("SUBJECTS9_"."TASK_SUBJECTS_ID")[22]
 21 - "SUBJECTS9_"."TASK_SUBJECTS_ID"[NUMBER,22]
 22 - (#keys=0) COUNT("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID")[22]
 23 - "DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]
Note
-----
  - dynamic sampling used for this statement
   Subject
   Requete Task
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/792579#792579]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]