1.0.575.verify.sql 684 B

1234567891011121314
  1. -- 表尚未建成时放行(1.0.571 会先建表;本脚本排在其后)。
  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 source_system FROM mdp_tenant_std_source
  7. WHERE tenant_id=797403760988229 AND std_object='INV_TRANS' LIMIT 1) = 'DOPDEMORQ_SQLSERVER'
  8. AND
  9. (SELECT IFNULL(source_scope,'') FROM mdp_tenant_std_source
  10. WHERE tenant_id=797403760988229 AND std_object='INV_TRANS' LIMIT 1) = '8010'
  11. AND
  12. (SELECT source_system FROM mdp_tenant_std_source
  13. WHERE tenant_id=797403760988229 AND std_object='FQC_TASK' LIMIT 1) = 'AIDOP_NATIVE'
  14. );