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