1.0.578.verify.sql 640 B

1234567891011121314
  1. -- 表尚未建成时放行。三个租户各自至少 21 条 AIDOP_NATIVE(目录对象数)。
  2. SELECT
  3. (SELECT COUNT(*) FROM information_schema.TABLES
  4. WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_tenant_std_source') = 0
  5. OR (
  6. (SELECT COUNT(*) FROM mdp_tenant_std_source
  7. WHERE tenant_id=824585161322565 AND source_system='AIDOP_NATIVE') >= 21
  8. AND
  9. (SELECT COUNT(*) FROM mdp_tenant_std_source
  10. WHERE tenant_id=838257212780613 AND source_system='AIDOP_NATIVE') >= 21
  11. AND
  12. (SELECT COUNT(*) FROM mdp_tenant_std_source
  13. WHERE tenant_id=838257237606469 AND source_system='AIDOP_NATIVE') >= 21
  14. );