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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124

use {
    crate::*,
    gluesql_core::{
        data::ValueError,
        prelude::{DataType, Payload, Value::*},
    },
};

test_case!(int64, async move {
    run!(
        "CREATE TABLE Item (
        field_one INT,
        field_two INT,
    );"
    );
    run!("INSERT INTO Item VALUES (1, -1), (-2, 2), (3, 3), (-4, -4);");

    let parse_i64 = |text: &str| -> i64 { text.parse().unwrap() };

    test!(
        &format!(
            "INSERT INTO Item VALUES ({:?}, {:?})",
            i64::MAX as i128 + 1,
            i64::MIN as i128 - 1
        ),
        Err(ValueError::FailedToParseNumber.into())
    );

    // cast i64::MAX+1
    test!(
        &format!("select cast({} as INT) from Item", i64::MAX as i128 + 1),
        Err(ValueError::LiteralCastToDataTypeFailed(
            DataType::Int,
            (i64::MAX as i128 + 1).to_string()
        )
        .into())
    );

    // cast i64::MIN-1
    test!(
        &format!("select cast({} as INT) from Item", i64::MIN as i128 - 1),
        Err(ValueError::LiteralCastToDataTypeFailed(
            DataType::Int,
            (i64::MIN as i128 - 1).to_string()
        )
        .into())
    );

    // lets try some valid SQL
    test!(
        "SELECT field_one, field_two FROM Item",
        Ok(select!(
            field_one          | field_two
            I64                |    I64;
            1                  parse_i64("-1");
            parse_i64("-2")    2;
            3                  3;
            parse_i64("-4")    parse_i64("-4")
        ))
    );

    test!(
        "SELECT field_one FROM Item WHERE field_one = 1",
        Ok(select!(field_one I64; 1))
    );

    test!(
        "SELECT field_one FROM Item WHERE field_one > 0",
        Ok(select!(field_one I64; 1; 3))
    );

    test!(
        "SELECT field_one FROM Item WHERE field_one >= 0",
        Ok(select!(field_one I64; 1; 3))
    );

    test!(
        "SELECT field_one FROM Item WHERE field_one = -2",
        Ok(select!(field_one I64; -2))
    );

    test!(
        "SELECT field_one FROM Item WHERE field_one < 0",
        Ok(select!(field_one I64; -2; -4))
    );

    test!(
        "SELECT field_one FROM Item WHERE field_one <= 0",
        Ok(select!(field_one I64; -2; -4))
    );

    test!(
        "SELECT field_one + field_two AS plus FROM Item;",
        Ok(select!(plus I64; 0; 0; 6; -8))
    );

    test!(
        "SELECT field_one - field_two AS sub FROM Item;",
        Ok(select!(sub I64; 2; -4; 0; 0))
    );

    test!(
        "SELECT field_one * field_two AS mul FROM Item;",
        Ok(select!(mul I64; -1; -4; 9; 16))
    );

    test!(
        "SELECT field_one / field_two AS div FROM Item;",
        Ok(select!(div I64; -1; -1; 1; 1))
    );

    test!(
        "SELECT field_one % field_two AS modulo FROM Item;",
        Ok(select!(modulo I64; 0; 0; 0; 0))
    );

    // try inserting i64 max and i64 min
    test!(
        &format!("INSERT INTO Item VALUES ({}, {})", i64::MAX, i64::MIN),
        Ok(Payload::Insert(1))
    );

    run!("DELETE FROM Item");
});