[SPARK-22726][TEST] Basic tests for Binary Comparison and ImplicitTypeCasts
## What changes were proposed in this pull request? Before we deliver the Hive compatibility mode, we plan to write a set of test cases that can be easily run in both Spark and Hive sides. We can easily compare whether they are the same or not. When new typeCoercion rules are added, we also can easily track the changes. These test cases can also be backported to the previous Spark versions for determining the changes we made. This PR is the first attempt for improving the test coverage for type coercion compatibility. We generate these test cases for our binary comparison and ImplicitTypeCasts based on the Apache Derby test cases in https://github.com/apache/derby/blob/10.14/java/testing/org/apache/derbyTesting/functionTests/tests/lang/implicitConversions.sql ## How was this patch tested? N/A Author: gatorsmile <gatorsm...@gmail.com> Closes #19918 from gatorsmile/typeCoercionTests. Project: http://git-wip-us.apache.org/repos/asf/spark/repo Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/3d82f6eb Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/3d82f6eb Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/3d82f6eb Branch: refs/heads/master Commit: 3d82f6eb782315b05453b3a0334d3bc05ab4298a Parents: 3f4060c Author: gatorsmile <gatorsm...@gmail.com> Authored: Mon Dec 11 15:55:23 2017 -0800 Committer: gatorsmile <gatorsm...@gmail.com> Committed: Mon Dec 11 15:55:23 2017 -0800 ---------------------------------------------------------------------- .../typeCoercion/native/binaryComparison.sql | 287 +++ .../typeCoercion/native/implicitTypeCasts.sql | 72 + .../sql-tests/results/datetime.sql.out | 2 + .../results/predicate-functions.sql.out | 152 +- .../native/binaryComparison.sql.out | 2146 ++++++++++++++++++ .../native/implicitTypeCasts.sql.out | 354 +++ .../apache/spark/sql/SQLQueryTestSuite.scala | 2 +- .../org/apache/spark/sql/TPCDSQuerySuite.scala | 2 +- .../hive/execution/HiveCompatibilitySuite.scala | 2 +- 9 files changed, 2940 insertions(+), 79 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/spark/blob/3d82f6eb/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/binaryComparison.sql ---------------------------------------------------------------------- diff --git a/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/binaryComparison.sql b/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/binaryComparison.sql new file mode 100644 index 0000000..522322a --- /dev/null +++ b/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/binaryComparison.sql @@ -0,0 +1,287 @@ +-- +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. +-- + +-- Binary Comparison + +CREATE TEMPORARY VIEW t AS SELECT 1; + +SELECT cast(1 as binary) = '1' FROM t; +SELECT cast(1 as binary) > '2' FROM t; +SELECT cast(1 as binary) >= '2' FROM t; +SELECT cast(1 as binary) < '2' FROM t; +SELECT cast(1 as binary) <= '2' FROM t; +SELECT cast(1 as binary) <> '2' FROM t; +SELECT cast(1 as binary) = cast(null as string) FROM t; +SELECT cast(1 as binary) > cast(null as string) FROM t; +SELECT cast(1 as binary) >= cast(null as string) FROM t; +SELECT cast(1 as binary) < cast(null as string) FROM t; +SELECT cast(1 as binary) <= cast(null as string) FROM t; +SELECT cast(1 as binary) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as binary) FROM t; +SELECT '2' > cast(1 as binary) FROM t; +SELECT '2' >= cast(1 as binary) FROM t; +SELECT '2' < cast(1 as binary) FROM t; +SELECT '2' <= cast(1 as binary) FROM t; +SELECT '2' <> cast(1 as binary) FROM t; +SELECT cast(null as string) = cast(1 as binary) FROM t; +SELECT cast(null as string) > cast(1 as binary) FROM t; +SELECT cast(null as string) >= cast(1 as binary) FROM t; +SELECT cast(null as string) < cast(1 as binary) FROM t; +SELECT cast(null as string) <= cast(1 as binary) FROM t; +SELECT cast(null as string) <> cast(1 as binary) FROM t; +SELECT cast(1 as tinyint) = '1' FROM t; +SELECT cast(1 as tinyint) > '2' FROM t; +SELECT cast(1 as tinyint) >= '2' FROM t; +SELECT cast(1 as tinyint) < '2' FROM t; +SELECT cast(1 as tinyint) <= '2' FROM t; +SELECT cast(1 as tinyint) <> '2' FROM t; +SELECT cast(1 as tinyint) = cast(null as string) FROM t; +SELECT cast(1 as tinyint) > cast(null as string) FROM t; +SELECT cast(1 as tinyint) >= cast(null as string) FROM t; +SELECT cast(1 as tinyint) < cast(null as string) FROM t; +SELECT cast(1 as tinyint) <= cast(null as string) FROM t; +SELECT cast(1 as tinyint) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as tinyint) FROM t; +SELECT '2' > cast(1 as tinyint) FROM t; +SELECT '2' >= cast(1 as tinyint) FROM t; +SELECT '2' < cast(1 as tinyint) FROM t; +SELECT '2' <= cast(1 as tinyint) FROM t; +SELECT '2' <> cast(1 as tinyint) FROM t; +SELECT cast(null as string) = cast(1 as tinyint) FROM t; +SELECT cast(null as string) > cast(1 as tinyint) FROM t; +SELECT cast(null as string) >= cast(1 as tinyint) FROM t; +SELECT cast(null as string) < cast(1 as tinyint) FROM t; +SELECT cast(null as string) <= cast(1 as tinyint) FROM t; +SELECT cast(null as string) <> cast(1 as tinyint) FROM t; +SELECT cast(1 as smallint) = '1' FROM t; +SELECT cast(1 as smallint) > '2' FROM t; +SELECT cast(1 as smallint) >= '2' FROM t; +SELECT cast(1 as smallint) < '2' FROM t; +SELECT cast(1 as smallint) <= '2' FROM t; +SELECT cast(1 as smallint) <> '2' FROM t; +SELECT cast(1 as smallint) = cast(null as string) FROM t; +SELECT cast(1 as smallint) > cast(null as string) FROM t; +SELECT cast(1 as smallint) >= cast(null as string) FROM t; +SELECT cast(1 as smallint) < cast(null as string) FROM t; +SELECT cast(1 as smallint) <= cast(null as string) FROM t; +SELECT cast(1 as smallint) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as smallint) FROM t; +SELECT '2' > cast(1 as smallint) FROM t; +SELECT '2' >= cast(1 as smallint) FROM t; +SELECT '2' < cast(1 as smallint) FROM t; +SELECT '2' <= cast(1 as smallint) FROM t; +SELECT '2' <> cast(1 as smallint) FROM t; +SELECT cast(null as string) = cast(1 as smallint) FROM t; +SELECT cast(null as string) > cast(1 as smallint) FROM t; +SELECT cast(null as string) >= cast(1 as smallint) FROM t; +SELECT cast(null as string) < cast(1 as smallint) FROM t; +SELECT cast(null as string) <= cast(1 as smallint) FROM t; +SELECT cast(null as string) <> cast(1 as smallint) FROM t; +SELECT cast(1 as int) = '1' FROM t; +SELECT cast(1 as int) > '2' FROM t; +SELECT cast(1 as int) >= '2' FROM t; +SELECT cast(1 as int) < '2' FROM t; +SELECT cast(1 as int) <= '2' FROM t; +SELECT cast(1 as int) <> '2' FROM t; +SELECT cast(1 as int) = cast(null as string) FROM t; +SELECT cast(1 as int) > cast(null as string) FROM t; +SELECT cast(1 as int) >= cast(null as string) FROM t; +SELECT cast(1 as int) < cast(null as string) FROM t; +SELECT cast(1 as int) <= cast(null as string) FROM t; +SELECT cast(1 as int) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as int) FROM t; +SELECT '2' > cast(1 as int) FROM t; +SELECT '2' >= cast(1 as int) FROM t; +SELECT '2' < cast(1 as int) FROM t; +SELECT '2' <> cast(1 as int) FROM t; +SELECT '2' <= cast(1 as int) FROM t; +SELECT cast(null as string) = cast(1 as int) FROM t; +SELECT cast(null as string) > cast(1 as int) FROM t; +SELECT cast(null as string) >= cast(1 as int) FROM t; +SELECT cast(null as string) < cast(1 as int) FROM t; +SELECT cast(null as string) <> cast(1 as int) FROM t; +SELECT cast(null as string) <= cast(1 as int) FROM t; +SELECT cast(1 as bigint) = '1' FROM t; +SELECT cast(1 as bigint) > '2' FROM t; +SELECT cast(1 as bigint) >= '2' FROM t; +SELECT cast(1 as bigint) < '2' FROM t; +SELECT cast(1 as bigint) <= '2' FROM t; +SELECT cast(1 as bigint) <> '2' FROM t; +SELECT cast(1 as bigint) = cast(null as string) FROM t; +SELECT cast(1 as bigint) > cast(null as string) FROM t; +SELECT cast(1 as bigint) >= cast(null as string) FROM t; +SELECT cast(1 as bigint) < cast(null as string) FROM t; +SELECT cast(1 as bigint) <= cast(null as string) FROM t; +SELECT cast(1 as bigint) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as bigint) FROM t; +SELECT '2' > cast(1 as bigint) FROM t; +SELECT '2' >= cast(1 as bigint) FROM t; +SELECT '2' < cast(1 as bigint) FROM t; +SELECT '2' <= cast(1 as bigint) FROM t; +SELECT '2' <> cast(1 as bigint) FROM t; +SELECT cast(null as string) = cast(1 as bigint) FROM t; +SELECT cast(null as string) > cast(1 as bigint) FROM t; +SELECT cast(null as string) >= cast(1 as bigint) FROM t; +SELECT cast(null as string) < cast(1 as bigint) FROM t; +SELECT cast(null as string) <= cast(1 as bigint) FROM t; +SELECT cast(null as string) <> cast(1 as bigint) FROM t; +SELECT cast(1 as decimal(10, 0)) = '1' FROM t; +SELECT cast(1 as decimal(10, 0)) > '2' FROM t; +SELECT cast(1 as decimal(10, 0)) >= '2' FROM t; +SELECT cast(1 as decimal(10, 0)) < '2' FROM t; +SELECT cast(1 as decimal(10, 0)) <> '2' FROM t; +SELECT cast(1 as decimal(10, 0)) <= '2' FROM t; +SELECT cast(1 as decimal(10, 0)) = cast(null as string) FROM t; +SELECT cast(1 as decimal(10, 0)) > cast(null as string) FROM t; +SELECT cast(1 as decimal(10, 0)) >= cast(null as string) FROM t; +SELECT cast(1 as decimal(10, 0)) < cast(null as string) FROM t; +SELECT cast(1 as decimal(10, 0)) <> cast(null as string) FROM t; +SELECT cast(1 as decimal(10, 0)) <= cast(null as string) FROM t; +SELECT '1' = cast(1 as decimal(10, 0)) FROM t; +SELECT '2' > cast(1 as decimal(10, 0)) FROM t; +SELECT '2' >= cast(1 as decimal(10, 0)) FROM t; +SELECT '2' < cast(1 as decimal(10, 0)) FROM t; +SELECT '2' <= cast(1 as decimal(10, 0)) FROM t; +SELECT '2' <> cast(1 as decimal(10, 0)) FROM t; +SELECT cast(null as string) = cast(1 as decimal(10, 0)) FROM t; +SELECT cast(null as string) > cast(1 as decimal(10, 0)) FROM t; +SELECT cast(null as string) >= cast(1 as decimal(10, 0)) FROM t; +SELECT cast(null as string) < cast(1 as decimal(10, 0)) FROM t; +SELECT cast(null as string) <= cast(1 as decimal(10, 0)) FROM t; +SELECT cast(null as string) <> cast(1 as decimal(10, 0)) FROM t; +SELECT cast(1 as double) = '1' FROM t; +SELECT cast(1 as double) > '2' FROM t; +SELECT cast(1 as double) >= '2' FROM t; +SELECT cast(1 as double) < '2' FROM t; +SELECT cast(1 as double) <= '2' FROM t; +SELECT cast(1 as double) <> '2' FROM t; +SELECT cast(1 as double) = cast(null as string) FROM t; +SELECT cast(1 as double) > cast(null as string) FROM t; +SELECT cast(1 as double) >= cast(null as string) FROM t; +SELECT cast(1 as double) < cast(null as string) FROM t; +SELECT cast(1 as double) <= cast(null as string) FROM t; +SELECT cast(1 as double) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as double) FROM t; +SELECT '2' > cast(1 as double) FROM t; +SELECT '2' >= cast(1 as double) FROM t; +SELECT '2' < cast(1 as double) FROM t; +SELECT '2' <= cast(1 as double) FROM t; +SELECT '2' <> cast(1 as double) FROM t; +SELECT cast(null as string) = cast(1 as double) FROM t; +SELECT cast(null as string) > cast(1 as double) FROM t; +SELECT cast(null as string) >= cast(1 as double) FROM t; +SELECT cast(null as string) < cast(1 as double) FROM t; +SELECT cast(null as string) <= cast(1 as double) FROM t; +SELECT cast(null as string) <> cast(1 as double) FROM t; +SELECT cast(1 as float) = '1' FROM t; +SELECT cast(1 as float) > '2' FROM t; +SELECT cast(1 as float) >= '2' FROM t; +SELECT cast(1 as float) < '2' FROM t; +SELECT cast(1 as float) <= '2' FROM t; +SELECT cast(1 as float) <> '2' FROM t; +SELECT cast(1 as float) = cast(null as string) FROM t; +SELECT cast(1 as float) > cast(null as string) FROM t; +SELECT cast(1 as float) >= cast(null as string) FROM t; +SELECT cast(1 as float) < cast(null as string) FROM t; +SELECT cast(1 as float) <= cast(null as string) FROM t; +SELECT cast(1 as float) <> cast(null as string) FROM t; +SELECT '1' = cast(1 as float) FROM t; +SELECT '2' > cast(1 as float) FROM t; +SELECT '2' >= cast(1 as float) FROM t; +SELECT '2' < cast(1 as float) FROM t; +SELECT '2' <= cast(1 as float) FROM t; +SELECT '2' <> cast(1 as float) FROM t; +SELECT cast(null as string) = cast(1 as float) FROM t; +SELECT cast(null as string) > cast(1 as float) FROM t; +SELECT cast(null as string) >= cast(1 as float) FROM t; +SELECT cast(null as string) < cast(1 as float) FROM t; +SELECT cast(null as string) <= cast(1 as float) FROM t; +SELECT cast(null as string) <> cast(1 as float) FROM t; +-- the following queries return 1 if the search condition is satisfied +-- and returns nothing if the search condition is not satisfied +SELECT '1996-09-09' = date('1996-09-09') FROM t; +SELECT '1996-9-10' > date('1996-09-09') FROM t; +SELECT '1996-9-10' >= date('1996-09-09') FROM t; +SELECT '1996-9-10' < date('1996-09-09') FROM t; +SELECT '1996-9-10' <= date('1996-09-09') FROM t; +SELECT '1996-9-10' <> date('1996-09-09') FROM t; +SELECT cast(null as string) = date('1996-09-09') FROM t; +SELECT cast(null as string)> date('1996-09-09') FROM t; +SELECT cast(null as string)>= date('1996-09-09') FROM t; +SELECT cast(null as string)< date('1996-09-09') FROM t; +SELECT cast(null as string)<= date('1996-09-09') FROM t; +SELECT cast(null as string)<> date('1996-09-09') FROM t; +SELECT date('1996-09-09') = '1996-09-09' FROM t; +SELECT date('1996-9-10') > '1996-09-09' FROM t; +SELECT date('1996-9-10') >= '1996-09-09' FROM t; +SELECT date('1996-9-10') < '1996-09-09' FROM t; +SELECT date('1996-9-10') <= '1996-09-09' FROM t; +SELECT date('1996-9-10') <> '1996-09-09' FROM t; +SELECT date('1996-09-09') = cast(null as string) FROM t; +SELECT date('1996-9-10') > cast(null as string) FROM t; +SELECT date('1996-9-10') >= cast(null as string) FROM t; +SELECT date('1996-9-10') < cast(null as string) FROM t; +SELECT date('1996-9-10') <= cast(null as string) FROM t; +SELECT date('1996-9-10') <> cast(null as string) FROM t; +SELECT '1996-09-09 12:12:12.4' = timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT '1996-09-09 12:12:12.5' > timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT '1996-09-09 12:12:12.5' >= timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT '1996-09-09 12:12:12.5' < timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT '1996-09-09 12:12:12.5' <= timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT '1996-09-09 12:12:12.5' <> timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT cast(null as string) = timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT cast(null as string) > timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT cast(null as string) >= timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT cast(null as string) < timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT cast(null as string) <= timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT cast(null as string) <> timestamp('1996-09-09 12:12:12.4') FROM t; +SELECT timestamp('1996-09-09 12:12:12.4' )= '1996-09-09 12:12:12.4' FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )> '1996-09-09 12:12:12.4' FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )>= '1996-09-09 12:12:12.4' FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )< '1996-09-09 12:12:12.4' FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )<= '1996-09-09 12:12:12.4' FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )<> '1996-09-09 12:12:12.4' FROM t; +SELECT timestamp('1996-09-09 12:12:12.4' )= cast(null as string) FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )> cast(null as string) FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )>= cast(null as string) FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )< cast(null as string) FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )<= cast(null as string) FROM t; +SELECT timestamp('1996-09-09 12:12:12.5' )<> cast(null as string) FROM t; +SELECT ' ' = X'0020' FROM t; +SELECT ' ' > X'001F' FROM t; +SELECT ' ' >= X'001F' FROM t; +SELECT ' ' < X'001F' FROM t; +SELECT ' ' <= X'001F' FROM t; +SELECT ' ' <> X'001F' FROM t; +SELECT cast(null as string) = X'0020' FROM t; +SELECT cast(null as string) > X'001F' FROM t; +SELECT cast(null as string) >= X'001F' FROM t; +SELECT cast(null as string) < X'001F' FROM t; +SELECT cast(null as string) <= X'001F' FROM t; +SELECT cast(null as string) <> X'001F' FROM t; +SELECT X'0020' = ' ' FROM t; +SELECT X'001F' > ' ' FROM t; +SELECT X'001F' >= ' ' FROM t; +SELECT X'001F' < ' ' FROM t; +SELECT X'001F' <= ' ' FROM t; +SELECT X'001F' <> ' ' FROM t; +SELECT X'0020' = cast(null as string) FROM t; +SELECT X'001F' > cast(null as string) FROM t; +SELECT X'001F' >= cast(null as string) FROM t; +SELECT X'001F' < cast(null as string) FROM t; +SELECT X'001F' <= cast(null as string) FROM t; +SELECT X'001F' <> cast(null as string) FROM t; http://git-wip-us.apache.org/repos/asf/spark/blob/3d82f6eb/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/implicitTypeCasts.sql ---------------------------------------------------------------------- diff --git a/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/implicitTypeCasts.sql b/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/implicitTypeCasts.sql new file mode 100644 index 0000000..58866f4 --- /dev/null +++ b/sql/core/src/test/resources/sql-tests/inputs/typeCoercion/native/implicitTypeCasts.sql @@ -0,0 +1,72 @@ +-- +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. +-- + +-- ImplicitTypeCasts + +CREATE TEMPORARY VIEW t AS SELECT 1; + +SELECT 1 + '2' FROM t; +SELECT 1 - '2' FROM t; +SELECT 1 * '2' FROM t; +SELECT 4 / '2' FROM t; +SELECT 1.1 + '2' FROM t; +SELECT 1.1 - '2' FROM t; +SELECT 1.1 * '2' FROM t; +SELECT 4.4 / '2' FROM t; +SELECT 1.1 + '2.2' FROM t; +SELECT 1.1 - '2.2' FROM t; +SELECT 1.1 * '2.2' FROM t; +SELECT 4.4 / '2.2' FROM t; + +-- concatentation +SELECT '$' || cast(1 as smallint) || '$' FROM t; +SELECT '$' || 1 || '$' FROM t; +SELECT '$' || cast(1 as bigint) || '$' FROM t; +SELECT '$' || cast(1.1 as float) || '$' FROM t; +SELECT '$' || cast(1.1 as double) || '$' FROM t; +SELECT '$' || 1.1 || '$' FROM t; +SELECT '$' || cast(1.1 as decimal(8,3)) || '$' FROM t; +SELECT '$' || 'abcd' || '$' FROM t; +SELECT '$' || date('1996-09-09') || '$' FROM t; +SELECT '$' || timestamp('1996-09-09 10:11:12.4' )|| '$' FROM t; + +-- length functions +SELECT length(cast(1 as smallint)) FROM t; +SELECT length(cast(1 as int)) FROM t; +SELECT length(cast(1 as bigint)) FROM t; +SELECT length(cast(1.1 as float)) FROM t; +SELECT length(cast(1.1 as double)) FROM t; +SELECT length(1.1) FROM t; +SELECT length(cast(1.1 as decimal(8,3))) FROM t; +SELECT length('four') FROM t; +SELECT length(date('1996-09-10')) FROM t; +SELECT length(timestamp('1996-09-10 10:11:12.4')) FROM t; + +-- extract +SELECT year( '1996-01-10') FROM t; +SELECT month( '1996-01-10') FROM t; +SELECT day( '1996-01-10') FROM t; +SELECT hour( '10:11:12') FROM t; +SELECT minute( '10:11:12') FROM t; +SELECT second( '10:11:12') FROM t; + +-- like +select 1 like '%' FROM t; +select date('1996-09-10') like '19%' FROM t; +select '1' like 1 FROM t; +select '1 ' like 1 FROM t; +select '1996-09-10' like date('1996-09-10') FROM t; http://git-wip-us.apache.org/repos/asf/spark/blob/3d82f6eb/sql/core/src/test/resources/sql-tests/results/datetime.sql.out ---------------------------------------------------------------------- diff --git a/sql/core/src/test/resources/sql-tests/results/datetime.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime.sql.out index 7b2f46f..bbb6851 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime.sql.out @@ -44,6 +44,7 @@ struct<> -- !query 4 output + -- !query 5 select current_date, current_timestamp from ttf1 -- !query 5 schema @@ -63,6 +64,7 @@ struct<> -- !query 6 output + -- !query 7 select current_date = current_date(), current_timestamp = current_timestamp(), a, b from ttf2 -- !query 7 schema http://git-wip-us.apache.org/repos/asf/spark/blob/3d82f6eb/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out ---------------------------------------------------------------------- diff --git a/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out index 8cd0d51..d51f6d3 100644 --- a/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out @@ -1,5 +1,5 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 31 +-- Number of queries: 32 -- !query 0 @@ -34,225 +34,225 @@ struct<(CAST(1.5 AS DOUBLE) = CAST(1.51 AS DOUBLE)):boolean> false --- !query 3 -select 1 > '1' --- !query 3 schema -struct<(1 > CAST(1 AS INT)):boolean> --- !query 3 output -false - - -- !query 4 -select 2 > '1.0' +select 1 > '1' -- !query 4 schema -struct<(2 > CAST(1.0 AS INT)):boolean> +struct<(1 > CAST(1 AS INT)):boolean> -- !query 4 output -true +false -- !query 5 -select 2 > '2.0' +select 2 > '1.0' -- !query 5 schema -struct<(2 > CAST(2.0 AS INT)):boolean> +struct<(2 > CAST(1.0 AS INT)):boolean> -- !query 5 output -false +true -- !query 6 -select 2 > '2.2' +select 2 > '2.0' -- !query 6 schema -struct<(2 > CAST(2.2 AS INT)):boolean> +struct<(2 > CAST(2.0 AS INT)):boolean> -- !query 6 output false -- !query 7 -select '1.5' > 0.5 +select 2 > '2.2' -- !query 7 schema -struct<(CAST(1.5 AS DOUBLE) > CAST(0.5 AS DOUBLE)):boolean> +struct<(2 > CAST(2.2 AS INT)):boolean> -- !query 7 output -true +false -- !query 8 -select to_date('2009-07-30 04:17:52') > to_date('2009-07-30 04:17:52') +select '1.5' > 0.5 -- !query 8 schema -struct<(to_date('2009-07-30 04:17:52') > to_date('2009-07-30 04:17:52')):boolean> +struct<(CAST(1.5 AS DOUBLE) > CAST(0.5 AS DOUBLE)):boolean> -- !query 8 output -false +true -- !query 9 -select to_date('2009-07-30 04:17:52') > '2009-07-30 04:17:52' +select to_date('2009-07-30 04:17:52') > to_date('2009-07-30 04:17:52') -- !query 9 schema -struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) > 2009-07-30 04:17:52):boolean> +struct<(to_date('2009-07-30 04:17:52') > to_date('2009-07-30 04:17:52')):boolean> -- !query 9 output false -- !query 10 -select 1 >= '1' +select to_date('2009-07-30 04:17:52') > '2009-07-30 04:17:52' -- !query 10 schema -struct<(1 >= CAST(1 AS INT)):boolean> +struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) > 2009-07-30 04:17:52):boolean> -- !query 10 output -true +false -- !query 11 -select 2 >= '1.0' +select 1 >= '1' -- !query 11 schema -struct<(2 >= CAST(1.0 AS INT)):boolean> +struct<(1 >= CAST(1 AS INT)):boolean> -- !query 11 output true -- !query 12 -select 2 >= '2.0' +select 2 >= '1.0' -- !query 12 schema -struct<(2 >= CAST(2.0 AS INT)):boolean> +struct<(2 >= CAST(1.0 AS INT)):boolean> -- !query 12 output true -- !query 13 -select 2.0 >= '2.2' +select 2 >= '2.0' -- !query 13 schema -struct<(CAST(2.0 AS DOUBLE) >= CAST(2.2 AS DOUBLE)):boolean> +struct<(2 >= CAST(2.0 AS INT)):boolean> -- !query 13 output -false +true -- !query 14 -select '1.5' >= 0.5 +select 2.0 >= '2.2' -- !query 14 schema -struct<(CAST(1.5 AS DOUBLE) >= CAST(0.5 AS DOUBLE)):boolean> +struct<(CAST(2.0 AS DOUBLE) >= CAST(2.2 AS DOUBLE)):boolean> -- !query 14 output -true +false -- !query 15 -select to_date('2009-07-30 04:17:52') >= to_date('2009-07-30 04:17:52') +select '1.5' >= 0.5 -- !query 15 schema -struct<(to_date('2009-07-30 04:17:52') >= to_date('2009-07-30 04:17:52')):boolean> +struct<(CAST(1.5 AS DOUBLE) >= CAST(0.5 AS DOUBLE)):boolean> -- !query 15 output true -- !query 16 -select to_date('2009-07-30 04:17:52') >= '2009-07-30 04:17:52' +select to_date('2009-07-30 04:17:52') >= to_date('2009-07-30 04:17:52') -- !query 16 schema -struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) >= 2009-07-30 04:17:52):boolean> +struct<(to_date('2009-07-30 04:17:52') >= to_date('2009-07-30 04:17:52')):boolean> -- !query 16 output -false +true -- !query 17 -select 1 < '1' +select to_date('2009-07-30 04:17:52') >= '2009-07-30 04:17:52' -- !query 17 schema -struct<(1 < CAST(1 AS INT)):boolean> +struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) >= 2009-07-30 04:17:52):boolean> -- !query 17 output false -- !query 18 -select 2 < '1.0' +select 1 < '1' -- !query 18 schema -struct<(2 < CAST(1.0 AS INT)):boolean> +struct<(1 < CAST(1 AS INT)):boolean> -- !query 18 output false -- !query 19 -select 2 < '2.0' +select 2 < '1.0' -- !query 19 schema -struct<(2 < CAST(2.0 AS INT)):boolean> +struct<(2 < CAST(1.0 AS INT)):boolean> -- !query 19 output false -- !query 20 -select 2.0 < '2.2' +select 2 < '2.0' -- !query 20 schema -struct<(CAST(2.0 AS DOUBLE) < CAST(2.2 AS DOUBLE)):boolean> +struct<(2 < CAST(2.0 AS INT)):boolean> -- !query 20 output -true +false -- !query 21 -select 0.5 < '1.5' +select 2.0 < '2.2' -- !query 21 schema -struct<(CAST(0.5 AS DOUBLE) < CAST(1.5 AS DOUBLE)):boolean> +struct<(CAST(2.0 AS DOUBLE) < CAST(2.2 AS DOUBLE)):boolean> -- !query 21 output true -- !query 22 -select to_date('2009-07-30 04:17:52') < to_date('2009-07-30 04:17:52') +select 0.5 < '1.5' -- !query 22 schema -struct<(to_date('2009-07-30 04:17:52') < to_date('2009-07-30 04:17:52')):boolean> +struct<(CAST(0.5 AS DOUBLE) < CAST(1.5 AS DOUBLE)):boolean> -- !query 22 output -false +true -- !query 23 -select to_date('2009-07-30 04:17:52') < '2009-07-30 04:17:52' +select to_date('2009-07-30 04:17:52') < to_date('2009-07-30 04:17:52') -- !query 23 schema -struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) < 2009-07-30 04:17:52):boolean> +struct<(to_date('2009-07-30 04:17:52') < to_date('2009-07-30 04:17:52')):boolean> -- !query 23 output -true +false -- !query 24 -select 1 <= '1' +select to_date('2009-07-30 04:17:52') < '2009-07-30 04:17:52' -- !query 24 schema -struct<(1 <= CAST(1 AS INT)):boolean> +struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) < 2009-07-30 04:17:52):boolean> -- !query 24 output true -- !query 25 -select 2 <= '1.0' +select 1 <= '1' -- !query 25 schema -struct<(2 <= CAST(1.0 AS INT)):boolean> +struct<(1 <= CAST(1 AS INT)):boolean> -- !query 25 output -false +true -- !query 26 -select 2 <= '2.0' +select 2 <= '1.0' -- !query 26 schema -struct<(2 <= CAST(2.0 AS INT)):boolean> +struct<(2 <= CAST(1.0 AS INT)):boolean> -- !query 26 output -true +false -- !query 27 -select 2.0 <= '2.2' +select 2 <= '2.0' -- !query 27 schema -struct<(CAST(2.0 AS DOUBLE) <= CAST(2.2 AS DOUBLE)):boolean> +struct<(2 <= CAST(2.0 AS INT)):boolean> -- !query 27 output true -- !query 28 -select 0.5 <= '1.5' +select 2.0 <= '2.2' -- !query 28 schema -struct<(CAST(0.5 AS DOUBLE) <= CAST(1.5 AS DOUBLE)):boolean> +struct<(CAST(2.0 AS DOUBLE) <= CAST(2.2 AS DOUBLE)):boolean> -- !query 28 output true -- !query 29 -select to_date('2009-07-30 04:17:52') <= to_date('2009-07-30 04:17:52') +select 0.5 <= '1.5' -- !query 29 schema -struct<(to_date('2009-07-30 04:17:52') <= to_date('2009-07-30 04:17:52')):boolean> +struct<(CAST(0.5 AS DOUBLE) <= CAST(1.5 AS DOUBLE)):boolean> -- !query 29 output true -- !query 30 -select to_date('2009-07-30 04:17:52') <= '2009-07-30 04:17:52' +select to_date('2009-07-30 04:17:52') <= to_date('2009-07-30 04:17:52') -- !query 30 schema -struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) <= 2009-07-30 04:17:52):boolean> +struct<(to_date('2009-07-30 04:17:52') <= to_date('2009-07-30 04:17:52')):boolean> -- !query 30 output true + + +-- !query 31 +select to_date('2009-07-30 04:17:52') <= '2009-07-30 04:17:52' +-- !query 31 schema +struct<(CAST(to_date('2009-07-30 04:17:52') AS STRING) <= 2009-07-30 04:17:52):boolean> +-- !query 31 output +true http://git-wip-us.apache.org/repos/asf/spark/blob/3d82f6eb/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out ---------------------------------------------------------------------- diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out new file mode 100644 index 0000000..fe7bde0 --- /dev/null +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out @@ -0,0 +1,2146 @@ +-- Automatically generated by SQLQueryTestSuite +-- Number of queries: 265 + + +-- !query 0 +CREATE TEMPORARY VIEW t AS SELECT 1 +-- !query 0 schema +struct<> +-- !query 0 output + + + +-- !query 1 +SELECT cast(1 as binary) = '1' FROM t +-- !query 1 schema +struct<> +-- !query 1 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 2 +SELECT cast(1 as binary) > '2' FROM t +-- !query 2 schema +struct<> +-- !query 2 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 3 +SELECT cast(1 as binary) >= '2' FROM t +-- !query 3 schema +struct<> +-- !query 3 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 4 +SELECT cast(1 as binary) < '2' FROM t +-- !query 4 schema +struct<> +-- !query 4 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 5 +SELECT cast(1 as binary) <= '2' FROM t +-- !query 5 schema +struct<> +-- !query 5 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 6 +SELECT cast(1 as binary) <> '2' FROM t +-- !query 6 schema +struct<> +-- !query 6 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 7 +SELECT cast(1 as binary) = cast(null as string) FROM t +-- !query 7 schema +struct<> +-- !query 7 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 8 +SELECT cast(1 as binary) > cast(null as string) FROM t +-- !query 8 schema +struct<> +-- !query 8 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 9 +SELECT cast(1 as binary) >= cast(null as string) FROM t +-- !query 9 schema +struct<> +-- !query 9 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 10 +SELECT cast(1 as binary) < cast(null as string) FROM t +-- !query 10 schema +struct<> +-- !query 10 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 11 +SELECT cast(1 as binary) <= cast(null as string) FROM t +-- !query 11 schema +struct<> +-- !query 11 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 12 +SELECT cast(1 as binary) <> cast(null as string) FROM t +-- !query 12 schema +struct<> +-- !query 12 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 7 + + +-- !query 13 +SELECT '1' = cast(1 as binary) FROM t +-- !query 13 schema +struct<> +-- !query 13 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 13 + + +-- !query 14 +SELECT '2' > cast(1 as binary) FROM t +-- !query 14 schema +struct<> +-- !query 14 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 13 + + +-- !query 15 +SELECT '2' >= cast(1 as binary) FROM t +-- !query 15 schema +struct<> +-- !query 15 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 14 + + +-- !query 16 +SELECT '2' < cast(1 as binary) FROM t +-- !query 16 schema +struct<> +-- !query 16 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 13 + + +-- !query 17 +SELECT '2' <= cast(1 as binary) FROM t +-- !query 17 schema +struct<> +-- !query 17 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 14 + + +-- !query 18 +SELECT '2' <> cast(1 as binary) FROM t +-- !query 18 schema +struct<> +-- !query 18 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 14 + + +-- !query 19 +SELECT cast(null as string) = cast(1 as binary) FROM t +-- !query 19 schema +struct<> +-- !query 19 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 30 + + +-- !query 20 +SELECT cast(null as string) > cast(1 as binary) FROM t +-- !query 20 schema +struct<> +-- !query 20 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 30 + + +-- !query 21 +SELECT cast(null as string) >= cast(1 as binary) FROM t +-- !query 21 schema +struct<> +-- !query 21 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 31 + + +-- !query 22 +SELECT cast(null as string) < cast(1 as binary) FROM t +-- !query 22 schema +struct<> +-- !query 22 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 30 + + +-- !query 23 +SELECT cast(null as string) <= cast(1 as binary) FROM t +-- !query 23 schema +struct<> +-- !query 23 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 31 + + +-- !query 24 +SELECT cast(null as string) <> cast(1 as binary) FROM t +-- !query 24 schema +struct<> +-- !query 24 output +org.apache.spark.sql.AnalysisException +cannot resolve 'CAST(1 AS BINARY)' due to data type mismatch: cannot cast IntegerType to BinaryType; line 1 pos 31 + + +-- !query 25 +SELECT cast(1 as tinyint) = '1' FROM t +-- !query 25 schema +struct<(CAST(1 AS TINYINT) = CAST(1 AS TINYINT)):boolean> +-- !query 25 output +true + + +-- !query 26 +SELECT cast(1 as tinyint) > '2' FROM t +-- !query 26 schema +struct<(CAST(1 AS TINYINT) > CAST(2 AS TINYINT)):boolean> +-- !query 26 output +false + + +-- !query 27 +SELECT cast(1 as tinyint) >= '2' FROM t +-- !query 27 schema +struct<(CAST(1 AS TINYINT) >= CAST(2 AS TINYINT)):boolean> +-- !query 27 output +false + + +-- !query 28 +SELECT cast(1 as tinyint) < '2' FROM t +-- !query 28 schema +struct<(CAST(1 AS TINYINT) < CAST(2 AS TINYINT)):boolean> +-- !query 28 output +true + + +-- !query 29 +SELECT cast(1 as tinyint) <= '2' FROM t +-- !query 29 schema +struct<(CAST(1 AS TINYINT) <= CAST(2 AS TINYINT)):boolean> +-- !query 29 output +true + + +-- !query 30 +SELECT cast(1 as tinyint) <> '2' FROM t +-- !query 30 schema +struct<(NOT (CAST(1 AS TINYINT) = CAST(2 AS TINYINT))):boolean> +-- !query 30 output +true + + +-- !query 31 +SELECT cast(1 as tinyint) = cast(null as string) FROM t +-- !query 31 schema +struct<(CAST(1 AS TINYINT) = CAST(CAST(NULL AS STRING) AS TINYINT)):boolean> +-- !query 31 output +NULL + + +-- !query 32 +SELECT cast(1 as tinyint) > cast(null as string) FROM t +-- !query 32 schema +struct<(CAST(1 AS TINYINT) > CAST(CAST(NULL AS STRING) AS TINYINT)):boolean> +-- !query 32 output +NULL + + +-- !query 33 +SELECT cast(1 as tinyint) >= cast(null as string) FROM t +-- !query 33 schema +struct<(CAST(1 AS TINYINT) >= CAST(CAST(NULL AS STRING) AS TINYINT)):boolean> +-- !query 33 output +NULL + + +-- !query 34 +SELECT cast(1 as tinyint) < cast(null as string) FROM t +-- !query 34 schema +struct<(CAST(1 AS TINYINT) < CAST(CAST(NULL AS STRING) AS TINYINT)):boolean> +-- !query 34 output +NULL + + +-- !query 35 +SELECT cast(1 as tinyint) <= cast(null as string) FROM t +-- !query 35 schema +struct<(CAST(1 AS TINYINT) <= CAST(CAST(NULL AS STRING) AS TINYINT)):boolean> +-- !query 35 output +NULL + + +-- !query 36 +SELECT cast(1 as tinyint) <> cast(null as string) FROM t +-- !query 36 schema +struct<(NOT (CAST(1 AS TINYINT) = CAST(CAST(NULL AS STRING) AS TINYINT))):boolean> +-- !query 36 output +NULL + + +-- !query 37 +SELECT '1' = cast(1 as tinyint) FROM t +-- !query 37 schema +struct<(CAST(1 AS TINYINT) = CAST(1 AS TINYINT)):boolean> +-- !query 37 output +true + + +-- !query 38 +SELECT '2' > cast(1 as tinyint) FROM t +-- !query 38 schema +struct<(CAST(2 AS TINYINT) > CAST(1 AS TINYINT)):boolean> +-- !query 38 output +true + + +-- !query 39 +SELECT '2' >= cast(1 as tinyint) FROM t +-- !query 39 schema +struct<(CAST(2 AS TINYINT) >= CAST(1 AS TINYINT)):boolean> +-- !query 39 output +true + + +-- !query 40 +SELECT '2' < cast(1 as tinyint) FROM t +-- !query 40 schema +struct<(CAST(2 AS TINYINT) < CAST(1 AS TINYINT)):boolean> +-- !query 40 output +false + + +-- !query 41 +SELECT '2' <= cast(1 as tinyint) FROM t +-- !query 41 schema +struct<(CAST(2 AS TINYINT) <= CAST(1 AS TINYINT)):boolean> +-- !query 41 output +false + + +-- !query 42 +SELECT '2' <> cast(1 as tinyint) FROM t +-- !query 42 schema +struct<(NOT (CAST(2 AS TINYINT) = CAST(1 AS TINYINT))):boolean> +-- !query 42 output +true + + +-- !query 43 +SELECT cast(null as string) = cast(1 as tinyint) FROM t +-- !query 43 schema +struct<(CAST(CAST(NULL AS STRING) AS TINYINT) = CAST(1 AS TINYINT)):boolean> +-- !query 43 output +NULL + + +-- !query 44 +SELECT cast(null as string) > cast(1 as tinyint) FROM t +-- !query 44 schema +struct<(CAST(CAST(NULL AS STRING) AS TINYINT) > CAST(1 AS TINYINT)):boolean> +-- !query 44 output +NULL + + +-- !query 45 +SELECT cast(null as string) >= cast(1 as tinyint) FROM t +-- !query 45 schema +struct<(CAST(CAST(NULL AS STRING) AS TINYINT) >= CAST(1 AS TINYINT)):boolean> +-- !query 45 output +NULL + + +-- !query 46 +SELECT cast(null as string) < cast(1 as tinyint) FROM t +-- !query 46 schema +struct<(CAST(CAST(NULL AS STRING) AS TINYINT) < CAST(1 AS TINYINT)):boolean> +-- !query 46 output +NULL + + +-- !query 47 +SELECT cast(null as string) <= cast(1 as tinyint) FROM t +-- !query 47 schema +struct<(CAST(CAST(NULL AS STRING) AS TINYINT) <= CAST(1 AS TINYINT)):boolean> +-- !query 47 output +NULL + + +-- !query 48 +SELECT cast(null as string) <> cast(1 as tinyint) FROM t +-- !query 48 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS TINYINT) = CAST(1 AS TINYINT))):boolean> +-- !query 48 output +NULL + + +-- !query 49 +SELECT cast(1 as smallint) = '1' FROM t +-- !query 49 schema +struct<(CAST(1 AS SMALLINT) = CAST(1 AS SMALLINT)):boolean> +-- !query 49 output +true + + +-- !query 50 +SELECT cast(1 as smallint) > '2' FROM t +-- !query 50 schema +struct<(CAST(1 AS SMALLINT) > CAST(2 AS SMALLINT)):boolean> +-- !query 50 output +false + + +-- !query 51 +SELECT cast(1 as smallint) >= '2' FROM t +-- !query 51 schema +struct<(CAST(1 AS SMALLINT) >= CAST(2 AS SMALLINT)):boolean> +-- !query 51 output +false + + +-- !query 52 +SELECT cast(1 as smallint) < '2' FROM t +-- !query 52 schema +struct<(CAST(1 AS SMALLINT) < CAST(2 AS SMALLINT)):boolean> +-- !query 52 output +true + + +-- !query 53 +SELECT cast(1 as smallint) <= '2' FROM t +-- !query 53 schema +struct<(CAST(1 AS SMALLINT) <= CAST(2 AS SMALLINT)):boolean> +-- !query 53 output +true + + +-- !query 54 +SELECT cast(1 as smallint) <> '2' FROM t +-- !query 54 schema +struct<(NOT (CAST(1 AS SMALLINT) = CAST(2 AS SMALLINT))):boolean> +-- !query 54 output +true + + +-- !query 55 +SELECT cast(1 as smallint) = cast(null as string) FROM t +-- !query 55 schema +struct<(CAST(1 AS SMALLINT) = CAST(CAST(NULL AS STRING) AS SMALLINT)):boolean> +-- !query 55 output +NULL + + +-- !query 56 +SELECT cast(1 as smallint) > cast(null as string) FROM t +-- !query 56 schema +struct<(CAST(1 AS SMALLINT) > CAST(CAST(NULL AS STRING) AS SMALLINT)):boolean> +-- !query 56 output +NULL + + +-- !query 57 +SELECT cast(1 as smallint) >= cast(null as string) FROM t +-- !query 57 schema +struct<(CAST(1 AS SMALLINT) >= CAST(CAST(NULL AS STRING) AS SMALLINT)):boolean> +-- !query 57 output +NULL + + +-- !query 58 +SELECT cast(1 as smallint) < cast(null as string) FROM t +-- !query 58 schema +struct<(CAST(1 AS SMALLINT) < CAST(CAST(NULL AS STRING) AS SMALLINT)):boolean> +-- !query 58 output +NULL + + +-- !query 59 +SELECT cast(1 as smallint) <= cast(null as string) FROM t +-- !query 59 schema +struct<(CAST(1 AS SMALLINT) <= CAST(CAST(NULL AS STRING) AS SMALLINT)):boolean> +-- !query 59 output +NULL + + +-- !query 60 +SELECT cast(1 as smallint) <> cast(null as string) FROM t +-- !query 60 schema +struct<(NOT (CAST(1 AS SMALLINT) = CAST(CAST(NULL AS STRING) AS SMALLINT))):boolean> +-- !query 60 output +NULL + + +-- !query 61 +SELECT '1' = cast(1 as smallint) FROM t +-- !query 61 schema +struct<(CAST(1 AS SMALLINT) = CAST(1 AS SMALLINT)):boolean> +-- !query 61 output +true + + +-- !query 62 +SELECT '2' > cast(1 as smallint) FROM t +-- !query 62 schema +struct<(CAST(2 AS SMALLINT) > CAST(1 AS SMALLINT)):boolean> +-- !query 62 output +true + + +-- !query 63 +SELECT '2' >= cast(1 as smallint) FROM t +-- !query 63 schema +struct<(CAST(2 AS SMALLINT) >= CAST(1 AS SMALLINT)):boolean> +-- !query 63 output +true + + +-- !query 64 +SELECT '2' < cast(1 as smallint) FROM t +-- !query 64 schema +struct<(CAST(2 AS SMALLINT) < CAST(1 AS SMALLINT)):boolean> +-- !query 64 output +false + + +-- !query 65 +SELECT '2' <= cast(1 as smallint) FROM t +-- !query 65 schema +struct<(CAST(2 AS SMALLINT) <= CAST(1 AS SMALLINT)):boolean> +-- !query 65 output +false + + +-- !query 66 +SELECT '2' <> cast(1 as smallint) FROM t +-- !query 66 schema +struct<(NOT (CAST(2 AS SMALLINT) = CAST(1 AS SMALLINT))):boolean> +-- !query 66 output +true + + +-- !query 67 +SELECT cast(null as string) = cast(1 as smallint) FROM t +-- !query 67 schema +struct<(CAST(CAST(NULL AS STRING) AS SMALLINT) = CAST(1 AS SMALLINT)):boolean> +-- !query 67 output +NULL + + +-- !query 68 +SELECT cast(null as string) > cast(1 as smallint) FROM t +-- !query 68 schema +struct<(CAST(CAST(NULL AS STRING) AS SMALLINT) > CAST(1 AS SMALLINT)):boolean> +-- !query 68 output +NULL + + +-- !query 69 +SELECT cast(null as string) >= cast(1 as smallint) FROM t +-- !query 69 schema +struct<(CAST(CAST(NULL AS STRING) AS SMALLINT) >= CAST(1 AS SMALLINT)):boolean> +-- !query 69 output +NULL + + +-- !query 70 +SELECT cast(null as string) < cast(1 as smallint) FROM t +-- !query 70 schema +struct<(CAST(CAST(NULL AS STRING) AS SMALLINT) < CAST(1 AS SMALLINT)):boolean> +-- !query 70 output +NULL + + +-- !query 71 +SELECT cast(null as string) <= cast(1 as smallint) FROM t +-- !query 71 schema +struct<(CAST(CAST(NULL AS STRING) AS SMALLINT) <= CAST(1 AS SMALLINT)):boolean> +-- !query 71 output +NULL + + +-- !query 72 +SELECT cast(null as string) <> cast(1 as smallint) FROM t +-- !query 72 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS SMALLINT) = CAST(1 AS SMALLINT))):boolean> +-- !query 72 output +NULL + + +-- !query 73 +SELECT cast(1 as int) = '1' FROM t +-- !query 73 schema +struct<(CAST(1 AS INT) = CAST(1 AS INT)):boolean> +-- !query 73 output +true + + +-- !query 74 +SELECT cast(1 as int) > '2' FROM t +-- !query 74 schema +struct<(CAST(1 AS INT) > CAST(2 AS INT)):boolean> +-- !query 74 output +false + + +-- !query 75 +SELECT cast(1 as int) >= '2' FROM t +-- !query 75 schema +struct<(CAST(1 AS INT) >= CAST(2 AS INT)):boolean> +-- !query 75 output +false + + +-- !query 76 +SELECT cast(1 as int) < '2' FROM t +-- !query 76 schema +struct<(CAST(1 AS INT) < CAST(2 AS INT)):boolean> +-- !query 76 output +true + + +-- !query 77 +SELECT cast(1 as int) <= '2' FROM t +-- !query 77 schema +struct<(CAST(1 AS INT) <= CAST(2 AS INT)):boolean> +-- !query 77 output +true + + +-- !query 78 +SELECT cast(1 as int) <> '2' FROM t +-- !query 78 schema +struct<(NOT (CAST(1 AS INT) = CAST(2 AS INT))):boolean> +-- !query 78 output +true + + +-- !query 79 +SELECT cast(1 as int) = cast(null as string) FROM t +-- !query 79 schema +struct<(CAST(1 AS INT) = CAST(CAST(NULL AS STRING) AS INT)):boolean> +-- !query 79 output +NULL + + +-- !query 80 +SELECT cast(1 as int) > cast(null as string) FROM t +-- !query 80 schema +struct<(CAST(1 AS INT) > CAST(CAST(NULL AS STRING) AS INT)):boolean> +-- !query 80 output +NULL + + +-- !query 81 +SELECT cast(1 as int) >= cast(null as string) FROM t +-- !query 81 schema +struct<(CAST(1 AS INT) >= CAST(CAST(NULL AS STRING) AS INT)):boolean> +-- !query 81 output +NULL + + +-- !query 82 +SELECT cast(1 as int) < cast(null as string) FROM t +-- !query 82 schema +struct<(CAST(1 AS INT) < CAST(CAST(NULL AS STRING) AS INT)):boolean> +-- !query 82 output +NULL + + +-- !query 83 +SELECT cast(1 as int) <= cast(null as string) FROM t +-- !query 83 schema +struct<(CAST(1 AS INT) <= CAST(CAST(NULL AS STRING) AS INT)):boolean> +-- !query 83 output +NULL + + +-- !query 84 +SELECT cast(1 as int) <> cast(null as string) FROM t +-- !query 84 schema +struct<(NOT (CAST(1 AS INT) = CAST(CAST(NULL AS STRING) AS INT))):boolean> +-- !query 84 output +NULL + + +-- !query 85 +SELECT '1' = cast(1 as int) FROM t +-- !query 85 schema +struct<(CAST(1 AS INT) = CAST(1 AS INT)):boolean> +-- !query 85 output +true + + +-- !query 86 +SELECT '2' > cast(1 as int) FROM t +-- !query 86 schema +struct<(CAST(2 AS INT) > CAST(1 AS INT)):boolean> +-- !query 86 output +true + + +-- !query 87 +SELECT '2' >= cast(1 as int) FROM t +-- !query 87 schema +struct<(CAST(2 AS INT) >= CAST(1 AS INT)):boolean> +-- !query 87 output +true + + +-- !query 88 +SELECT '2' < cast(1 as int) FROM t +-- !query 88 schema +struct<(CAST(2 AS INT) < CAST(1 AS INT)):boolean> +-- !query 88 output +false + + +-- !query 89 +SELECT '2' <> cast(1 as int) FROM t +-- !query 89 schema +struct<(NOT (CAST(2 AS INT) = CAST(1 AS INT))):boolean> +-- !query 89 output +true + + +-- !query 90 +SELECT '2' <= cast(1 as int) FROM t +-- !query 90 schema +struct<(CAST(2 AS INT) <= CAST(1 AS INT)):boolean> +-- !query 90 output +false + + +-- !query 91 +SELECT cast(null as string) = cast(1 as int) FROM t +-- !query 91 schema +struct<(CAST(CAST(NULL AS STRING) AS INT) = CAST(1 AS INT)):boolean> +-- !query 91 output +NULL + + +-- !query 92 +SELECT cast(null as string) > cast(1 as int) FROM t +-- !query 92 schema +struct<(CAST(CAST(NULL AS STRING) AS INT) > CAST(1 AS INT)):boolean> +-- !query 92 output +NULL + + +-- !query 93 +SELECT cast(null as string) >= cast(1 as int) FROM t +-- !query 93 schema +struct<(CAST(CAST(NULL AS STRING) AS INT) >= CAST(1 AS INT)):boolean> +-- !query 93 output +NULL + + +-- !query 94 +SELECT cast(null as string) < cast(1 as int) FROM t +-- !query 94 schema +struct<(CAST(CAST(NULL AS STRING) AS INT) < CAST(1 AS INT)):boolean> +-- !query 94 output +NULL + + +-- !query 95 +SELECT cast(null as string) <> cast(1 as int) FROM t +-- !query 95 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS INT) = CAST(1 AS INT))):boolean> +-- !query 95 output +NULL + + +-- !query 96 +SELECT cast(null as string) <= cast(1 as int) FROM t +-- !query 96 schema +struct<(CAST(CAST(NULL AS STRING) AS INT) <= CAST(1 AS INT)):boolean> +-- !query 96 output +NULL + + +-- !query 97 +SELECT cast(1 as bigint) = '1' FROM t +-- !query 97 schema +struct<(CAST(1 AS BIGINT) = CAST(1 AS BIGINT)):boolean> +-- !query 97 output +true + + +-- !query 98 +SELECT cast(1 as bigint) > '2' FROM t +-- !query 98 schema +struct<(CAST(1 AS BIGINT) > CAST(2 AS BIGINT)):boolean> +-- !query 98 output +false + + +-- !query 99 +SELECT cast(1 as bigint) >= '2' FROM t +-- !query 99 schema +struct<(CAST(1 AS BIGINT) >= CAST(2 AS BIGINT)):boolean> +-- !query 99 output +false + + +-- !query 100 +SELECT cast(1 as bigint) < '2' FROM t +-- !query 100 schema +struct<(CAST(1 AS BIGINT) < CAST(2 AS BIGINT)):boolean> +-- !query 100 output +true + + +-- !query 101 +SELECT cast(1 as bigint) <= '2' FROM t +-- !query 101 schema +struct<(CAST(1 AS BIGINT) <= CAST(2 AS BIGINT)):boolean> +-- !query 101 output +true + + +-- !query 102 +SELECT cast(1 as bigint) <> '2' FROM t +-- !query 102 schema +struct<(NOT (CAST(1 AS BIGINT) = CAST(2 AS BIGINT))):boolean> +-- !query 102 output +true + + +-- !query 103 +SELECT cast(1 as bigint) = cast(null as string) FROM t +-- !query 103 schema +struct<(CAST(1 AS BIGINT) = CAST(CAST(NULL AS STRING) AS BIGINT)):boolean> +-- !query 103 output +NULL + + +-- !query 104 +SELECT cast(1 as bigint) > cast(null as string) FROM t +-- !query 104 schema +struct<(CAST(1 AS BIGINT) > CAST(CAST(NULL AS STRING) AS BIGINT)):boolean> +-- !query 104 output +NULL + + +-- !query 105 +SELECT cast(1 as bigint) >= cast(null as string) FROM t +-- !query 105 schema +struct<(CAST(1 AS BIGINT) >= CAST(CAST(NULL AS STRING) AS BIGINT)):boolean> +-- !query 105 output +NULL + + +-- !query 106 +SELECT cast(1 as bigint) < cast(null as string) FROM t +-- !query 106 schema +struct<(CAST(1 AS BIGINT) < CAST(CAST(NULL AS STRING) AS BIGINT)):boolean> +-- !query 106 output +NULL + + +-- !query 107 +SELECT cast(1 as bigint) <= cast(null as string) FROM t +-- !query 107 schema +struct<(CAST(1 AS BIGINT) <= CAST(CAST(NULL AS STRING) AS BIGINT)):boolean> +-- !query 107 output +NULL + + +-- !query 108 +SELECT cast(1 as bigint) <> cast(null as string) FROM t +-- !query 108 schema +struct<(NOT (CAST(1 AS BIGINT) = CAST(CAST(NULL AS STRING) AS BIGINT))):boolean> +-- !query 108 output +NULL + + +-- !query 109 +SELECT '1' = cast(1 as bigint) FROM t +-- !query 109 schema +struct<(CAST(1 AS BIGINT) = CAST(1 AS BIGINT)):boolean> +-- !query 109 output +true + + +-- !query 110 +SELECT '2' > cast(1 as bigint) FROM t +-- !query 110 schema +struct<(CAST(2 AS BIGINT) > CAST(1 AS BIGINT)):boolean> +-- !query 110 output +true + + +-- !query 111 +SELECT '2' >= cast(1 as bigint) FROM t +-- !query 111 schema +struct<(CAST(2 AS BIGINT) >= CAST(1 AS BIGINT)):boolean> +-- !query 111 output +true + + +-- !query 112 +SELECT '2' < cast(1 as bigint) FROM t +-- !query 112 schema +struct<(CAST(2 AS BIGINT) < CAST(1 AS BIGINT)):boolean> +-- !query 112 output +false + + +-- !query 113 +SELECT '2' <= cast(1 as bigint) FROM t +-- !query 113 schema +struct<(CAST(2 AS BIGINT) <= CAST(1 AS BIGINT)):boolean> +-- !query 113 output +false + + +-- !query 114 +SELECT '2' <> cast(1 as bigint) FROM t +-- !query 114 schema +struct<(NOT (CAST(2 AS BIGINT) = CAST(1 AS BIGINT))):boolean> +-- !query 114 output +true + + +-- !query 115 +SELECT cast(null as string) = cast(1 as bigint) FROM t +-- !query 115 schema +struct<(CAST(CAST(NULL AS STRING) AS BIGINT) = CAST(1 AS BIGINT)):boolean> +-- !query 115 output +NULL + + +-- !query 116 +SELECT cast(null as string) > cast(1 as bigint) FROM t +-- !query 116 schema +struct<(CAST(CAST(NULL AS STRING) AS BIGINT) > CAST(1 AS BIGINT)):boolean> +-- !query 116 output +NULL + + +-- !query 117 +SELECT cast(null as string) >= cast(1 as bigint) FROM t +-- !query 117 schema +struct<(CAST(CAST(NULL AS STRING) AS BIGINT) >= CAST(1 AS BIGINT)):boolean> +-- !query 117 output +NULL + + +-- !query 118 +SELECT cast(null as string) < cast(1 as bigint) FROM t +-- !query 118 schema +struct<(CAST(CAST(NULL AS STRING) AS BIGINT) < CAST(1 AS BIGINT)):boolean> +-- !query 118 output +NULL + + +-- !query 119 +SELECT cast(null as string) <= cast(1 as bigint) FROM t +-- !query 119 schema +struct<(CAST(CAST(NULL AS STRING) AS BIGINT) <= CAST(1 AS BIGINT)):boolean> +-- !query 119 output +NULL + + +-- !query 120 +SELECT cast(null as string) <> cast(1 as bigint) FROM t +-- !query 120 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS BIGINT) = CAST(1 AS BIGINT))):boolean> +-- !query 120 output +NULL + + +-- !query 121 +SELECT cast(1 as decimal(10, 0)) = '1' FROM t +-- !query 121 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) = CAST(1 AS DOUBLE)):boolean> +-- !query 121 output +true + + +-- !query 122 +SELECT cast(1 as decimal(10, 0)) > '2' FROM t +-- !query 122 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) > CAST(2 AS DOUBLE)):boolean> +-- !query 122 output +false + + +-- !query 123 +SELECT cast(1 as decimal(10, 0)) >= '2' FROM t +-- !query 123 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) >= CAST(2 AS DOUBLE)):boolean> +-- !query 123 output +false + + +-- !query 124 +SELECT cast(1 as decimal(10, 0)) < '2' FROM t +-- !query 124 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) < CAST(2 AS DOUBLE)):boolean> +-- !query 124 output +true + + +-- !query 125 +SELECT cast(1 as decimal(10, 0)) <> '2' FROM t +-- !query 125 schema +struct<(NOT (CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) = CAST(2 AS DOUBLE))):boolean> +-- !query 125 output +true + + +-- !query 126 +SELECT cast(1 as decimal(10, 0)) <= '2' FROM t +-- !query 126 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) <= CAST(2 AS DOUBLE)):boolean> +-- !query 126 output +true + + +-- !query 127 +SELECT cast(1 as decimal(10, 0)) = cast(null as string) FROM t +-- !query 127 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) = CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 127 output +NULL + + +-- !query 128 +SELECT cast(1 as decimal(10, 0)) > cast(null as string) FROM t +-- !query 128 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) > CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 128 output +NULL + + +-- !query 129 +SELECT cast(1 as decimal(10, 0)) >= cast(null as string) FROM t +-- !query 129 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) >= CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 129 output +NULL + + +-- !query 130 +SELECT cast(1 as decimal(10, 0)) < cast(null as string) FROM t +-- !query 130 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) < CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 130 output +NULL + + +-- !query 131 +SELECT cast(1 as decimal(10, 0)) <> cast(null as string) FROM t +-- !query 131 schema +struct<(NOT (CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) = CAST(CAST(NULL AS STRING) AS DOUBLE))):boolean> +-- !query 131 output +NULL + + +-- !query 132 +SELECT cast(1 as decimal(10, 0)) <= cast(null as string) FROM t +-- !query 132 schema +struct<(CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE) <= CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 132 output +NULL + + +-- !query 133 +SELECT '1' = cast(1 as decimal(10, 0)) FROM t +-- !query 133 schema +struct<(CAST(1 AS DOUBLE) = CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 133 output +true + + +-- !query 134 +SELECT '2' > cast(1 as decimal(10, 0)) FROM t +-- !query 134 schema +struct<(CAST(2 AS DOUBLE) > CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 134 output +true + + +-- !query 135 +SELECT '2' >= cast(1 as decimal(10, 0)) FROM t +-- !query 135 schema +struct<(CAST(2 AS DOUBLE) >= CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 135 output +true + + +-- !query 136 +SELECT '2' < cast(1 as decimal(10, 0)) FROM t +-- !query 136 schema +struct<(CAST(2 AS DOUBLE) < CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 136 output +false + + +-- !query 137 +SELECT '2' <= cast(1 as decimal(10, 0)) FROM t +-- !query 137 schema +struct<(CAST(2 AS DOUBLE) <= CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 137 output +false + + +-- !query 138 +SELECT '2' <> cast(1 as decimal(10, 0)) FROM t +-- !query 138 schema +struct<(NOT (CAST(2 AS DOUBLE) = CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE))):boolean> +-- !query 138 output +true + + +-- !query 139 +SELECT cast(null as string) = cast(1 as decimal(10, 0)) FROM t +-- !query 139 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) = CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 139 output +NULL + + +-- !query 140 +SELECT cast(null as string) > cast(1 as decimal(10, 0)) FROM t +-- !query 140 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) > CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 140 output +NULL + + +-- !query 141 +SELECT cast(null as string) >= cast(1 as decimal(10, 0)) FROM t +-- !query 141 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) >= CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 141 output +NULL + + +-- !query 142 +SELECT cast(null as string) < cast(1 as decimal(10, 0)) FROM t +-- !query 142 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) < CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 142 output +NULL + + +-- !query 143 +SELECT cast(null as string) <= cast(1 as decimal(10, 0)) FROM t +-- !query 143 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) <= CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE)):boolean> +-- !query 143 output +NULL + + +-- !query 144 +SELECT cast(null as string) <> cast(1 as decimal(10, 0)) FROM t +-- !query 144 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS DOUBLE) = CAST(CAST(1 AS DECIMAL(10,0)) AS DOUBLE))):boolean> +-- !query 144 output +NULL + + +-- !query 145 +SELECT cast(1 as double) = '1' FROM t +-- !query 145 schema +struct<(CAST(1 AS DOUBLE) = CAST(1 AS DOUBLE)):boolean> +-- !query 145 output +true + + +-- !query 146 +SELECT cast(1 as double) > '2' FROM t +-- !query 146 schema +struct<(CAST(1 AS DOUBLE) > CAST(2 AS DOUBLE)):boolean> +-- !query 146 output +false + + +-- !query 147 +SELECT cast(1 as double) >= '2' FROM t +-- !query 147 schema +struct<(CAST(1 AS DOUBLE) >= CAST(2 AS DOUBLE)):boolean> +-- !query 147 output +false + + +-- !query 148 +SELECT cast(1 as double) < '2' FROM t +-- !query 148 schema +struct<(CAST(1 AS DOUBLE) < CAST(2 AS DOUBLE)):boolean> +-- !query 148 output +true + + +-- !query 149 +SELECT cast(1 as double) <= '2' FROM t +-- !query 149 schema +struct<(CAST(1 AS DOUBLE) <= CAST(2 AS DOUBLE)):boolean> +-- !query 149 output +true + + +-- !query 150 +SELECT cast(1 as double) <> '2' FROM t +-- !query 150 schema +struct<(NOT (CAST(1 AS DOUBLE) = CAST(2 AS DOUBLE))):boolean> +-- !query 150 output +true + + +-- !query 151 +SELECT cast(1 as double) = cast(null as string) FROM t +-- !query 151 schema +struct<(CAST(1 AS DOUBLE) = CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 151 output +NULL + + +-- !query 152 +SELECT cast(1 as double) > cast(null as string) FROM t +-- !query 152 schema +struct<(CAST(1 AS DOUBLE) > CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 152 output +NULL + + +-- !query 153 +SELECT cast(1 as double) >= cast(null as string) FROM t +-- !query 153 schema +struct<(CAST(1 AS DOUBLE) >= CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 153 output +NULL + + +-- !query 154 +SELECT cast(1 as double) < cast(null as string) FROM t +-- !query 154 schema +struct<(CAST(1 AS DOUBLE) < CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 154 output +NULL + + +-- !query 155 +SELECT cast(1 as double) <= cast(null as string) FROM t +-- !query 155 schema +struct<(CAST(1 AS DOUBLE) <= CAST(CAST(NULL AS STRING) AS DOUBLE)):boolean> +-- !query 155 output +NULL + + +-- !query 156 +SELECT cast(1 as double) <> cast(null as string) FROM t +-- !query 156 schema +struct<(NOT (CAST(1 AS DOUBLE) = CAST(CAST(NULL AS STRING) AS DOUBLE))):boolean> +-- !query 156 output +NULL + + +-- !query 157 +SELECT '1' = cast(1 as double) FROM t +-- !query 157 schema +struct<(CAST(1 AS DOUBLE) = CAST(1 AS DOUBLE)):boolean> +-- !query 157 output +true + + +-- !query 158 +SELECT '2' > cast(1 as double) FROM t +-- !query 158 schema +struct<(CAST(2 AS DOUBLE) > CAST(1 AS DOUBLE)):boolean> +-- !query 158 output +true + + +-- !query 159 +SELECT '2' >= cast(1 as double) FROM t +-- !query 159 schema +struct<(CAST(2 AS DOUBLE) >= CAST(1 AS DOUBLE)):boolean> +-- !query 159 output +true + + +-- !query 160 +SELECT '2' < cast(1 as double) FROM t +-- !query 160 schema +struct<(CAST(2 AS DOUBLE) < CAST(1 AS DOUBLE)):boolean> +-- !query 160 output +false + + +-- !query 161 +SELECT '2' <= cast(1 as double) FROM t +-- !query 161 schema +struct<(CAST(2 AS DOUBLE) <= CAST(1 AS DOUBLE)):boolean> +-- !query 161 output +false + + +-- !query 162 +SELECT '2' <> cast(1 as double) FROM t +-- !query 162 schema +struct<(NOT (CAST(2 AS DOUBLE) = CAST(1 AS DOUBLE))):boolean> +-- !query 162 output +true + + +-- !query 163 +SELECT cast(null as string) = cast(1 as double) FROM t +-- !query 163 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) = CAST(1 AS DOUBLE)):boolean> +-- !query 163 output +NULL + + +-- !query 164 +SELECT cast(null as string) > cast(1 as double) FROM t +-- !query 164 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) > CAST(1 AS DOUBLE)):boolean> +-- !query 164 output +NULL + + +-- !query 165 +SELECT cast(null as string) >= cast(1 as double) FROM t +-- !query 165 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) >= CAST(1 AS DOUBLE)):boolean> +-- !query 165 output +NULL + + +-- !query 166 +SELECT cast(null as string) < cast(1 as double) FROM t +-- !query 166 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) < CAST(1 AS DOUBLE)):boolean> +-- !query 166 output +NULL + + +-- !query 167 +SELECT cast(null as string) <= cast(1 as double) FROM t +-- !query 167 schema +struct<(CAST(CAST(NULL AS STRING) AS DOUBLE) <= CAST(1 AS DOUBLE)):boolean> +-- !query 167 output +NULL + + +-- !query 168 +SELECT cast(null as string) <> cast(1 as double) FROM t +-- !query 168 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS DOUBLE) = CAST(1 AS DOUBLE))):boolean> +-- !query 168 output +NULL + + +-- !query 169 +SELECT cast(1 as float) = '1' FROM t +-- !query 169 schema +struct<(CAST(1 AS FLOAT) = CAST(1 AS FLOAT)):boolean> +-- !query 169 output +true + + +-- !query 170 +SELECT cast(1 as float) > '2' FROM t +-- !query 170 schema +struct<(CAST(1 AS FLOAT) > CAST(2 AS FLOAT)):boolean> +-- !query 170 output +false + + +-- !query 171 +SELECT cast(1 as float) >= '2' FROM t +-- !query 171 schema +struct<(CAST(1 AS FLOAT) >= CAST(2 AS FLOAT)):boolean> +-- !query 171 output +false + + +-- !query 172 +SELECT cast(1 as float) < '2' FROM t +-- !query 172 schema +struct<(CAST(1 AS FLOAT) < CAST(2 AS FLOAT)):boolean> +-- !query 172 output +true + + +-- !query 173 +SELECT cast(1 as float) <= '2' FROM t +-- !query 173 schema +struct<(CAST(1 AS FLOAT) <= CAST(2 AS FLOAT)):boolean> +-- !query 173 output +true + + +-- !query 174 +SELECT cast(1 as float) <> '2' FROM t +-- !query 174 schema +struct<(NOT (CAST(1 AS FLOAT) = CAST(2 AS FLOAT))):boolean> +-- !query 174 output +true + + +-- !query 175 +SELECT cast(1 as float) = cast(null as string) FROM t +-- !query 175 schema +struct<(CAST(1 AS FLOAT) = CAST(CAST(NULL AS STRING) AS FLOAT)):boolean> +-- !query 175 output +NULL + + +-- !query 176 +SELECT cast(1 as float) > cast(null as string) FROM t +-- !query 176 schema +struct<(CAST(1 AS FLOAT) > CAST(CAST(NULL AS STRING) AS FLOAT)):boolean> +-- !query 176 output +NULL + + +-- !query 177 +SELECT cast(1 as float) >= cast(null as string) FROM t +-- !query 177 schema +struct<(CAST(1 AS FLOAT) >= CAST(CAST(NULL AS STRING) AS FLOAT)):boolean> +-- !query 177 output +NULL + + +-- !query 178 +SELECT cast(1 as float) < cast(null as string) FROM t +-- !query 178 schema +struct<(CAST(1 AS FLOAT) < CAST(CAST(NULL AS STRING) AS FLOAT)):boolean> +-- !query 178 output +NULL + + +-- !query 179 +SELECT cast(1 as float) <= cast(null as string) FROM t +-- !query 179 schema +struct<(CAST(1 AS FLOAT) <= CAST(CAST(NULL AS STRING) AS FLOAT)):boolean> +-- !query 179 output +NULL + + +-- !query 180 +SELECT cast(1 as float) <> cast(null as string) FROM t +-- !query 180 schema +struct<(NOT (CAST(1 AS FLOAT) = CAST(CAST(NULL AS STRING) AS FLOAT))):boolean> +-- !query 180 output +NULL + + +-- !query 181 +SELECT '1' = cast(1 as float) FROM t +-- !query 181 schema +struct<(CAST(1 AS FLOAT) = CAST(1 AS FLOAT)):boolean> +-- !query 181 output +true + + +-- !query 182 +SELECT '2' > cast(1 as float) FROM t +-- !query 182 schema +struct<(CAST(2 AS FLOAT) > CAST(1 AS FLOAT)):boolean> +-- !query 182 output +true + + +-- !query 183 +SELECT '2' >= cast(1 as float) FROM t +-- !query 183 schema +struct<(CAST(2 AS FLOAT) >= CAST(1 AS FLOAT)):boolean> +-- !query 183 output +true + + +-- !query 184 +SELECT '2' < cast(1 as float) FROM t +-- !query 184 schema +struct<(CAST(2 AS FLOAT) < CAST(1 AS FLOAT)):boolean> +-- !query 184 output +false + + +-- !query 185 +SELECT '2' <= cast(1 as float) FROM t +-- !query 185 schema +struct<(CAST(2 AS FLOAT) <= CAST(1 AS FLOAT)):boolean> +-- !query 185 output +false + + +-- !query 186 +SELECT '2' <> cast(1 as float) FROM t +-- !query 186 schema +struct<(NOT (CAST(2 AS FLOAT) = CAST(1 AS FLOAT))):boolean> +-- !query 186 output +true + + +-- !query 187 +SELECT cast(null as string) = cast(1 as float) FROM t +-- !query 187 schema +struct<(CAST(CAST(NULL AS STRING) AS FLOAT) = CAST(1 AS FLOAT)):boolean> +-- !query 187 output +NULL + + +-- !query 188 +SELECT cast(null as string) > cast(1 as float) FROM t +-- !query 188 schema +struct<(CAST(CAST(NULL AS STRING) AS FLOAT) > CAST(1 AS FLOAT)):boolean> +-- !query 188 output +NULL + + +-- !query 189 +SELECT cast(null as string) >= cast(1 as float) FROM t +-- !query 189 schema +struct<(CAST(CAST(NULL AS STRING) AS FLOAT) >= CAST(1 AS FLOAT)):boolean> +-- !query 189 output +NULL + + +-- !query 190 +SELECT cast(null as string) < cast(1 as float) FROM t +-- !query 190 schema +struct<(CAST(CAST(NULL AS STRING) AS FLOAT) < CAST(1 AS FLOAT)):boolean> +-- !query 190 output +NULL + + +-- !query 191 +SELECT cast(null as string) <= cast(1 as float) FROM t +-- !query 191 schema +struct<(CAST(CAST(NULL AS STRING) AS FLOAT) <= CAST(1 AS FLOAT)):boolean> +-- !query 191 output +NULL + + +-- !query 192 +SELECT cast(null as string) <> cast(1 as float) FROM t +-- !query 192 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS FLOAT) = CAST(1 AS FLOAT))):boolean> +-- !query 192 output +NULL + + +-- !query 193 +SELECT '1996-09-09' = date('1996-09-09') FROM t +-- !query 193 schema +struct<(1996-09-09 = CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 193 output +true + + +-- !query 194 +SELECT '1996-9-10' > date('1996-09-09') FROM t +-- !query 194 schema +struct<(1996-9-10 > CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 194 output +true + + +-- !query 195 +SELECT '1996-9-10' >= date('1996-09-09') FROM t +-- !query 195 schema +struct<(1996-9-10 >= CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 195 output +true + + +-- !query 196 +SELECT '1996-9-10' < date('1996-09-09') FROM t +-- !query 196 schema +struct<(1996-9-10 < CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 196 output +false + + +-- !query 197 +SELECT '1996-9-10' <= date('1996-09-09') FROM t +-- !query 197 schema +struct<(1996-9-10 <= CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 197 output +false + + +-- !query 198 +SELECT '1996-9-10' <> date('1996-09-09') FROM t +-- !query 198 schema +struct<(NOT (1996-9-10 = CAST(CAST(1996-09-09 AS DATE) AS STRING))):boolean> +-- !query 198 output +true + + +-- !query 199 +SELECT cast(null as string) = date('1996-09-09') FROM t +-- !query 199 schema +struct<(CAST(NULL AS STRING) = CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 199 output +NULL + + +-- !query 200 +SELECT cast(null as string)> date('1996-09-09') FROM t +-- !query 200 schema +struct<(CAST(NULL AS STRING) > CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 200 output +NULL + + +-- !query 201 +SELECT cast(null as string)>= date('1996-09-09') FROM t +-- !query 201 schema +struct<(CAST(NULL AS STRING) >= CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 201 output +NULL + + +-- !query 202 +SELECT cast(null as string)< date('1996-09-09') FROM t +-- !query 202 schema +struct<(CAST(NULL AS STRING) < CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 202 output +NULL + + +-- !query 203 +SELECT cast(null as string)<= date('1996-09-09') FROM t +-- !query 203 schema +struct<(CAST(NULL AS STRING) <= CAST(CAST(1996-09-09 AS DATE) AS STRING)):boolean> +-- !query 203 output +NULL + + +-- !query 204 +SELECT cast(null as string)<> date('1996-09-09') FROM t +-- !query 204 schema +struct<(NOT (CAST(NULL AS STRING) = CAST(CAST(1996-09-09 AS DATE) AS STRING))):boolean> +-- !query 204 output +NULL + + +-- !query 205 +SELECT date('1996-09-09') = '1996-09-09' FROM t +-- !query 205 schema +struct<(CAST(CAST(1996-09-09 AS DATE) AS STRING) = 1996-09-09):boolean> +-- !query 205 output +true + + +-- !query 206 +SELECT date('1996-9-10') > '1996-09-09' FROM t +-- !query 206 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) > 1996-09-09):boolean> +-- !query 206 output +true + + +-- !query 207 +SELECT date('1996-9-10') >= '1996-09-09' FROM t +-- !query 207 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) >= 1996-09-09):boolean> +-- !query 207 output +true + + +-- !query 208 +SELECT date('1996-9-10') < '1996-09-09' FROM t +-- !query 208 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) < 1996-09-09):boolean> +-- !query 208 output +false + + +-- !query 209 +SELECT date('1996-9-10') <= '1996-09-09' FROM t +-- !query 209 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) <= 1996-09-09):boolean> +-- !query 209 output +false + + +-- !query 210 +SELECT date('1996-9-10') <> '1996-09-09' FROM t +-- !query 210 schema +struct<(NOT (CAST(CAST(1996-9-10 AS DATE) AS STRING) = 1996-09-09)):boolean> +-- !query 210 output +true + + +-- !query 211 +SELECT date('1996-09-09') = cast(null as string) FROM t +-- !query 211 schema +struct<(CAST(CAST(1996-09-09 AS DATE) AS STRING) = CAST(NULL AS STRING)):boolean> +-- !query 211 output +NULL + + +-- !query 212 +SELECT date('1996-9-10') > cast(null as string) FROM t +-- !query 212 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) > CAST(NULL AS STRING)):boolean> +-- !query 212 output +NULL + + +-- !query 213 +SELECT date('1996-9-10') >= cast(null as string) FROM t +-- !query 213 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) >= CAST(NULL AS STRING)):boolean> +-- !query 213 output +NULL + + +-- !query 214 +SELECT date('1996-9-10') < cast(null as string) FROM t +-- !query 214 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) < CAST(NULL AS STRING)):boolean> +-- !query 214 output +NULL + + +-- !query 215 +SELECT date('1996-9-10') <= cast(null as string) FROM t +-- !query 215 schema +struct<(CAST(CAST(1996-9-10 AS DATE) AS STRING) <= CAST(NULL AS STRING)):boolean> +-- !query 215 output +NULL + + +-- !query 216 +SELECT date('1996-9-10') <> cast(null as string) FROM t +-- !query 216 schema +struct<(NOT (CAST(CAST(1996-9-10 AS DATE) AS STRING) = CAST(NULL AS STRING))):boolean> +-- !query 216 output +NULL + + +-- !query 217 +SELECT '1996-09-09 12:12:12.4' = timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 217 schema +struct<(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) = CAST(1996-09-09 12:12:12.4 AS TIMESTAMP)):boolean> +-- !query 217 output +true + + +-- !query 218 +SELECT '1996-09-09 12:12:12.5' > timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 218 schema +struct<(1996-09-09 12:12:12.5 > CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 218 output +true + + +-- !query 219 +SELECT '1996-09-09 12:12:12.5' >= timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 219 schema +struct<(1996-09-09 12:12:12.5 >= CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 219 output +true + + +-- !query 220 +SELECT '1996-09-09 12:12:12.5' < timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 220 schema +struct<(1996-09-09 12:12:12.5 < CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 220 output +false + + +-- !query 221 +SELECT '1996-09-09 12:12:12.5' <= timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 221 schema +struct<(1996-09-09 12:12:12.5 <= CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 221 output +false + + +-- !query 222 +SELECT '1996-09-09 12:12:12.5' <> timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 222 schema +struct<(NOT (CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) = CAST(1996-09-09 12:12:12.4 AS TIMESTAMP))):boolean> +-- !query 222 output +true + + +-- !query 223 +SELECT cast(null as string) = timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 223 schema +struct<(CAST(CAST(NULL AS STRING) AS TIMESTAMP) = CAST(1996-09-09 12:12:12.4 AS TIMESTAMP)):boolean> +-- !query 223 output +NULL + + +-- !query 224 +SELECT cast(null as string) > timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 224 schema +struct<(CAST(NULL AS STRING) > CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 224 output +NULL + + +-- !query 225 +SELECT cast(null as string) >= timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 225 schema +struct<(CAST(NULL AS STRING) >= CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 225 output +NULL + + +-- !query 226 +SELECT cast(null as string) < timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 226 schema +struct<(CAST(NULL AS STRING) < CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 226 output +NULL + + +-- !query 227 +SELECT cast(null as string) <= timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 227 schema +struct<(CAST(NULL AS STRING) <= CAST(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) AS STRING)):boolean> +-- !query 227 output +NULL + + +-- !query 228 +SELECT cast(null as string) <> timestamp('1996-09-09 12:12:12.4') FROM t +-- !query 228 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS TIMESTAMP) = CAST(1996-09-09 12:12:12.4 AS TIMESTAMP))):boolean> +-- !query 228 output +NULL + + +-- !query 229 +SELECT timestamp('1996-09-09 12:12:12.4' )= '1996-09-09 12:12:12.4' FROM t +-- !query 229 schema +struct<(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) = CAST(1996-09-09 12:12:12.4 AS TIMESTAMP)):boolean> +-- !query 229 output +true + + +-- !query 230 +SELECT timestamp('1996-09-09 12:12:12.5' )> '1996-09-09 12:12:12.4' FROM t +-- !query 230 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) > 1996-09-09 12:12:12.4):boolean> +-- !query 230 output +true + + +-- !query 231 +SELECT timestamp('1996-09-09 12:12:12.5' )>= '1996-09-09 12:12:12.4' FROM t +-- !query 231 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) >= 1996-09-09 12:12:12.4):boolean> +-- !query 231 output +true + + +-- !query 232 +SELECT timestamp('1996-09-09 12:12:12.5' )< '1996-09-09 12:12:12.4' FROM t +-- !query 232 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) < 1996-09-09 12:12:12.4):boolean> +-- !query 232 output +false + + +-- !query 233 +SELECT timestamp('1996-09-09 12:12:12.5' )<= '1996-09-09 12:12:12.4' FROM t +-- !query 233 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) <= 1996-09-09 12:12:12.4):boolean> +-- !query 233 output +false + + +-- !query 234 +SELECT timestamp('1996-09-09 12:12:12.5' )<> '1996-09-09 12:12:12.4' FROM t +-- !query 234 schema +struct<(NOT (CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) = CAST(1996-09-09 12:12:12.4 AS TIMESTAMP))):boolean> +-- !query 234 output +true + + +-- !query 235 +SELECT timestamp('1996-09-09 12:12:12.4' )= cast(null as string) FROM t +-- !query 235 schema +struct<(CAST(1996-09-09 12:12:12.4 AS TIMESTAMP) = CAST(CAST(NULL AS STRING) AS TIMESTAMP)):boolean> +-- !query 235 output +NULL + + +-- !query 236 +SELECT timestamp('1996-09-09 12:12:12.5' )> cast(null as string) FROM t +-- !query 236 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) > CAST(NULL AS STRING)):boolean> +-- !query 236 output +NULL + + +-- !query 237 +SELECT timestamp('1996-09-09 12:12:12.5' )>= cast(null as string) FROM t +-- !query 237 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) >= CAST(NULL AS STRING)):boolean> +-- !query 237 output +NULL + + +-- !query 238 +SELECT timestamp('1996-09-09 12:12:12.5' )< cast(null as string) FROM t +-- !query 238 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) < CAST(NULL AS STRING)):boolean> +-- !query 238 output +NULL + + +-- !query 239 +SELECT timestamp('1996-09-09 12:12:12.5' )<= cast(null as string) FROM t +-- !query 239 schema +struct<(CAST(CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) AS STRING) <= CAST(NULL AS STRING)):boolean> +-- !query 239 output +NULL + + +-- !query 240 +SELECT timestamp('1996-09-09 12:12:12.5' )<> cast(null as string) FROM t +-- !query 240 schema +struct<(NOT (CAST(1996-09-09 12:12:12.5 AS TIMESTAMP) = CAST(CAST(NULL AS STRING) AS TIMESTAMP))):boolean> +-- !query 240 output +NULL + + +-- !query 241 +SELECT ' ' = X'0020' FROM t +-- !query 241 schema +struct<(CAST( AS BINARY) = X'0020'):boolean> +-- !query 241 output +false + + +-- !query 242 +SELECT ' ' > X'001F' FROM t +-- !query 242 schema +struct<(CAST( AS BINARY) > X'001F'):boolean> +-- !query 242 output +true + + +-- !query 243 +SELECT ' ' >= X'001F' FROM t +-- !query 243 schema +struct<(CAST( AS BINARY) >= X'001F'):boolean> +-- !query 243 output +true + + +-- !query 244 +SELECT ' ' < X'001F' FROM t +-- !query 244 schema +struct<(CAST( AS BINARY) < X'001F'):boolean> +-- !query 244 output +false + + +-- !query 245 +SELECT ' ' <= X'001F' FROM t +-- !query 245 schema +struct<(CAST( AS BINARY) <= X'001F'):boolean> +-- !query 245 output +false + + +-- !query 246 +SELECT ' ' <> X'001F' FROM t +-- !query 246 schema +struct<(NOT (CAST( AS BINARY) = X'001F')):boolean> +-- !query 246 output +true + + +-- !query 247 +SELECT cast(null as string) = X'0020' FROM t +-- !query 247 schema +struct<(CAST(CAST(NULL AS STRING) AS BINARY) = X'0020'):boolean> +-- !query 247 output +NULL + + +-- !query 248 +SELECT cast(null as string) > X'001F' FROM t +-- !query 248 schema +struct<(CAST(CAST(NULL AS STRING) AS BINARY) > X'001F'):boolean> +-- !query 248 output +NULL + + +-- !query 249 +SELECT cast(null as string) >= X'001F' FROM t +-- !query 249 schema +struct<(CAST(CAST(NULL AS STRING) AS BINARY) >= X'001F'):boolean> +-- !query 249 output +NULL + + +-- !query 250 +SELECT cast(null as string) < X'001F' FROM t +-- !query 250 schema +struct<(CAST(CAST(NULL AS STRING) AS BINARY) < X'001F'):boolean> +-- !query 250 output +NULL + + +-- !query 251 +SELECT cast(null as string) <= X'001F' FROM t +-- !query 251 schema +struct<(CAST(CAST(NULL AS STRING) AS BINARY) <= X'001F'):boolean> +-- !query 251 output +NULL + + +-- !query 252 +SELECT cast(null as string) <> X'001F' FROM t +-- !query 252 schema +struct<(NOT (CAST(CAST(NULL AS STRING) AS BINARY) = X'001F')):boolean> +-- !query 252 output +NULL + + +-- !query 253 +SELECT X'0020' = ' ' FROM t +-- !query 253 schema +struct<(X'0020' = CAST( AS BINARY)):boolean> +-- !query 253 output +false + + +-- !query 254 +SELECT X'001F' > ' ' FROM t +-- !query 254 schema +struct<(X'001F' > CAST( AS BINARY)):boolean> +-- !query 254 output +false + + +-- !query 255 +SELECT X'001F' >= ' ' FROM t +-- !query 255 schema +struct<(X'001F' >= CAST( AS BINARY)):boolean> +-- !query 255 output +false + + +-- !query 256 +SELECT X'001F' < ' ' FROM t +-- !query 256 schema +struct<(X'001F' < CAST( AS BINARY)):boolean> +-- !query 256 output +true + + +-- !query 257 +SELECT X'001F' <= ' ' FROM t +-- !query 257 schema +struct<(X'001F' <= CAST( AS BINARY)):boolean> +-- !query 257 output +true + + +-- !query 258 +SELECT X'001F' <> ' ' FROM t +-- !query 258 schema +struct<(NOT (X'001F' = CAST( AS BINARY))):boolean> +-- !query 258 output +true + + +-- !query 259 +SELECT X'0020' = cast(null as string) FROM t +-- !query 259 schema +struct<(X'0020' = CAST(CAST(NULL AS STRING) AS BINARY)):boolean> +-- !query 259 output +NULL + + +-- !query 260 +SELECT X'001F' > cast(null as string) FROM t +-- !query 260 schema +struct<(X'001F' > CAST(CAST(NULL AS STRING) AS BINARY)):boolean> +-- !query 260 output +NULL + + +-- !query 261 +SELECT X'001F' >= cast(null as string) FROM t +-- !query 261 schema +struct<(X'001F' >= CAST(CAST(NULL AS STRING) AS BINARY)):boolean> +-- !query 261 output +NULL + + +-- !query 262 +SELECT X'001F' < cast(null as string) FROM t +-- !query 262 schema +struct<(X'001F' < CAST(CAST(NULL AS STRING) AS BINARY)):boolean> +-- !query 262 output +NULL + + +-- !query 263 +SELECT X'001F' <= cast(null as string) FROM t +-- !query 263 schema +struct<(X'001F' <= CAST(CAST(NULL AS STRING) AS BINARY)):boolean> +-- !query 263 output +NULL + + +-- !query 264 +SELECT X'001F' <> cast(null as string) FROM t +-- !query 264 schema +struct<(NOT (X'001F' = CAST(CAST(NULL AS STRING) AS BINARY))):boolean> +-- !query 264 output +NULL --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org
