aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/pragma/classic_division.sql
blob: a6988269f3522512f899ce9828e505c2932c2994 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
/* postgres can not */
SELECT 1 / 2;

PRAGMA ClassicDivision("false");
SELECT 3 / 4;
PRAGMA ClassicDivision("true");
SELECT 5 / 6;

DEFINE ACTION $div_8_by_value($value) AS
    PRAGMA ClassicDivision("false");
    SELECT 8 / $value;
END DEFINE;

DO $div_8_by_value(9);

SELECT 10 / 11;