Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1310711

Summary:	[QA](6.2.z)Missing indexes in jbpm schema DDL for Sybase
Product:	[Retired] JBoss BPMS Platform 6	Reporter:	Alessandro Lazarotti <alazarot>
Component:	jBPM Core	Assignee:	Alessandro Lazarotti <alazarot>
Status:	CLOSED EOL	QA Contact:	Radovan Synek <rsynek>
Severity:	medium	Docs Contact:
Priority:	high
Version:	6.2.0	CC:	alazarot, kverlaen, lpetrovi, rsynek
Target Milestone:	CR1
Target Release:	6.2.2
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:	1300598	Environment:
Last Closed:	2020-03-27 20:06:41 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:
Embargoed:
Bug Depends On:	1300598
Bug Blocks:	1309326

Description Alessandro Lazarotti 2016-02-22 15:00:52 UTC

+++ This bug was initially created as a clone of Bug #1300598 +++

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 Maciej Swiderski 2016-02-25 10:53:24 UTC

back ported into 6.3.x

jbpm
6.3.x:
https://github.com/droolsjbpm/jbpm/commit/4e9935f4f683cb12c846cc04c11e3603046d6955

Comment 3 Tomas Livora 2016-03-07 12:54:31 UTC

Verified on BPM Suite 6.2.2 CR1