098.concur.query.mql 462 B

1234567891011121314151617181920212223
  1. /**
  2. scope(file)
  3. parallel(4)
  4. loop(400)
  5. **/
  6. ;
  7. SELECT room.id AS "room_id" INTO /temp_room_count_2d41157f-6ec5-403a-badd-cdcda196b910-{%d,filei} FROM /hxyy/room room LIMIT 0, 500000 WITH TIMEOUT = 3m
  8. /**
  9. onerror(continue,"proc timeout")
  10. **/
  11. ;
  12. {"sql":"SELECT count(temp.room_id) AS \"total_rooms\" FROM /temp_room_count_2d41157f-6ec5-403a-badd-cdcda196b910-{%d,filei} temp LIMIT 0, 500000"}
  13. /**
  14. output()
  15. **/
  16. ;
  17. select * from /matrix/ldap limit 1
  18. /**
  19. output()
  20. **/
  21. ;