[CAM-6274] Database scripts contain invalid characters and comments Created: 21/Jun/16  Updated: 01/Feb/17  Resolved: 14/Jul/16

Status: Closed
Project: camunda BPM
Component/s: continuous integration, engine
Affects Version/s: None
Fix Version/s: 7.6.0, 7.2.10, 7.3.8, 7.5.3, 7.6.0-alpha3, 7.4.10

Type: Bug Report Priority: L3 - Default
Reporter: Christian Lipphardt Assignee: Sebastian Menski
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: Not Specified
Original Estimate: 0 minutes

Issue Links:
Depedendency
depends on CAM-6334 Replace invalid characters and traili... Closed
depends on CAM-6339 Replace snapshot version with 7.2.11 ... Open
depends on CAM-6340 Replace snapshot version with 7.3.8 i... Open
depends on CAM-6341 Replace snapshot version with 7.4.9 i... Resolved
depends on CAM-6338 Execute upgrade tests with new SQL sc... Closed
depends on CAM-6342 Replace snapshot version with 7.5.3 i... Closed
depends on CAM-6343 Make 7.1.11 snapshot available on Nexus Closed
Duplicate
is duplicated by CAM-6246 MySQL update scripts contain invalid ... Closed

 Description   

Problem:
The database create and upgrade scripts (maybe delete too) contain invalid characters which causes them to fail when they are executed using a database vendor REPL like mysql. DB2 and Oracle scripts also have some problems accordingly to some manual smoke tests.

AT:

  • Clean all database scripts on all branches from invalid formatted comments, invalid characters etc.
  • All scripts are tested by running them against the database using the database vendor own REPL tool manually.
  • Test-DB-Upgrade runs successfully with option 'keepFormat' set to true for the sql-maven-plugin


 Comments   
Comment by Sebastian Menski [ 21/Jun/16 ]

Does this ticket replace CAM-6246?

Comment by Robert Gimbel [ 14/Jul/16 ]

This ticket has somehow the wrong versions. 7.5.3 is released but this ticket it open. Does not fit.

Comment by Sebastian Menski [ 15/Jul/16 ]

Christopher Zell what is the reason for this commit? https://github.com/camunda/camunda-bpm-platform/commit/1eaca673f795c78165b56f8fa2ad30b63d91e198

  • a property is set which is not used?
  • why was the oracle driver added to the pom?
Comment by Sebastian Menski [ 15/Jul/16 ]

Robert Gimbel to answer your question: the changes where part of the 7.5.3 release, only the review was not done.

Generated at Sun Aug 25 00:39:28 CEST 2019 using JIRA 6.4.6#64021-sha1:33e5b454af4594f54560ac233c30a6e00459507e.