Sum of empty set cast to a nullable type returns null instead of zero

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Unknown
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • None
    • Dotnet Drivers
    • Hide

      1. What would you like to communicate to the user about this feature?
      2. Would you like the user to see examples of the syntax and/or executable code and its output?
      3. Which versions of the driver/connector does this apply to?

      Show
      1. What would you like to communicate to the user about this feature? 2. Would you like the user to see examples of the syntax and/or executable code and its output? 3. Which versions of the driver/connector does this apply to?
    • None
    • None
    • None
    • None
    • None
    • None

      See EF-232 for details.

      Driver-only repro:

      var client = new MongoClient("mongodb://localhost:27017");
      var database = client.GetDatabase("db221");
      database.DropCollection("Orders");
      
      var collection = database.GetCollection<Order>("Orders");
      collection.InsertMany([new Order { Id = 1, Foo = "ABC" }, new Order { Id = 2, Foo = "DEF" }]);
      
      var value = collection.AsQueryable().Where(o => o.Id < 0).Select(o => (int?)o.Id).Sum();
      Console.WriteLine(value.HasValue ? value.Value.ToString() : "<null>");
      
      public class Order
      {
          public int Id { get; set; }
          public string Foo { get; set; }
      }
      

            Assignee:
            Unassigned
            Reporter:
            Arthur Vickers
            None
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: