Uploaded image for project: 'HPCC'
  1. HPCC
  2. HPCC-16110

Dedup unexpected results when using KEEP n and RIGHT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.0.x
    • Fix Version/s: 6.4.0
    • Component/s: Roxie
    • Labels:
      None

      Description

      This ecl code returns unexpected results:

      SomeFile := DATASET([

      {'C','G'},{'C','C'},{'C','B'},{'C','N'},{'C','T'},{'C','D'},
      {'A','X'},{'B','G'},{'A','B'}],MyRec);
      Val1Sort := SORT(SomeFile,Value1);
      output(DEDUP(Val1Sort, Value1, Keep 3, RIGHT));

      Expected results should be
      {'A','X'},{'A','B'},{'B','G'},{'C','N'}, {'C','T'},{'C','D'}
      but results are
      {'A','X'},{'A','B'},{'B','G'},{'C','G'}

      ,

      {'C','C'}

      ,

      {'C','D'}

      This is a Roxie only issue. (In Thor - an error message is shown if RIGHT is used with keep>1.)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shamser Shamser Ahmed
                Reporter:
                shamser Shamser Ahmed
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: