Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Cannot install tests when using default user names as provided in template.env.sh #1200

Copy link
Copy link
Closed
@PhilippSalvisberg

Description

@PhilippSalvisberg
Issue body actions

Describe the bug

In template.env.sh the user name UT3$USER# is configured for ${UT3_USER}. In install_ut3_tester_helper.sql the user is hard coded. ut3_user is used.

When I use an env.sh based on template.env.sh and do not change the default users then running test/install_and_run_tests.sh produces an error while running this statement create or replace synonym ut3_user.coverage_helper for ut3_tester_helper.coverage_helper; because the user ut3_user does not exist.

Expected behavior

Installation of tests work when using the default usernames in template.env.sh.

Workaround

Configure export UT3_USER=UT3_USER in env.sh.

Off topic remark

I do not see a value in making the test users configurable. Quite the contrary. It makes the the test setup more complicated and also more fragile. Making the utPLSQL schema owner for production use configurable makes sense. But the testing users? - I don't think so.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    Morty Proxy This is a proxified and sanitized view of the page, visit original site.