mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-09 06:42:57 +00:00
97897aaf9b
* fix: prune predicate show use real schema to create physical exprs * refactor: remove redundant results * fix: unit tests * test: add more sqlness cases * test: add more sqlness cases * fix: sqlness orderby * chore: update log * fix: cache physical expr in memtable iter --------- Co-authored-by: Yingwen <realevenyag@gmail.com>
84 lines
3.4 KiB
Plaintext
84 lines
3.4 KiB
Plaintext
create table demo(ts timestamp time index, `value` double, host string,idc string, collector string, primary key(host, idc, collector));
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into demo values(1,2,'test1', 'idc1', 'disk') ,(2,3,'test2', 'idc1', 'disk'), (3,4,'test3', 'idc2','memory');
|
|
|
|
Affected Rows: 3
|
|
|
|
select * from demo where host='test1';
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.001 | 2.0 | test1 | idc1 | disk |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where host='test2';
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.002 | 3.0 | test2 | idc1 | disk |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where host='test3';
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.003 | 4.0 | test3 | idc2 | memory |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where host='test2' and idc='idc1';
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.002 | 3.0 | test2 | idc1 | disk |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where host='test2' and idc='idc1' and collector='disk';
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.002 | 3.0 | test2 | idc1 | disk |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where host='test2' and idc='idc2';
|
|
|
|
++
|
|
++
|
|
|
|
select * from demo where host='test3' and idc>'idc1';
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.003 | 4.0 | test3 | idc2 | memory |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where idc='idc1' order by ts;
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.001 | 2.0 | test1 | idc1 | disk |
|
|
| 1970-01-01T00:00:00.002 | 3.0 | test2 | idc1 | disk |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
select * from demo where collector='disk' order by ts;
|
|
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| ts | value | host | idc | collector |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
| 1970-01-01T00:00:00.001 | 2.0 | test1 | idc1 | disk |
|
|
| 1970-01-01T00:00:00.002 | 3.0 | test2 | idc1 | disk |
|
|
+-------------------------+-------+-------+------+-----------+
|
|
|
|
drop table demo;
|
|
|
|
Affected Rows: 0
|
|
|