Details
-
Bug Report
-
Resolution: Fixed
-
L3 - Default
-
None
-
None
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
mgm-controller-panel
This is the controller panel for Smart Panels app
Attachments
Issue Links
- depends on
-
CAM-6334 Replace invalid characters and trailing whitespaces in SQL-Scripts
- Closed
-
CAM-6338 Execute upgrade tests with new SQL scripts
- Closed
-
CAM-6339 Replace snapshot version with 7.2.11 in test upgrade pom
- Closed
-
CAM-6340 Replace snapshot version with 7.3.8 in test upgrade pom
- Closed
-
CAM-6341 Replace snapshot version with 7.4.9 in test upgrade pom
- Closed
-
CAM-6342 Replace snapshot version with 7.5.3 in test upgrade pom
- Closed
-
CAM-6343 Make 7.1.11 snapshot available on Nexus
- Closed
- is duplicated by
-
CAM-6246 MySQL update scripts contain invalid comment syntax
- Closed