- -- 表尚未建成时放行。三个租户各自至少 21 条 AIDOP_NATIVE(目录对象数)。
- SELECT
- (SELECT COUNT(*) FROM information_schema.TABLES
- WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_tenant_std_source') = 0
- OR (
- (SELECT COUNT(*) FROM mdp_tenant_std_source
- WHERE tenant_id=824585161322565 AND source_system='AIDOP_NATIVE') >= 21
- AND
- (SELECT COUNT(*) FROM mdp_tenant_std_source
- WHERE tenant_id=838257212780613 AND source_system='AIDOP_NATIVE') >= 21
- AND
- (SELECT COUNT(*) FROM mdp_tenant_std_source
- WHERE tenant_id=838257237606469 AND source_system='AIDOP_NATIVE') >= 21
- );
|