| 1234567891011121314 |
- -- 表尚未建成时放行(1.0.571 会先建表;本脚本排在其后)。
- SELECT
- (SELECT COUNT(*) FROM information_schema.TABLES
- WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_tenant_std_source') = 0
- OR (
- (SELECT source_system FROM mdp_tenant_std_source
- WHERE tenant_id=797403760988229 AND std_object='INV_TRANS' LIMIT 1) = 'DOPDEMORQ_SQLSERVER'
- AND
- (SELECT IFNULL(source_scope,'') FROM mdp_tenant_std_source
- WHERE tenant_id=797403760988229 AND std_object='INV_TRANS' LIMIT 1) = '8010'
- AND
- (SELECT source_system FROM mdp_tenant_std_source
- WHERE tenant_id=797403760988229 AND std_object='FQC_TASK' LIMIT 1) = 'AIDOP_NATIVE'
- );
|