8000 Cannot install tests when using default user names as provided in template.env.sh · Issue #1200 · utPLSQL/utPLSQL · GitHub
[go: up one dir, main page]

Skip to content
Cannot install tests when using default user names as provided in template.env.sh #1200
Closed
@PhilippSalvisberg

Description

@PhilippSalvisberg

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

    0