503.assert函数测试.mql 368 B

1234567891011121314151617
  1. select id,attr0,attr1 from /mingdao1/staff limit -1
  2. /**
  3. output()
  4. **/
  5. ;
  6. select id,attr0,attr1,staff_perf.time('2023-06-01 00:00:00','2023-07-01 00:00:00').find(name = 'CN002859P').avg('1d').sum() from /mingdao1/staff where staff_perf.time('2023-06-01 00:00:00','2023-07-01 00:00:00').find(name = 'CN002859P').avg('1d').assert($1>3)
  7. /**
  8. timeout(3m)
  9. output()
  10. **/
  11. ;