typeCoercion/native/decimalPrecision.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 decimal(3, 0)) FROM t;
0021 SELECT cast(1 as tinyint) + cast(1 as decimal(5, 0)) FROM t;
0022 SELECT cast(1 as tinyint) + cast(1 as decimal(10, 0)) FROM t;
0023 SELECT cast(1 as tinyint) + cast(1 as decimal(20, 0)) FROM t;
0024
0025 SELECT cast(1 as smallint) + cast(1 as decimal(3, 0)) FROM t;
0026 SELECT cast(1 as smallint) + cast(1 as decimal(5, 0)) FROM t;
0027 SELECT cast(1 as smallint) + cast(1 as decimal(10, 0)) FROM t;
0028 SELECT cast(1 as smallint) + cast(1 as decimal(20, 0)) FROM t;
0029
0030 SELECT cast(1 as int) + cast(1 as decimal(3, 0)) FROM t;
0031 SELECT cast(1 as int) + cast(1 as decimal(5, 0)) FROM t;
0032 SELECT cast(1 as int) + cast(1 as decimal(10, 0)) FROM t;
0033 SELECT cast(1 as int) + cast(1 as decimal(20, 0)) FROM t;
0034
0035 SELECT cast(1 as bigint) + cast(1 as decimal(3, 0)) FROM t;
0036 SELECT cast(1 as bigint) + cast(1 as decimal(5, 0)) FROM t;
0037 SELECT cast(1 as bigint) + cast(1 as decimal(10, 0)) FROM t;
0038 SELECT cast(1 as bigint) + cast(1 as decimal(20, 0)) FROM t;
0039
0040 SELECT cast(1 as float) + cast(1 as decimal(3, 0)) FROM t;
0041 SELECT cast(1 as float) + cast(1 as decimal(5, 0)) FROM t;
0042 SELECT cast(1 as float) + cast(1 as decimal(10, 0)) FROM t;
0043 SELECT cast(1 as float) + cast(1 as decimal(20, 0)) FROM t;
0044
0045 SELECT cast(1 as double) + cast(1 as decimal(3, 0)) FROM t;
0046 SELECT cast(1 as double) + cast(1 as decimal(5, 0)) FROM t;
0047 SELECT cast(1 as double) + cast(1 as decimal(10, 0)) FROM t;
0048 SELECT cast(1 as double) + cast(1 as decimal(20, 0)) FROM t;
0049
0050 SELECT cast(1 as decimal(10, 0)) + cast(1 as decimal(3, 0)) FROM t;
0051 SELECT cast(1 as decimal(10, 0)) + cast(1 as decimal(5, 0)) FROM t;
0052 SELECT cast(1 as decimal(10, 0)) + cast(1 as decimal(10, 0)) FROM t;
0053 SELECT cast(1 as decimal(10, 0)) + cast(1 as decimal(20, 0)) FROM t;
0054
0055 SELECT cast('1' as binary) + cast(1 as decimal(3, 0)) FROM t;
0056 SELECT cast('1' as binary) + cast(1 as decimal(5, 0)) FROM t;
0057 SELECT cast('1' as binary) + cast(1 as decimal(10, 0)) FROM t;
0058 SELECT cast('1' as binary) + cast(1 as decimal(20, 0)) FROM t;
0059
0060 SELECT cast('2017-12-11 09:30:00.0' as timestamp) + cast(1 as decimal(3, 0)) FROM t;
0061 SELECT cast('2017-12-11 09:30:00.0' as timestamp) + cast(1 as decimal(5, 0)) FROM t;
0062 SELECT cast('2017-12-11 09:30:00.0' as timestamp) + cast(1 as decimal(10, 0)) FROM t;
0063 SELECT cast('2017-12-11 09:30:00.0' as timestamp) + cast(1 as decimal(20, 0)) FROM t;
0064
0065 SELECT cast('2017-12-11 09:30:00' as date) + cast(1 as decimal(3, 0)) FROM t;
0066 SELECT cast('2017-12-11 09:30:00' as date) + cast(1 as decimal(5, 0)) FROM t;
0067 SELECT cast('2017-12-11 09:30:00' as date) + cast(1 as decimal(10, 0)) FROM t;
0068 SELECT cast('2017-12-11 09:30:00' as date) + cast(1 as decimal(20, 0)) FROM t;
0069
0070 SELECT cast(1 as decimal(3, 0))  + cast(1 as tinyint) FROM t;
0071 SELECT cast(1 as decimal(5, 0))  + cast(1 as tinyint) FROM t;
0072 SELECT cast(1 as decimal(10, 0)) + cast(1 as tinyint) FROM t;
0073 SELECT cast(1 as decimal(20, 0)) + cast(1 as tinyint) FROM t;
0074
0075 SELECT cast(1 as decimal(3, 0))  + cast(1 as smallint) FROM t;
0076 SELECT cast(1 as decimal(5, 0))  + cast(1 as smallint) FROM t;
0077 SELECT cast(1 as decimal(10, 0)) + cast(1 as smallint) FROM t;
0078 SELECT cast(1 as decimal(20, 0)) + cast(1 as smallint) FROM t;
0079
0080 SELECT cast(1 as decimal(3, 0))  + cast(1 as int) FROM t;
0081 SELECT cast(1 as decimal(5, 0))  + cast(1 as int) FROM t;
0082 SELECT cast(1 as decimal(10, 0)) + cast(1 as int) FROM t;
0083 SELECT cast(1 as decimal(20, 0)) + cast(1 as int) FROM t;
0084
0085 SELECT cast(1 as decimal(3, 0))  + cast(1 as bigint) FROM t;
0086 SELECT cast(1 as decimal(5, 0))  + cast(1 as bigint) FROM t;
0087 SELECT cast(1 as decimal(10, 0)) + cast(1 as bigint) FROM t;
0088 SELECT cast(1 as decimal(20, 0)) + cast(1 as bigint) FROM t;
0089
0090 SELECT cast(1 as decimal(3, 0))  + cast(1 as float) FROM t;
0091 SELECT cast(1 as decimal(5, 0))  + cast(1 as float) FROM t;
0092 SELECT cast(1 as decimal(10, 0)) + cast(1 as float) FROM t;
0093 SELECT cast(1 as decimal(20, 0)) + cast(1 as float) FROM t;
0094
0095 SELECT cast(1 as decimal(3, 0))  + cast(1 as double) FROM t;
0096 SELECT cast(1 as decimal(5, 0))  + cast(1 as double) FROM t;
0097 SELECT cast(1 as decimal(10, 0)) + cast(1 as double) FROM t;
0098 SELECT cast(1 as decimal(20, 0)) + cast(1 as double) FROM t;
0099
0100 SELECT cast(1 as decimal(3, 0))  + cast(1 as decimal(10, 0)) FROM t;
0101 SELECT cast(1 as decimal(5, 0))  + cast(1 as decimal(10, 0)) FROM t;
0102 SELECT cast(1 as decimal(10, 0)) + cast(1 as decimal(10, 0)) FROM t;
0103 SELECT cast(1 as decimal(20, 0)) + cast(1 as decimal(10, 0)) FROM t;
0104
0105 SELECT cast(1 as decimal(3, 0))  + cast(1 as string) FROM t;
0106 SELECT cast(1 as decimal(5, 0))  + cast(1 as string) FROM t;
0107 SELECT cast(1 as decimal(10, 0)) + cast(1 as string) FROM t;
0108 SELECT cast(1 as decimal(20, 0)) + cast(1 as string) FROM t;
0109
0110 SELECT cast(1 as decimal(3, 0))  + cast('1' as binary) FROM t;
0111 SELECT cast(1 as decimal(5, 0))  + cast('1' as binary) FROM t;
0112 SELECT cast(1 as decimal(10, 0)) + cast('1' as binary) FROM t;
0113 SELECT cast(1 as decimal(20, 0)) + cast('1' as binary) FROM t;
0114
0115 SELECT cast(1 as decimal(3, 0))  + cast(1 as boolean) FROM t;
0116 SELECT cast(1 as decimal(5, 0))  + cast(1 as boolean) FROM t;
0117 SELECT cast(1 as decimal(10, 0)) + cast(1 as boolean) FROM t;
0118 SELECT cast(1 as decimal(20, 0)) + cast(1 as boolean) FROM t;
0119
0120 SELECT cast(1 as decimal(3, 0))  + cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0121 SELECT cast(1 as decimal(5, 0))  + cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0122 SELECT cast(1 as decimal(10, 0)) + cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0123 SELECT cast(1 as decimal(20, 0)) + cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0124
0125 SELECT cast(1 as decimal(3, 0))  + cast('2017-12-11 09:30:00' as date) FROM t;
0126 SELECT cast(1 as decimal(5, 0))  + cast('2017-12-11 09:30:00' as date) FROM t;
0127 SELECT cast(1 as decimal(10, 0)) + cast('2017-12-11 09:30:00' as date) FROM t;
0128 SELECT cast(1 as decimal(20, 0)) + cast('2017-12-11 09:30:00' as date) FROM t;
0129
0130 SELECT cast(1 as tinyint) - cast(1 as decimal(3, 0)) FROM t;
0131 SELECT cast(1 as tinyint) - cast(1 as decimal(5, 0)) FROM t;
0132 SELECT cast(1 as tinyint) - cast(1 as decimal(10, 0)) FROM t;
0133 SELECT cast(1 as tinyint) - cast(1 as decimal(20, 0)) FROM t;
0134
0135 SELECT cast(1 as smallint) - cast(1 as decimal(3, 0)) FROM t;
0136 SELECT cast(1 as smallint) - cast(1 as decimal(5, 0)) FROM t;
0137 SELECT cast(1 as smallint) - cast(1 as decimal(10, 0)) FROM t;
0138 SELECT cast(1 as smallint) - cast(1 as decimal(20, 0)) FROM t;
0139
0140 SELECT cast(1 as int) - cast(1 as decimal(3, 0)) FROM t;
0141 SELECT cast(1 as int) - cast(1 as decimal(5, 0)) FROM t;
0142 SELECT cast(1 as int) - cast(1 as decimal(10, 0)) FROM t;
0143 SELECT cast(1 as int) - cast(1 as decimal(20, 0)) FROM t;
0144
0145 SELECT cast(1 as bigint) - cast(1 as decimal(3, 0)) FROM t;
0146 SELECT cast(1 as bigint) - cast(1 as decimal(5, 0)) FROM t;
0147 SELECT cast(1 as bigint) - cast(1 as decimal(10, 0)) FROM t;
0148 SELECT cast(1 as bigint) - cast(1 as decimal(20, 0)) FROM t;
0149
0150 SELECT cast(1 as float) - cast(1 as decimal(3, 0)) FROM t;
0151 SELECT cast(1 as float) - cast(1 as decimal(5, 0)) FROM t;
0152 SELECT cast(1 as float) - cast(1 as decimal(10, 0)) FROM t;
0153 SELECT cast(1 as float) - cast(1 as decimal(20, 0)) FROM t;
0154
0155 SELECT cast(1 as double) - cast(1 as decimal(3, 0)) FROM t;
0156 SELECT cast(1 as double) - cast(1 as decimal(5, 0)) FROM t;
0157 SELECT cast(1 as double) - cast(1 as decimal(10, 0)) FROM t;
0158 SELECT cast(1 as double) - cast(1 as decimal(20, 0)) FROM t;
0159
0160 SELECT cast(1 as decimal(10, 0)) - cast(1 as decimal(3, 0)) FROM t;
0161 SELECT cast(1 as decimal(10, 0)) - cast(1 as decimal(5, 0)) FROM t;
0162 SELECT cast(1 as decimal(10, 0)) - cast(1 as decimal(10, 0)) FROM t;
0163 SELECT cast(1 as decimal(10, 0)) - cast(1 as decimal(20, 0)) FROM t;
0164
0165 SELECT cast('1' as binary) - cast(1 as decimal(3, 0)) FROM t;
0166 SELECT cast('1' as binary) - cast(1 as decimal(5, 0)) FROM t;
0167 SELECT cast('1' as binary) - cast(1 as decimal(10, 0)) FROM t;
0168 SELECT cast('1' as binary) - cast(1 as decimal(20, 0)) FROM t;
0169
0170 SELECT cast('2017-12-11 09:30:00.0' as timestamp) - cast(1 as decimal(3, 0)) FROM t;
0171 SELECT cast('2017-12-11 09:30:00.0' as timestamp) - cast(1 as decimal(5, 0)) FROM t;
0172 SELECT cast('2017-12-11 09:30:00.0' as timestamp) - cast(1 as decimal(10, 0)) FROM t;
0173 SELECT cast('2017-12-11 09:30:00.0' as timestamp) - cast(1 as decimal(20, 0)) FROM t;
0174
0175 SELECT cast('2017-12-11 09:30:00' as date) - cast(1 as decimal(3, 0)) FROM t;
0176 SELECT cast('2017-12-11 09:30:00' as date) - cast(1 as decimal(5, 0)) FROM t;
0177 SELECT cast('2017-12-11 09:30:00' as date) - cast(1 as decimal(10, 0)) FROM t;
0178 SELECT cast('2017-12-11 09:30:00' as date) - cast(1 as decimal(20, 0)) FROM t;
0179
0180 SELECT cast(1 as decimal(3, 0))  - cast(1 as tinyint) FROM t;
0181 SELECT cast(1 as decimal(5, 0))  - cast(1 as tinyint) FROM t;
0182 SELECT cast(1 as decimal(10, 0)) - cast(1 as tinyint) FROM t;
0183 SELECT cast(1 as decimal(20, 0)) - cast(1 as tinyint) FROM t;
0184
0185 SELECT cast(1 as decimal(3, 0))  - cast(1 as smallint) FROM t;
0186 SELECT cast(1 as decimal(5, 0))  - cast(1 as smallint) FROM t;
0187 SELECT cast(1 as decimal(10, 0)) - cast(1 as smallint) FROM t;
0188 SELECT cast(1 as decimal(20, 0)) - cast(1 as smallint) FROM t;
0189
0190 SELECT cast(1 as decimal(3, 0))  - cast(1 as int) FROM t;
0191 SELECT cast(1 as decimal(5, 0))  - cast(1 as int) FROM t;
0192 SELECT cast(1 as decimal(10, 0)) - cast(1 as int) FROM t;
0193 SELECT cast(1 as decimal(20, 0)) - cast(1 as int) FROM t;
0194
0195 SELECT cast(1 as decimal(3, 0))  - cast(1 as bigint) FROM t;
0196 SELECT cast(1 as decimal(5, 0))  - cast(1 as bigint) FROM t;
0197 SELECT cast(1 as decimal(10, 0)) - cast(1 as bigint) FROM t;
0198 SELECT cast(1 as decimal(20, 0)) - cast(1 as bigint) FROM t;
0199
0200 SELECT cast(1 as decimal(3, 0))  - cast(1 as float) FROM t;
0201 SELECT cast(1 as decimal(5, 0))  - cast(1 as float) FROM t;
0202 SELECT cast(1 as decimal(10, 0)) - cast(1 as float) FROM t;
0203 SELECT cast(1 as decimal(20, 0)) - cast(1 as float) FROM t;
0204
0205 SELECT cast(1 as decimal(3, 0))  - cast(1 as double) FROM t;
0206 SELECT cast(1 as decimal(5, 0))  - cast(1 as double) FROM t;
0207 SELECT cast(1 as decimal(10, 0)) - cast(1 as double) FROM t;
0208 SELECT cast(1 as decimal(20, 0)) - cast(1 as double) FROM t;
0209
0210 SELECT cast(1 as decimal(3, 0))  - cast(1 as decimal(10, 0)) FROM t;
0211 SELECT cast(1 as decimal(5, 0))  - cast(1 as decimal(10, 0)) FROM t;
0212 SELECT cast(1 as decimal(10, 0)) - cast(1 as decimal(10, 0)) FROM t;
0213 SELECT cast(1 as decimal(20, 0)) - cast(1 as decimal(10, 0)) FROM t;
0214
0215 SELECT cast(1 as decimal(3, 0))  - cast(1 as string) FROM t;
0216 SELECT cast(1 as decimal(5, 0))  - cast(1 as string) FROM t;
0217 SELECT cast(1 as decimal(10, 0)) - cast(1 as string) FROM t;
0218 SELECT cast(1 as decimal(20, 0)) - cast(1 as string) FROM t;
0219
0220 SELECT cast(1 as decimal(3, 0))  - cast('1' as binary) FROM t;
0221 SELECT cast(1 as decimal(5, 0))  - cast('1' as binary) FROM t;
0222 SELECT cast(1 as decimal(10, 0)) - cast('1' as binary) FROM t;
0223 SELECT cast(1 as decimal(20, 0)) - cast('1' as binary) FROM t;
0224
0225 SELECT cast(1 as decimal(3, 0))  - cast(1 as boolean) FROM t;
0226 SELECT cast(1 as decimal(5, 0))  - cast(1 as boolean) FROM t;
0227 SELECT cast(1 as decimal(10, 0)) - cast(1 as boolean) FROM t;
0228 SELECT cast(1 as decimal(20, 0)) - cast(1 as boolean) FROM t;
0229
0230 SELECT cast(1 as decimal(3, 0))  - cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0231 SELECT cast(1 as decimal(5, 0))  - cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0232 SELECT cast(1 as decimal(10, 0)) - cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0233 SELECT cast(1 as decimal(20, 0)) - cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0234
0235 SELECT cast(1 as decimal(3, 0))  - cast('2017-12-11 09:30:00' as date) FROM t;
0236 SELECT cast(1 as decimal(5, 0))  - cast('2017-12-11 09:30:00' as date) FROM t;
0237 SELECT cast(1 as decimal(10, 0)) - cast('2017-12-11 09:30:00' as date) FROM t;
0238 SELECT cast(1 as decimal(20, 0)) - cast('2017-12-11 09:30:00' as date) FROM t;
0239
0240 SELECT cast(1 as tinyint) * cast(1 as decimal(3, 0)) FROM t;
0241 SELECT cast(1 as tinyint) * cast(1 as decimal(5, 0)) FROM t;
0242 SELECT cast(1 as tinyint) * cast(1 as decimal(10, 0)) FROM t;
0243 SELECT cast(1 as tinyint) * cast(1 as decimal(20, 0)) FROM t;
0244
0245 SELECT cast(1 as smallint) * cast(1 as decimal(3, 0)) FROM t;
0246 SELECT cast(1 as smallint) * cast(1 as decimal(5, 0)) FROM t;
0247 SELECT cast(1 as smallint) * cast(1 as decimal(10, 0)) FROM t;
0248 SELECT cast(1 as smallint) * cast(1 as decimal(20, 0)) FROM t;
0249
0250 SELECT cast(1 as int) * cast(1 as decimal(3, 0)) FROM t;
0251 SELECT cast(1 as int) * cast(1 as decimal(5, 0)) FROM t;
0252 SELECT cast(1 as int) * cast(1 as decimal(10, 0)) FROM t;
0253 SELECT cast(1 as int) * cast(1 as decimal(20, 0)) FROM t;
0254
0255 SELECT cast(1 as bigint) * cast(1 as decimal(3, 0)) FROM t;
0256 SELECT cast(1 as bigint) * cast(1 as decimal(5, 0)) FROM t;
0257 SELECT cast(1 as bigint) * cast(1 as decimal(10, 0)) FROM t;
0258 SELECT cast(1 as bigint) * cast(1 as decimal(20, 0)) FROM t;
0259
0260 SELECT cast(1 as float) * cast(1 as decimal(3, 0)) FROM t;
0261 SELECT cast(1 as float) * cast(1 as decimal(5, 0)) FROM t;
0262 SELECT cast(1 as float) * cast(1 as decimal(10, 0)) FROM t;
0263 SELECT cast(1 as float) * cast(1 as decimal(20, 0)) FROM t;
0264
0265 SELECT cast(1 as double) * cast(1 as decimal(3, 0)) FROM t;
0266 SELECT cast(1 as double) * cast(1 as decimal(5, 0)) FROM t;
0267 SELECT cast(1 as double) * cast(1 as decimal(10, 0)) FROM t;
0268 SELECT cast(1 as double) * cast(1 as decimal(20, 0)) FROM t;
0269
0270 SELECT cast(1 as decimal(10, 0)) * cast(1 as decimal(3, 0)) FROM t;
0271 SELECT cast(1 as decimal(10, 0)) * cast(1 as decimal(5, 0)) FROM t;
0272 SELECT cast(1 as decimal(10, 0)) * cast(1 as decimal(10, 0)) FROM t;
0273 SELECT cast(1 as decimal(10, 0)) * cast(1 as decimal(20, 0)) FROM t;
0274
0275 SELECT cast('1' as binary) * cast(1 as decimal(3, 0)) FROM t;
0276 SELECT cast('1' as binary) * cast(1 as decimal(5, 0)) FROM t;
0277 SELECT cast('1' as binary) * cast(1 as decimal(10, 0)) FROM t;
0278 SELECT cast('1' as binary) * cast(1 as decimal(20, 0)) FROM t;
0279
0280 SELECT cast('2017*12*11 09:30:00.0' as timestamp) * cast(1 as decimal(3, 0)) FROM t;
0281 SELECT cast('2017*12*11 09:30:00.0' as timestamp) * cast(1 as decimal(5, 0)) FROM t;
0282 SELECT cast('2017*12*11 09:30:00.0' as timestamp) * cast(1 as decimal(10, 0)) FROM t;
0283 SELECT cast('2017*12*11 09:30:00.0' as timestamp) * cast(1 as decimal(20, 0)) FROM t;
0284
0285 SELECT cast('2017*12*11 09:30:00' as date) * cast(1 as decimal(3, 0)) FROM t;
0286 SELECT cast('2017*12*11 09:30:00' as date) * cast(1 as decimal(5, 0)) FROM t;
0287 SELECT cast('2017*12*11 09:30:00' as date) * cast(1 as decimal(10, 0)) FROM t;
0288 SELECT cast('2017*12*11 09:30:00' as date) * cast(1 as decimal(20, 0)) FROM t;
0289
0290 SELECT cast(1 as decimal(3, 0))  * cast(1 as tinyint) FROM t;
0291 SELECT cast(1 as decimal(5, 0))  * cast(1 as tinyint) FROM t;
0292 SELECT cast(1 as decimal(10, 0)) * cast(1 as tinyint) FROM t;
0293 SELECT cast(1 as decimal(20, 0)) * cast(1 as tinyint) FROM t;
0294
0295 SELECT cast(1 as decimal(3, 0))  * cast(1 as smallint) FROM t;
0296 SELECT cast(1 as decimal(5, 0))  * cast(1 as smallint) FROM t;
0297 SELECT cast(1 as decimal(10, 0)) * cast(1 as smallint) FROM t;
0298 SELECT cast(1 as decimal(20, 0)) * cast(1 as smallint) FROM t;
0299
0300 SELECT cast(1 as decimal(3, 0))  * cast(1 as int) FROM t;
0301 SELECT cast(1 as decimal(5, 0))  * cast(1 as int) FROM t;
0302 SELECT cast(1 as decimal(10, 0)) * cast(1 as int) FROM t;
0303 SELECT cast(1 as decimal(20, 0)) * cast(1 as int) FROM t;
0304
0305 SELECT cast(1 as decimal(3, 0))  * cast(1 as bigint) FROM t;
0306 SELECT cast(1 as decimal(5, 0))  * cast(1 as bigint) FROM t;
0307 SELECT cast(1 as decimal(10, 0)) * cast(1 as bigint) FROM t;
0308 SELECT cast(1 as decimal(20, 0)) * cast(1 as bigint) FROM t;
0309
0310 SELECT cast(1 as decimal(3, 0))  * cast(1 as float) FROM t;
0311 SELECT cast(1 as decimal(5, 0))  * cast(1 as float) FROM t;
0312 SELECT cast(1 as decimal(10, 0)) * cast(1 as float) FROM t;
0313 SELECT cast(1 as decimal(20, 0)) * cast(1 as float) FROM t;
0314
0315 SELECT cast(1 as decimal(3, 0))  * cast(1 as double) FROM t;
0316 SELECT cast(1 as decimal(5, 0))  * cast(1 as double) FROM t;
0317 SELECT cast(1 as decimal(10, 0)) * cast(1 as double) FROM t;
0318 SELECT cast(1 as decimal(20, 0)) * cast(1 as double) FROM t;
0319
0320 SELECT cast(1 as decimal(3, 0))  * cast(1 as decimal(10, 0)) FROM t;
0321 SELECT cast(1 as decimal(5, 0))  * cast(1 as decimal(10, 0)) FROM t;
0322 SELECT cast(1 as decimal(10, 0)) * cast(1 as decimal(10, 0)) FROM t;
0323 SELECT cast(1 as decimal(20, 0)) * cast(1 as decimal(10, 0)) FROM t;
0324
0325 SELECT cast(1 as decimal(3, 0))  * cast(1 as string) FROM t;
0326 SELECT cast(1 as decimal(5, 0))  * cast(1 as string) FROM t;
0327 SELECT cast(1 as decimal(10, 0)) * cast(1 as string) FROM t;
0328 SELECT cast(1 as decimal(20, 0)) * cast(1 as string) FROM t;
0329
0330 SELECT cast(1 as decimal(3, 0))  * cast('1' as binary) FROM t;
0331 SELECT cast(1 as decimal(5, 0))  * cast('1' as binary) FROM t;
0332 SELECT cast(1 as decimal(10, 0)) * cast('1' as binary) FROM t;
0333 SELECT cast(1 as decimal(20, 0)) * cast('1' as binary) FROM t;
0334
0335 SELECT cast(1 as decimal(3, 0))  * cast(1 as boolean) FROM t;
0336 SELECT cast(1 as decimal(5, 0))  * cast(1 as boolean) FROM t;
0337 SELECT cast(1 as decimal(10, 0)) * cast(1 as boolean) FROM t;
0338 SELECT cast(1 as decimal(20, 0)) * cast(1 as boolean) FROM t;
0339
0340 SELECT cast(1 as decimal(3, 0))  * cast('2017*12*11 09:30:00.0' as timestamp) FROM t;
0341 SELECT cast(1 as decimal(5, 0))  * cast('2017*12*11 09:30:00.0' as timestamp) FROM t;
0342 SELECT cast(1 as decimal(10, 0)) * cast('2017*12*11 09:30:00.0' as timestamp) FROM t;
0343 SELECT cast(1 as decimal(20, 0)) * cast('2017*12*11 09:30:00.0' as timestamp) FROM t;
0344
0345 SELECT cast(1 as decimal(3, 0))  * cast('2017*12*11 09:30:00' as date) FROM t;
0346 SELECT cast(1 as decimal(5, 0))  * cast('2017*12*11 09:30:00' as date) FROM t;
0347 SELECT cast(1 as decimal(10, 0)) * cast('2017*12*11 09:30:00' as date) FROM t;
0348 SELECT cast(1 as decimal(20, 0)) * cast('2017*12*11 09:30:00' as date) FROM t;
0349
0350 SELECT cast(1 as tinyint) / cast(1 as decimal(3, 0)) FROM t;
0351 SELECT cast(1 as tinyint) / cast(1 as decimal(5, 0)) FROM t;
0352 SELECT cast(1 as tinyint) / cast(1 as decimal(10, 0)) FROM t;
0353 SELECT cast(1 as tinyint) / cast(1 as decimal(20, 0)) FROM t;
0354
0355 SELECT cast(1 as smallint) / cast(1 as decimal(3, 0)) FROM t;
0356 SELECT cast(1 as smallint) / cast(1 as decimal(5, 0)) FROM t;
0357 SELECT cast(1 as smallint) / cast(1 as decimal(10, 0)) FROM t;
0358 SELECT cast(1 as smallint) / cast(1 as decimal(20, 0)) FROM t;
0359
0360 SELECT cast(1 as int) / cast(1 as decimal(3, 0)) FROM t;
0361 SELECT cast(1 as int) / cast(1 as decimal(5, 0)) FROM t;
0362 SELECT cast(1 as int) / cast(1 as decimal(10, 0)) FROM t;
0363 SELECT cast(1 as int) / cast(1 as decimal(20, 0)) FROM t;
0364
0365 SELECT cast(1 as bigint) / cast(1 as decimal(3, 0)) FROM t;
0366 SELECT cast(1 as bigint) / cast(1 as decimal(5, 0)) FROM t;
0367 SELECT cast(1 as bigint) / cast(1 as decimal(10, 0)) FROM t;
0368 SELECT cast(1 as bigint) / cast(1 as decimal(20, 0)) FROM t;
0369
0370 SELECT cast(1 as float) / cast(1 as decimal(3, 0)) FROM t;
0371 SELECT cast(1 as float) / cast(1 as decimal(5, 0)) FROM t;
0372 SELECT cast(1 as float) / cast(1 as decimal(10, 0)) FROM t;
0373 SELECT cast(1 as float) / cast(1 as decimal(20, 0)) FROM t;
0374
0375 SELECT cast(1 as double) / cast(1 as decimal(3, 0)) FROM t;
0376 SELECT cast(1 as double) / cast(1 as decimal(5, 0)) FROM t;
0377 SELECT cast(1 as double) / cast(1 as decimal(10, 0)) FROM t;
0378 SELECT cast(1 as double) / cast(1 as decimal(20, 0)) FROM t;
0379
0380 SELECT cast(1 as decimal(10, 0)) / cast(1 as decimal(3, 0)) FROM t;
0381 SELECT cast(1 as decimal(10, 0)) / cast(1 as decimal(5, 0)) FROM t;
0382 SELECT cast(1 as decimal(10, 0)) / cast(1 as decimal(10, 0)) FROM t;
0383 SELECT cast(1 as decimal(10, 0)) / cast(1 as decimal(20, 0)) FROM t;
0384
0385 SELECT cast('1' as binary) / cast(1 as decimal(3, 0)) FROM t;
0386 SELECT cast('1' as binary) / cast(1 as decimal(5, 0)) FROM t;
0387 SELECT cast('1' as binary) / cast(1 as decimal(10, 0)) FROM t;
0388 SELECT cast('1' as binary) / cast(1 as decimal(20, 0)) FROM t;
0389
0390 SELECT cast('2017/12/11 09:30:00.0' as timestamp) / cast(1 as decimal(3, 0)) FROM t;
0391 SELECT cast('2017/12/11 09:30:00.0' as timestamp) / cast(1 as decimal(5, 0)) FROM t;
0392 SELECT cast('2017/12/11 09:30:00.0' as timestamp) / cast(1 as decimal(10, 0)) FROM t;
0393 SELECT cast('2017/12/11 09:30:00.0' as timestamp) / cast(1 as decimal(20, 0)) FROM t;
0394
0395 SELECT cast('2017/12/11 09:30:00' as date) / cast(1 as decimal(3, 0)) FROM t;
0396 SELECT cast('2017/12/11 09:30:00' as date) / cast(1 as decimal(5, 0)) FROM t;
0397 SELECT cast('2017/12/11 09:30:00' as date) / cast(1 as decimal(10, 0)) FROM t;
0398 SELECT cast('2017/12/11 09:30:00' as date) / cast(1 as decimal(20, 0)) FROM t;
0399
0400 SELECT cast(1 as decimal(3, 0))  / cast(1 as tinyint) FROM t;
0401 SELECT cast(1 as decimal(5, 0))  / cast(1 as tinyint) FROM t;
0402 SELECT cast(1 as decimal(10, 0)) / cast(1 as tinyint) FROM t;
0403 SELECT cast(1 as decimal(20, 0)) / cast(1 as tinyint) FROM t;
0404
0405 SELECT cast(1 as decimal(3, 0))  / cast(1 as smallint) FROM t;
0406 SELECT cast(1 as decimal(5, 0))  / cast(1 as smallint) FROM t;
0407 SELECT cast(1 as decimal(10, 0)) / cast(1 as smallint) FROM t;
0408 SELECT cast(1 as decimal(20, 0)) / cast(1 as smallint) FROM t;
0409
0410 SELECT cast(1 as decimal(3, 0))  / cast(1 as int) FROM t;
0411 SELECT cast(1 as decimal(5, 0))  / cast(1 as int) FROM t;
0412 SELECT cast(1 as decimal(10, 0)) / cast(1 as int) FROM t;
0413 SELECT cast(1 as decimal(20, 0)) / cast(1 as int) FROM t;
0414
0415 SELECT cast(1 as decimal(3, 0))  / cast(1 as bigint) FROM t;
0416 SELECT cast(1 as decimal(5, 0))  / cast(1 as bigint) FROM t;
0417 SELECT cast(1 as decimal(10, 0)) / cast(1 as bigint) FROM t;
0418 SELECT cast(1 as decimal(20, 0)) / cast(1 as bigint) FROM t;
0419
0420 SELECT cast(1 as decimal(3, 0))  / cast(1 as float) FROM t;
0421 SELECT cast(1 as decimal(5, 0))  / cast(1 as float) FROM t;
0422 SELECT cast(1 as decimal(10, 0)) / cast(1 as float) FROM t;
0423 SELECT cast(1 as decimal(20, 0)) / cast(1 as float) FROM t;
0424
0425 SELECT cast(1 as decimal(3, 0))  / cast(1 as double) FROM t;
0426 SELECT cast(1 as decimal(5, 0))  / cast(1 as double) FROM t;
0427 SELECT cast(1 as decimal(10, 0)) / cast(1 as double) FROM t;
0428 SELECT cast(1 as decimal(20, 0)) / cast(1 as double) FROM t;
0429
0430 SELECT cast(1 as decimal(3, 0))  / cast(1 as decimal(10, 0)) FROM t;
0431 SELECT cast(1 as decimal(5, 0))  / cast(1 as decimal(10, 0)) FROM t;
0432 SELECT cast(1 as decimal(10, 0)) / cast(1 as decimal(10, 0)) FROM t;
0433 SELECT cast(1 as decimal(20, 0)) / cast(1 as decimal(10, 0)) FROM t;
0434
0435 SELECT cast(1 as decimal(3, 0))  / cast(1 as string) FROM t;
0436 SELECT cast(1 as decimal(5, 0))  / cast(1 as string) FROM t;
0437 SELECT cast(1 as decimal(10, 0)) / cast(1 as string) FROM t;
0438 SELECT cast(1 as decimal(20, 0)) / cast(1 as string) FROM t;
0439
0440 SELECT cast(1 as decimal(3, 0))  / cast('1' as binary) FROM t;
0441 SELECT cast(1 as decimal(5, 0))  / cast('1' as binary) FROM t;
0442 SELECT cast(1 as decimal(10, 0)) / cast('1' as binary) FROM t;
0443 SELECT cast(1 as decimal(20, 0)) / cast('1' as binary) FROM t;
0444
0445 SELECT cast(1 as decimal(3, 0))  / cast(1 as boolean) FROM t;
0446 SELECT cast(1 as decimal(5, 0))  / cast(1 as boolean) FROM t;
0447 SELECT cast(1 as decimal(10, 0)) / cast(1 as boolean) FROM t;
0448 SELECT cast(1 as decimal(20, 0)) / cast(1 as boolean) FROM t;
0449
0450 SELECT cast(1 as decimal(3, 0))  / cast('2017/12/11 09:30:00.0' as timestamp) FROM t;
0451 SELECT cast(1 as decimal(5, 0))  / cast('2017/12/11 09:30:00.0' as timestamp) FROM t;
0452 SELECT cast(1 as decimal(10, 0)) / cast('2017/12/11 09:30:00.0' as timestamp) FROM t;
0453 SELECT cast(1 as decimal(20, 0)) / cast('2017/12/11 09:30:00.0' as timestamp) FROM t;
0454
0455 SELECT cast(1 as decimal(3, 0))  / cast('2017/12/11 09:30:00' as date) FROM t;
0456 SELECT cast(1 as decimal(5, 0))  / cast('2017/12/11 09:30:00' as date) FROM t;
0457 SELECT cast(1 as decimal(10, 0)) / cast('2017/12/11 09:30:00' as date) FROM t;
0458 SELECT cast(1 as decimal(20, 0)) / cast('2017/12/11 09:30:00' as date) FROM t;
0459
0460 SELECT cast(1 as tinyint) % cast(1 as decimal(3, 0)) FROM t;
0461 SELECT cast(1 as tinyint) % cast(1 as decimal(5, 0)) FROM t;
0462 SELECT cast(1 as tinyint) % cast(1 as decimal(10, 0)) FROM t;
0463 SELECT cast(1 as tinyint) % cast(1 as decimal(20, 0)) FROM t;
0464
0465 SELECT cast(1 as smallint) % cast(1 as decimal(3, 0)) FROM t;
0466 SELECT cast(1 as smallint) % cast(1 as decimal(5, 0)) FROM t;
0467 SELECT cast(1 as smallint) % cast(1 as decimal(10, 0)) FROM t;
0468 SELECT cast(1 as smallint) % cast(1 as decimal(20, 0)) FROM t;
0469
0470 SELECT cast(1 as int) % cast(1 as decimal(3, 0)) FROM t;
0471 SELECT cast(1 as int) % cast(1 as decimal(5, 0)) FROM t;
0472 SELECT cast(1 as int) % cast(1 as decimal(10, 0)) FROM t;
0473 SELECT cast(1 as int) % cast(1 as decimal(20, 0)) FROM t;
0474
0475 SELECT cast(1 as bigint) % cast(1 as decimal(3, 0)) FROM t;
0476 SELECT cast(1 as bigint) % cast(1 as decimal(5, 0)) FROM t;
0477 SELECT cast(1 as bigint) % cast(1 as decimal(10, 0)) FROM t;
0478 SELECT cast(1 as bigint) % cast(1 as decimal(20, 0)) FROM t;
0479
0480 SELECT cast(1 as float) % cast(1 as decimal(3, 0)) FROM t;
0481 SELECT cast(1 as float) % cast(1 as decimal(5, 0)) FROM t;
0482 SELECT cast(1 as float) % cast(1 as decimal(10, 0)) FROM t;
0483 SELECT cast(1 as float) % cast(1 as decimal(20, 0)) FROM t;
0484
0485 SELECT cast(1 as double) % cast(1 as decimal(3, 0)) FROM t;
0486 SELECT cast(1 as double) % cast(1 as decimal(5, 0)) FROM t;
0487 SELECT cast(1 as double) % cast(1 as decimal(10, 0)) FROM t;
0488 SELECT cast(1 as double) % cast(1 as decimal(20, 0)) FROM t;
0489
0490 SELECT cast(1 as decimal(10, 0)) % cast(1 as decimal(3, 0)) FROM t;
0491 SELECT cast(1 as decimal(10, 0)) % cast(1 as decimal(5, 0)) FROM t;
0492 SELECT cast(1 as decimal(10, 0)) % cast(1 as decimal(10, 0)) FROM t;
0493 SELECT cast(1 as decimal(10, 0)) % cast(1 as decimal(20, 0)) FROM t;
0494
0495 SELECT cast('1' as binary) % cast(1 as decimal(3, 0)) FROM t;
0496 SELECT cast('1' as binary) % cast(1 as decimal(5, 0)) FROM t;
0497 SELECT cast('1' as binary) % cast(1 as decimal(10, 0)) FROM t;
0498 SELECT cast('1' as binary) % cast(1 as decimal(20, 0)) FROM t;
0499
0500 SELECT cast('2017-12-11 09:30:00.0' as timestamp) % cast(1 as decimal(3, 0)) FROM t;
0501 SELECT cast('2017-12-11 09:30:00.0' as timestamp) % cast(1 as decimal(5, 0)) FROM t;
0502 SELECT cast('2017-12-11 09:30:00.0' as timestamp) % cast(1 as decimal(10, 0)) FROM t;
0503 SELECT cast('2017-12-11 09:30:00.0' as timestamp) % cast(1 as decimal(20, 0)) FROM t;
0504
0505 SELECT cast('2017-12-11 09:30:00' as date) % cast(1 as decimal(3, 0)) FROM t;
0506 SELECT cast('2017-12-11 09:30:00' as date) % cast(1 as decimal(5, 0)) FROM t;
0507 SELECT cast('2017-12-11 09:30:00' as date) % cast(1 as decimal(10, 0)) FROM t;
0508 SELECT cast('2017-12-11 09:30:00' as date) % cast(1 as decimal(20, 0)) FROM t;
0509
0510 SELECT cast(1 as decimal(3, 0))  % cast(1 as tinyint) FROM t;
0511 SELECT cast(1 as decimal(5, 0))  % cast(1 as tinyint) FROM t;
0512 SELECT cast(1 as decimal(10, 0)) % cast(1 as tinyint) FROM t;
0513 SELECT cast(1 as decimal(20, 0)) % cast(1 as tinyint) FROM t;
0514
0515 SELECT cast(1 as decimal(3, 0))  % cast(1 as smallint) FROM t;
0516 SELECT cast(1 as decimal(5, 0))  % cast(1 as smallint) FROM t;
0517 SELECT cast(1 as decimal(10, 0)) % cast(1 as smallint) FROM t;
0518 SELECT cast(1 as decimal(20, 0)) % cast(1 as smallint) FROM t;
0519
0520 SELECT cast(1 as decimal(3, 0))  % cast(1 as int) FROM t;
0521 SELECT cast(1 as decimal(5, 0))  % cast(1 as int) FROM t;
0522 SELECT cast(1 as decimal(10, 0)) % cast(1 as int) FROM t;
0523 SELECT cast(1 as decimal(20, 0)) % cast(1 as int) FROM t;
0524
0525 SELECT cast(1 as decimal(3, 0))  % cast(1 as bigint) FROM t;
0526 SELECT cast(1 as decimal(5, 0))  % cast(1 as bigint) FROM t;
0527 SELECT cast(1 as decimal(10, 0)) % cast(1 as bigint) FROM t;
0528 SELECT cast(1 as decimal(20, 0)) % cast(1 as bigint) FROM t;
0529
0530 SELECT cast(1 as decimal(3, 0))  % cast(1 as float) FROM t;
0531 SELECT cast(1 as decimal(5, 0))  % cast(1 as float) FROM t;
0532 SELECT cast(1 as decimal(10, 0)) % cast(1 as float) FROM t;
0533 SELECT cast(1 as decimal(20, 0)) % cast(1 as float) FROM t;
0534
0535 SELECT cast(1 as decimal(3, 0))  % cast(1 as double) FROM t;
0536 SELECT cast(1 as decimal(5, 0))  % cast(1 as double) FROM t;
0537 SELECT cast(1 as decimal(10, 0)) % cast(1 as double) FROM t;
0538 SELECT cast(1 as decimal(20, 0)) % cast(1 as double) FROM t;
0539
0540 SELECT cast(1 as decimal(3, 0))  % cast(1 as decimal(10, 0)) FROM t;
0541 SELECT cast(1 as decimal(5, 0))  % cast(1 as decimal(10, 0)) FROM t;
0542 SELECT cast(1 as decimal(10, 0)) % cast(1 as decimal(10, 0)) FROM t;
0543 SELECT cast(1 as decimal(20, 0)) % cast(1 as decimal(10, 0)) FROM t;
0544
0545 SELECT cast(1 as decimal(3, 0))  % cast(1 as string) FROM t;
0546 SELECT cast(1 as decimal(5, 0))  % cast(1 as string) FROM t;
0547 SELECT cast(1 as decimal(10, 0)) % cast(1 as string) FROM t;
0548 SELECT cast(1 as decimal(20, 0)) % cast(1 as string) FROM t;
0549
0550 SELECT cast(1 as decimal(3, 0))  % cast('1' as binary) FROM t;
0551 SELECT cast(1 as decimal(5, 0))  % cast('1' as binary) FROM t;
0552 SELECT cast(1 as decimal(10, 0)) % cast('1' as binary) FROM t;
0553 SELECT cast(1 as decimal(20, 0)) % cast('1' as binary) FROM t;
0554
0555 SELECT cast(1 as decimal(3, 0))  % cast(1 as boolean) FROM t;
0556 SELECT cast(1 as decimal(5, 0))  % cast(1 as boolean) FROM t;
0557 SELECT cast(1 as decimal(10, 0)) % cast(1 as boolean) FROM t;
0558 SELECT cast(1 as decimal(20, 0)) % cast(1 as boolean) FROM t;
0559
0560 SELECT cast(1 as decimal(3, 0))  % cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0561 SELECT cast(1 as decimal(5, 0))  % cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0562 SELECT cast(1 as decimal(10, 0)) % cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0563 SELECT cast(1 as decimal(20, 0)) % cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0564
0565 SELECT cast(1 as decimal(3, 0))  % cast('2017-12-11 09:30:00' as date) FROM t;
0566 SELECT cast(1 as decimal(5, 0))  % cast('2017-12-11 09:30:00' as date) FROM t;
0567 SELECT cast(1 as decimal(10, 0)) % cast('2017-12-11 09:30:00' as date) FROM t;
0568 SELECT cast(1 as decimal(20, 0)) % cast('2017-12-11 09:30:00' as date) FROM t;
0569
0570 SELECT pmod(cast(1 as tinyint), cast(1 as decimal(3, 0))) FROM t;
0571 SELECT pmod(cast(1 as tinyint), cast(1 as decimal(5, 0))) FROM t;
0572 SELECT pmod(cast(1 as tinyint), cast(1 as decimal(10, 0))) FROM t;
0573 SELECT pmod(cast(1 as tinyint), cast(1 as decimal(20, 0))) FROM t;
0574
0575 SELECT pmod(cast(1 as smallint), cast(1 as decimal(3, 0))) FROM t;
0576 SELECT pmod(cast(1 as smallint), cast(1 as decimal(5, 0))) FROM t;
0577 SELECT pmod(cast(1 as smallint), cast(1 as decimal(10, 0))) FROM t;
0578 SELECT pmod(cast(1 as smallint), cast(1 as decimal(20, 0))) FROM t;
0579
0580 SELECT pmod(cast(1 as int), cast(1 as decimal(3, 0))) FROM t;
0581 SELECT pmod(cast(1 as int), cast(1 as decimal(5, 0))) FROM t;
0582 SELECT pmod(cast(1 as int), cast(1 as decimal(10, 0))) FROM t;
0583 SELECT pmod(cast(1 as int), cast(1 as decimal(20, 0))) FROM t;
0584
0585 SELECT pmod(cast(1 as bigint), cast(1 as decimal(3, 0))) FROM t;
0586 SELECT pmod(cast(1 as bigint), cast(1 as decimal(5, 0))) FROM t;
0587 SELECT pmod(cast(1 as bigint), cast(1 as decimal(10, 0))) FROM t;
0588 SELECT pmod(cast(1 as bigint), cast(1 as decimal(20, 0))) FROM t;
0589
0590 SELECT pmod(cast(1 as float), cast(1 as decimal(3, 0))) FROM t;
0591 SELECT pmod(cast(1 as float), cast(1 as decimal(5, 0))) FROM t;
0592 SELECT pmod(cast(1 as float), cast(1 as decimal(10, 0))) FROM t;
0593 SELECT pmod(cast(1 as float), cast(1 as decimal(20, 0))) FROM t;
0594
0595 SELECT pmod(cast(1 as double), cast(1 as decimal(3, 0))) FROM t;
0596 SELECT pmod(cast(1 as double), cast(1 as decimal(5, 0))) FROM t;
0597 SELECT pmod(cast(1 as double), cast(1 as decimal(10, 0))) FROM t;
0598 SELECT pmod(cast(1 as double), cast(1 as decimal(20, 0))) FROM t;
0599
0600 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as decimal(3, 0))) FROM t;
0601 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as decimal(5, 0))) FROM t;
0602 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as decimal(10, 0))) FROM t;
0603 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as decimal(20, 0))) FROM t;
0604
0605 SELECT pmod(cast('1' as binary), cast(1 as decimal(3, 0))) FROM t;
0606 SELECT pmod(cast('1' as binary), cast(1 as decimal(5, 0))) FROM t;
0607 SELECT pmod(cast('1' as binary), cast(1 as decimal(10, 0))) FROM t;
0608 SELECT pmod(cast('1' as binary), cast(1 as decimal(20, 0))) FROM t;
0609
0610 SELECT pmod(cast('2017-12-11 09:30:00.0' as timestamp), cast(1 as decimal(3, 0))) FROM t;
0611 SELECT pmod(cast('2017-12-11 09:30:00.0' as timestamp), cast(1 as decimal(5, 0))) FROM t;
0612 SELECT pmod(cast('2017-12-11 09:30:00.0' as timestamp), cast(1 as decimal(10, 0))) FROM t;
0613 SELECT pmod(cast('2017-12-11 09:30:00.0' as timestamp), cast(1 as decimal(20, 0))) FROM t;
0614
0615 SELECT pmod(cast('2017-12-11 09:30:00' as date), cast(1 as decimal(3, 0))) FROM t;
0616 SELECT pmod(cast('2017-12-11 09:30:00' as date), cast(1 as decimal(5, 0))) FROM t;
0617 SELECT pmod(cast('2017-12-11 09:30:00' as date), cast(1 as decimal(10, 0))) FROM t;
0618 SELECT pmod(cast('2017-12-11 09:30:00' as date), cast(1 as decimal(20, 0))) FROM t;
0619
0620 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as tinyint)) FROM t;
0621 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as tinyint)) FROM t;
0622 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as tinyint)) FROM t;
0623 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as tinyint)) FROM t;
0624
0625 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as smallint)) FROM t;
0626 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as smallint)) FROM t;
0627 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as smallint)) FROM t;
0628 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as smallint)) FROM t;
0629
0630 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as int)) FROM t;
0631 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as int)) FROM t;
0632 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as int)) FROM t;
0633 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as int)) FROM t;
0634
0635 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as bigint)) FROM t;
0636 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as bigint)) FROM t;
0637 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as bigint)) FROM t;
0638 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as bigint)) FROM t;
0639
0640 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as float)) FROM t;
0641 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as float)) FROM t;
0642 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as float)) FROM t;
0643 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as float)) FROM t;
0644
0645 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as double)) FROM t;
0646 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as double)) FROM t;
0647 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as double)) FROM t;
0648 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as double)) FROM t;
0649
0650 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as decimal(10, 0))) FROM t;
0651 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as decimal(10, 0))) FROM t;
0652 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as decimal(10, 0))) FROM t;
0653 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as decimal(10, 0))) FROM t;
0654
0655 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as string)) FROM t;
0656 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as string)) FROM t;
0657 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as string)) FROM t;
0658 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as string)) FROM t;
0659
0660 SELECT pmod(cast(1 as decimal(3, 0)) , cast('1' as binary)) FROM t;
0661 SELECT pmod(cast(1 as decimal(5, 0)) , cast('1' as binary)) FROM t;
0662 SELECT pmod(cast(1 as decimal(10, 0)), cast('1' as binary)) FROM t;
0663 SELECT pmod(cast(1 as decimal(20, 0)), cast('1' as binary)) FROM t;
0664
0665 SELECT pmod(cast(1 as decimal(3, 0)) , cast(1 as boolean)) FROM t;
0666 SELECT pmod(cast(1 as decimal(5, 0)) , cast(1 as boolean)) FROM t;
0667 SELECT pmod(cast(1 as decimal(10, 0)), cast(1 as boolean)) FROM t;
0668 SELECT pmod(cast(1 as decimal(20, 0)), cast(1 as boolean)) FROM t;
0669
0670 SELECT pmod(cast(1 as decimal(3, 0)) , cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0671 SELECT pmod(cast(1 as decimal(5, 0)) , cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0672 SELECT pmod(cast(1 as decimal(10, 0)), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0673 SELECT pmod(cast(1 as decimal(20, 0)), cast('2017-12-11 09:30:00.0' as timestamp)) FROM t;
0674
0675 SELECT pmod(cast(1 as decimal(3, 0)) , cast('2017-12-11 09:30:00' as date)) FROM t;
0676 SELECT pmod(cast(1 as decimal(5, 0)) , cast('2017-12-11 09:30:00' as date)) FROM t;
0677 SELECT pmod(cast(1 as decimal(10, 0)), cast('2017-12-11 09:30:00' as date)) FROM t;
0678 SELECT pmod(cast(1 as decimal(20, 0)), cast('2017-12-11 09:30:00' as date)) FROM t;
0679
0680 SELECT cast(1 as tinyint) = cast(1 as decimal(3, 0)) FROM t;
0681 SELECT cast(1 as tinyint) = cast(1 as decimal(5, 0)) FROM t;
0682 SELECT cast(1 as tinyint) = cast(1 as decimal(10, 0)) FROM t;
0683 SELECT cast(1 as tinyint) = cast(1 as decimal(20, 0)) FROM t;
0684
0685 SELECT cast(1 as smallint) = cast(1 as decimal(3, 0)) FROM t;
0686 SELECT cast(1 as smallint) = cast(1 as decimal(5, 0)) FROM t;
0687 SELECT cast(1 as smallint) = cast(1 as decimal(10, 0)) FROM t;
0688 SELECT cast(1 as smallint) = cast(1 as decimal(20, 0)) FROM t;
0689
0690 SELECT cast(1 as int) = cast(1 as decimal(3, 0)) FROM t;
0691 SELECT cast(1 as int) = cast(1 as decimal(5, 0)) FROM t;
0692 SELECT cast(1 as int) = cast(1 as decimal(10, 0)) FROM t;
0693 SELECT cast(1 as int) = cast(1 as decimal(20, 0)) FROM t;
0694
0695 SELECT cast(1 as bigint) = cast(1 as decimal(3, 0)) FROM t;
0696 SELECT cast(1 as bigint) = cast(1 as decimal(5, 0)) FROM t;
0697 SELECT cast(1 as bigint) = cast(1 as decimal(10, 0)) FROM t;
0698 SELECT cast(1 as bigint) = cast(1 as decimal(20, 0)) FROM t;
0699
0700 SELECT cast(1 as float) = cast(1 as decimal(3, 0)) FROM t;
0701 SELECT cast(1 as float) = cast(1 as decimal(5, 0)) FROM t;
0702 SELECT cast(1 as float) = cast(1 as decimal(10, 0)) FROM t;
0703 SELECT cast(1 as float) = cast(1 as decimal(20, 0)) FROM t;
0704
0705 SELECT cast(1 as double) = cast(1 as decimal(3, 0)) FROM t;
0706 SELECT cast(1 as double) = cast(1 as decimal(5, 0)) FROM t;
0707 SELECT cast(1 as double) = cast(1 as decimal(10, 0)) FROM t;
0708 SELECT cast(1 as double) = cast(1 as decimal(20, 0)) FROM t;
0709
0710 SELECT cast(1 as decimal(10, 0)) = cast(1 as decimal(3, 0)) FROM t;
0711 SELECT cast(1 as decimal(10, 0)) = cast(1 as decimal(5, 0)) FROM t;
0712 SELECT cast(1 as decimal(10, 0)) = cast(1 as decimal(10, 0)) FROM t;
0713 SELECT cast(1 as decimal(10, 0)) = cast(1 as decimal(20, 0)) FROM t;
0714
0715 SELECT cast('1' as binary) = cast(1 as decimal(3, 0)) FROM t;
0716 SELECT cast('1' as binary) = cast(1 as decimal(5, 0)) FROM t;
0717 SELECT cast('1' as binary) = cast(1 as decimal(10, 0)) FROM t;
0718 SELECT cast('1' as binary) = cast(1 as decimal(20, 0)) FROM t;
0719
0720 SELECT cast('2017-12-11 09:30:00.0' as timestamp) = cast(1 as decimal(3, 0)) FROM t;
0721 SELECT cast('2017-12-11 09:30:00.0' as timestamp) = cast(1 as decimal(5, 0)) FROM t;
0722 SELECT cast('2017-12-11 09:30:00.0' as timestamp) = cast(1 as decimal(10, 0)) FROM t;
0723 SELECT cast('2017-12-11 09:30:00.0' as timestamp) = cast(1 as decimal(20, 0)) FROM t;
0724
0725 SELECT cast('2017-12-11 09:30:00' as date) = cast(1 as decimal(3, 0)) FROM t;
0726 SELECT cast('2017-12-11 09:30:00' as date) = cast(1 as decimal(5, 0)) FROM t;
0727 SELECT cast('2017-12-11 09:30:00' as date) = cast(1 as decimal(10, 0)) FROM t;
0728 SELECT cast('2017-12-11 09:30:00' as date) = cast(1 as decimal(20, 0)) FROM t;
0729
0730 SELECT cast(1 as decimal(3, 0))  = cast(1 as tinyint) FROM t;
0731 SELECT cast(1 as decimal(5, 0))  = cast(1 as tinyint) FROM t;
0732 SELECT cast(1 as decimal(10, 0)) = cast(1 as tinyint) FROM t;
0733 SELECT cast(1 as decimal(20, 0)) = cast(1 as tinyint) FROM t;
0734
0735 SELECT cast(1 as decimal(3, 0))  = cast(1 as smallint) FROM t;
0736 SELECT cast(1 as decimal(5, 0))  = cast(1 as smallint) FROM t;
0737 SELECT cast(1 as decimal(10, 0)) = cast(1 as smallint) FROM t;
0738 SELECT cast(1 as decimal(20, 0)) = cast(1 as smallint) FROM t;
0739
0740 SELECT cast(1 as decimal(3, 0))  = cast(1 as int) FROM t;
0741 SELECT cast(1 as decimal(5, 0))  = cast(1 as int) FROM t;
0742 SELECT cast(1 as decimal(10, 0)) = cast(1 as int) FROM t;
0743 SELECT cast(1 as decimal(20, 0)) = cast(1 as int) FROM t;
0744
0745 SELECT cast(1 as decimal(3, 0))  = cast(1 as bigint) FROM t;
0746 SELECT cast(1 as decimal(5, 0))  = cast(1 as bigint) FROM t;
0747 SELECT cast(1 as decimal(10, 0)) = cast(1 as bigint) FROM t;
0748 SELECT cast(1 as decimal(20, 0)) = cast(1 as bigint) FROM t;
0749
0750 SELECT cast(1 as decimal(3, 0))  = cast(1 as float) FROM t;
0751 SELECT cast(1 as decimal(5, 0))  = cast(1 as float) FROM t;
0752 SELECT cast(1 as decimal(10, 0)) = cast(1 as float) FROM t;
0753 SELECT cast(1 as decimal(20, 0)) = cast(1 as float) FROM t;
0754
0755 SELECT cast(1 as decimal(3, 0))  = cast(1 as double) FROM t;
0756 SELECT cast(1 as decimal(5, 0))  = cast(1 as double) FROM t;
0757 SELECT cast(1 as decimal(10, 0)) = cast(1 as double) FROM t;
0758 SELECT cast(1 as decimal(20, 0)) = cast(1 as double) FROM t;
0759
0760 SELECT cast(1 as decimal(3, 0))  = cast(1 as decimal(10, 0)) FROM t;
0761 SELECT cast(1 as decimal(5, 0))  = cast(1 as decimal(10, 0)) FROM t;
0762 SELECT cast(1 as decimal(10, 0)) = cast(1 as decimal(10, 0)) FROM t;
0763 SELECT cast(1 as decimal(20, 0)) = cast(1 as decimal(10, 0)) FROM t;
0764
0765 SELECT cast(1 as decimal(3, 0))  = cast(1 as string) FROM t;
0766 SELECT cast(1 as decimal(5, 0))  = cast(1 as string) FROM t;
0767 SELECT cast(1 as decimal(10, 0)) = cast(1 as string) FROM t;
0768 SELECT cast(1 as decimal(20, 0)) = cast(1 as string) FROM t;
0769
0770 SELECT cast(1 as decimal(3, 0))  = cast('1' as binary) FROM t;
0771 SELECT cast(1 as decimal(5, 0))  = cast('1' as binary) FROM t;
0772 SELECT cast(1 as decimal(10, 0)) = cast('1' as binary) FROM t;
0773 SELECT cast(1 as decimal(20, 0)) = cast('1' as binary) FROM t;
0774
0775 SELECT cast(1 as decimal(3, 0))  = cast(1 as boolean) FROM t;
0776 SELECT cast(1 as decimal(5, 0))  = cast(1 as boolean) FROM t;
0777 SELECT cast(1 as decimal(10, 0)) = cast(1 as boolean) FROM t;
0778 SELECT cast(1 as decimal(20, 0)) = cast(1 as boolean) FROM t;
0779
0780 SELECT cast(1 as decimal(3, 0))  = cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0781 SELECT cast(1 as decimal(5, 0))  = cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0782 SELECT cast(1 as decimal(10, 0)) = cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0783 SELECT cast(1 as decimal(20, 0)) = cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0784
0785 SELECT cast(1 as decimal(3, 0))  = cast('2017-12-11 09:30:00' as date) FROM t;
0786 SELECT cast(1 as decimal(5, 0))  = cast('2017-12-11 09:30:00' as date) FROM t;
0787 SELECT cast(1 as decimal(10, 0)) = cast('2017-12-11 09:30:00' as date) FROM t;
0788 SELECT cast(1 as decimal(20, 0)) = cast('2017-12-11 09:30:00' as date) FROM t;
0789
0790 SELECT cast(1 as tinyint) <=> cast(1 as decimal(3, 0)) FROM t;
0791 SELECT cast(1 as tinyint) <=> cast(1 as decimal(5, 0)) FROM t;
0792 SELECT cast(1 as tinyint) <=> cast(1 as decimal(10, 0)) FROM t;
0793 SELECT cast(1 as tinyint) <=> cast(1 as decimal(20, 0)) FROM t;
0794
0795 SELECT cast(1 as smallint) <=> cast(1 as decimal(3, 0)) FROM t;
0796 SELECT cast(1 as smallint) <=> cast(1 as decimal(5, 0)) FROM t;
0797 SELECT cast(1 as smallint) <=> cast(1 as decimal(10, 0)) FROM t;
0798 SELECT cast(1 as smallint) <=> cast(1 as decimal(20, 0)) FROM t;
0799
0800 SELECT cast(1 as int) <=> cast(1 as decimal(3, 0)) FROM t;
0801 SELECT cast(1 as int) <=> cast(1 as decimal(5, 0)) FROM t;
0802 SELECT cast(1 as int) <=> cast(1 as decimal(10, 0)) FROM t;
0803 SELECT cast(1 as int) <=> cast(1 as decimal(20, 0)) FROM t;
0804
0805 SELECT cast(1 as bigint) <=> cast(1 as decimal(3, 0)) FROM t;
0806 SELECT cast(1 as bigint) <=> cast(1 as decimal(5, 0)) FROM t;
0807 SELECT cast(1 as bigint) <=> cast(1 as decimal(10, 0)) FROM t;
0808 SELECT cast(1 as bigint) <=> cast(1 as decimal(20, 0)) FROM t;
0809
0810 SELECT cast(1 as float) <=> cast(1 as decimal(3, 0)) FROM t;
0811 SELECT cast(1 as float) <=> cast(1 as decimal(5, 0)) FROM t;
0812 SELECT cast(1 as float) <=> cast(1 as decimal(10, 0)) FROM t;
0813 SELECT cast(1 as float) <=> cast(1 as decimal(20, 0)) FROM t;
0814
0815 SELECT cast(1 as double) <=> cast(1 as decimal(3, 0)) FROM t;
0816 SELECT cast(1 as double) <=> cast(1 as decimal(5, 0)) FROM t;
0817 SELECT cast(1 as double) <=> cast(1 as decimal(10, 0)) FROM t;
0818 SELECT cast(1 as double) <=> cast(1 as decimal(20, 0)) FROM t;
0819
0820 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as decimal(3, 0)) FROM t;
0821 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as decimal(5, 0)) FROM t;
0822 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as decimal(10, 0)) FROM t;
0823 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as decimal(20, 0)) FROM t;
0824
0825 SELECT cast('1' as binary) <=> cast(1 as decimal(3, 0)) FROM t;
0826 SELECT cast('1' as binary) <=> cast(1 as decimal(5, 0)) FROM t;
0827 SELECT cast('1' as binary) <=> cast(1 as decimal(10, 0)) FROM t;
0828 SELECT cast('1' as binary) <=> cast(1 as decimal(20, 0)) FROM t;
0829
0830 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <=> cast(1 as decimal(3, 0)) FROM t;
0831 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <=> cast(1 as decimal(5, 0)) FROM t;
0832 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <=> cast(1 as decimal(10, 0)) FROM t;
0833 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <=> cast(1 as decimal(20, 0)) FROM t;
0834
0835 SELECT cast('2017-12-11 09:30:00' as date) <=> cast(1 as decimal(3, 0)) FROM t;
0836 SELECT cast('2017-12-11 09:30:00' as date) <=> cast(1 as decimal(5, 0)) FROM t;
0837 SELECT cast('2017-12-11 09:30:00' as date) <=> cast(1 as decimal(10, 0)) FROM t;
0838 SELECT cast('2017-12-11 09:30:00' as date) <=> cast(1 as decimal(20, 0)) FROM t;
0839
0840 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as tinyint) FROM t;
0841 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as tinyint) FROM t;
0842 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as tinyint) FROM t;
0843 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as tinyint) FROM t;
0844
0845 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as smallint) FROM t;
0846 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as smallint) FROM t;
0847 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as smallint) FROM t;
0848 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as smallint) FROM t;
0849
0850 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as int) FROM t;
0851 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as int) FROM t;
0852 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as int) FROM t;
0853 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as int) FROM t;
0854
0855 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as bigint) FROM t;
0856 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as bigint) FROM t;
0857 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as bigint) FROM t;
0858 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as bigint) FROM t;
0859
0860 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as float) FROM t;
0861 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as float) FROM t;
0862 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as float) FROM t;
0863 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as float) FROM t;
0864
0865 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as double) FROM t;
0866 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as double) FROM t;
0867 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as double) FROM t;
0868 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as double) FROM t;
0869
0870 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as decimal(10, 0)) FROM t;
0871 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as decimal(10, 0)) FROM t;
0872 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as decimal(10, 0)) FROM t;
0873 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as decimal(10, 0)) FROM t;
0874
0875 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as string) FROM t;
0876 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as string) FROM t;
0877 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as string) FROM t;
0878 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as string) FROM t;
0879
0880 SELECT cast(1 as decimal(3, 0))  <=> cast('1' as binary) FROM t;
0881 SELECT cast(1 as decimal(5, 0))  <=> cast('1' as binary) FROM t;
0882 SELECT cast(1 as decimal(10, 0)) <=> cast('1' as binary) FROM t;
0883 SELECT cast(1 as decimal(20, 0)) <=> cast('1' as binary) FROM t;
0884
0885 SELECT cast(1 as decimal(3, 0))  <=> cast(1 as boolean) FROM t;
0886 SELECT cast(1 as decimal(5, 0))  <=> cast(1 as boolean) FROM t;
0887 SELECT cast(1 as decimal(10, 0)) <=> cast(1 as boolean) FROM t;
0888 SELECT cast(1 as decimal(20, 0)) <=> cast(1 as boolean) FROM t;
0889
0890 SELECT cast(1 as decimal(3, 0))  <=> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0891 SELECT cast(1 as decimal(5, 0))  <=> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0892 SELECT cast(1 as decimal(10, 0)) <=> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0893 SELECT cast(1 as decimal(20, 0)) <=> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0894
0895 SELECT cast(1 as decimal(3, 0))  <=> cast('2017-12-11 09:30:00' as date) FROM t;
0896 SELECT cast(1 as decimal(5, 0))  <=> cast('2017-12-11 09:30:00' as date) FROM t;
0897 SELECT cast(1 as decimal(10, 0)) <=> cast('2017-12-11 09:30:00' as date) FROM t;
0898 SELECT cast(1 as decimal(20, 0)) <=> cast('2017-12-11 09:30:00' as date) FROM t;
0899
0900 SELECT cast(1 as tinyint) < cast(1 as decimal(3, 0)) FROM t;
0901 SELECT cast(1 as tinyint) < cast(1 as decimal(5, 0)) FROM t;
0902 SELECT cast(1 as tinyint) < cast(1 as decimal(10, 0)) FROM t;
0903 SELECT cast(1 as tinyint) < cast(1 as decimal(20, 0)) FROM t;
0904
0905 SELECT cast(1 as smallint) < cast(1 as decimal(3, 0)) FROM t;
0906 SELECT cast(1 as smallint) < cast(1 as decimal(5, 0)) FROM t;
0907 SELECT cast(1 as smallint) < cast(1 as decimal(10, 0)) FROM t;
0908 SELECT cast(1 as smallint) < cast(1 as decimal(20, 0)) FROM t;
0909
0910 SELECT cast(1 as int) < cast(1 as decimal(3, 0)) FROM t;
0911 SELECT cast(1 as int) < cast(1 as decimal(5, 0)) FROM t;
0912 SELECT cast(1 as int) < cast(1 as decimal(10, 0)) FROM t;
0913 SELECT cast(1 as int) < cast(1 as decimal(20, 0)) FROM t;
0914
0915 SELECT cast(1 as bigint) < cast(1 as decimal(3, 0)) FROM t;
0916 SELECT cast(1 as bigint) < cast(1 as decimal(5, 0)) FROM t;
0917 SELECT cast(1 as bigint) < cast(1 as decimal(10, 0)) FROM t;
0918 SELECT cast(1 as bigint) < cast(1 as decimal(20, 0)) FROM t;
0919
0920 SELECT cast(1 as float) < cast(1 as decimal(3, 0)) FROM t;
0921 SELECT cast(1 as float) < cast(1 as decimal(5, 0)) FROM t;
0922 SELECT cast(1 as float) < cast(1 as decimal(10, 0)) FROM t;
0923 SELECT cast(1 as float) < cast(1 as decimal(20, 0)) FROM t;
0924
0925 SELECT cast(1 as double) < cast(1 as decimal(3, 0)) FROM t;
0926 SELECT cast(1 as double) < cast(1 as decimal(5, 0)) FROM t;
0927 SELECT cast(1 as double) < cast(1 as decimal(10, 0)) FROM t;
0928 SELECT cast(1 as double) < cast(1 as decimal(20, 0)) FROM t;
0929
0930 SELECT cast(1 as decimal(10, 0)) < cast(1 as decimal(3, 0)) FROM t;
0931 SELECT cast(1 as decimal(10, 0)) < cast(1 as decimal(5, 0)) FROM t;
0932 SELECT cast(1 as decimal(10, 0)) < cast(1 as decimal(10, 0)) FROM t;
0933 SELECT cast(1 as decimal(10, 0)) < cast(1 as decimal(20, 0)) FROM t;
0934
0935 SELECT cast('1' as binary) < cast(1 as decimal(3, 0)) FROM t;
0936 SELECT cast('1' as binary) < cast(1 as decimal(5, 0)) FROM t;
0937 SELECT cast('1' as binary) < cast(1 as decimal(10, 0)) FROM t;
0938 SELECT cast('1' as binary) < cast(1 as decimal(20, 0)) FROM t;
0939
0940 SELECT cast('2017-12-11 09:30:00.0' as timestamp) < cast(1 as decimal(3, 0)) FROM t;
0941 SELECT cast('2017-12-11 09:30:00.0' as timestamp) < cast(1 as decimal(5, 0)) FROM t;
0942 SELECT cast('2017-12-11 09:30:00.0' as timestamp) < cast(1 as decimal(10, 0)) FROM t;
0943 SELECT cast('2017-12-11 09:30:00.0' as timestamp) < cast(1 as decimal(20, 0)) FROM t;
0944
0945 SELECT cast('2017-12-11 09:30:00' as date) < cast(1 as decimal(3, 0)) FROM t;
0946 SELECT cast('2017-12-11 09:30:00' as date) < cast(1 as decimal(5, 0)) FROM t;
0947 SELECT cast('2017-12-11 09:30:00' as date) < cast(1 as decimal(10, 0)) FROM t;
0948 SELECT cast('2017-12-11 09:30:00' as date) < cast(1 as decimal(20, 0)) FROM t;
0949
0950 SELECT cast(1 as decimal(3, 0))  < cast(1 as tinyint) FROM t;
0951 SELECT cast(1 as decimal(5, 0))  < cast(1 as tinyint) FROM t;
0952 SELECT cast(1 as decimal(10, 0)) < cast(1 as tinyint) FROM t;
0953 SELECT cast(1 as decimal(20, 0)) < cast(1 as tinyint) FROM t;
0954
0955 SELECT cast(1 as decimal(3, 0))  < cast(1 as smallint) FROM t;
0956 SELECT cast(1 as decimal(5, 0))  < cast(1 as smallint) FROM t;
0957 SELECT cast(1 as decimal(10, 0)) < cast(1 as smallint) FROM t;
0958 SELECT cast(1 as decimal(20, 0)) < cast(1 as smallint) FROM t;
0959
0960 SELECT cast(1 as decimal(3, 0))  < cast(1 as int) FROM t;
0961 SELECT cast(1 as decimal(5, 0))  < cast(1 as int) FROM t;
0962 SELECT cast(1 as decimal(10, 0)) < cast(1 as int) FROM t;
0963 SELECT cast(1 as decimal(20, 0)) < cast(1 as int) FROM t;
0964
0965 SELECT cast(1 as decimal(3, 0))  < cast(1 as bigint) FROM t;
0966 SELECT cast(1 as decimal(5, 0))  < cast(1 as bigint) FROM t;
0967 SELECT cast(1 as decimal(10, 0)) < cast(1 as bigint) FROM t;
0968 SELECT cast(1 as decimal(20, 0)) < cast(1 as bigint) FROM t;
0969
0970 SELECT cast(1 as decimal(3, 0))  < cast(1 as float) FROM t;
0971 SELECT cast(1 as decimal(5, 0))  < cast(1 as float) FROM t;
0972 SELECT cast(1 as decimal(10, 0)) < cast(1 as float) FROM t;
0973 SELECT cast(1 as decimal(20, 0)) < cast(1 as float) FROM t;
0974
0975 SELECT cast(1 as decimal(3, 0))  < cast(1 as double) FROM t;
0976 SELECT cast(1 as decimal(5, 0))  < cast(1 as double) FROM t;
0977 SELECT cast(1 as decimal(10, 0)) < cast(1 as double) FROM t;
0978 SELECT cast(1 as decimal(20, 0)) < cast(1 as double) FROM t;
0979
0980 SELECT cast(1 as decimal(3, 0))  < cast(1 as decimal(10, 0)) FROM t;
0981 SELECT cast(1 as decimal(5, 0))  < cast(1 as decimal(10, 0)) FROM t;
0982 SELECT cast(1 as decimal(10, 0)) < cast(1 as decimal(10, 0)) FROM t;
0983 SELECT cast(1 as decimal(20, 0)) < cast(1 as decimal(10, 0)) FROM t;
0984
0985 SELECT cast(1 as decimal(3, 0))  < cast(1 as string) FROM t;
0986 SELECT cast(1 as decimal(5, 0))  < cast(1 as string) FROM t;
0987 SELECT cast(1 as decimal(10, 0)) < cast(1 as string) FROM t;
0988 SELECT cast(1 as decimal(20, 0)) < cast(1 as string) FROM t;
0989
0990 SELECT cast(1 as decimal(3, 0))  < cast('1' as binary) FROM t;
0991 SELECT cast(1 as decimal(5, 0))  < cast('1' as binary) FROM t;
0992 SELECT cast(1 as decimal(10, 0)) < cast('1' as binary) FROM t;
0993 SELECT cast(1 as decimal(20, 0)) < cast('1' as binary) FROM t;
0994
0995 SELECT cast(1 as decimal(3, 0))  < cast(1 as boolean) FROM t;
0996 SELECT cast(1 as decimal(5, 0))  < cast(1 as boolean) FROM t;
0997 SELECT cast(1 as decimal(10, 0)) < cast(1 as boolean) FROM t;
0998 SELECT cast(1 as decimal(20, 0)) < cast(1 as boolean) FROM t;
0999
1000 SELECT cast(1 as decimal(3, 0))  < cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1001 SELECT cast(1 as decimal(5, 0))  < cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1002 SELECT cast(1 as decimal(10, 0)) < cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1003 SELECT cast(1 as decimal(20, 0)) < cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1004
1005 SELECT cast(1 as decimal(3, 0))  < cast('2017-12-11 09:30:00' as date) FROM t;
1006 SELECT cast(1 as decimal(5, 0))  < cast('2017-12-11 09:30:00' as date) FROM t;
1007 SELECT cast(1 as decimal(10, 0)) < cast('2017-12-11 09:30:00' as date) FROM t;
1008 SELECT cast(1 as decimal(20, 0)) < cast('2017-12-11 09:30:00' as date) FROM t;
1009
1010 SELECT cast(1 as tinyint) <= cast(1 as decimal(3, 0)) FROM t;
1011 SELECT cast(1 as tinyint) <= cast(1 as decimal(5, 0)) FROM t;
1012 SELECT cast(1 as tinyint) <= cast(1 as decimal(10, 0)) FROM t;
1013 SELECT cast(1 as tinyint) <= cast(1 as decimal(20, 0)) FROM t;
1014
1015 SELECT cast(1 as smallint) <= cast(1 as decimal(3, 0)) FROM t;
1016 SELECT cast(1 as smallint) <= cast(1 as decimal(5, 0)) FROM t;
1017 SELECT cast(1 as smallint) <= cast(1 as decimal(10, 0)) FROM t;
1018 SELECT cast(1 as smallint) <= cast(1 as decimal(20, 0)) FROM t;
1019
1020 SELECT cast(1 as int) <= cast(1 as decimal(3, 0)) FROM t;
1021 SELECT cast(1 as int) <= cast(1 as decimal(5, 0)) FROM t;
1022 SELECT cast(1 as int) <= cast(1 as decimal(10, 0)) FROM t;
1023 SELECT cast(1 as int) <= cast(1 as decimal(20, 0)) FROM t;
1024
1025 SELECT cast(1 as bigint) <= cast(1 as decimal(3, 0)) FROM t;
1026 SELECT cast(1 as bigint) <= cast(1 as decimal(5, 0)) FROM t;
1027 SELECT cast(1 as bigint) <= cast(1 as decimal(10, 0)) FROM t;
1028 SELECT cast(1 as bigint) <= cast(1 as decimal(20, 0)) FROM t;
1029
1030 SELECT cast(1 as float) <= cast(1 as decimal(3, 0)) FROM t;
1031 SELECT cast(1 as float) <= cast(1 as decimal(5, 0)) FROM t;
1032 SELECT cast(1 as float) <= cast(1 as decimal(10, 0)) FROM t;
1033 SELECT cast(1 as float) <= cast(1 as decimal(20, 0)) FROM t;
1034
1035 SELECT cast(1 as double) <= cast(1 as decimal(3, 0)) FROM t;
1036 SELECT cast(1 as double) <= cast(1 as decimal(5, 0)) FROM t;
1037 SELECT cast(1 as double) <= cast(1 as decimal(10, 0)) FROM t;
1038 SELECT cast(1 as double) <= cast(1 as decimal(20, 0)) FROM t;
1039
1040 SELECT cast(1 as decimal(10, 0)) <= cast(1 as decimal(3, 0)) FROM t;
1041 SELECT cast(1 as decimal(10, 0)) <= cast(1 as decimal(5, 0)) FROM t;
1042 SELECT cast(1 as decimal(10, 0)) <= cast(1 as decimal(10, 0)) FROM t;
1043 SELECT cast(1 as decimal(10, 0)) <= cast(1 as decimal(20, 0)) FROM t;
1044
1045 SELECT cast('1' as binary) <= cast(1 as decimal(3, 0)) FROM t;
1046 SELECT cast('1' as binary) <= cast(1 as decimal(5, 0)) FROM t;
1047 SELECT cast('1' as binary) <= cast(1 as decimal(10, 0)) FROM t;
1048 SELECT cast('1' as binary) <= cast(1 as decimal(20, 0)) FROM t;
1049
1050 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <= cast(1 as decimal(3, 0)) FROM t;
1051 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <= cast(1 as decimal(5, 0)) FROM t;
1052 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <= cast(1 as decimal(10, 0)) FROM t;
1053 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <= cast(1 as decimal(20, 0)) FROM t;
1054
1055 SELECT cast('2017-12-11 09:30:00' as date) <= cast(1 as decimal(3, 0)) FROM t;
1056 SELECT cast('2017-12-11 09:30:00' as date) <= cast(1 as decimal(5, 0)) FROM t;
1057 SELECT cast('2017-12-11 09:30:00' as date) <= cast(1 as decimal(10, 0)) FROM t;
1058 SELECT cast('2017-12-11 09:30:00' as date) <= cast(1 as decimal(20, 0)) FROM t;
1059
1060 SELECT cast(1 as decimal(3, 0))  <= cast(1 as tinyint) FROM t;
1061 SELECT cast(1 as decimal(5, 0))  <= cast(1 as tinyint) FROM t;
1062 SELECT cast(1 as decimal(10, 0)) <= cast(1 as tinyint) FROM t;
1063 SELECT cast(1 as decimal(20, 0)) <= cast(1 as tinyint) FROM t;
1064
1065 SELECT cast(1 as decimal(3, 0))  <= cast(1 as smallint) FROM t;
1066 SELECT cast(1 as decimal(5, 0))  <= cast(1 as smallint) FROM t;
1067 SELECT cast(1 as decimal(10, 0)) <= cast(1 as smallint) FROM t;
1068 SELECT cast(1 as decimal(20, 0)) <= cast(1 as smallint) FROM t;
1069
1070 SELECT cast(1 as decimal(3, 0))  <= cast(1 as int) FROM t;
1071 SELECT cast(1 as decimal(5, 0))  <= cast(1 as int) FROM t;
1072 SELECT cast(1 as decimal(10, 0)) <= cast(1 as int) FROM t;
1073 SELECT cast(1 as decimal(20, 0)) <= cast(1 as int) FROM t;
1074
1075 SELECT cast(1 as decimal(3, 0))  <= cast(1 as bigint) FROM t;
1076 SELECT cast(1 as decimal(5, 0))  <= cast(1 as bigint) FROM t;
1077 SELECT cast(1 as decimal(10, 0)) <= cast(1 as bigint) FROM t;
1078 SELECT cast(1 as decimal(20, 0)) <= cast(1 as bigint) FROM t;
1079
1080 SELECT cast(1 as decimal(3, 0))  <= cast(1 as float) FROM t;
1081 SELECT cast(1 as decimal(5, 0))  <= cast(1 as float) FROM t;
1082 SELECT cast(1 as decimal(10, 0)) <= cast(1 as float) FROM t;
1083 SELECT cast(1 as decimal(20, 0)) <= cast(1 as float) FROM t;
1084
1085 SELECT cast(1 as decimal(3, 0))  <= cast(1 as double) FROM t;
1086 SELECT cast(1 as decimal(5, 0))  <= cast(1 as double) FROM t;
1087 SELECT cast(1 as decimal(10, 0)) <= cast(1 as double) FROM t;
1088 SELECT cast(1 as decimal(20, 0)) <= cast(1 as double) FROM t;
1089
1090 SELECT cast(1 as decimal(3, 0))  <= cast(1 as decimal(10, 0)) FROM t;
1091 SELECT cast(1 as decimal(5, 0))  <= cast(1 as decimal(10, 0)) FROM t;
1092 SELECT cast(1 as decimal(10, 0)) <= cast(1 as decimal(10, 0)) FROM t;
1093 SELECT cast(1 as decimal(20, 0)) <= cast(1 as decimal(10, 0)) FROM t;
1094
1095 SELECT cast(1 as decimal(3, 0))  <= cast(1 as string) FROM t;
1096 SELECT cast(1 as decimal(5, 0))  <= cast(1 as string) FROM t;
1097 SELECT cast(1 as decimal(10, 0)) <= cast(1 as string) FROM t;
1098 SELECT cast(1 as decimal(20, 0)) <= cast(1 as string) FROM t;
1099
1100 SELECT cast(1 as decimal(3, 0))  <= cast('1' as binary) FROM t;
1101 SELECT cast(1 as decimal(5, 0))  <= cast('1' as binary) FROM t;
1102 SELECT cast(1 as decimal(10, 0)) <= cast('1' as binary) FROM t;
1103 SELECT cast(1 as decimal(20, 0)) <= cast('1' as binary) FROM t;
1104
1105 SELECT cast(1 as decimal(3, 0))  <= cast(1 as boolean) FROM t;
1106 SELECT cast(1 as decimal(5, 0))  <= cast(1 as boolean) FROM t;
1107 SELECT cast(1 as decimal(10, 0)) <= cast(1 as boolean) FROM t;
1108 SELECT cast(1 as decimal(20, 0)) <= cast(1 as boolean) FROM t;
1109
1110 SELECT cast(1 as decimal(3, 0))  <= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1111 SELECT cast(1 as decimal(5, 0))  <= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1112 SELECT cast(1 as decimal(10, 0)) <= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1113 SELECT cast(1 as decimal(20, 0)) <= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1114
1115 SELECT cast(1 as decimal(3, 0))  <= cast('2017-12-11 09:30:00' as date) FROM t;
1116 SELECT cast(1 as decimal(5, 0))  <= cast('2017-12-11 09:30:00' as date) FROM t;
1117 SELECT cast(1 as decimal(10, 0)) <= cast('2017-12-11 09:30:00' as date) FROM t;
1118 SELECT cast(1 as decimal(20, 0)) <= cast('2017-12-11 09:30:00' as date) FROM t;
1119
1120 SELECT cast(1 as tinyint) > cast(1 as decimal(3, 0)) FROM t;
1121 SELECT cast(1 as tinyint) > cast(1 as decimal(5, 0)) FROM t;
1122 SELECT cast(1 as tinyint) > cast(1 as decimal(10, 0)) FROM t;
1123 SELECT cast(1 as tinyint) > cast(1 as decimal(20, 0)) FROM t;
1124
1125 SELECT cast(1 as smallint) > cast(1 as decimal(3, 0)) FROM t;
1126 SELECT cast(1 as smallint) > cast(1 as decimal(5, 0)) FROM t;
1127 SELECT cast(1 as smallint) > cast(1 as decimal(10, 0)) FROM t;
1128 SELECT cast(1 as smallint) > cast(1 as decimal(20, 0)) FROM t;
1129
1130 SELECT cast(1 as int) > cast(1 as decimal(3, 0)) FROM t;
1131 SELECT cast(1 as int) > cast(1 as decimal(5, 0)) FROM t;
1132 SELECT cast(1 as int) > cast(1 as decimal(10, 0)) FROM t;
1133 SELECT cast(1 as int) > cast(1 as decimal(20, 0)) FROM t;
1134
1135 SELECT cast(1 as bigint) > cast(1 as decimal(3, 0)) FROM t;
1136 SELECT cast(1 as bigint) > cast(1 as decimal(5, 0)) FROM t;
1137 SELECT cast(1 as bigint) > cast(1 as decimal(10, 0)) FROM t;
1138 SELECT cast(1 as bigint) > cast(1 as decimal(20, 0)) FROM t;
1139
1140 SELECT cast(1 as float) > cast(1 as decimal(3, 0)) FROM t;
1141 SELECT cast(1 as float) > cast(1 as decimal(5, 0)) FROM t;
1142 SELECT cast(1 as float) > cast(1 as decimal(10, 0)) FROM t;
1143 SELECT cast(1 as float) > cast(1 as decimal(20, 0)) FROM t;
1144
1145 SELECT cast(1 as double) > cast(1 as decimal(3, 0)) FROM t;
1146 SELECT cast(1 as double) > cast(1 as decimal(5, 0)) FROM t;
1147 SELECT cast(1 as double) > cast(1 as decimal(10, 0)) FROM t;
1148 SELECT cast(1 as double) > cast(1 as decimal(20, 0)) FROM t;
1149
1150 SELECT cast(1 as decimal(10, 0)) > cast(1 as decimal(3, 0)) FROM t;
1151 SELECT cast(1 as decimal(10, 0)) > cast(1 as decimal(5, 0)) FROM t;
1152 SELECT cast(1 as decimal(10, 0)) > cast(1 as decimal(10, 0)) FROM t;
1153 SELECT cast(1 as decimal(10, 0)) > cast(1 as decimal(20, 0)) FROM t;
1154
1155 SELECT cast('1' as binary) > cast(1 as decimal(3, 0)) FROM t;
1156 SELECT cast('1' as binary) > cast(1 as decimal(5, 0)) FROM t;
1157 SELECT cast('1' as binary) > cast(1 as decimal(10, 0)) FROM t;
1158 SELECT cast('1' as binary) > cast(1 as decimal(20, 0)) FROM t;
1159
1160 SELECT cast('2017-12-11 09:30:00.0' as timestamp) > cast(1 as decimal(3, 0)) FROM t;
1161 SELECT cast('2017-12-11 09:30:00.0' as timestamp) > cast(1 as decimal(5, 0)) FROM t;
1162 SELECT cast('2017-12-11 09:30:00.0' as timestamp) > cast(1 as decimal(10, 0)) FROM t;
1163 SELECT cast('2017-12-11 09:30:00.0' as timestamp) > cast(1 as decimal(20, 0)) FROM t;
1164
1165 SELECT cast('2017-12-11 09:30:00' as date) > cast(1 as decimal(3, 0)) FROM t;
1166 SELECT cast('2017-12-11 09:30:00' as date) > cast(1 as decimal(5, 0)) FROM t;
1167 SELECT cast('2017-12-11 09:30:00' as date) > cast(1 as decimal(10, 0)) FROM t;
1168 SELECT cast('2017-12-11 09:30:00' as date) > cast(1 as decimal(20, 0)) FROM t;
1169
1170 SELECT cast(1 as decimal(3, 0))  > cast(1 as tinyint) FROM t;
1171 SELECT cast(1 as decimal(5, 0))  > cast(1 as tinyint) FROM t;
1172 SELECT cast(1 as decimal(10, 0)) > cast(1 as tinyint) FROM t;
1173 SELECT cast(1 as decimal(20, 0)) > cast(1 as tinyint) FROM t;
1174
1175 SELECT cast(1 as decimal(3, 0))  > cast(1 as smallint) FROM t;
1176 SELECT cast(1 as decimal(5, 0))  > cast(1 as smallint) FROM t;
1177 SELECT cast(1 as decimal(10, 0)) > cast(1 as smallint) FROM t;
1178 SELECT cast(1 as decimal(20, 0)) > cast(1 as smallint) FROM t;
1179
1180 SELECT cast(1 as decimal(3, 0))  > cast(1 as int) FROM t;
1181 SELECT cast(1 as decimal(5, 0))  > cast(1 as int) FROM t;
1182 SELECT cast(1 as decimal(10, 0)) > cast(1 as int) FROM t;
1183 SELECT cast(1 as decimal(20, 0)) > cast(1 as int) FROM t;
1184
1185 SELECT cast(1 as decimal(3, 0))  > cast(1 as bigint) FROM t;
1186 SELECT cast(1 as decimal(5, 0))  > cast(1 as bigint) FROM t;
1187 SELECT cast(1 as decimal(10, 0)) > cast(1 as bigint) FROM t;
1188 SELECT cast(1 as decimal(20, 0)) > cast(1 as bigint) FROM t;
1189
1190 SELECT cast(1 as decimal(3, 0))  > cast(1 as float) FROM t;
1191 SELECT cast(1 as decimal(5, 0))  > cast(1 as float) FROM t;
1192 SELECT cast(1 as decimal(10, 0)) > cast(1 as float) FROM t;
1193 SELECT cast(1 as decimal(20, 0)) > cast(1 as float) FROM t;
1194
1195 SELECT cast(1 as decimal(3, 0))  > cast(1 as double) FROM t;
1196 SELECT cast(1 as decimal(5, 0))  > cast(1 as double) FROM t;
1197 SELECT cast(1 as decimal(10, 0)) > cast(1 as double) FROM t;
1198 SELECT cast(1 as decimal(20, 0)) > cast(1 as double) FROM t;
1199
1200 SELECT cast(1 as decimal(3, 0))  > cast(1 as decimal(10, 0)) FROM t;
1201 SELECT cast(1 as decimal(5, 0))  > cast(1 as decimal(10, 0)) FROM t;
1202 SELECT cast(1 as decimal(10, 0)) > cast(1 as decimal(10, 0)) FROM t;
1203 SELECT cast(1 as decimal(20, 0)) > cast(1 as decimal(10, 0)) FROM t;
1204
1205 SELECT cast(1 as decimal(3, 0))  > cast(1 as string) FROM t;
1206 SELECT cast(1 as decimal(5, 0))  > cast(1 as string) FROM t;
1207 SELECT cast(1 as decimal(10, 0)) > cast(1 as string) FROM t;
1208 SELECT cast(1 as decimal(20, 0)) > cast(1 as string) FROM t;
1209
1210 SELECT cast(1 as decimal(3, 0))  > cast('1' as binary) FROM t;
1211 SELECT cast(1 as decimal(5, 0))  > cast('1' as binary) FROM t;
1212 SELECT cast(1 as decimal(10, 0)) > cast('1' as binary) FROM t;
1213 SELECT cast(1 as decimal(20, 0)) > cast('1' as binary) FROM t;
1214
1215 SELECT cast(1 as decimal(3, 0))  > cast(1 as boolean) FROM t;
1216 SELECT cast(1 as decimal(5, 0))  > cast(1 as boolean) FROM t;
1217 SELECT cast(1 as decimal(10, 0)) > cast(1 as boolean) FROM t;
1218 SELECT cast(1 as decimal(20, 0)) > cast(1 as boolean) FROM t;
1219
1220 SELECT cast(1 as decimal(3, 0))  > cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1221 SELECT cast(1 as decimal(5, 0))  > cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1222 SELECT cast(1 as decimal(10, 0)) > cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1223 SELECT cast(1 as decimal(20, 0)) > cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1224
1225 SELECT cast(1 as decimal(3, 0))  > cast('2017-12-11 09:30:00' as date) FROM t;
1226 SELECT cast(1 as decimal(5, 0))  > cast('2017-12-11 09:30:00' as date) FROM t;
1227 SELECT cast(1 as decimal(10, 0)) > cast('2017-12-11 09:30:00' as date) FROM t;
1228 SELECT cast(1 as decimal(20, 0)) > cast('2017-12-11 09:30:00' as date) FROM t;
1229
1230 SELECT cast(1 as tinyint) >= cast(1 as decimal(3, 0)) FROM t;
1231 SELECT cast(1 as tinyint) >= cast(1 as decimal(5, 0)) FROM t;
1232 SELECT cast(1 as tinyint) >= cast(1 as decimal(10, 0)) FROM t;
1233 SELECT cast(1 as tinyint) >= cast(1 as decimal(20, 0)) FROM t;
1234
1235 SELECT cast(1 as smallint) >= cast(1 as decimal(3, 0)) FROM t;
1236 SELECT cast(1 as smallint) >= cast(1 as decimal(5, 0)) FROM t;
1237 SELECT cast(1 as smallint) >= cast(1 as decimal(10, 0)) FROM t;
1238 SELECT cast(1 as smallint) >= cast(1 as decimal(20, 0)) FROM t;
1239
1240 SELECT cast(1 as int) >= cast(1 as decimal(3, 0)) FROM t;
1241 SELECT cast(1 as int) >= cast(1 as decimal(5, 0)) FROM t;
1242 SELECT cast(1 as int) >= cast(1 as decimal(10, 0)) FROM t;
1243 SELECT cast(1 as int) >= cast(1 as decimal(20, 0)) FROM t;
1244
1245 SELECT cast(1 as bigint) >= cast(1 as decimal(3, 0)) FROM t;
1246 SELECT cast(1 as bigint) >= cast(1 as decimal(5, 0)) FROM t;
1247 SELECT cast(1 as bigint) >= cast(1 as decimal(10, 0)) FROM t;
1248 SELECT cast(1 as bigint) >= cast(1 as decimal(20, 0)) FROM t;
1249
1250 SELECT cast(1 as float) >= cast(1 as decimal(3, 0)) FROM t;
1251 SELECT cast(1 as float) >= cast(1 as decimal(5, 0)) FROM t;
1252 SELECT cast(1 as float) >= cast(1 as decimal(10, 0)) FROM t;
1253 SELECT cast(1 as float) >= cast(1 as decimal(20, 0)) FROM t;
1254
1255 SELECT cast(1 as double) >= cast(1 as decimal(3, 0)) FROM t;
1256 SELECT cast(1 as double) >= cast(1 as decimal(5, 0)) FROM t;
1257 SELECT cast(1 as double) >= cast(1 as decimal(10, 0)) FROM t;
1258 SELECT cast(1 as double) >= cast(1 as decimal(20, 0)) FROM t;
1259
1260 SELECT cast(1 as decimal(10, 0)) >= cast(1 as decimal(3, 0)) FROM t;
1261 SELECT cast(1 as decimal(10, 0)) >= cast(1 as decimal(5, 0)) FROM t;
1262 SELECT cast(1 as decimal(10, 0)) >= cast(1 as decimal(10, 0)) FROM t;
1263 SELECT cast(1 as decimal(10, 0)) >= cast(1 as decimal(20, 0)) FROM t;
1264
1265 SELECT cast('1' as binary) >= cast(1 as decimal(3, 0)) FROM t;
1266 SELECT cast('1' as binary) >= cast(1 as decimal(5, 0)) FROM t;
1267 SELECT cast('1' as binary) >= cast(1 as decimal(10, 0)) FROM t;
1268 SELECT cast('1' as binary) >= cast(1 as decimal(20, 0)) FROM t;
1269
1270 SELECT cast('2017-12-11 09:30:00.0' as timestamp) >= cast(1 as decimal(3, 0)) FROM t;
1271 SELECT cast('2017-12-11 09:30:00.0' as timestamp) >= cast(1 as decimal(5, 0)) FROM t;
1272 SELECT cast('2017-12-11 09:30:00.0' as timestamp) >= cast(1 as decimal(10, 0)) FROM t;
1273 SELECT cast('2017-12-11 09:30:00.0' as timestamp) >= cast(1 as decimal(20, 0)) FROM t;
1274
1275 SELECT cast('2017-12-11 09:30:00' as date) >= cast(1 as decimal(3, 0)) FROM t;
1276 SELECT cast('2017-12-11 09:30:00' as date) >= cast(1 as decimal(5, 0)) FROM t;
1277 SELECT cast('2017-12-11 09:30:00' as date) >= cast(1 as decimal(10, 0)) FROM t;
1278 SELECT cast('2017-12-11 09:30:00' as date) >= cast(1 as decimal(20, 0)) FROM t;
1279
1280 SELECT cast(1 as decimal(3, 0))  >= cast(1 as tinyint) FROM t;
1281 SELECT cast(1 as decimal(5, 0))  >= cast(1 as tinyint) FROM t;
1282 SELECT cast(1 as decimal(10, 0)) >= cast(1 as tinyint) FROM t;
1283 SELECT cast(1 as decimal(20, 0)) >= cast(1 as tinyint) FROM t;
1284
1285 SELECT cast(1 as decimal(3, 0))  >= cast(1 as smallint) FROM t;
1286 SELECT cast(1 as decimal(5, 0))  >= cast(1 as smallint) FROM t;
1287 SELECT cast(1 as decimal(10, 0)) >= cast(1 as smallint) FROM t;
1288 SELECT cast(1 as decimal(20, 0)) >= cast(1 as smallint) FROM t;
1289
1290 SELECT cast(1 as decimal(3, 0))  >= cast(1 as int) FROM t;
1291 SELECT cast(1 as decimal(5, 0))  >= cast(1 as int) FROM t;
1292 SELECT cast(1 as decimal(10, 0)) >= cast(1 as int) FROM t;
1293 SELECT cast(1 as decimal(20, 0)) >= cast(1 as int) FROM t;
1294
1295 SELECT cast(1 as decimal(3, 0))  >= cast(1 as bigint) FROM t;
1296 SELECT cast(1 as decimal(5, 0))  >= cast(1 as bigint) FROM t;
1297 SELECT cast(1 as decimal(10, 0)) >= cast(1 as bigint) FROM t;
1298 SELECT cast(1 as decimal(20, 0)) >= cast(1 as bigint) FROM t;
1299
1300 SELECT cast(1 as decimal(3, 0))  >= cast(1 as float) FROM t;
1301 SELECT cast(1 as decimal(5, 0))  >= cast(1 as float) FROM t;
1302 SELECT cast(1 as decimal(10, 0)) >= cast(1 as float) FROM t;
1303 SELECT cast(1 as decimal(20, 0)) >= cast(1 as float) FROM t;
1304
1305 SELECT cast(1 as decimal(3, 0))  >= cast(1 as double) FROM t;
1306 SELECT cast(1 as decimal(5, 0))  >= cast(1 as double) FROM t;
1307 SELECT cast(1 as decimal(10, 0)) >= cast(1 as double) FROM t;
1308 SELECT cast(1 as decimal(20, 0)) >= cast(1 as double) FROM t;
1309
1310 SELECT cast(1 as decimal(3, 0))  >= cast(1 as decimal(10, 0)) FROM t;
1311 SELECT cast(1 as decimal(5, 0))  >= cast(1 as decimal(10, 0)) FROM t;
1312 SELECT cast(1 as decimal(10, 0)) >= cast(1 as decimal(10, 0)) FROM t;
1313 SELECT cast(1 as decimal(20, 0)) >= cast(1 as decimal(10, 0)) FROM t;
1314
1315 SELECT cast(1 as decimal(3, 0))  >= cast(1 as string) FROM t;
1316 SELECT cast(1 as decimal(5, 0))  >= cast(1 as string) FROM t;
1317 SELECT cast(1 as decimal(10, 0)) >= cast(1 as string) FROM t;
1318 SELECT cast(1 as decimal(20, 0)) >= cast(1 as string) FROM t;
1319
1320 SELECT cast(1 as decimal(3, 0))  >= cast('1' as binary) FROM t;
1321 SELECT cast(1 as decimal(5, 0))  >= cast('1' as binary) FROM t;
1322 SELECT cast(1 as decimal(10, 0)) >= cast('1' as binary) FROM t;
1323 SELECT cast(1 as decimal(20, 0)) >= cast('1' as binary) FROM t;
1324
1325 SELECT cast(1 as decimal(3, 0))  >= cast(1 as boolean) FROM t;
1326 SELECT cast(1 as decimal(5, 0))  >= cast(1 as boolean) FROM t;
1327 SELECT cast(1 as decimal(10, 0)) >= cast(1 as boolean) FROM t;
1328 SELECT cast(1 as decimal(20, 0)) >= cast(1 as boolean) FROM t;
1329
1330 SELECT cast(1 as decimal(3, 0))  >= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1331 SELECT cast(1 as decimal(5, 0))  >= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1332 SELECT cast(1 as decimal(10, 0)) >= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1333 SELECT cast(1 as decimal(20, 0)) >= cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1334
1335 SELECT cast(1 as decimal(3, 0))  >= cast('2017-12-11 09:30:00' as date) FROM t;
1336 SELECT cast(1 as decimal(5, 0))  >= cast('2017-12-11 09:30:00' as date) FROM t;
1337 SELECT cast(1 as decimal(10, 0)) >= cast('2017-12-11 09:30:00' as date) FROM t;
1338 SELECT cast(1 as decimal(20, 0)) >= cast('2017-12-11 09:30:00' as date) FROM t;
1339
1340 SELECT cast(1 as tinyint) <> cast(1 as decimal(3, 0)) FROM t;
1341 SELECT cast(1 as tinyint) <> cast(1 as decimal(5, 0)) FROM t;
1342 SELECT cast(1 as tinyint) <> cast(1 as decimal(10, 0)) FROM t;
1343 SELECT cast(1 as tinyint) <> cast(1 as decimal(20, 0)) FROM t;
1344
1345 SELECT cast(1 as smallint) <> cast(1 as decimal(3, 0)) FROM t;
1346 SELECT cast(1 as smallint) <> cast(1 as decimal(5, 0)) FROM t;
1347 SELECT cast(1 as smallint) <> cast(1 as decimal(10, 0)) FROM t;
1348 SELECT cast(1 as smallint) <> cast(1 as decimal(20, 0)) FROM t;
1349
1350 SELECT cast(1 as int) <> cast(1 as decimal(3, 0)) FROM t;
1351 SELECT cast(1 as int) <> cast(1 as decimal(5, 0)) FROM t;
1352 SELECT cast(1 as int) <> cast(1 as decimal(10, 0)) FROM t;
1353 SELECT cast(1 as int) <> cast(1 as decimal(20, 0)) FROM t;
1354
1355 SELECT cast(1 as bigint) <> cast(1 as decimal(3, 0)) FROM t;
1356 SELECT cast(1 as bigint) <> cast(1 as decimal(5, 0)) FROM t;
1357 SELECT cast(1 as bigint) <> cast(1 as decimal(10, 0)) FROM t;
1358 SELECT cast(1 as bigint) <> cast(1 as decimal(20, 0)) FROM t;
1359
1360 SELECT cast(1 as float) <> cast(1 as decimal(3, 0)) FROM t;
1361 SELECT cast(1 as float) <> cast(1 as decimal(5, 0)) FROM t;
1362 SELECT cast(1 as float) <> cast(1 as decimal(10, 0)) FROM t;
1363 SELECT cast(1 as float) <> cast(1 as decimal(20, 0)) FROM t;
1364
1365 SELECT cast(1 as double) <> cast(1 as decimal(3, 0)) FROM t;
1366 SELECT cast(1 as double) <> cast(1 as decimal(5, 0)) FROM t;
1367 SELECT cast(1 as double) <> cast(1 as decimal(10, 0)) FROM t;
1368 SELECT cast(1 as double) <> cast(1 as decimal(20, 0)) FROM t;
1369
1370 SELECT cast(1 as decimal(10, 0)) <> cast(1 as decimal(3, 0)) FROM t;
1371 SELECT cast(1 as decimal(10, 0)) <> cast(1 as decimal(5, 0)) FROM t;
1372 SELECT cast(1 as decimal(10, 0)) <> cast(1 as decimal(10, 0)) FROM t;
1373 SELECT cast(1 as decimal(10, 0)) <> cast(1 as decimal(20, 0)) FROM t;
1374
1375 SELECT cast('1' as binary) <> cast(1 as decimal(3, 0)) FROM t;
1376 SELECT cast('1' as binary) <> cast(1 as decimal(5, 0)) FROM t;
1377 SELECT cast('1' as binary) <> cast(1 as decimal(10, 0)) FROM t;
1378 SELECT cast('1' as binary) <> cast(1 as decimal(20, 0)) FROM t;
1379
1380 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <> cast(1 as decimal(3, 0)) FROM t;
1381 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <> cast(1 as decimal(5, 0)) FROM t;
1382 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <> cast(1 as decimal(10, 0)) FROM t;
1383 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <> cast(1 as decimal(20, 0)) FROM t;
1384
1385 SELECT cast('2017-12-11 09:30:00' as date) <> cast(1 as decimal(3, 0)) FROM t;
1386 SELECT cast('2017-12-11 09:30:00' as date) <> cast(1 as decimal(5, 0)) FROM t;
1387 SELECT cast('2017-12-11 09:30:00' as date) <> cast(1 as decimal(10, 0)) FROM t;
1388 SELECT cast('2017-12-11 09:30:00' as date) <> cast(1 as decimal(20, 0)) FROM t;
1389
1390 SELECT cast(1 as decimal(3, 0))  <> cast(1 as tinyint) FROM t;
1391 SELECT cast(1 as decimal(5, 0))  <> cast(1 as tinyint) FROM t;
1392 SELECT cast(1 as decimal(10, 0)) <> cast(1 as tinyint) FROM t;
1393 SELECT cast(1 as decimal(20, 0)) <> cast(1 as tinyint) FROM t;
1394
1395 SELECT cast(1 as decimal(3, 0))  <> cast(1 as smallint) FROM t;
1396 SELECT cast(1 as decimal(5, 0))  <> cast(1 as smallint) FROM t;
1397 SELECT cast(1 as decimal(10, 0)) <> cast(1 as smallint) FROM t;
1398 SELECT cast(1 as decimal(20, 0)) <> cast(1 as smallint) FROM t;
1399
1400 SELECT cast(1 as decimal(3, 0))  <> cast(1 as int) FROM t;
1401 SELECT cast(1 as decimal(5, 0))  <> cast(1 as int) FROM t;
1402 SELECT cast(1 as decimal(10, 0)) <> cast(1 as int) FROM t;
1403 SELECT cast(1 as decimal(20, 0)) <> cast(1 as int) FROM t;
1404
1405 SELECT cast(1 as decimal(3, 0))  <> cast(1 as bigint) FROM t;
1406 SELECT cast(1 as decimal(5, 0))  <> cast(1 as bigint) FROM t;
1407 SELECT cast(1 as decimal(10, 0)) <> cast(1 as bigint) FROM t;
1408 SELECT cast(1 as decimal(20, 0)) <> cast(1 as bigint) FROM t;
1409
1410 SELECT cast(1 as decimal(3, 0))  <> cast(1 as float) FROM t;
1411 SELECT cast(1 as decimal(5, 0))  <> cast(1 as float) FROM t;
1412 SELECT cast(1 as decimal(10, 0)) <> cast(1 as float) FROM t;
1413 SELECT cast(1 as decimal(20, 0)) <> cast(1 as float) FROM t;
1414
1415 SELECT cast(1 as decimal(3, 0))  <> cast(1 as double) FROM t;
1416 SELECT cast(1 as decimal(5, 0))  <> cast(1 as double) FROM t;
1417 SELECT cast(1 as decimal(10, 0)) <> cast(1 as double) FROM t;
1418 SELECT cast(1 as decimal(20, 0)) <> cast(1 as double) FROM t;
1419
1420 SELECT cast(1 as decimal(3, 0))  <> cast(1 as decimal(10, 0)) FROM t;
1421 SELECT cast(1 as decimal(5, 0))  <> cast(1 as decimal(10, 0)) FROM t;
1422 SELECT cast(1 as decimal(10, 0)) <> cast(1 as decimal(10, 0)) FROM t;
1423 SELECT cast(1 as decimal(20, 0)) <> cast(1 as decimal(10, 0)) FROM t;
1424
1425 SELECT cast(1 as decimal(3, 0))  <> cast(1 as string) FROM t;
1426 SELECT cast(1 as decimal(5, 0))  <> cast(1 as string) FROM t;
1427 SELECT cast(1 as decimal(10, 0)) <> cast(1 as string) FROM t;
1428 SELECT cast(1 as decimal(20, 0)) <> cast(1 as string) FROM t;
1429
1430 SELECT cast(1 as decimal(3, 0))  <> cast('1' as binary) FROM t;
1431 SELECT cast(1 as decimal(5, 0))  <> cast('1' as binary) FROM t;
1432 SELECT cast(1 as decimal(10, 0)) <> cast('1' as binary) FROM t;
1433 SELECT cast(1 as decimal(20, 0)) <> cast('1' as binary) FROM t;
1434
1435 SELECT cast(1 as decimal(3, 0))  <> cast(1 as boolean) FROM t;
1436 SELECT cast(1 as decimal(5, 0))  <> cast(1 as boolean) FROM t;
1437 SELECT cast(1 as decimal(10, 0)) <> cast(1 as boolean) FROM t;
1438 SELECT cast(1 as decimal(20, 0)) <> cast(1 as boolean) FROM t;
1439
1440 SELECT cast(1 as decimal(3, 0))  <> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1441 SELECT cast(1 as decimal(5, 0))  <> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1442 SELECT cast(1 as decimal(10, 0)) <> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1443 SELECT cast(1 as decimal(20, 0)) <> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
1444
1445 SELECT cast(1 as decimal(3, 0))  <> cast('2017-12-11 09:30:00' as date) FROM t;
1446 SELECT cast(1 as decimal(5, 0))  <> cast('2017-12-11 09:30:00' as date) FROM t;
1447 SELECT cast(1 as decimal(10, 0)) <> cast('2017-12-11 09:30:00' as date) FROM t;
1448 SELECT cast(1 as decimal(20, 0)) <> cast('2017-12-11 09:30:00' as date) FROM t;