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
|
# name: test/sql/parser/dollar_quotes_internal_issue2224.test
# description: Unexpected implicit conversion of string literal with full-width space
# group: [parser]
# we replace unicode spaces in query strings, except if they are quoted
# internal issue 2224 found that this doesn't work properly for double-dollar quoting
# lhs is regular space, rhs is a wider unicode space, so this should be false
#query I
#select $$ $$ = $$ $$;
#----
#false
query I
select $tag$ $tag$ = $tag$ $tag$;
----
false
# worked properly before for these quotes
query I
select ' ' = ' ';
----
false
# just checking if parsing didn't break by fixing the dollar thing
query I
select $$$$ = '';
----
true
query I
select $tag$$tag$ = '';
----
true
query I
select '' = $$$$;
----
true
query I
select '' = $tag$$tag$;
----
true
query I
select $$ $$ = $$ $$ or ' ' = ' ';
----
false
query I
select $tag$ $tag$ = $tag$ $tag$ or ' ' = ' ';
----
false
query I
select ' ' = ' ' or $$ $$ = $$ $$;
----
false
query I
select ' ' = ' ' or $tag$ $tag$ = $tag$ $tag$;
----
false
# we can nest dollars if tags don't match
query I
select $tag$ $duck$ $tag$ = $tag$ $duck$ $tag$;
----
false
# of course we have to try this too
query I
select $🦆$du ck$🦆$ = $🦆$du ck$🦆$;
----
false
# and some more unicode
query I
select $ü$x x$ü$ = $ü$x x$ü$;
----
false
|
