Bug 1300598 - Missing indexes in jbpm schema DDL for Sybase
Summary: 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
unspecified
medium
Target Milestone: ER1
: 6.3.0
Assignee: Alessandro Lazarotti
QA Contact: Radovan Synek
URL:
Whiteboard:
Depends On:
Blocks: 1310711
TreeView+ depends on / blocked
 
Reported: 2016-01-21 09:24 UTC by Radovan Synek
Modified: 2020-03-27 20:02 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 1310711 (view as bug list)
Environment:
Last Closed: 2020-03-27 20:02:56 UTC
Type: Bug

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

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 1 Maciej Swiderski 2016-02-25 10:18:54 UTC 
indexes added for sybase ddl script

jbpm
master:
https://github.com/droolsjbpm/jbpm/commit/9c23b5b451e2ab1bf93700b01e36b89f55192ba9

6.4.x:
https://github.com/droolsjbpm/jbpm/commit/d71e07b6b1e3d5bbac16913fd21145fdd152a402
Comment 2 Radovan Synek 2016-03-24 13:24:42 UTC 
Verified for BPMS-6.3.0.ER1
Note You need to log in before you can comment on or make changes to this bug.