Bug 1300598

Summary: Missing indexes in jbpm schema DDL for Sybase
Product: [Retired] JBoss BPMS Platform 6 Reporter: Radovan Synek <rsynek>
Component: jBPM CoreAssignee: Alessandro Lazarotti <alazarot>
Status: CLOSED EOL QA Contact: Radovan Synek <rsynek>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: alazarot
Target Milestone: ER1   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1310711 (view as bug list) Environment:
Last Closed: 2020-03-27 20:02:56 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 1310711    

Description Radovan Synek 2016-01-21 09:24:06 UTC
For all other DBs, we define in jbpm schema DDL indexes for all columns that can participate in queries, however this does not hold for Sybase:
https://github.com/droolsjbpm/jbpm/blob/master/jbpm-installer/db/ddl-scripts/sybase/sybase-jbpm-schema.sql

Comment 2 Radovan Synek 2016-03-24 13:24:42 UTC
Verified for BPMS-6.3.0.ER1