Skip to content

Commit 8ffc9eb

Browse files
cloud-fancloud-fan
committed
remove test
1 parent 3822f30 commit 8ffc9eb

File tree

3 files changed

+2
-414
lines changed

3 files changed

+2
-414
lines changed

‎sql/core/src/test/resources/sql-tests/inputs/interval.sql‎

Lines changed: 0 additions & 64 deletions
Original file line numberDiff line numberDiff line change
@@ -84,70 +84,6 @@ select interval (-30) day;
8484
select interval (a + 1) day;
8585
select interval 30 day day day;
8686

87-
-- sum interval values
88-
-- null
89-
select sum(cast(null as interval));
90-
91-
-- empty set
92-
select sum(cast(v as interval)) from VALUES ('1 seconds') t(v) where 1=0;
93-
94-
-- basic interval sum
95-
select sum(cast(v as interval)) from VALUES ('1 seconds'), ('2 seconds'), (null) t(v);
96-
select sum(cast(v as interval)) from VALUES ('-1 seconds'), ('2 seconds'), (null) t(v);
97-
select sum(cast(v as interval)) from VALUES ('-1 seconds'), ('-2 seconds'), (null) t(v);
98-
select sum(cast(v as interval)) from VALUES ('-1 weeks'), ('2 seconds'), (null) t(v);
99-
100-
-- group by
101-
select
102-
i,
103-
sum(cast(v as interval))
104-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
105-
group by i;
106-
107-
-- having
108-
select
109-
sum(cast(v as interval)) as sv
110-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
111-
having sv is not null;
112-
113-
-- window
114-
SELECT
115-
i,
116-
sum(cast(v as interval)) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
117-
FROM VALUES(1, '1 seconds'), (1, '2 seconds'), (2, NULL), (2, NULL) t(i,v);
118-
119-
-- average with interval type
120-
-- null
121-
select avg(cast(v as interval)) from VALUES (null) t(v);
122-
123-
-- empty set
124-
select avg(cast(v as interval)) from VALUES ('1 seconds'), ('2 seconds'), (null) t(v) where 1=0;
125-
126-
-- basic interval avg
127-
select avg(cast(v as interval)) from VALUES ('1 seconds'), ('2 seconds'), (null) t(v);
128-
select avg(cast(v as interval)) from VALUES ('-1 seconds'), ('2 seconds'), (null) t(v);
129-
select avg(cast(v as interval)) from VALUES ('-1 seconds'), ('-2 seconds'), (null) t(v);
130-
select avg(cast(v as interval)) from VALUES ('-1 weeks'), ('2 seconds'), (null) t(v);
131-
132-
-- group by
133-
select
134-
i,
135-
avg(cast(v as interval))
136-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
137-
group by i;
138-
139-
-- having
140-
select
141-
avg(cast(v as interval)) as sv
142-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
143-
having sv is not null;
144-
145-
-- window
146-
SELECT
147-
i,
148-
avg(cast(v as interval)) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
149-
FROM VALUES (1,'1 seconds'), (1,'2 seconds'), (2,NULL), (2,NULL) t(i,v);
150-
15187
-- Interval year-month arithmetic
15288

15389
create temporary view interval_arithmetic as

‎sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out‎

Lines changed: 1 addition & 175 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
-- Automatically generated by SQLQueryTestSuite
2-
-- Number of queries: 99
2+
-- Number of queries: 81
33

44

55
-- !query
@@ -631,180 +631,6 @@ select interval 30 day day day
631631
-----------------------^^^
632632

633633

