[OPENIDM-13302] Modify VertexEdgeTableHandler to utilize WITH clause in supporting DBs. Created: 28/May/19  Updated: 21/Feb/20  Resolved: 19/Jun/19

Status: Closed
Project: OpenIDM
Component/s: Module - Relationships, Performance
Affects Version/s: 7.0.0
Fix Version/s: 7.0.0

Type: Bug Priority: Major
Reporter: jason vincent Assignee: jason vincent
Resolution: Fixed Votes: 0
Labels: DIXON
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Target Version/s:
Verified Version/s:
Story Points: 3
Sprint: 2019.8 - IDM


The Vertex-Edge link expansion mega-query can utilize the WITH clause SQL syntax to improve performance on the DB's that support it. MySQL <8 don't support it, but all others do.

Comment by Alexander Dracka [ 21/Feb/20 ]

Functional tests are not required

Generated at Mon Mar 08 12:13:45 UTC 2021 using Jira 7.13.12#713012-sha1:6e07c38070d5191bbf7353952ed38f111754533a.