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