AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.537.verify.sql

-- 1.0.537.verify.sql — 每条 SELECT 必须返回真值

SELECT COUNT(*) = 2
  FROM mdp_entity
 WHERE entity_code IN ('S1_SALES_ORDER_ENTRY', 'MDM_ITEM')
   AND IFNULL(remark, '') LIKE '%inbound_delete=unsupported%';

SELECT COUNT(*) = 1
  FROM mdp_entity
 WHERE entity_code = 'S1_SALES_ORDER_ENTRY'
   AND biz_key_expr = 'bill_no,entry_seq';

SELECT COUNT(*) = 1
  FROM mdp_entity
 WHERE entity_code = 'MDM_ITEM'
   AND biz_key_expr = 'Domain,ItemNum';