odbtools/odbctest/mql/test/m3event/7.test.mql

-- SELECT
--   alertgroup as "分组" , count(*) as "计 数"
-- FROM
--   /m3event/devops/alerts_status group by alertgroup order by "计 数" desc
-- /**
--     output()
-- **/
-- ;

-- SELECT
--   alertgroup as "分组" , count(*) as "计 数"
-- FROM
--   /m3event/devops/alerts_status group by 分组 order by "计 数" desc
-- /**
--     output()
-- **/
-- ;

-- select * from /m3event/devops/alerts_status where severity != 5 limit -1
-- /**
--     output()
-- **/
-- ;


-- update /m3event/devops/alerts_status set tags=tags+'x' where severity = 5
-- ;


-- update /m3event/devops/alerts_status set tags=null where id = 916430775853365296
-- ;


-- update /m3event/devops/alerts_status set tags=tags+'m' where id = 5367294368478167840
-- ;

-- select id,vtime,tags from /m3event/devops/alerts_status where tags = 'x' 
-- /**
--     output()
-- **/
-- ;

-- select id,vtime,tags,firstoccurrence,lastoccurrence,internallast,statechange from /m3event/devops/alerts_status where id = 2245957211358017209
-- /**
--     output()
-- **/
-- ;

-- select id,vtime,tags,firstoccurrence,lastoccurrence,internallast,statechange from /m3event/devops/alerts_status where tags = null or tags = 'm' or tags in ('a',"z") 
-- /**
--     output()
-- **/
-- ;


-- select id,vtime,tags,firstoccurrence,lastoccurrence,internallast,statechange from /m3event/devops/alerts_status where connect = null
-- /**
--     output()
-- **/
-- ;