Sorting with collation that has `numericOrdering`, `alternate`, and `shifted` seems to ignore `numericOrdering`

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Works as Designed
    • Priority: Major - P3
    • None
    • Affects Version/s: 4.2.3
    • Component/s: None
    • Environment:
      Ubuntu 18.04 with XFCE
    • Fully Compatible
    • ALL
    • Hide

      Run the given script. I ran it using MongoDB server and shell 4.2.3-rc1

      Show
      Run the given script. I ran it using MongoDB server and shell 4.2.3-rc1
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      The below script prints that "950 000" before "970". I'd expect that the given collation makes MongoDB ignore whitespace and treat "950 000" as "950000"

      db.dropDatabase();

db.createCollection('test', {
  collation: {
    locale: "en_US",
    numericOrdering: true,
    alternate: "shifted",
    maxVariable: "punct"
  }
});

db.test.insertMany([
  { price: '970' },
  { price: '950 000' }
]);

var res = db.test.find({}).collation({
  locale: "en_US",
  numericOrdering: true,
  alternate: "shifted",
  maxVariable: "space"
}).sort({ price: 1 }).toArray();

print(res[0].price); // 950 000
print(res[1].price); // 970

            Assignee:
            Katya Kamenieva
            Reporter:
            Valeri Karpov
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: