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
|
SELECT 2*3
SELECT 2 * 3
SELECT field * 8
SELECT 8 * field
SELECT foo * bar
SELECT `escaped_field` * 16
SELECT 16 * `escaped_field`
SELECT `foo` * `bar`
SELECT `foo`*`bar`
SELECT 1 * (SELECT COUNT(1) FROM nb_rows)
SELECT (SELECT COUNT(1) FROM nb_rows) * 1
SELECT (SELECT COUNT(1) FROM nb_rows) * (SELECT COUNT(1) FROM nb_rows)
SELECT (1 * 1) * (2 * 2)
SELECT 1 * (2 * (3 * (4 * 5)))
SELECT 2.71 * 3.14
SELECT 2.71 * -3.14
SELECT -2.71 * 3.14
SELECT -2.71 * -3.14
SELECT 0xABC * 0xCBA
SELECT 0xABC * -0xCBA
SELECT -0xABC * 0xCBA
SELECT -0xABC * -0xCBA
-- Now same but with comments inside (C style comments could conflicts with operator if lexer is failing)
SELECT 2 * /* comment */3
SELECT 2/* comment */ * 3
SELECT 2/* comment with * inside */ * 3
SELECT /* comment */ field /* comment */ * /* comment */ 8 /* comment */
SELECT /* comment */ 8 /* comment */ * /* comment */ field /* comment */
SELECT /* comment */ foo /* comment */ * /* comment */ bar /* comment */
SELECT /* comment */ `escaped_field` /* comment */ * /* comment */ 16 /* comment */
SELECT /* comment */ 16 /* comment */ * /* comment */ `escaped_field` /* comment */
SELECT /* comment */ `foo` /* comment */ * /* comment */ `bar` /* comment */
SELECT /* `comment` */ `foo` /* `comment` */ * /* `comment` */ `bar` /* `comment` */
SELECT /* comment */ 1 /* comment */ * /* comment */ (SELECT COUNT(/* comment */1/* comment */) /* comment */ FROM nb_rows)
SELECT /* comment */ (SELECT COUNT(1) /* comment */FROM/* comment */ nb_rows) /* comment */ * /* comment */ 1
SELECT (SELECT /* comment */ COUNT(1) /* comment */ FROM /* comment */ nb_rows) /* comment */ * /* comment */ (SELECT COUNT(1) FROM nb_rows)
SELECT (1 * 1) /* comment */ * /* comment */ (2 * 2)
SELECT /* comment */ 1 /* comment */ * /* comment */ (2 /* comment */ * /* comment */ (3 /* comment */ * /* comment */ (4 /* comment */ * /* comment */ 5))) /* comment */
SELECT 2.71 /* comment */ * /* comment */ 3.14
SELECT 2.71 /* comment */ * /* comment */ -3.14
SELECT -2.71 /* comment */ * /* comment */ 3.14
SELECT -2.71 /* comment */ * /* comment */ -3.14
SELECT 0xABC /* comment */ * /* comment */ 0xCBA
SELECT 0xABC /* comment */ * /* comment */ -0xCBA
SELECT -0xABC /* comment */ * /* comment */ 0xCBA
SELECT -0xABC /* comment */ * /* comment */ -0xCBA
SELECT 1 /* comment with FROM keyword */ * /* comment with USING keyword */1
SELECT 1 /* comment with ) */ * /* comment with , keyword */1
|
