aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/decimal_comparison.sql
blob: c41cc5540e076661381d2653822745c4db74515a (plain) (blame)
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
USE plato;

SELECT
    cs_ext_list_price == cs_ext_tax,
    cs_ext_list_price != cs_ext_tax,
    cs_ext_list_price < cs_ext_tax,
    cs_ext_list_price <= cs_ext_tax,
    cs_ext_list_price > cs_ext_tax,
    cs_ext_list_price >= cs_ext_tax,

    cs_ext_tax == decimal("26.91", 7, 2),
    cs_ext_tax != decimal("26.91", 7, 2),
    cs_ext_tax < decimal("26.91", 7, 2),
    cs_ext_tax <= decimal("26.91", 7, 2),
    cs_ext_tax > decimal("26.91", 7, 2),
    cs_ext_tax >= decimal("26.91", 7, 2),

    decimal("26.91", 7, 2) == cs_ext_tax,
    decimal("26.91", 7, 2) != cs_ext_tax,
    decimal("26.91", 7, 2) < cs_ext_tax,
    decimal("26.91", 7, 2) <= cs_ext_tax,
    decimal("26.91", 7, 2) > cs_ext_tax,
    decimal("26.91", 7, 2) >= cs_ext_tax,
FROM Input;