operators.sql.out

-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 59


-- !query 0
select -100
-- !query 0 schema
struct<-100:int>
-- !query 0 output
-100


-- !query 1
select +230
-- !query 1 schema
struct<230:int>
-- !query 1 output
230


-- !query 2
select -5.2
-- !query 2 schema
struct<-5.2:decimal(2,1)>
-- !query 2 output
-5.2


-- !query 3
select +6.8e0
-- !query 3 schema
struct<6.8:decimal(2,1)>
-- !query 3 output
6.8


-- !query 4
select -key, +key from testdata where key = 2
-- !query 4 schema
struct<(- key):int,key:int>
-- !query 4 output
-2	2


-- !query 5
select -(key + 1), - key + 1, +(key + 5) from testdata where key = 1
-- !query 5 schema
struct<(- (key + 1)):int,((- key) + 1):int,(key + 5):int>
-- !query 5 output
-2	0	6


-- !query 6
select -max(key), +max(key) from testdata
-- !query 6 schema
struct<(- max(key)):int,max(key):int>
-- !query 6 output
-100	100


-- !query 7
select - (-10)
-- !query 7 schema
struct<(- -10):int>
-- !query 7 output
10


-- !query 8
select + (-key) from testdata where key = 32
-- !query 8 schema
struct<(- key):int>
-- !query 8 output
-32


-- !query 9
select - (+max(key)) from testdata
-- !query 9 schema
struct<(- max(key)):int>
-- !query 9 output
-100


-- !query 10
select - - 3
-- !query 10 schema
struct<(- -3):int>
-- !query 10 output
3


-- !query 11
select - + 20
-- !query 11 schema
struct<(- 20):int>
-- !query 11 output
-20


-- !query 12
select + + 100
-- !query 12 schema
struct<100:int>
-- !query 12 output
100


-- !query 13
select - - max(key) from testdata
-- !query 13 schema
struct<(- (- max(key))):int>
-- !query 13 output
100


-- !query 14
select + - key from testdata where key = 33
-- !query 14 schema
struct<(- key):int>
-- !query 14 output
-33


-- !query 15
select 5 / 2
-- !query 15 schema
struct<(CAST(5 AS DOUBLE) / CAST(2 AS DOUBLE)):double>
-- !query 15 output
2.5


-- !query 16
select 5 / 0
-- !query 16 schema
struct<(CAST(5 AS DOUBLE) / CAST(0 AS DOUBLE)):double>
-- !query 16 output
NULL


-- !query 17
select 5 / null
-- !query 17 schema
struct<(CAST(5 AS DOUBLE) / CAST(NULL AS DOUBLE)):double>
-- !query 17 output
NULL


-- !query 18
select null / 5
-- !query 18 schema
struct<(CAST(NULL AS DOUBLE) / CAST(5 AS DOUBLE)):double>
-- !query 18 output
NULL


-- !query 19
select 5 div 2
-- !query 19 schema
struct<CAST((CAST(5 AS DOUBLE) / CAST(2 AS DOUBLE)) AS BIGINT):bigint>
-- !query 19 output
2


-- !query 20
select 5 div 0
-- !query 20 schema
struct<CAST((CAST(5 AS DOUBLE) / CAST(0 AS DOUBLE)) AS BIGINT):bigint>
-- !query 20 output
NULL


-- !query 21
select 5 div null
-- !query 21 schema
struct<CAST((CAST(5 AS DOUBLE) / CAST(NULL AS DOUBLE)) AS BIGINT):bigint>
-- !query 21 output
NULL


-- !query 22
select null div 5
-- !query 22 schema
struct<CAST((CAST(NULL AS DOUBLE) / CAST(5 AS DOUBLE)) AS BIGINT):bigint>
-- !query 22 output
NULL


-- !query 23
select 1 + 2
-- !query 23 schema
struct<(1 + 2):int>
-- !query 23 output
3


