typeCoercion/native/booleanEquality.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 true = cast(1 as tinyint) FROM t;
0021 SELECT true = cast(1 as smallint) FROM t;
0022 SELECT true = cast(1 as int) FROM t;
0023 SELECT true = cast(1 as bigint) FROM t;
0024 SELECT true = cast(1 as float) FROM t;
0025 SELECT true = cast(1 as double) FROM t;
0026 SELECT true = cast(1 as decimal(10, 0)) FROM t;
0027 SELECT true = cast(1 as string) FROM t;
0028 SELECT true = cast('1' as binary) FROM t;
0029 SELECT true = cast(1 as boolean) FROM t;
0030 SELECT true = cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0031 SELECT true = cast('2017-12-11 09:30:00' as date) FROM t;
0032
0033 SELECT true <=> cast(1 as tinyint) FROM t;
0034 SELECT true <=> cast(1 as smallint) FROM t;
0035 SELECT true <=> cast(1 as int) FROM t;
0036 SELECT true <=> cast(1 as bigint) FROM t;
0037 SELECT true <=> cast(1 as float) FROM t;
0038 SELECT true <=> cast(1 as double) FROM t;
0039 SELECT true <=> cast(1 as decimal(10, 0)) FROM t;
0040 SELECT true <=> cast(1 as string) FROM t;
0041 SELECT true <=> cast('1' as binary) FROM t;
0042 SELECT true <=> cast(1 as boolean) FROM t;
0043 SELECT true <=> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0044 SELECT true <=> cast('2017-12-11 09:30:00' as date) FROM t;
0045
0046 SELECT cast(1 as tinyint) = true FROM t;
0047 SELECT cast(1 as smallint) = true FROM t;
0048 SELECT cast(1 as int) = true FROM t;
0049 SELECT cast(1 as bigint) = true FROM t;
0050 SELECT cast(1 as float) = true FROM t;
0051 SELECT cast(1 as double) = true FROM t;
0052 SELECT cast(1 as decimal(10, 0)) = true FROM t;
0053 SELECT cast(1 as string) = true FROM t;
0054 SELECT cast('1' as binary) = true FROM t;
0055 SELECT cast(1 as boolean) = true FROM t;
0056 SELECT cast('2017-12-11 09:30:00.0' as timestamp) = true FROM t;
0057 SELECT cast('2017-12-11 09:30:00' as date) = true FROM t;
0058
0059 SELECT cast(1 as tinyint) <=> true FROM t;
0060 SELECT cast(1 as smallint) <=> true FROM t;
0061 SELECT cast(1 as int) <=> true FROM t;
0062 SELECT cast(1 as bigint) <=> true FROM t;
0063 SELECT cast(1 as float) <=> true FROM t;
0064 SELECT cast(1 as double) <=> true FROM t;
0065 SELECT cast(1 as decimal(10, 0)) <=> true FROM t;
0066 SELECT cast(1 as string) <=> true FROM t;
0067 SELECT cast('1' as binary) <=> true FROM t;
0068 SELECT cast(1 as boolean) <=> true FROM t;
0069 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <=> true FROM t;
0070 SELECT cast('2017-12-11 09:30:00' as date) <=> true FROM t;
0071
0072 SELECT false = cast(0 as tinyint) FROM t;
0073 SELECT false = cast(0 as smallint) FROM t;
0074 SELECT false = cast(0 as int) FROM t;
0075 SELECT false = cast(0 as bigint) FROM t;
0076 SELECT false = cast(0 as float) FROM t;
0077 SELECT false = cast(0 as double) FROM t;
0078 SELECT false = cast(0 as decimal(10, 0)) FROM t;
0079 SELECT false = cast(0 as string) FROM t;
0080 SELECT false = cast('0' as binary) FROM t;
0081 SELECT false = cast(0 as boolean) FROM t;
0082 SELECT false = cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0083 SELECT false = cast('2017-12-11 09:30:00' as date) FROM t;
0084
0085 SELECT false <=> cast(0 as tinyint) FROM t;
0086 SELECT false <=> cast(0 as smallint) FROM t;
0087 SELECT false <=> cast(0 as int) FROM t;
0088 SELECT false <=> cast(0 as bigint) FROM t;
0089 SELECT false <=> cast(0 as float) FROM t;
0090 SELECT false <=> cast(0 as double) FROM t;
0091 SELECT false <=> cast(0 as decimal(10, 0)) FROM t;
0092 SELECT false <=> cast(0 as string) FROM t;
0093 SELECT false <=> cast('0' as binary) FROM t;
0094 SELECT false <=> cast(0 as boolean) FROM t;
0095 SELECT false <=> cast('2017-12-11 09:30:00.0' as timestamp) FROM t;
0096 SELECT false <=> cast('2017-12-11 09:30:00' as date) FROM t;
0097
0098 SELECT cast(0 as tinyint) = false FROM t;
0099 SELECT cast(0 as smallint) = false FROM t;
0100 SELECT cast(0 as int) = false FROM t;
0101 SELECT cast(0 as bigint) = false FROM t;
0102 SELECT cast(0 as float) = false FROM t;
0103 SELECT cast(0 as double) = false FROM t;
0104 SELECT cast(0 as decimal(10, 0)) = false FROM t;
0105 SELECT cast(0 as string) = false FROM t;
0106 SELECT cast('0' as binary) = false FROM t;
0107 SELECT cast(0 as boolean) = false FROM t;
0108 SELECT cast('2017-12-11 09:30:00.0' as timestamp) = false FROM t;
0109 SELECT cast('2017-12-11 09:30:00' as date) = false FROM t;
0110
0111 SELECT cast(0 as tinyint) <=> false FROM t;
0112 SELECT cast(0 as smallint) <=> false FROM t;
0113 SELECT cast(0 as int) <=> false FROM t;
0114 SELECT cast(0 as bigint) <=> false FROM t;
0115 SELECT cast(0 as float) <=> false FROM t;
0116 SELECT cast(0 as double) <=> false FROM t;
0117 SELECT cast(0 as decimal(10, 0)) <=> false FROM t;
0118 SELECT cast(0 as string) <=> false FROM t;
0119 SELECT cast('0' as binary) <=> false FROM t;
0120 SELECT cast(0 as boolean) <=> false FROM t;
0121 SELECT cast('2017-12-11 09:30:00.0' as timestamp) <=> false FROM t;
0122 SELECT cast('2017-12-11 09:30:00' as date) <=> false FROM t;