Bug 1310711 - [QA](6.2.z)Missing indexes in jbpm schema DDL for Sybase
Summary: [QA](6.2.z)Missing indexes in jbpm schema DDL for Sybase
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: jBPM Core
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
high
medium
Target Milestone: CR1
: 6.2.2
Assignee: Alessandro Lazarotti
QA Contact: Radovan Synek
URL:
Whiteboard:
Depends On: 1300598
Blocks: 1309326
TreeView+ depends on / blocked
 
Reported: 2016-02-22 15:00 UTC by Alessandro Lazarotti
Modified: 2020-03-27 20:06 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of: 1300598
Environment:
Last Closed: 2020-03-27 20:06:41 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

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
Note You need to log in before you can comment on or make changes to this bug.