René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Multiple spaces are replaced by single spaces in failure message","articleBody":"When the actual or expected value has multiple consecutive spaces and the test fails, the message on the failures tab shows both values with all multi-spaces replaced by a single one.\r\n(See test script below)\r\n\r\nThis is annoying because at first I couldn't figure out why a test was failing because the message showed identical strings for actual and expected.\r\nRunning the test from SQLcl showed that actual had an extra space which isn't visible in feedback from the plugin.\r\n\r\n**Test Suite to reproduce**\r\n```\r\ncreate or replace package ut_spaces\r\nauthid definer\r\nis\r\n    -- %suite(Test Plugin Output)\r\n\r\n    -- %context(Multiple spaces in values)\r\n\r\n        -- %test(Multiple spaces in actual)\r\n        procedure multi_space_actual;\r\n\r\n        -- %test(Multiple spaces in expect)\r\n        procedure multi_space_expect;\r\n\r\n    -- %endcontext\r\n\r\nend ut_spaces;\r\n/\r\n\r\ncreate or replace package body ut_spaces\r\nis\r\n\r\n    -- Multiple spaces in actual\r\n    procedure multi_space_actual\r\n    is\r\n        l_expect   varchar2(100);\r\n        l_actual   varchar2(100);\r\n    begin\r\n        l_expect := 'This line has spaces';\r\n        l_actual := 'This          line          has          spaces';\r\n\r\n        ut.expect(l_actual).to_equal(l_expect);\r\n    end;\r\n\r\n\r\n    -- Multiple spaces in expect\r\n    procedure multi_space_expect\r\n    is\r\n        l_expect   varchar2(100);\r\n        l_actual   varchar2(100);\r\n    begin\r\n        l_expect := 'This          line          has          spaces';\r\n        l_actual := 'This line has spaces';\r\n\r\n        ut.expect(l_actual).to_equal(l_expect);\r\n    end;\r\n\r\nend ut_spaces;\r\n/\r\n```\r\n\r\n**In SQL Developer plugin**\r\nRunning hese tests the plugin will report on the Failures tab:\r\n```\r\nActual: 'This line has spaces' (varchar2) was expected to equal: 'This line has spaces' (varchar2)\r\nat \"ERO.UT_SPACES.MULTI_SPACE_ACTUAL\", line 13 ut.expect(l_actual).to_equal(l_expect);\r\n```\r\n\r\nNote how all multiple spaces have been replaced by single spaces.\r\n\r\n**In SQLcl**\r\n```\r\nRunning the tests in SQLcl does show the multiple spaces\r\nERO@EVROCS\u003eexec ut.run ('ut_spaces')\r\nTest Plugin Output\r\n  Multiple spaces in values\r\n    Multiple spaces in actual [,481 sec] (FAILED - 1)\r\n    Multiple spaces in expect [,004 sec] (FAILED - 2)\r\n\r\nFailures:\r\n\r\n  1) multi_space_actual\r\n      Actual: 'This          line          has          spaces' (varchar2) was expected to equal: 'This line has spaces' (varchar2)\r\n      at \"ERO.UT_SPACES.MULTI_SPACE_ACTUAL\", line 13 ut.expect(l_actual).to_equal(l_expect);\r\n\r\n  2) multi_space_expect\r\n      Actual: 'This line has spaces' (varchar2) was expected to equal: 'This          line          has          spaces' (varchar2)\r\n      at \"ERO.UT_SPACES.MULTI_SPACE_EXPECT\", line 26 ut.expect(l_actual).to_equal(l_expect);\r\n\r\nFinished in ,487971 seconds\r\n2 tests, 2 failed, 0 errored, 0 disabled, 0 warning(s)\r\n\r\n\r\nPL/SQL procedure successfully completed.\r\n```\r\n\r\n","author":{"url":"https://github.com/erikvanroon","@type":"Person","name":"erikvanroon"},"datePublished":"2022-01-06T10:58:08.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/140/utPLSQL-SQLDeveloper/issues/140"}