typeCoercion/native/ifCoercion.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 IF(true, cast(1 as tinyint), cast(2 as tinyint)) FROM t;
0021 SELECT IF(true, cast(1 as tinyint), cast(2 as smallint)) FROM t;
0022 SELECT IF(true, cast(1 as tinyint), cast(2 as int)) FROM t;
0023 SELECT IF(true, cast(1 as tinyint), cast(2 as bigint)) FROM t;
0024 SELECT IF(true, cast(1 as tinyint), cast(2 as float)) FROM t;
0025 SELECT IF(true, cast(1 as tinyint), cast(2 as double)) FROM t;
0026 SELECT IF(true, cast(1 as tinyint), cast(2 as decimal(10, 0))) FROM t;
0027 SELECT IF(true, cast(1 as tinyint), cast(2 as string)) FROM t;
0028 SELECT IF(true, cast(1 as tinyint), cast('2' as binary)) FROM t;
0029 SELECT IF(true, cast(1 as tinyint), cast(2 as boolean)) FROM t;
0030 SELECT IF(true, cast(1 as tinyint), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0031 SELECT IF(true, cast(1 as tinyint), cast('2017-12-11 09:30:00' as date)) FROM t;
0032
0033 SELECT IF(true, cast(1 as smallint), cast(2 as tinyint)) FROM t;
0034 SELECT IF(true, cast(1 as smallint), cast(2 as smallint)) FROM t;
0035 SELECT IF(true, cast(1 as smallint), cast(2 as int)) FROM t;
0036 SELECT IF(true, cast(1 as smallint), cast(2 as bigint)) FROM t;
0037 SELECT IF(true, cast(1 as smallint), cast(2 as float)) FROM t;
0038 SELECT IF(true, cast(1 as smallint), cast(2 as double)) FROM t;
0039 SELECT IF(true, cast(1 as smallint), cast(2 as decimal(10, 0))) FROM t;
0040 SELECT IF(true, cast(1 as smallint), cast(2 as string)) FROM t;
0041 SELECT IF(true, cast(1 as smallint), cast('2' as binary)) FROM t;
0042 SELECT IF(true, cast(1 as smallint), cast(2 as boolean)) FROM t;
0043 SELECT IF(true, cast(1 as smallint), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0044 SELECT IF(true, cast(1 as smallint), cast('2017-12-11 09:30:00' as date)) FROM t;
0045
0046 SELECT IF(true, cast(1 as int), cast(2 as tinyint)) FROM t;
0047 SELECT IF(true, cast(1 as int), cast(2 as smallint)) FROM t;
0048 SELECT IF(true, cast(1 as int), cast(2 as int)) FROM t;
0049 SELECT IF(true, cast(1 as int), cast(2 as bigint)) FROM t;
0050 SELECT IF(true, cast(1 as int), cast(2 as float)) FROM t;
0051 SELECT IF(true, cast(1 as int), cast(2 as double)) FROM t;
0052 SELECT IF(true, cast(1 as int), cast(2 as decimal(10, 0))) FROM t;
0053 SELECT IF(true, cast(1 as int), cast(2 as string)) FROM t;
0054 SELECT IF(true, cast(1 as int), cast('2' as binary)) FROM t;
0055 SELECT IF(true, cast(1 as int), cast(2 as boolean)) FROM t;
0056 SELECT IF(true, cast(1 as int), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0057 SELECT IF(true, cast(1 as int), cast('2017-12-11 09:30:00' as date)) FROM t;
0058
0059 SELECT IF(true, cast(1 as bigint), cast(2 as tinyint)) FROM t;
0060 SELECT IF(true, cast(1 as bigint), cast(2 as smallint)) FROM t;
0061 SELECT IF(true, cast(1 as bigint), cast(2 as int)) FROM t;
0062 SELECT IF(true, cast(1 as bigint), cast(2 as bigint)) FROM t;
0063 SELECT IF(true, cast(1 as bigint), cast(2 as float)) FROM t;
0064 SELECT IF(true, cast(1 as bigint), cast(2 as double)) FROM t;
0065 SELECT IF(true, cast(1 as bigint), cast(2 as decimal(10, 0))) FROM t;
0066 SELECT IF(true, cast(1 as bigint), cast(2 as string)) FROM t;
0067 SELECT IF(true, cast(1 as bigint), cast('2' as binary)) FROM t;
0068 SELECT IF(true, cast(1 as bigint), cast(2 as boolean)) FROM t;
0069 SELECT IF(true, cast(1 as bigint), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0070 SELECT IF(true, cast(1 as bigint), cast('2017-12-11 09:30:00' as date)) FROM t;
0071
0072 SELECT IF(true, cast(1 as float), cast(2 as tinyint)) FROM t;
0073 SELECT IF(true, cast(1 as float), cast(2 as smallint)) FROM t;
0074 SELECT IF(true, cast(1 as float), cast(2 as int)) FROM t;
0075 SELECT IF(true, cast(1 as float), cast(2 as bigint)) FROM t;
0076 SELECT IF(true, cast(1 as float), cast(2 as float)) FROM t;
0077 SELECT IF(true, cast(1 as float), cast(2 as double)) FROM t;
0078 SELECT IF(true, cast(1 as float), cast(2 as decimal(10, 0))) FROM t;
0079 SELECT IF(true, cast(1 as float), cast(2 as string)) FROM t;
0080 SELECT IF(true, cast(1 as float), cast('2' as binary)) FROM t;
0081 SELECT IF(true, cast(1 as float), cast(2 as boolean)) FROM t;
0082 SELECT IF(true, cast(1 as float), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0083 SELECT IF(true, cast(1 as float), cast('2017-12-11 09:30:00' as date)) FROM t;
0084
0085 SELECT IF(true, cast(1 as double), cast(2 as tinyint)) FROM t;
0086 SELECT IF(true, cast(1 as double), cast(2 as smallint)) FROM t;
0087 SELECT IF(true, cast(1 as double), cast(2 as int)) FROM t;
0088 SELECT IF(true, cast(1 as double), cast(2 as bigint)) FROM t;
0089 SELECT IF(true, cast(1 as double), cast(2 as float)) FROM t;
0090 SELECT IF(true, cast(1 as double), cast(2 as double)) FROM t;
0091 SELECT IF(true, cast(1 as double), cast(2 as decimal(10, 0))) FROM t;
0092 SELECT IF(true, cast(1 as double), cast(2 as string)) FROM t;
0093 SELECT IF(true, cast(1 as double), cast('2' as binary)) FROM t;
0094 SELECT IF(true, cast(1 as double), cast(2 as boolean)) FROM t;
0095 SELECT IF(true, cast(1 as double), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0096 SELECT IF(true, cast(1 as double), cast('2017-12-11 09:30:00' as date)) FROM t;
0097
0098 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as tinyint)) FROM t;
0099 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as smallint)) FROM t;
0100 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as int)) FROM t;
0101 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as bigint)) FROM t;
0102 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as float)) FROM t;
0103 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as double)) FROM t;
0104 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as decimal(10, 0))) FROM t;
0105 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as string)) FROM t;
0106 SELECT IF(true, cast(1 as decimal(10, 0)), cast('2' as binary)) FROM t;
0107 SELECT IF(true, cast(1 as decimal(10, 0)), cast(2 as boolean)) FROM t;
0108 SELECT IF(true, cast(1 as decimal(10, 0)), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0109 SELECT IF(true, cast(1 as decimal(10, 0)), cast('2017-12-11 09:30:00' as date)) FROM t;
0110
0111 SELECT IF(true, cast(1 as string), cast(2 as tinyint)) FROM t;
0112 SELECT IF(true, cast(1 as string), cast(2 as smallint)) FROM t;
0113 SELECT IF(true, cast(1 as string), cast(2 as int)) FROM t;
0114 SELECT IF(true, cast(1 as string), cast(2 as bigint)) FROM t;
0115 SELECT IF(true, cast(1 as string), cast(2 as float)) FROM t;
0116 SELECT IF(true, cast(1 as string), cast(2 as double)) FROM t;
0117 SELECT IF(true, cast(1 as string), cast(2 as decimal(10, 0))) FROM t;
0118 SELECT IF(true, cast(1 as string), cast(2 as string)) FROM t;
0119 SELECT IF(true, cast(1 as string), cast('2' as binary)) FROM t;
0120 SELECT IF(true, cast(1 as string), cast(2 as boolean)) FROM t;
0121 SELECT IF(true, cast(1 as string), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0122 SELECT IF(true, cast(1 as string), cast('2017-12-11 09:30:00' as date)) FROM t;
0123
0124 SELECT IF(true, cast('1' as binary), cast(2 as tinyint)) FROM t;
0125 SELECT IF(true, cast('1' as binary), cast(2 as smallint)) FROM t;
0126 SELECT IF(true, cast('1' as binary), cast(2 as int)) FROM t;
0127 SELECT IF(true, cast('1' as binary), cast(2 as bigint)) FROM t;
0128 SELECT IF(true, cast('1' as binary), cast(2 as float)) FROM t;
0129 SELECT IF(true, cast('1' as binary), cast(2 as double)) FROM t;
0130 SELECT IF(true, cast('1' as binary), cast(2 as decimal(10, 0))) FROM t;
0131 SELECT IF(true, cast('1' as binary), cast(2 as string)) FROM t;
0132 SELECT IF(true, cast('1' as binary), cast('2' as binary)) FROM t;
0133 SELECT IF(true, cast('1' as binary), cast(2 as boolean)) FROM t;
0134 SELECT IF(true, cast('1' as binary), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0135 SELECT IF(true, cast('1' as binary), cast('2017-12-11 09:30:00' as date)) FROM t;
0136
0137 SELECT IF(true, cast(1 as boolean), cast(2 as tinyint)) FROM t;
0138 SELECT IF(true, cast(1 as boolean), cast(2 as smallint)) FROM t;
0139 SELECT IF(true, cast(1 as boolean), cast(2 as int)) FROM t;
0140 SELECT IF(true, cast(1 as boolean), cast(2 as bigint)) FROM t;
0141 SELECT IF(true, cast(1 as boolean), cast(2 as float)) FROM t;
0142 SELECT IF(true, cast(1 as boolean), cast(2 as double)) FROM t;
0143 SELECT IF(true, cast(1 as boolean), cast(2 as decimal(10, 0))) FROM t;
0144 SELECT IF(true, cast(1 as boolean), cast(2 as string)) FROM t;
0145 SELECT IF(true, cast(1 as boolean), cast('2' as binary)) FROM t;
0146 SELECT IF(true, cast(1 as boolean), cast(2 as boolean)) FROM t;
0147 SELECT IF(true, cast(1 as boolean), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0148 SELECT IF(true, cast(1 as boolean), cast('2017-12-11 09:30:00' as date)) FROM t;
0149
0150 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as tinyint)) FROM t;
0151 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as smallint)) FROM t;
0152 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as int)) FROM t;
0153 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as bigint)) FROM t;
0154 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as float)) FROM t;
0155 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as double)) FROM t;
0156 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as decimal(10, 0))) FROM t;
0157 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as string)) FROM t;
0158 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast('2' as binary)) FROM t;
0159 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast(2 as boolean)) FROM t;
0160 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0161 SELECT IF(true, cast('2017-12-12 09:30:00.0' as timestamp), cast('2017-12-11 09:30:00' as date)) FROM t;
0162
0163 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as tinyint)) FROM t;
0164 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as smallint)) FROM t;
0165 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as int)) FROM t;
0166 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as bigint)) FROM t;
0167 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as float)) FROM t;
0168 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as double)) FROM t;
0169 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as decimal(10, 0))) FROM t;
0170 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as string)) FROM t;
0171 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast('2' as binary)) FROM t;
0172 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast(2 as boolean)) FROM t;
0173 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0174 SELECT IF(true, cast('2017-12-12 09:30:00' as date), cast('2017-12-11 09:30:00' as date)) FROM t;