GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Test results are messed up under specific conditions. · Issue #1060 · utPLSQL/utPLSQL

Test results are messed up under specific conditions. #1060

New issue
Copy link
New issue
Copy link
Closed
Closed
Test results are messed up under specific conditions.#1060
Copy link
Assignees
jgebal
Labels
bug
Milestone
v3.1.11

Description

@just-doit
just-doit
opened on Mar 24, 2020
Issue body actions

To demonstrate the problem I use the following two packages.

CREATE OR REPLACE PACKAGE ut_abc
IS
   -- %suite
   -- %suitepath(main.abc)

   -- %test
   PROCEDURE ut_test_01;
END ut_abc;
/

CREATE OR REPLACE PACKAGE BODY ut_abc
IS
   PROCEDURE ut_test_01
   AS
   BEGIN
      ut.expect(TRUE).to_be_true;
   END;
END ut_abc;
/

CREATE OR REPLACE PACKAGE ut_abc_def
IS
   -- %suite
   -- %suitepath(main.abc_def)

   -- %test
   PROCEDURE ut_test_01;
END ut_abc_def;
/

CREATE OR REPLACE PACKAGE BODY ut_abc_def
IS
   PROCEDURE ut_test_01
   AS
   BEGIN
      ut.expect(TRUE).to_be_true;
   END;
END ut_abc_def;
/

The result would correctly look like this:

main
  abc_def
    ut_abc_def
      ut_test_01 [,002 sec]
  abc
    ut_abc
      ut_test_01 [,001 sec]
 
Finished in ,006906 seconds
2 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)

But if you set NLS_SORT to GERMAN you will get:

main
  abc_def
    ut_abc
      ut_test_01 [,001 sec]
    ut_abc_def
      ut_test_01 [,001 sec]
  abc
 
Finished in ,006294 seconds
2 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)

BR
Dirk

Activity

  1. jgebal commented on Mar 24, 2020

    @jgebal
    jgebal
    on Mar 24, 2020
    Member
    More actions

    Thanks for reporing this issue amd getting to the bottom of problem (NLS_SORT)
    It's an interesting issue.

    Will look into fixing that.

  2. jgebal
    self-assigned this
    on Mar 24, 2020
  3. jgebal
    added
    bug
    on Mar 24, 2020
  4. jgebal
    added a commit that references this issue on Mar 25, 2020

    Resolves issue #1060 with suites not properly built with GERMAN (non-…

    b8c0287
  5. jgebal
    added this to the 3.1.11 milestone on Mar 25, 2020
  6. jgebal
    added a commit that references this issue on Mar 25, 2020

    Merge pull request #1061 from utPLSQL/bugfix/suitepath_with_nlssort

    2689052
  7. jgebal commented on Mar 25, 2020

    @jgebal
    jgebal
    on Mar 25, 2020
    Member
    More actions

    It's resolved in develop branch now.
    Will be released as part on v3.1.11.

    Thakns again fror finding and reporting this issue.

  8. jgebal
    closed this as completedon Mar 25, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @jgebal
    jgebal

Labels

bug

Type

No type

Projects

No projects

    Milestone

    • v3.1.11

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    You are visitor 01402503 — GeezerVison does not store the pages you look up.
    Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.