typeCoercion/native/inConversion.sql

0001 --
0002 --   Licensed to the Apache Software Foundation (ASF) under one or more
0003 --   contributor license agreements.  See the NOTICE file distributed with
0004 --   this work for additional information regarding copyright ownership.
0005 --   The ASF licenses this file to You under the Apache License, Version 2.0
0006 --   (the "License"); you may not use this file except in compliance with
0007 --   the License.  You may obtain a copy of the License at
0008 --
0009 --      http://www.apache.org/licenses/LICENSE-2.0
0010 --
0011 --   Unless required by applicable law or agreed to in writing, software
0012 --   distributed under the License is distributed on an "AS IS" BASIS,
0013 --   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
0014 --   See the License for the specific language governing permissions and
0015 --   limitations under the License.
0016 --
0017
0018 CREATE TEMPORARY VIEW t AS SELECT 1;
0019
0020 SELECT cast(1 as tinyint) in (cast(1 as tinyint)) FROM t;
0021 SELECT cast(1 as tinyint) in (cast(1 as smallint)) FROM t;
0022 SELECT cast(1 as tinyint) in (cast(1 as int)) FROM t;
0023 SELECT cast(1 as tinyint) in (cast(1 as bigint)) FROM t;
0024 SELECT cast(1 as tinyint) in (cast(1 as float)) FROM t;
0025 SELECT cast(1 as tinyint) in (cast(1 as double)) FROM t;
0026 SELECT cast(1 as tinyint) in (cast(1 as decimal(10, 0))) FROM t;
0027 SELECT cast(1 as tinyint) in (cast(1 as string)) FROM t;
0028 SELECT cast(1 as tinyint) in (cast('1' as binary)) FROM t;
0029 SELECT cast(1 as tinyint) in (cast(1 as boolean)) FROM t;
0030 SELECT cast(1 as tinyint) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0031 SELECT cast(1 as tinyint) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0032
0033 SELECT cast(1 as smallint) in (cast(1 as tinyint)) FROM t;
0034 SELECT cast(1 as smallint) in (cast(1 as smallint)) FROM t;
0035 SELECT cast(1 as smallint) in (cast(1 as int)) FROM t;
0036 SELECT cast(1 as smallint) in (cast(1 as bigint)) FROM t;
0037 SELECT cast(1 as smallint) in (cast(1 as float)) FROM t;
0038 SELECT cast(1 as smallint) in (cast(1 as double)) FROM t;
0039 SELECT cast(1 as smallint) in (cast(1 as decimal(10, 0))) FROM t;
0040 SELECT cast(1 as smallint) in (cast(1 as string)) FROM t;
0041 SELECT cast(1 as smallint) in (cast('1' as binary)) FROM t;
0042 SELECT cast(1 as smallint) in (cast(1 as boolean)) FROM t;
0043 SELECT cast(1 as smallint) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0044 SELECT cast(1 as smallint) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0045
0046 SELECT cast(1 as int) in (cast(1 as tinyint)) FROM t;
0047 SELECT cast(1 as int) in (cast(1 as smallint)) FROM t;
0048 SELECT cast(1 as int) in (cast(1 as int)) FROM t;
0049 SELECT cast(1 as int) in (cast(1 as bigint)) FROM t;
0050 SELECT cast(1 as int) in (cast(1 as float)) FROM t;
0051 SELECT cast(1 as int) in (cast(1 as double)) FROM t;
0052 SELECT cast(1 as int) in (cast(1 as decimal(10, 0))) FROM t;
0053 SELECT cast(1 as int) in (cast(1 as string)) FROM t;
0054 SELECT cast(1 as int) in (cast('1' as binary)) FROM t;
0055 SELECT cast(1 as int) in (cast(1 as boolean)) FROM t;
0056 SELECT cast(1 as int) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0057 SELECT cast(1 as int) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0058
0059 SELECT cast(1 as bigint) in (cast(1 as tinyint)) FROM t;
0060 SELECT cast(1 as bigint) in (cast(1 as smallint)) FROM t;
0061 SELECT cast(1 as bigint) in (cast(1 as int)) FROM t;
0062 SELECT cast(1 as bigint) in (cast(1 as bigint)) FROM t;
0063 SELECT cast(1 as bigint) in (cast(1 as float)) FROM t;
0064 SELECT cast(1 as bigint) in (cast(1 as double)) FROM t;
0065 SELECT cast(1 as bigint) in (cast(1 as decimal(10, 0))) FROM t;
0066 SELECT cast(1 as bigint) in (cast(1 as string)) FROM t;
0067 SELECT cast(1 as bigint) in (cast('1' as binary)) FROM t;
0068 SELECT cast(1 as bigint) in (cast(1 as boolean)) FROM t;
0069 SELECT cast(1 as bigint) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0070 SELECT cast(1 as bigint) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0071
0072 SELECT cast(1 as float) in (cast(1 as tinyint)) FROM t;
0073 SELECT cast(1 as float) in (cast(1 as smallint)) FROM t;
0074 SELECT cast(1 as float) in (cast(1 as int)) FROM t;
0075 SELECT cast(1 as float) in (cast(1 as bigint)) FROM t;
0076 SELECT cast(1 as float) in (cast(1 as float)) FROM t;
0077 SELECT cast(1 as float) in (cast(1 as double)) FROM t;
0078 SELECT cast(1 as float) in (cast(1 as decimal(10, 0))) FROM t;
0079 SELECT cast(1 as float) in (cast(1 as string)) FROM t;
0080 SELECT cast(1 as float) in (cast('1' as binary)) FROM t;
0081 SELECT cast(1 as float) in (cast(1 as boolean)) FROM t;
0082 SELECT cast(1 as float) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0083 SELECT cast(1 as float) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0084
0085 SELECT cast(1 as double) in (cast(1 as tinyint)) FROM t;
0086 SELECT cast(1 as double) in (cast(1 as smallint)) FROM t;
0087 SELECT cast(1 as double) in (cast(1 as int)) FROM t;
0088 SELECT cast(1 as double) in (cast(1 as bigint)) FROM t;
0089 SELECT cast(1 as double) in (cast(1 as float)) FROM t;
0090 SELECT cast(1 as double) in (cast(1 as double)) FROM t;
0091 SELECT cast(1 as double) in (cast(1 as decimal(10, 0))) FROM t;
0092 SELECT cast(1 as double) in (cast(1 as string)) FROM t;
0093 SELECT cast(1 as double) in (cast('1' as binary)) FROM t;
0094 SELECT cast(1 as double) in (cast(1 as boolean)) FROM t;
0095 SELECT cast(1 as double) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0096 SELECT cast(1 as double) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0097
0098 SELECT cast(1 as decimal(10, 0)) in (cast(1 as tinyint)) FROM t;
0099 SELECT cast(1 as decimal(10, 0)) in (cast(1 as smallint)) FROM t;
0100 SELECT cast(1 as decimal(10, 0)) in (cast(1 as int)) FROM t;
0101 SELECT cast(1 as decimal(10, 0)) in (cast(1 as bigint)) FROM t;
0102 SELECT cast(1 as decimal(10, 0)) in (cast(1 as float)) FROM t;
0103 SELECT cast(1 as decimal(10, 0)) in (cast(1 as double)) FROM t;
0104 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0))) FROM t;
0105 SELECT cast(1 as decimal(10, 0)) in (cast(1 as string)) FROM t;
0106 SELECT cast(1 as decimal(10, 0)) in (cast('1' as binary)) FROM t;
0107 SELECT cast(1 as decimal(10, 0)) in (cast(1 as boolean)) FROM t;
0108 SELECT cast(1 as decimal(10, 0)) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0109 SELECT cast(1 as decimal(10, 0)) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0110
0111 SELECT cast(1 as string) in (cast(1 as tinyint)) FROM t;
0112 SELECT cast(1 as string) in (cast(1 as smallint)) FROM t;
0113 SELECT cast(1 as string) in (cast(1 as int)) FROM t;
0114 SELECT cast(1 as string) in (cast(1 as bigint)) FROM t;
0115 SELECT cast(1 as string) in (cast(1 as float)) FROM t;
0116 SELECT cast(1 as string) in (cast(1 as double)) FROM t;
0117 SELECT cast(1 as string) in (cast(1 as decimal(10, 0))) FROM t;
0118 SELECT cast(1 as string) in (cast(1 as string)) FROM t;
0119 SELECT cast(1 as string) in (cast('1' as binary)) FROM t;
0120 SELECT cast(1 as string) in (cast(1 as boolean)) FROM t;
0121 SELECT cast(1 as string) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0122 SELECT cast(1 as string) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0123
0124 SELECT cast('1' as binary) in (cast(1 as tinyint)) FROM t;
0125 SELECT cast('1' as binary) in (cast(1 as smallint)) FROM t;
0126 SELECT cast('1' as binary) in (cast(1 as int)) FROM t;
0127 SELECT cast('1' as binary) in (cast(1 as bigint)) FROM t;
0128 SELECT cast('1' as binary) in (cast(1 as float)) FROM t;
0129 SELECT cast('1' as binary) in (cast(1 as double)) FROM t;
0130 SELECT cast('1' as binary) in (cast(1 as decimal(10, 0))) FROM t;
0131 SELECT cast('1' as binary) in (cast(1 as string)) FROM t;
0132 SELECT cast('1' as binary) in (cast('1' as binary)) FROM t;
0133 SELECT cast('1' as binary) in (cast(1 as boolean)) FROM t;
0134 SELECT cast('1' as binary) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0135 SELECT cast('1' as binary) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0136
0137 SELECT true in (cast(1 as tinyint)) FROM t;
0138 SELECT true in (cast(1 as smallint)) FROM t;
0139 SELECT true in (cast(1 as int)) FROM t;
0140 SELECT true in (cast(1 as bigint)) FROM t;
0141 SELECT true in (cast(1 as float)) FROM t;
0142 SELECT true in (cast(1 as double)) FROM t;
0143 SELECT true in (cast(1 as decimal(10, 0))) FROM t;
0144 SELECT true in (cast(1 as string)) FROM t;
0145 SELECT true in (cast('1' as binary)) FROM t;
0146 SELECT true in (cast(1 as boolean)) FROM t;
0147 SELECT true in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0148 SELECT true in (cast('2017-12-11 09:30:00' as date)) FROM t;
0149
0150 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as tinyint)) FROM t;
0151 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as smallint)) FROM t;
0152 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as int)) FROM t;
0153 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as bigint)) FROM t;
0154 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as float)) FROM t;
0155 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as double)) FROM t;
0156 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as decimal(10, 0))) FROM t;
0157 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as string)) FROM t;
0158 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2' as binary)) FROM t;
0159 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast(2 as boolean)) FROM t;
0160 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0161 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0162
0163 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as tinyint)) FROM t;
0164 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as smallint)) FROM t;
0165 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as int)) FROM t;
0166 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as bigint)) FROM t;
0167 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as float)) FROM t;
0168 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as double)) FROM t;
0169 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as decimal(10, 0))) FROM t;
0170 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as string)) FROM t;
0171 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2' as binary)) FROM t;
0172 SELECT cast('2017-12-12 09:30:00' as date) in (cast(2 as boolean)) FROM t;
0173 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0174 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-11 09:30:00' as date)) FROM t;
0175
0176 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as tinyint)) FROM t;
0177 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as smallint)) FROM t;
0178 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as int)) FROM t;
0179 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as bigint)) FROM t;
0180 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as float)) FROM t;
0181 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as double)) FROM t;
0182 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as decimal(10, 0))) FROM t;
0183 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as string)) FROM t;
0184 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast('1' as binary)) FROM t;
0185 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast(1 as boolean)) FROM t;
0186 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0187 SELECT cast(1 as tinyint) in (cast(1 as tinyint), cast('2017-12-11 09:30:00' as date)) FROM t;
0188
0189 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as tinyint)) FROM t;
0190 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as smallint)) FROM t;
0191 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as int)) FROM t;
0192 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as bigint)) FROM t;
0193 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as float)) FROM t;
0194 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as double)) FROM t;
0195 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as decimal(10, 0))) FROM t;
0196 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as string)) FROM t;
0197 SELECT cast(1 as smallint) in (cast(1 as smallint), cast('1' as binary)) FROM t;
0198 SELECT cast(1 as smallint) in (cast(1 as smallint), cast(1 as boolean)) FROM t;
0199 SELECT cast(1 as smallint) in (cast(1 as smallint), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0200 SELECT cast(1 as smallint) in (cast(1 as smallint), cast('2017-12-11 09:30:00' as date)) FROM t;
0201
0202 SELECT cast(1 as int) in (cast(1 as int), cast(1 as tinyint)) FROM t;
0203 SELECT cast(1 as int) in (cast(1 as int), cast(1 as smallint)) FROM t;
0204 SELECT cast(1 as int) in (cast(1 as int), cast(1 as int)) FROM t;
0205 SELECT cast(1 as int) in (cast(1 as int), cast(1 as bigint)) FROM t;
0206 SELECT cast(1 as int) in (cast(1 as int), cast(1 as float)) FROM t;
0207 SELECT cast(1 as int) in (cast(1 as int), cast(1 as double)) FROM t;
0208 SELECT cast(1 as int) in (cast(1 as int), cast(1 as decimal(10, 0))) FROM t;
0209 SELECT cast(1 as int) in (cast(1 as int), cast(1 as string)) FROM t;
0210 SELECT cast(1 as int) in (cast(1 as int), cast('1' as binary)) FROM t;
0211 SELECT cast(1 as int) in (cast(1 as int), cast(1 as boolean)) FROM t;
0212 SELECT cast(1 as int) in (cast(1 as int), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0213 SELECT cast(1 as int) in (cast(1 as int), cast('2017-12-11 09:30:00' as date)) FROM t;
0214
0215 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as tinyint)) FROM t;
0216 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as smallint)) FROM t;
0217 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as int)) FROM t;
0218 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as bigint)) FROM t;
0219 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as float)) FROM t;
0220 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as double)) FROM t;
0221 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as decimal(10, 0))) FROM t;
0222 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as string)) FROM t;
0223 SELECT cast(1 as bigint) in (cast(1 as bigint), cast('1' as binary)) FROM t;
0224 SELECT cast(1 as bigint) in (cast(1 as bigint), cast(1 as boolean)) FROM t;
0225 SELECT cast(1 as bigint) in (cast(1 as bigint), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0226 SELECT cast(1 as bigint) in (cast(1 as bigint), cast('2017-12-11 09:30:00' as date)) FROM t;
0227
0228 SELECT cast(1 as float) in (cast(1 as float), cast(1 as tinyint)) FROM t;
0229 SELECT cast(1 as float) in (cast(1 as float), cast(1 as smallint)) FROM t;
0230 SELECT cast(1 as float) in (cast(1 as float), cast(1 as int)) FROM t;
0231 SELECT cast(1 as float) in (cast(1 as float), cast(1 as bigint)) FROM t;
0232 SELECT cast(1 as float) in (cast(1 as float), cast(1 as float)) FROM t;
0233 SELECT cast(1 as float) in (cast(1 as float), cast(1 as double)) FROM t;
0234 SELECT cast(1 as float) in (cast(1 as float), cast(1 as decimal(10, 0))) FROM t;
0235 SELECT cast(1 as float) in (cast(1 as float), cast(1 as string)) FROM t;
0236 SELECT cast(1 as float) in (cast(1 as float), cast('1' as binary)) FROM t;
0237 SELECT cast(1 as float) in (cast(1 as float), cast(1 as boolean)) FROM t;
0238 SELECT cast(1 as float) in (cast(1 as float), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0239 SELECT cast(1 as float) in (cast(1 as float), cast('2017-12-11 09:30:00' as date)) FROM t;
0240
0241 SELECT cast(1 as double) in (cast(1 as double), cast(1 as tinyint)) FROM t;
0242 SELECT cast(1 as double) in (cast(1 as double), cast(1 as smallint)) FROM t;
0243 SELECT cast(1 as double) in (cast(1 as double), cast(1 as int)) FROM t;
0244 SELECT cast(1 as double) in (cast(1 as double), cast(1 as bigint)) FROM t;
0245 SELECT cast(1 as double) in (cast(1 as double), cast(1 as float)) FROM t;
0246 SELECT cast(1 as double) in (cast(1 as double), cast(1 as double)) FROM t;
0247 SELECT cast(1 as double) in (cast(1 as double), cast(1 as decimal(10, 0))) FROM t;
0248 SELECT cast(1 as double) in (cast(1 as double), cast(1 as string)) FROM t;
0249 SELECT cast(1 as double) in (cast(1 as double), cast('1' as binary)) FROM t;
0250 SELECT cast(1 as double) in (cast(1 as double), cast(1 as boolean)) FROM t;
0251 SELECT cast(1 as double) in (cast(1 as double), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0252 SELECT cast(1 as double) in (cast(1 as double), cast('2017-12-11 09:30:00' as date)) FROM t;
0253
0254 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as tinyint)) FROM t;
0255 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as smallint)) FROM t;
0256 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as int)) FROM t;
0257 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as bigint)) FROM t;
0258 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as float)) FROM t;
0259 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as double)) FROM t;
0260 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as decimal(10, 0))) FROM t;
0261 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as string)) FROM t;
0262 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast('1' as binary)) FROM t;
0263 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast(1 as boolean)) FROM t;
0264 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0265 SELECT cast(1 as decimal(10, 0)) in (cast(1 as decimal(10, 0)), cast('2017-12-11 09:30:00' as date)) FROM t;
0266
0267 SELECT cast(1 as string) in (cast(1 as string), cast(1 as tinyint)) FROM t;
0268 SELECT cast(1 as string) in (cast(1 as string), cast(1 as smallint)) FROM t;
0269 SELECT cast(1 as string) in (cast(1 as string), cast(1 as int)) FROM t;
0270 SELECT cast(1 as string) in (cast(1 as string), cast(1 as bigint)) FROM t;
0271 SELECT cast(1 as string) in (cast(1 as string), cast(1 as float)) FROM t;
0272 SELECT cast(1 as string) in (cast(1 as string), cast(1 as double)) FROM t;
0273 SELECT cast(1 as string) in (cast(1 as string), cast(1 as decimal(10, 0))) FROM t;
0274 SELECT cast(1 as string) in (cast(1 as string), cast(1 as string)) FROM t;
0275 SELECT cast(1 as string) in (cast(1 as string), cast('1' as binary)) FROM t;
0276 SELECT cast(1 as string) in (cast(1 as string), cast(1 as boolean)) FROM t;
0277 SELECT cast(1 as string) in (cast(1 as string), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0278 SELECT cast(1 as string) in (cast(1 as string), cast('2017-12-11 09:30:00' as date)) FROM t;
0279
0280 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as tinyint)) FROM t;
0281 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as smallint)) FROM t;
0282 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as int)) FROM t;
0283 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as bigint)) FROM t;
0284 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as float)) FROM t;
0285 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as double)) FROM t;
0286 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as decimal(10, 0))) FROM t;
0287 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as string)) FROM t;
0288 SELECT cast('1' as binary) in (cast('1' as binary), cast('1' as binary)) FROM t;
0289 SELECT cast('1' as binary) in (cast('1' as binary), cast(1 as boolean)) FROM t;
0290 SELECT cast('1' as binary) in (cast('1' as binary), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0291 SELECT cast('1' as binary) in (cast('1' as binary), cast('2017-12-11 09:30:00' as date)) FROM t;
0292
0293 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as tinyint)) FROM t;
0294 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as smallint)) FROM t;
0295 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as int)) FROM t;
0296 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as bigint)) FROM t;
0297 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as float)) FROM t;
0298 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as double)) FROM t;
0299 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as decimal(10, 0))) FROM t;
0300 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as string)) FROM t;
0301 SELECT cast('1' as boolean) in (cast('1' as boolean), cast('1' as binary)) FROM t;
0302 SELECT cast('1' as boolean) in (cast('1' as boolean), cast(1 as boolean)) FROM t;
0303 SELECT cast('1' as boolean) in (cast('1' as boolean), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0304 SELECT cast('1' as boolean) in (cast('1' as boolean), cast('2017-12-11 09:30:00' as date)) FROM t;
0305
0306 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as tinyint)) FROM t;
0307 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as smallint)) FROM t;
0308 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as int)) FROM t;
0309 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as bigint)) FROM t;
0310 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as float)) FROM t;
0311 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as double)) FROM t;
0312 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as decimal(10, 0))) FROM t;
0313 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as string)) FROM t;
0314 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast('1' as binary)) FROM t;
0315 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast(1 as boolean)) FROM t;
0316 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0317 SELECT cast('2017-12-12 09:30:00.0' as timestamp) in (cast('2017-12-12 09:30:00.0' as timestamp), cast('2017-12-11 09:30:00' as date)) FROM t;
0318
0319 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as tinyint)) FROM t;
0320 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as smallint)) FROM t;
0321 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as int)) FROM t;
0322 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as bigint)) FROM t;
0323 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as float)) FROM t;
0324 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as double)) FROM t;
0325 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as decimal(10, 0))) FROM t;
0326 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as string)) FROM t;
0327 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast('1' as binary)) FROM t;
0328 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast(1 as boolean)) FROM t;
0329 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0330 SELECT cast('2017-12-12 09:30:00' as date) in (cast('2017-12-12 09:30:00' as date), cast('2017-12-11 09:30:00' as date)) FROM t;