Skip to content

Commit f8313a3

Browse files
alexey-milovidovalexey-milovidov
committed
Add test for some possible ambiguities in syntax
1 parent 202d1f2 commit f8313a3

2 files changed

Lines changed: 25 additions & 0 deletions

File tree

‎tests/queries/0_stateless/01638_div_mod_ambiguities.reference‎

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
MOD
2+
1
3+
MOD
4+
1
5+
modulo(DIV, 1)
6+
0
7+
DIV
8+
1
9+
mod
10+
1
11+
MOD
12+
1
13+
modulo(DIV, 1)
14+
0
15+
div
16+
1

‎tests/queries/0_stateless/01638_div_mod_ambiguities.sql‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
SELECT DIV AS MOD FROM (SELECT 1 `DIV`) FORMAT TSVWithNames;
2+
SELECT DIV `MOD` FROM (SELECT 1 `DIV`) FORMAT TSVWithNames;
3+
SELECT DIV MOD 1 FROM (SELECT 1 `DIV`) FORMAT TSVWithNames;
4+
SELECT 1 DIV `MOD` `DIV` FROM (SELECT 1 `MOD`) FORMAT TSVWithNames;
5+
6+
SELECT DIV AS mod FROM (SELECT 1 `DIV`) FORMAT TSVWithNames;
7+
SELECT div `MOD` FROM (SELECT 1 `div`) FORMAT TSVWithNames;
8+
SELECT DIV mod 1 FROM (SELECT 1 `DIV`) FORMAT TSVWithNames;
9+
SELECT 1 div `mod` `div` FROM (SELECT 1 `mod`) FORMAT TSVWithNames;

0 commit comments

Comments
 (0)