Implement a test to ensure DB tables are created and queried using all uppercase characters

[mboskamp]

Acceptance Criteria (Required on creation)

We have tests in all places where there is interaction with DB tables to ensure table names are always upper-case.

Background: DBs can be configured using a case-sensitive collation. We need to ensure that this won't break functionality in Camunda Platform 7.

Hints

Known places are:

• CE engine
• CE webapps
• EE webapps

There are tests for column names already:

• CE engine
• CE webapps
• EE webapps

Links

• Related to https://github.com/camunda/camunda-bpm-platform/issues/4525

Breakdown

### Pull Requests

Dev2QA handover

• [ ] Does this ticket need a QA test and the testing goals are not clear from the description? Add a Dev2QA handover comment

[vizai]

I am going to work on this.

[mboskamp]

@vizai, Awesome to hear that you want to contribute this enhancement. I was thinking of adding a test similar to what I did for this ticket. Specifically, you can check out the test for lower-case column names.

[vizai]

@mboskamp , Yes I am referring the previous story to bring similar logic for table names. Also, adding "upgrade" folder in the scanned folders for these tests:

public static String[] SCANNED_FOLDERS = { "org/camunda/bpm/engine/impl/mapping/entity/", "org/camunda/bpm/engine/db/create", "org/camunda/bpm/engine/db/drop", "org/camunda/bpm/engine/db/upgrade" "org/camunda/bpm/engine/db/liquibase/baseline" };

[mboskamp]

Hey @vizai, How is it going? What is the status of your contribution? Do you need any input/assistance?

[vizai]

I have fix ready, verified. I will create PR. I am using the regex expression to find the table names starts with "act_"