-- !query 24
select 1 - 2
-- !query 24 schema
struct<(1 - 2):int>
-- !query 24 output
-1


-- !query 25
select 2 * 5
-- !query 25 schema
struct<(2 * 5):int>
-- !query 25 output
10


-- !query 26
select 5 % 3
-- !query 26 schema
struct<(5 % 3):int>
-- !query 26 output
2


-- !query 27
select pmod(-7, 3)
-- !query 27 schema
struct<pmod(-7, 3):int>
-- !query 27 output
2


-- !query 28
explain select 'a' || 1 + 2
-- !query 28 schema
struct<plan:string>
-- !query 28 output
== Physical Plan ==
*Project [null AS (CAST(concat(a, CAST(1 AS STRING)) AS DOUBLE) + CAST(2 AS DOUBLE))#x]
+- Scan OneRowRelation[]


-- !query 29
explain select 1 - 2 || 'b'
-- !query 29 schema
struct<plan:string>
-- !query 29 output
== Physical Plan ==
*Project [-1b AS concat(CAST((1 - 2) AS STRING), b)#x]
+- Scan OneRowRelation[]


-- !query 30
explain select 2 * 4  + 3 || 'b'
-- !query 30 schema
struct<plan:string>
-- !query 30 output
== Physical Plan ==
*Project [11b AS concat(CAST(((2 * 4) + 3) AS STRING), b)#x]
+- Scan OneRowRelation[]


-- !query 31
explain select 3 + 1 || 'a' || 4 / 2
-- !query 31 schema
struct<plan:string>
-- !query 31 output
== Physical Plan ==
*Project [4a2.0 AS concat(concat(CAST((3 + 1) AS STRING), a), CAST((CAST(4 AS DOUBLE) / CAST(2 AS DOUBLE)) AS STRING))#x]
+- Scan OneRowRelation[]


-- !query 32
explain select 1 == 1 OR 'a' || 'b' ==  'ab'
-- !query 32 schema
struct<plan:string>
-- !query 32 output
== Physical Plan ==
*Project [true AS ((1 = 1) OR (concat(a, b) = ab))#x]
+- Scan OneRowRelation[]


-- !query 33
explain select 'a' || 'c' == 'ac' AND 2 == 3
-- !query 33 schema
struct<plan:string>
-- !query 33 output
== Physical Plan ==
*Project [false AS ((concat(a, c) = ac) AND (2 = 3))#x]
+- Scan OneRowRelation[]


-- !query 34
select cot(1)
-- !query 34 schema
struct<COT(CAST(1 AS DOUBLE)):double>
-- !query 34 output
0.6420926159343306


-- !query 35
select cot(null)
-- !query 35 schema
struct<COT(CAST(NULL AS DOUBLE)):double>
-- !query 35 output
NULL


-- !query 36
select cot(0)
-- !query 36 schema
struct<COT(CAST(0 AS DOUBLE)):double>
-- !query 36 output
Infinity


-- !query 37
select cot(-1)
-- !query 37 schema
struct<COT(CAST(-1 AS DOUBLE)):double>
-- !query 37 output
-0.6420926159343306


-- !query 38
select ceiling(0)
-- !query 38 schema
struct<CEIL(CAST(0 AS DOUBLE)):bigint>
-- !query 38 output
0


-- !query 39
select ceiling(1)
-- !query 39 schema
struct<CEIL(CAST(1 AS DOUBLE)):bigint>
-- !query 39 output
1


-- !query 40
select ceil(1234567890123456)
-- !query 40 schema
struct<CEIL(1234567890123456):bigint>
-- !query 40 output
1234567890123456


-- !query 41
select ceiling(1234567890123456)
-- !query 41 schema
struct<CEIL(1234567890123456):bigint>
-- !query 41 output
1234567890123456


-- !query 42
select ceil(0.01)
-- !query 42 schema
struct<CEIL(0.01):decimal(1,0)>
-- !query 42 output
1


-- !query 43
select ceiling(-0.10)
-- !query 43 schema
struct<CEIL(-0.10):decimal(1,0)>
-- !query 43 output
0


-- !query 44
select floor(0)
-- !query 44 schema
struct<FLOOR(CAST(0 AS DOUBLE)):bigint>
-- !query 44 output
0


-- !query 45
select floor(1)
-- !query 45 schema
struct<FLOOR(CAST(1 AS DOUBLE)):bigint>
-- !query 45 output
1


-- !query 46
select floor(1234567890123456)
-- !query 46 schema
struct<FLOOR(1234567890123456):bigint>
-- !query 46 output
1234567890123456


-- !query 47
select floor(0.01)
-- !query 47 schema
struct<FLOOR(0.01):decimal(1,0)>
-- !query 47 output
0


-- !query 48
select floor(-0.10)
-- !query 48 schema
struct<FLOOR(-0.10):decimal(1,0)>
-- !query 48 output
-1


-- !query 49
select 1 > 0.00001
-- !query 49 schema
struct<(CAST(1 AS BIGINT) > 0):boolean>
-- !query 49 output
true


-- !query 50
select mod(7, 2), mod(7, 0), mod(0, 2), mod(7, null), mod(null, 2), mod(null, null)
-- !query 50 schema
struct<(7 % 2):int,(7 % 0):int,(0 % 2):int,(7 % CAST(NULL AS INT)):int,(CAST(NULL AS INT) % 2):int,(CAST(NULL AS DOUBLE) % CAST(NULL AS DOUBLE)):double>
-- !query 50 output
1	NULL	0	NULL	NULL	NULL


-- !query 51
select BIT_LENGTH('abc')
-- !query 51 schema
struct<bit_length(abc):int>
-- !query 51 output
24


-- !query 52
select CHAR_LENGTH('abc')
-- !query 52 schema
struct<length(abc):int>
-- !query 52 output
3


-- !query 53
select CHARACTER_LENGTH('abc')
-- !query 53 schema
struct<length(abc):int>
-- !query 53 output
3


-- !query 54
select OCTET_LENGTH('abc')
-- !query 54 schema
struct<octet_length(abc):int>
-- !query 54 output
3


-- !query 55
select abs(-3.13), abs('-2.19')
-- !query 55 schema
struct<abs(-3.13):decimal(3,2),abs(CAST(-2.19 AS DOUBLE)):double>
-- !query 55 output
3.13	2.19


-- !query 56
select positive('-1.11'), positive(-1.11), negative('-1.11'), negative(-1.11)
-- !query 56 schema
struct<(+ CAST(-1.11 AS DOUBLE)):double,(+ -1.11):decimal(3,2),(- CAST(-1.11 AS DOUBLE)):double,(- -1.11):decimal(3,2)>
-- !query 56 output
-1.11	-1.11	1.11	1.11


-- !query 57
select pmod(-7, 2), pmod(0, 2), pmod(7, 0), pmod(7, null), pmod(null, 2), pmod(null, null)
-- !query 57 schema
struct<pmod(-7, 2):int,pmod(0, 2):int,pmod(7, 0):int,pmod(7, CAST(NULL AS INT)):int,pmod(CAST(NULL AS INT), 2):int,pmod(CAST(NULL AS DOUBLE), CAST(NULL AS DOUBLE)):double>
-- !query 57 output
1	0	NULL	NULL	NULL	NULL


-- !query 58
select pmod(cast(3.13 as decimal), cast(0 as decimal)), pmod(cast(2 as smallint), cast(0 as smallint))
-- !query 58 schema
struct<pmod(CAST(3.13 AS DECIMAL(10,0)), CAST(0 AS DECIMAL(10,0))):decimal(10,0),pmod(CAST(2 AS SMALLINT), CAST(0 AS SMALLINT)):smallint>
-- !query 58 output
NULL	NULL