Skip to content

Commit 91d8209

Browse files
committed
Updated tests
1 parent 504cc33 commit 91d8209

File tree

3 files changed

+13
-13
lines changed

3 files changed

+13
-13
lines changed

tests/queries/0_stateless/01232_untuple.reference

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
hello 1 3 world
33
9
44
9 (0,1)
5-
key tupleElement(argMax(tuple(v1, v2, v3, v4, v5), v1), \'1\') tupleElement(argMax(tuple(v1, v2, v3, v4, v5), v1), \'2\') tupleElement(argMax(tuple(v1, v2, v3, v4, v5), v1), \'3\') tupleElement(argMax(tuple(v1, v2, v3, v4, v5), v1), \'4\') tupleElement(argMax(tuple(v1, v2, v3, v4, v5), v1), \'5\')
5+
key tupleElement(argMax((v1, v2, v3, v4, v5), v1), \'1\') tupleElement(argMax((v1, v2, v3, v4, v5), v1), \'2\') tupleElement(argMax((v1, v2, v3, v4, v5), v1), \'3\') tupleElement(argMax((v1, v2, v3, v4, v5), v1), \'4\') tupleElement(argMax((v1, v2, v3, v4, v5), v1), \'5\')
66
1 20 20 10 20 30
77
2 11 20 10 20 30
88
3 70 20 10 20 30

tests/queries/0_stateless/02483_cuturlparameter_with_arrays.reference

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ SELECT
3131
FORMAT Vertical;
3232
Row 1:
3333
──────
34-
cutURLParameter('http://bigmir.net/?a=b&c=d', array()): http://bigmir.net/?a=b&c=d
34+
cutURLParameter('http://bigmir.net/?a=b&c=d', []): http://bigmir.net/?a=b&c=d
3535
cutURLParameter('http://bigmir.net/?a=b&c=d', ['a']): http://bigmir.net/?c=d
3636
cutURLParameter('http://bigmir.net/?a=b&c=d', ['a', 'c']): http://bigmir.net/?
3737
cutURLParameter('http://bigmir.net/?a=b&c=d', ['c']): http://bigmir.net/?a=b
@@ -44,7 +44,7 @@ cutURLParameter('http://bigmir.net/?a=b&c=d#e&g=h', ['c', 'g']): http:
4444
cutURLParameter('http://bigmir.net/?a=b&c=d#e&g=h', ['e', 'g']): http://bigmir.net/?a=b&c=d#e
4545
cutURLParameter('http://bigmir.net/?a=b&c=d#test?e=f&g=h', ['test', 'e']): http://bigmir.net/?a=b&c=d#test?g=h
4646
cutURLParameter('http://bigmir.net/?a=b&c=d#test?e=f&g=h', ['test', 'g']): http://bigmir.net/?a=b&c=d#test?e=f
47-
cutURLParameter('//bigmir.net/?a=b&c=d', array()): //bigmir.net/?a=b&c=d
47+
cutURLParameter('//bigmir.net/?a=b&c=d', []): //bigmir.net/?a=b&c=d
4848
cutURLParameter('//bigmir.net/?a=b&c=d', ['a']): //bigmir.net/?c=d
4949
cutURLParameter('//bigmir.net/?a=b&c=d', ['a', 'c']): //bigmir.net/?
5050
cutURLParameter('//bigmir.net/?a=b&c=d#e=f', ['a', 'e']): //bigmir.net/?c=d#
@@ -89,7 +89,7 @@ SELECT
8989
FORMAT Vertical;
9090
Row 1:
9191
──────
92-
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d'), array()): http://bigmir.net/?a=b&c=d
92+
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d'), []): http://bigmir.net/?a=b&c=d
9393
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d'), ['a']): http://bigmir.net/?c=d
9494
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d'), ['a', 'c']): http://bigmir.net/?
9595
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d'), ['c']): http://bigmir.net/?a=b
@@ -102,7 +102,7 @@ cutURLParameter(materialize('http://bigmir.net/?a=b&c=d#e&g=h'), ['c', 'g']):
102102
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d#e&g=h'), ['e', 'g']): http://bigmir.net/?a=b&c=d#e
103103
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d#test?e=f&g=h'), ['test', 'e']): http://bigmir.net/?a=b&c=d#test?g=h
104104
cutURLParameter(materialize('http://bigmir.net/?a=b&c=d#test?e=f&g=h'), ['test', 'g']): http://bigmir.net/?a=b&c=d#test?e=f
105-
cutURLParameter(materialize('//bigmir.net/?a=b&c=d'), array()): //bigmir.net/?a=b&c=d
105+
cutURLParameter(materialize('//bigmir.net/?a=b&c=d'), []): //bigmir.net/?a=b&c=d
106106
cutURLParameter(materialize('//bigmir.net/?a=b&c=d'), ['a']): //bigmir.net/?c=d
107107
cutURLParameter(materialize('//bigmir.net/?a=b&c=d'), ['a', 'c']): //bigmir.net/?
108108
cutURLParameter(materialize('//bigmir.net/?a=b&c=d#e=f'), ['a', 'e']): //bigmir.net/?c=d#

tests/queries/0_stateless/02890_untuple_column_names.reference

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -5,12 +5,12 @@ tupleElement(CAST(tuple(1), 'Tuple(a Int)'), 1): 1
55
tupleElement(CAST(tuple('s'), 'Tuple(a String)'), 1): s
66
Row 1:
77
──────
8-
tupleElement(CAST(tuple(1), 'Tuple(a Int)'), 'a'): 1
9-
tupleElement(CAST(tuple('s'), 'Tuple(a String)'), 'a'): s
8+
tupleElement(CAST((1), 'Tuple(a Int)'), 'a'): 1
9+
tupleElement(CAST(('s'), 'Tuple(a String)'), 'a'): s
1010
Row 1:
1111
──────
12-
tupleElement(CAST(tuple(1), 'Tuple(a Int)'), 'a'): 1
13-
tupleElement(CAST(tuple(1), 'Tuple(a Int)'), 'a'): 1
12+
tupleElement(CAST((1), 'Tuple(a Int)'), 'a'): 1
13+
tupleElement(CAST((1), 'Tuple(a Int)'), 'a'): 1
1414
-- tuple element alias + untuple() alias
1515
Row 1:
1616
──────
@@ -44,12 +44,12 @@ tupleElement(CAST(tuple(1), 'Tuple(Int)'), 1): 1
4444
tupleElement(CAST(tuple('s'), 'Tuple(String)'), 1): s
4545
Row 1:
4646
──────
47-
tupleElement(CAST(tuple(1), 'Tuple(Int)'), '1'): 1
48-
tupleElement(CAST(tuple('s'), 'Tuple(String)'), '1'): s
47+
tupleElement(CAST((1), 'Tuple(Int)'), '1'): 1
48+
tupleElement(CAST(('s'), 'Tuple(String)'), '1'): s
4949
Row 1:
5050
──────
51-
tupleElement(CAST(tuple(1), 'Tuple(Int)'), '1'): 1
52-
tupleElement(CAST(tuple(1), 'Tuple(Int)'), '1'): 1
51+
tupleElement(CAST((1), 'Tuple(Int)'), '1'): 1
52+
tupleElement(CAST((1), 'Tuple(Int)'), '1'): 1
5353
-- tuple() loses the column names (would be good to fix, see #36773)
5454
Row 1:
5555
──────

0 commit comments

Comments
 (0)