1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89

use {
    crate::*,
    gluesql_core::{
        error::{EvaluateError, TranslateError},
        prelude::Value::*,
    },
};

test_case!(sign, async move {
    let test_cases = [
        (
            "SELECT
                SIGN(2) AS SIGN1, 
                SIGN(-2) AS SIGN2, 
                SIGN(+2) AS SIGN3 
            ;",
            Ok(select!(
                "SIGN1" | "SIGN2"                 | "SIGN3";
                I8      | I8                      | I8;
                1_i8      f64::signum(-2.0) as i8    1_i8
            )),
        ),
        (
            "SELECT
                SIGN(2.0) AS SIGN1, 
                SIGN(-2.0) AS SIGN2, 
                SIGN(+2.0) AS SIGN3 
            ;",
            Ok(select!(
                "SIGN1" | "SIGN2"                 | "SIGN3";
                I8      | I8                      | I8;
                1_i8      f64::signum(-2.0) as i8   1_i8
            )),
        ),
        (
            "SELECT
                SIGN(0.0) AS SIGN1, 
                SIGN(-0.0) AS SIGN2, 
                SIGN(+0.0) AS SIGN3 
            ;",
            Ok(select!(
                "SIGN1" | "SIGN2" | "SIGN3";
                I8      | I8      | I8;
                0_i8      0_i8      0_i8
            )),
        ),
        (
            "SELECT
                SIGN(0) AS SIGN1, 
                SIGN(-0) AS SIGN2, 
                SIGN(+0) AS SIGN3 
            ;",
            Ok(select!(
                "SIGN1" | "SIGN2" | "SIGN3";
                I8      | I8      | I8;
                0_i8      0_i8      0_i8
            )),
        ),
        (
            "SELECT SIGN('string') AS SIGN",
            Err(EvaluateError::FunctionRequiresFloatValue(String::from("SIGN")).into()),
        ),
        (
            "SELECT SIGN(NULL) AS sign",
            Ok(select_with_null!(sign; Null)),
        ),
        (
            "SELECT SIGN(TRUE) AS sign",
            Err(EvaluateError::FunctionRequiresFloatValue(String::from("SIGN")).into()),
        ),
        (
            "SELECT SIGN(FALSE) AS sign",
            Err(EvaluateError::FunctionRequiresFloatValue(String::from("SIGN")).into()),
        ),
        (
            "SELECT SIGN('string', 'string2') AS SIGN",
            Err(TranslateError::FunctionArgsLengthNotMatching {
                name: "SIGN".to_owned(),
                expected: 1,
                found: 2,
            }
            .into()),
        ),
    ];

    for (sql, expected) in test_cases {
        test!(sql, expected);
    }
});