Аномалия SQLite подзапроса в случае использования GROUP BY

var data = await DbContext.Instance.Queryable<CusOrder>()
    .Where(x => x.RecipientName == SqlFunc.Subqueryable<CusOrder>().GroupBy(it => it.RecipientName).Having(it => SqlFunc.AggregateSum(it.ActualPaymentAmount) < 3000).Select(it => it.RecipientName))
    .ToListAsync();

Вывод лога:

OnLogExecuting:
 [Sql]:SELECT `Id`,`RecipientName`,`OrderTime`,`ActualPaymentAmount`,`ProductName`,`RecipientAddress`,`PaymentMethod`,`Sellor` FROM `cus_order` `x`  WHERE  `RecipientName`  in (SELECT `RecipientName` FROM `cus_order` `it`  GROUP BY `RecipientName` Having (SUM(`ActualPaymentAmount`) < @Const0 ))
 [Pars]:
 [Name]:@Const0 [Value]:3000 [Type]:Decimal

В коде возвращаются данные, но если запустить SQL-запрос напрямую в базе данных, данные не будут найдены.

CREATE TABLE "cus_order"(
 "Id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
 "RecipientName" varchar(32) NULL,
 "OrderTime" datetime NULL,
 "ActualPaymentAmount" decimal NULL,
 "ProductName" varchar(100) NULL,
 "RecipientAddress" varchar(255) NULL,
 "PaymentMethod" varchar(32) NULL,
 "Sellor" varchar(64) NULL );
```INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (1, '花开富贵', '2025-02-15 00:00:00', 1290, '舒俱来项链', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'K姐');
INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (2, '晴天', '2025-02-15 00:00:00', 2599, '舒俱来手串', '河南省郑州市保利嘉元2-1-1202 胡先生 13699959999', '抖音', 'K姐');
INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (3, '向上姐姐', '2025-02-15 00:00:00', 5890, '舒俱来吊坠', '湖南省长沙市保利嘉元2-1-1202 高先生 15328367777', '淘宝', 'Aj');
INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (4, '花开富贵', '2025-02-16 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
```INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (5, '周震', '2025-02-16 00:00:00', 2000, '舒俱来项链', '北京市朝阳区人民政府', '抖音', 'Aj');
INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (6, '花开富贵', '2025-02-17 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (7, '花开富贵', '2025-02-18 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (8, '花开富贵', '2025-02-19 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
``` INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (9, '花开富贵', '2025-02-20 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (10, '花开富贵', '2025-02-15 00:00:00', 1290, '舒俱来项链', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'K姐');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (11, '晴天', '2025-02-15 00:00:00', 2599, '舒俱来手串', '河南省郑州市保利嘉元2-1-1202 胡先生 13699959999', '抖音', 'K姐');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (12, '向上姐姐', '2025-02-15 00:00:00', 5890, '舒俱来吊坠', '湖南省长沙市保利嘉元2-1-1202 高先生 15328367777', '淘宝', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (13, '花开富贵', '2025-02-16 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (14, '周震', '2025-02-16 00:00:00', 2000, '舒俱来项链', '北京市朝阳区人民政府', '抖音', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (15, '花开富贵', '2025-02-17 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (16, '花开富贵', '2025-02-18 00:00:00', 16800, '舒俱来手串', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', '抖音', 'Aj'); INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (17, '花开富贵', '2025-02-19 00:00:00', 16800, 'Shujula рукав', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', 'Дианьтоу', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (18, '花开富贵', '2025-02-20 00:00:00', 16800, 'Shujula рукав', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', 'Дианьтоу', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (19, '花开富贵', '2025-02-15 00:00:00', 1290, 'Shujula ожерелье', '河北省邯郸市保利嘉元2-1-1202 刘先生 15328366536', 'Дианьтоу', 'K姐');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (21, '向上姐姐', '2025-02-15 00:00:00', 5890, 'Shujula подвеска', '湖南省长沙市保利嘉元2-1-1202 高先生 15328367777', 'Таobao', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (22, '花开富贵', '2025-02-16 00:00:00', 16800, 'Шу-цзулай браслет', 'Китайская провинция Хэbei, город Ханчжоу, район保利嘉元2-1-1202, мистер Лян 15328366536', 'Дианьтоу', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (23, 'Чжоу Чжэнь', '2025-02-16 00:00:00', 2000, 'Шу-цзулай ожерелье', 'Китай, город Beijing, район Chaoyang', 'Дианьтоу', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (24, '花开富贵', '2025-02-17 00:00:00', 16800, 'Шу-цзулай браслет', 'Китайская провинция Хэbei, город Ханчжоу, район保利嘉元2-1-1202, мистер Лян 15328366536', 'Дианьтоу', 'Aj'); INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (25, '花开富贵', '2025-02-18 00:00:00', 16800, 'Шу-цзулай браслет', 'Китайская провинция Хэбэй, город Ханчжоу, район保利嘉元2-1-1202, мистер Лян 15328366536', 'Дианьтоу', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (26, '花开富贵', '2025-02-19 00:00:00', 16800, 'Шу-цзулай браслет', 'Китайская провинция Хэбэй, город Ханчжоу, район保利嘉元2-1-1202, мистер Лян 15328366536', 'Дианьтоу', 'Aj');
  INSERT INTO "cus_order" ("Id", "RecipientName", "OrderTime", "ActualPaymentAmount", "ProductName", "RecipientAddress", "PaymentMethod", "Sellor") VALUES (27, '花开富贵', '2025-02-20 00:00:00', 16800, 'Шу-цзулай браслет', 'Китайская провинция Хэбэй, город Ханчжоу, район保利嘉元2-1-1202, мистер Лян 15328366536', 'Дианьтоу', 'Aj');В тексте отсутствуют строки для перевода. Пожалуйста, предоставьте текст для перевода.

OSCHINA-MIRROR/dotnetchina-SqlSugar

Опасно

Комментарий (0)

OSCHINA-MIRROR/dotnetchina-SqlSugar .gitee-modal { min-width: 500px !important; } .gitee-modal .close { right: 0.6rem !important; }

Опасно

Аномалия SQLite подзапроса в случае использования GROUP BY

Комментарий (0)

OSCHINA-MIRROR/dotnetchina-SqlSugar