mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-27 16:32:54 +00:00
b737a240de
* correct range manipulate exec fmt text Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix partition requirement Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix udf signature Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * finilise Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * ignore unstable ordered result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add nan value test Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
14 lines
284 B
SQL
14 lines
284 B
SQL
create table data (ts timestamp(3) time index, val double);
|
|
|
|
insert into data values
|
|
(0, 'infinity'::double),
|
|
(1, '-infinity'::double),
|
|
(2, 'nan'::double),
|
|
(3, 'NaN'::double);
|
|
|
|
select * from data;
|
|
|
|
insert into data values (4, 'infinityyyy'::double);
|
|
|
|
drop table data;
|