| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| |
| use TinySocial; |
| |
| { |
| "t1": (select array_union(t.`referred-topics`, {{"t-mobile", "platform"}}, {{"t-mobile"}}) from TweetMessages t order by t.tweetid), |
| "t2": (select array_union([1, "John", 2], (select value v.id from d1 v), [2,4,1])), |
| "t3": (array_union([3,5,1], [5,7,3], [3,2,5,1])), |
| "t4": (array_union([3,5.0,1], [5,7,3], [3,2,5,1])), |
| "t5": (array_union([3,"a",1], ["a",7,3], [3,2,"a",1])), |
| "t6": (array_union([3,"a",1], ["A",7,3], [3,2,"a",1])), |
| "t7": (array_union([3,"a",null], ["A",7,missing], [3,2,"a",1, null])), |
| "t8": (array_union([3,"a",null], ["A",7,null], [3,2,"a",1, null])), |
| "t9": (array_union([3,missing,"a",null], [missing,"A",7,null], [3,2,"a",1, null,missing])), |
| "t10": (array_union([3,5,1], [7,3], [2,5,1])), |
| "t11": (array_union([3,5,1], missing, [2,5,1])), |
| "t12": (array_union([3,5,1], null, [2,5,1])), |
| "t13": (array_union([3,5,1], "non_array", [2,5,1])), |
| "t14": (array_union(missing, "non_array", [2,5,1])), |
| "t15": (array_union([], [], [])), |
| "t16": (array_union([], [3,2], [])), |
| "t17": (select array_union(d.followers, ["John Green", "sth"], ["sth", "1"]) from d1 d) |
| }; |