René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Actual reported as expected and vice versa for `JSON_ELEMENT_T`","articleBody":"## Describe the bug\r\nWhen comparing a `JSON_ELEMENT_T` value the actual value is reported as expected and the expected value as actual.\r\n\r\nThe following example was taken from http://utplsql.org/utPLSQL/latest/userguide/expectations.html:\r\n\r\n```sql\r\nbegin\r\n  ut.expect( 'the tested value' ).to_equal('the expected value');\r\nend;\r\n/\r\n```\r\n\r\nThe first value is the actual value and the second one is the expected value. This should be true regardless of the compared data type.\r\n\r\n## Provide version info\r\n\r\n```\r\n21.0.0.0.0\r\n20.0.0\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n\r\n\r\nUT_VERSION                                                  \r\n------------------------------------------------------------\r\nv3.1.11.3466-develop\r\n\r\n\r\nBANNER                                                                           BANNER_FULL                                                                                                                                                      BANNER_LEGACY                                                                        CON_ID\r\n-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------\r\nOracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production           Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production                                                                                           Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production                    0\r\n                                                                                 Version 21.1.0.0.0                                                                                                                                                                                                                                          \r\n\r\n\r\n\r\nPARAMETER                      VALUE                                                           \r\n------------------------------ ----------------------------------------------------------------\r\nNLS_LANGUAGE                   AMERICAN                                                        \r\nNLS_TERRITORY                  AMERICA                                                         \r\nNLS_CURRENCY                   $                                                               \r\nNLS_ISO_CURRENCY               AMERICA                                                         \r\nNLS_NUMERIC_CHARACTERS         .,                                                              \r\nNLS_CALENDAR                   GREGORIAN                                                       \r\nNLS_DATE_FORMAT                DD.MM.YYYY                                                      \r\nNLS_DATE_LANGUAGE              AMERICAN                                                        \r\nNLS_SORT                       BINARY                                                          \r\nNLS_TIME_FORMAT                HH.MI.SSXFF AM                                                  \r\nNLS_TIMESTAMP_FORMAT           DD.MM.YYYY HH24:MI:SSXFF                                        \r\nNLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR                                              \r\nNLS_TIMESTAMP_TZ_FORMAT        DD.MM.YYYY HH24:MI:SSXFF TZR                                    \r\nNLS_DUAL_CURRENCY              $                                                               \r\nNLS_COMP                       BINARY                                                          \r\nNLS_LENGTH_SEMANTICS           BYTE                                                            \r\nNLS_NCHAR_CONV_EXCP            FALSE                                                           \r\n\r\n17 rows selected. \r\n\r\n\r\nPORT_STRING                                                 \r\n------------------------------------------------------------\r\nx86_64/Linux 2.4.xx\r\n```\r\n\r\n## Information about client software\r\n\r\nSQL Developer 20.2.0\r\n\r\n## To Reproduce\r\n\r\n### 1. Compare JSON_ELEMENT_T\r\n\r\nRun this code\r\n\r\n```sql\r\nset serveroutput on\r\nbegin\r\n   ut.expect(json_element_t.parse('{\"a\":\"value a\"}'))\r\n      .to_equal(json_element_t.parse('{\"a\":\"value b\"}'));\r\nend;\r\n/\r\n```\r\n\r\nthe output is\r\n\r\n```\r\nFAILURE\r\n  Actual: json was expected to equal: json\r\n  Diff: 1 differences found\r\n  1 unequal values\r\n    Actual value: \"value b\" was expected to be: \"value a\" on path: $.\"a\"\r\n  at \"anonymous block\", line 2\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n```\r\n\r\n`value a` is reported as expected. That's wrong.\r\n\r\n### 2. Compare VARCHAR2 \r\n\r\nRun this code\r\n\r\n```sql\r\nset serveroutput on\r\nbegin\r\n   ut.expect('value a').to_equal('value b');\r\nend;\r\n/\r\n```\r\n\r\nthe output is\r\n\r\n```\r\nFAILURE\r\n  Actual: 'value a' (varchar2) was expected to equal: 'value b' (varchar2)\r\n  at \"anonymous block\", line 2\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n```\r\n\r\n`value b` is reported as expected. That's correct. \r\n\r\n## Expected behavior\r\n\r\nWhen comparing a `JSON_ELEMENT_T` report expected and actual values as for other data types (e.g. `NUMBER` or `VARCHAR2`).\r\n","author":{"url":"https://github.com/PhilippSalvisberg","@type":"Person","name":"PhilippSalvisberg"},"datePublished":"2020-12-13T12:25:56.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/1113/utPLSQL/issues/1113"}