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 — Failure when comparing nested objects · Issue #1082 · utPLSQL/utPLSQL

Failure when comparing nested objects #1082

New issue
Copy link
New issue
Copy link
Closed
#1179
Closed
Failure when comparing nested objects#1082
#1179
Copy link
Assignees
lwasylow
Labels
bug
Milestone
v3.1.12

Description

@jgebal
jgebal
opened on Jun 21, 2020
Issue body actions

Describe the bug
When comparing nested objects the comparison fails with an exception.

Provide version info
utPLSQL 3.1.10 - any database

Information about client software
not applicable

To Reproduce

Run the below script

create or replace type some_value as object(
  the_value   number,
  is_relative integer(1)
);

create or replace type some_item as object (
  first_value  some_value,
  second_value some_value
);

declare
  l_expected some_item;
  l_actual   some_item;
begin
  l_expected := some_item(some_value( 1, 0 ), some_value(2.22, 1));
  l_actual   := some_item(some_value( 1, 0 ), some_value(2.22, 0));
  ut.expect(anydata.convertObject(l_actual)).to_equal(anydata.convertObject(l_expected));
end;
/

See the exception:

ORA-00902: invalid datatype
ORA-06512: at "UT3.UT_DATA_VALUE_REFCURSOR", line 336
ORA-06512: at "UT3.UT_COMPOUND_DATA_HELPER", line 628
ORA-06512: at "UT3.UT_DATA_VALUE_REFCURSOR", line 328
ORA-06512: at "UT3.UT_DATA_VALUE_REFCURSOR", line 384
ORA-06512: at "UT3.UT_DATA_VALUE_ANYDATA", line 129
ORA-06512: at "UT3.UT_EQUAL", line 229
ORA-06512: at "UT3.UT_EXPECTATION", line 26
ORA-06512: at "UT3.UT_EXPECTATION", line 96
ORA-06512: at line 7

Expected behavior

The expectation should report data differences.

Additional context

The behavior seem to show up when the object contains nested objects.

Activity

  1. jgebal
    added
    bug
    on Jun 21, 2020
  2. jgebal
    pinned this issue on Nov 11, 2021
  3. lwasylow
    self-assigned this
    on Jan 23, 2022
  4. lwasylow
    linked a pull request that will close this issueFeature/1082 failure when comparing nested objects #1179on Jan 26, 2022
  5. lwasylow
    closed this as completedin #1179on Jan 29, 2022
  6. jgebal
    unpinned this issue on Feb 11, 2022
  7. jgebal
    added this to the 3.1.12 milestone on Feb 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @lwasylow
    lwasylow

Labels

bug

Type

No type

Projects

No projects

    Milestone

    • v3.1.12

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    You are visitor 01402520 — 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.