634-
-- !query
635-
select sum(cast(null as interval))
636-
-- !query schema
637-
struct<sum(CAST(NULL AS INTERVAL)):interval>
638-
-- !query output
639-
NULL
640-
641-
642-
-- !query
643-
select sum(cast(v as interval)) from VALUES ('1 seconds') t(v) where 1=0
644-
-- !query schema
645-
struct<sum(CAST(v AS INTERVAL)):interval>
646-
-- !query output
647-
NULL
648-
649-
650-
-- !query
651-
select sum(cast(v as interval)) from VALUES ('1 seconds'), ('2 seconds'), (null) t(v)
652-
-- !query schema
653-
struct<sum(CAST(v AS INTERVAL)):interval>
654-
-- !query output
655-
3 seconds
656-
657-
658-
-- !query
659-
select sum(cast(v as interval)) from VALUES ('-1 seconds'), ('2 seconds'), (null) t(v)
660-
-- !query schema
661-
struct<sum(CAST(v AS INTERVAL)):interval>
662-
-- !query output
663-
1 seconds
664-
665-
666-
-- !query
667-
select sum(cast(v as interval)) from VALUES ('-1 seconds'), ('-2 seconds'), (null) t(v)
668-
-- !query schema
669-
struct<sum(CAST(v AS INTERVAL)):interval>
670-
-- !query output
671-
-3 seconds
672-
673-
674-
-- !query
675-
select sum(cast(v as interval)) from VALUES ('-1 weeks'), ('2 seconds'), (null) t(v)
676-
-- !query schema
677-
struct<sum(CAST(v AS INTERVAL)):interval>
678-
-- !query output
679-
-7 days 2 seconds
680-
681-
682-
-- !query
683-
select
684-
i,
685-
sum(cast(v as interval))
686-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
687-
group by i
688-
-- !query schema
689-
struct<i:int,sum(CAST(v AS INTERVAL)):interval>
690-
-- !query output
691-
1 -2 days
692-
2 2 seconds
693-
3 NULL
694-
695-
696-
-- !query
697-
select
698-
sum(cast(v as interval)) as sv
699-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
700-
having sv is not null
701-
-- !query schema
702-
struct<sv:interval>
703-
-- !query output
704-
-2 days 2 seconds
705-
706-
707-
-- !query
708-
SELECT
709-
i,
710-
sum(cast(v as interval)) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
711-
FROM VALUES(1, '1 seconds'), (1, '2 seconds'), (2, NULL), (2, NULL) t(i,v)
712-
-- !query schema
713-
struct<i:int,sum(CAST(v AS INTERVAL)) OVER (ORDER BY i ASC NULLS FIRST ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING):interval>
714-
-- !query output
715-
1 2 seconds
716-
1 3 seconds
717-
2 NULL
718-
2 NULL
719-
720-
721-
-- !query
722-
select avg(cast(v as interval)) from VALUES (null) t(v)
723-
-- !query schema
724-
struct<avg(CAST(v AS INTERVAL)):interval>
725-
-- !query output
726-
NULL
727-
728-
729-
-- !query
730-
select avg(cast(v as interval)) from VALUES ('1 seconds'), ('2 seconds'), (null) t(v) where 1=0
731-
-- !query schema
732-
struct<avg(CAST(v AS INTERVAL)):interval>
733-
-- !query output
734-
NULL
735-
736-
737-
-- !query
738-
select avg(cast(v as interval)) from VALUES ('1 seconds'), ('2 seconds'), (null) t(v)
739-
-- !query schema
740-
struct<avg(CAST(v AS INTERVAL)):interval>
741-
-- !query output
742-
1.5 seconds
743-
744-
745-
-- !query
746-
select avg(cast(v as interval)) from VALUES ('-1 seconds'), ('2 seconds'), (null) t(v)
747-
-- !query schema
748-
struct<avg(CAST(v AS INTERVAL)):interval>
749-
-- !query output
750-
0.5 seconds
751-
752-
753-
-- !query
754-
select avg(cast(v as interval)) from VALUES ('-1 seconds'), ('-2 seconds'), (null) t(v)
755-
-- !query schema
756-
struct<avg(CAST(v AS INTERVAL)):interval>
757-
-- !query output
758-
-1.5 seconds
759-
760-
761-
-- !query
762-
select avg(cast(v as interval)) from VALUES ('-1 weeks'), ('2 seconds'), (null) t(v)
763-
-- !query schema
764-
struct<avg(CAST(v AS INTERVAL)):interval>
765-
-- !query output
766-
-3 days -11 hours -59 minutes -59 seconds
767-
768-
769-
-- !query
770-
select
771-
i,
772-
avg(cast(v as interval))
773-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
774-
group by i
775-
-- !query schema
776-
struct<i:int,avg(CAST(v AS INTERVAL)):interval>
777-
-- !query output
778-
1 -1 days
779-
2 2 seconds
780-
3 NULL
781-
782-
783-
-- !query
784-
select
785-
avg(cast(v as interval)) as sv
786-
from VALUES (1, '-1 weeks'), (2, '2 seconds'), (3, null), (1, '5 days') t(i, v)
787-
having sv is not null
788-
-- !query schema
789-
struct<sv:interval>
790-
-- !query output
791-
-15 hours -59 minutes -59.333333 seconds
792-
793-
794-
-- !query
795-
SELECT
796-
i,
797-
avg(cast(v as interval)) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)
798-
FROM VALUES (1,'1 seconds'), (1,'2 seconds'), (2,NULL), (2,NULL) t(i,v)
799-
-- !query schema
800-
struct<i:int,avg(CAST(v AS INTERVAL)) OVER (ORDER BY i ASC NULLS FIRST ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING):interval>
801-
-- !query output
802-
1 1.5 seconds
803-
1 2 seconds
804-
2 NULL
805-
2 NULL
806-
807-
808634
-- !query
809635
create temporary view interval_arithmetic as
810636
select CAST(dateval AS date), CAST(tsval AS timestamp) from values

0 commit comments

Comments
 (0)