mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-28 00:42:56 +00:00
c6e95ffe63
* test: test on_compaction_finished * fix: avoid submit same region to compact * feat: persist and recover compaction time window * test: fix test * test: sort like result
17 lines
293 B
SQL
17 lines
293 B
SQL
CREATE TABLE host (
|
|
ts TIMESTAMP(3) TIME INDEX,
|
|
host STRING PRIMARY KEY,
|
|
val DOUBLE,
|
|
);
|
|
|
|
INSERT INTO TABLE host VALUES
|
|
(0, 'a+b', 1.0),
|
|
(1, 'b+c', 2.0),
|
|
(2, 'a', 3.0),
|
|
(3, 'c', 4.0);
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
SELECT * FROM host WHERE host LIKE '%+%';
|
|
|
|
DROP TABLE host;
|