-- ============================================================
-- float 类型搜索测试
-- ============================================================

-- 1. 等值搜索 float
select * from /test/aaa/test_search where s_float=10.5
/**
output()
**/
;

-- 2. 大于搜索 float
select * from /test/aaa/test_search where s_float>30.0
/**
output()
**/
;

-- 3. 小于搜索 float
select * from /test/aaa/test_search where s_float<1.0
/**
output()
**/
;

-- 4. 区间搜索 float
select * from /test/aaa/test_search where s_float>=10.0 and s_float<=60.0
/**
output()
**/
;

-- 5. double 类型搜索
select * from /test/aaa/test_search where s_double=10.555
/**
output()
**/
;

-- 6. 搜索不存在的 float 值
select * from /test/aaa/test_search where s_float=99999.99
/**
output()
count(0)
**/
;

-- 7. 搜索浮点范围的边界值
select * from /test/aaa/test_search where s_double<1.0
/**
output()
**/
;