odbtools/odbctest/mql/basic/10index/88_local.mql

delete 性能备份AaB from /test/性能AaB_Local with version
/**
onerror(continue,`not exist`,`not find`,`not found`)
**/
;

delete 性能AaB from /test/性能AaB_Local with version
/**
onerror(continue,`not exist`,`not find`,`not found`)
**/
;

delete from /test/性能AaB_Local with version
/**
onerror(continue,`not exist`,`not find`,`not found`)
**/
;

drop class if exists /test/性能AaB_Local;

create class if not exists /test/性能AaB_Local (
    主机AaB					varchar,
	v_date					date,
	v_timestamp				timestamp,
	性能备份AaB					bucket 		{
            "dict": true,
            "slot": 5,
            "ttl": 2,
            "type": "promdb",
            "version": 1
    },
    noindex				varchar,
    性能AaB				bucket 		{
            "dict": true,
            "slot": 5,
            "ttl": 2,
            "type": "promdb",
            "version": 1
    },
    keys(主机AaB),
    indexes(主机AaB, v_date, v_timestamp )
)with core=local , autosearch=true , version=false , key=manu, alias='性能测试' , nickname='性能AaB_Local'
;

insert into /test/性能AaB_Local	 (id,主机AaB,v_date,v_timestamp) values ('性能AaB_Local:test',"[服务器1]","2026-04-02","2026-04-02 15:55:55");
insert into /test/性能AaB_Local	 (id,主机AaB,v_date,v_timestamp) values ('性能AaB_Local:test2',"*服务器2?","1754-08-31","1901-08-31 15:55:55");
insert into /test/性能AaB_Local	 (id,主机AaB,v_date,v_timestamp) values ('性能AaB_Local:test3',"*服务器2?",1775059200000,"2026-04-02 15:55:55");
insert into /test/性能AaB_Local	 (id,day,vtime,主机AaB,v_date,v_timestamp) values ('性能AaB_Local:test4',"2026-04-02","2026-04-02 15:55:55", "*服务器2?",1775059200000,"2026-04-02 15:55:55");


select * from /test/性能AaB_Local where v_date=1775059200000 refresh
/**
output()
count(3)
**/
;

select * from /test/性能AaB_Local where day=1775059200000 refresh
/**
output()
count(1)
**/
;

select * from /test/性能AaB_Local where v_date='2026-04-02' refresh
/**
output()
count(3)
**/
;

select * from /test/性能AaB_Local where day='2026-04-02' refresh
/**
output()
count(1)
**/
;

select * from /test/性能AaB_Local where v_date='1754-08-31' refresh
/**
output()
count(1)
**/
;

select * from /test/性能AaB_Local where v_timestamp='1901-08-31 15:55:55' refresh
/**
output()
count(1)
**/
;

create ("性能AaB_Local:test")-[:connect]->("性能AaB_Local:test2")
/**
output()
**/
;

create ("性能AaB_Local:test2")-[:connect]->("性能AaB_Local:test")
/**
output()
**/
;

match ("性能AaB_Local:test")-[:connect*1..1]->("性能AaB_Local:test2")
/**
match("graph.nodes.len",2)
**/
;

match ("性能AaB_Local:test")-[:connect]->("性能AaB_Local:test2")
/**
match("graph.nodes.len",2)
**/
;

--match ("性能AaB_Local:test")-[*]->("性能AaB_Local:test2")
/**
--match("graph.nodes.len",2)
**/
;

select connect from /test/性能AaB_Local
/**
output()
matchcount("connect",{"_all":["性能AaB_Local:test"]},1)
matchcount("connect",{"_all":["性能AaB_Local:test2"]},1)
**/
;

select count(*) from /test/性能AaB_Local where 主机AaB='[服务器1]'
/**
output()
count(1)
**/
;

sql: select count(*) from /test/性能AaB_Local where 主机AaB='*服务器2?'
/**
output()
count(1)
**/
;

cql: select * from field where namespace='test' and name in ('主机aab','noindex')
/**
match("name", "主机aab", "isindex", 1)
match("name", "noindex", "isindex", 0)
**/
;

select * from /test/性能AaB_Local where v_date between 1774972800000 and 1776182400000 limit 10
/**
output()
count(3)
**/
;

select "hello".id from /test/性能AaB_Local "hello" where v_date between 1774972800000 and 1776182400000 order by "hello".v_date limit 10
/**
output()
count(3)
**/
;

select * from /test/性能AaB_Local where v_timestamp between 1774972800000 and 1776182400000 limit 10
/**
output()
count(3)
**/
;

{"sql":"select * from /test/性能AaB_Local where v_date between 1774972800000 and 1776182400000 limit 10"}
/**
output()
count(3)
**/
;

{"sql":"select \"order\".id from /test/性能AaB_Local \"order\" where \"order\".v_date between 1774972800000 and 1776182400000 limit 10"}
/**
output()
count(3)
**/
;

{"sql":"select * from /test/性能AaB_Local where v_timestamp between 1774972800000 and 1776182400000 limit 10"}
/**
output()
count(3)
**/
;