odbtools/odbctest/mql/test/basic/99.x.mql

update /matrix/group set _group = ? where name in ?
/**
    params({}, ["admin"])
**/
;

select _group from /matrix/group where name = 'admin' refresh
/**
    output()
**/
;

update /matrix/group set _group = _group + ? where name in ? 
/**
    params({"add": ["网络部"], "delete": ["网络部"], "edit": ["网络部"], "list": ["网络部"]}, ["admin"])
**/
;

update /matrix/group set _group = _group + ? where name in ? 
/**
    params({"add": ["市场部"]}, ["admin"])
**/
;

select _group from /matrix/group where name = 'admin' refresh
/**
    output()
    equal(0,_group.add.len,2)
**/
;



select distinct class from /matrix/ldap
/**
    output()
**/
;

select * from /matrix/ldap
/**
    output()
    metainfo()
    matchcount(username,admin,1)
    matchcount(username,/,1)
    equal(1,username,/)
    equal(-1,columns./matrix/ldap.0.name,class)
**/
;

select distinct username,id from /matrix/ldap
/**
    output()
**/
;