You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by tl...@apache.org on 2021/04/28 13:51:10 UTC
[ignite] branch sql-calcite updated: IGNITE-14633 Calcite engine.
Sort out the types/[hugeint|map|null|struct|unsigned] directories
This is an automated email from the ASF dual-hosted git repository.
tledkov pushed a commit to branch sql-calcite
in repository https://gitbox.apache.org/repos/asf/ignite.git
The following commit(s) were added to refs/heads/sql-calcite by this push:
new ea567ba IGNITE-14633 Calcite engine. Sort out the types/[hugeint|map|null|struct|unsigned] directories
ea567ba is described below
commit ea567ba132f78fbc5d171791ac70f17e1849ecf5
Author: korlov42 <ko...@gridgain.com>
AuthorDate: Wed Apr 28 16:50:19 2021 +0300
IGNITE-14633 Calcite engine. Sort out the types/[hugeint|map|null|struct|unsigned] directories
---
.../test/sql/types/hugeint/hugeint_multiply.test | 144 ---------------
.../sql/types/hugeint/test_hugeint_aggregates.test | 26 ---
.../sql/types/hugeint/test_hugeint_arithmetic.test | 193 ---------------------
.../sql/types/hugeint/test_hugeint_auto_cast.test | 32 ----
.../sql/types/hugeint/test_hugeint_bitwise.test | 137 ---------------
.../sql/types/hugeint/test_hugeint_conversion.test | 167 ------------------
.../sql/types/hugeint/test_hugeint_functions.test | 45 -----
.../sql/types/hugeint/test_hugeint_null_value.test | 48 -----
.../test/sql/types/hugeint/test_hugeint_ops.test | 75 --------
.../map/{test_map.test => test_map.test_ignored} | 1 +
.../src/test/sql/types/null/test_boolean_null.test | 16 +-
.../src/test/sql/types/null/test_is_null.test | 14 +-
.../calcite/src/test/sql/types/null/test_null.test | 32 +---
.../src/test/sql/types/null/test_null_aggr.test | 4 +-
.../sql/types/struct/lineitem_struct.test_slow | 38 ----
.../test/sql/types/struct/struct_aggregates.test | 16 --
.../src/test/sql/types/struct/test_struct.test | 177 -------------------
....test => test_unsigned_arithmetic.test_ignored} | 1 +
...t.test => test_unsigned_auto_cast.test_ignored} | 1 +
....test => test_unsigned_conversion.test_ignored} | 1 +
20 files changed, 26 insertions(+), 1142 deletions(-)
diff --git a/modules/calcite/src/test/sql/types/hugeint/hugeint_multiply.test b/modules/calcite/src/test/sql/types/hugeint/hugeint_multiply.test
deleted file mode 100644
index 5edbe65..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/hugeint_multiply.test
+++ /dev/null
@@ -1,144 +0,0 @@
-# name: test/sql/types/hugeint/hugeint_multiply.test
-# description: Test correct computation of hugeint multiplication
-# group: [hugeint]
-
-# overflows of various parts of the multiplication
-# hugeint multiplication is done in 4 segments (low bits & high bits of the lower and upper int64 part)
-# we test all combinations here
-# 251658240 = [low, low]
-# 1080863910568919040 = [low, high]
-# 4642275147320176030871715840 [high, low]
-# 19938419936773738093557105904205168640 [high, high]
-
-# [low, low] mult
-query I
-SELECT 251658240::HUGEINT * 251658240::HUGEINT
-----
-63331869759897600
-
-query I
-SELECT 251658240::HUGEINT * 1080863910568919040::HUGEINT
-----
-272008309413291564308889600
-
-query I
-SELECT 251658240::HUGEINT * 4642275147320176030871715840::HUGEINT
-----
-1168266793170336216419361674074521600
-
-statement error
-SELECT 251658240::HUGEINT * 19938419936773738093557105904205168640::HUGEINT
-
-# [low, high]
-query I
-SELECT 1080863910568919040::HUGEINT * 251658240::HUGEINT
-----
-272008309413291564308889600
-
-query I
-SELECT 1080863910568919040::HUGEINT * 1080863910568919040::HUGEINT
-----
-1168266793170336216419361674074521600
-
-statement error
-SELECT 1080863910568919040::HUGEINT * 4642275147320176030871715840::HUGEINT
-
-statement error
-SELECT 1080863910568919040::HUGEINT * 19938419936773738093557105904205168640::HUGEINT
-
-# [high, low]
-query I
-SELECT 4642275147320176030871715840::HUGEINT * 251658240::HUGEINT
-----
-1168266793170336216419361674074521600
-
-statement error
-SELECT 4642275147320176030871715840::HUGEINT * 1080863910568919040::HUGEINT
-
-statement error
-SELECT 4642275147320176030871715840::HUGEINT * 4642275147320176030871715840::HUGEINT
-
-statement error
-SELECT 4642275147320176030871715840::HUGEINT * 19938419936773738093557105904205168640::HUGEINT
-
-# [high, high]
-statement error
-SELECT 19938419936773738093557105904205168640::HUGEINT * 251658240::HUGEINT
-
-statement error
-SELECT 19938419936773738093557105904205168640::HUGEINT * 1080863910568919040::HUGEINT
-
-statement error
-SELECT 19938419936773738093557105904205168640::HUGEINT * 4642275147320176030871715840::HUGEINT
-
-statement error
-SELECT 19938419936773738093557105904205168640::HUGEINT * 19938419936773738093557105904205168640::HUGEINT
-
-# more overflow tests on the boundaries
-query I
-SELECT 85070591730234615865843651857942052863::HUGEINT * 2::HUGEINT
-----
-170141183460469231731687303715884105726
-
-statement error
-SELECT 85070591730234615865843651857942052864::HUGEINT * 2::HUGEINT
-
-statement error
-SELECT 85070591730234615865843651857942052865::HUGEINT * 2::HUGEINT
-
-query I
-SELECT 19807040628566084398385987583::HUGEINT * 8589934592::HUGEINT
-----
-170141183460469231731687303707294171136
-
-statement error
-SELECT 19807040628566084398385987584::HUGEINT*8589934592::HUGEINT;
-
-query I
-SELECT 36893488147419103231::HUGEINT * 4611686018427387904::HUGEINT
-----
-170141183460469231727075617697456717824
-
-statement error
-SELECT 36893488147419103232::HUGEINT * 4611686018427387904::HUGEINT
-
-# now reverse sides
-query I
-SELECT 2::HUGEINT * 85070591730234615865843651857942052863::HUGEINT
-----
-170141183460469231731687303715884105726
-
-statement error
-SELECT 2::HUGEINT * 85070591730234615865843651857942052864::HUGEINT
-
-statement error
-SELECT 2::HUGEINT * 85070591730234615865843651857942052865::HUGEINT
-
-query I
-SELECT 8589934592::HUGEINT * 19807040628566084398385987583::HUGEINT
-----
-170141183460469231731687303707294171136
-
-statement error
-SELECT 8589934592::HUGEINT * 19807040628566084398385987584::HUGEINT
-
-query I
-SELECT 4611686018427387904::HUGEINT * 36893488147419103231::HUGEINT
-----
-170141183460469231727075617697456717824
-
-statement error
-SELECT 4611686018427387904::HUGEINT * 36893488147419103232::HUGEINT
-
-query I
-SELECT 10376293541461622783::HUGEINT * 10376293541461622783::HUGEINT
-----
-107667467658578185684455784799784665089
-
-query I
-SELECT 10376293541461622783::HUGEINT * 10376293541461622783::HUGEINT
-----
-107667467658578185684455784799784665089
-
-statement error
-SELECT 17293822569102704639::HUGEINT * 10376293541461622783::HUGEINT
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_aggregates.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_aggregates.test
deleted file mode 100644
index 670099b..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_aggregates.test
+++ /dev/null
@@ -1,26 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_aggregates.test
-# description: Test hugeint aggregates
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-statement ok
-CREATE TABLE hugeints(g INTEGER, h HUGEINT);
-
-statement ok
-INSERT INTO hugeints VALUES (1, 42.0), (2, 1267650600228229401496703205376), (2, -439847238974238975238975), (1, '-12');
-
-# min, max, first, sum
-# ungrouped aggregate
-query IIII
-SELECT MIN(h), MAX(h), SUM(h), FIRST(h) FROM hugeints;
-----
--439847238974238975238975 1267650600228229401496703205376 1267650160380990427257727966431 42
-
-# grouped aggregate
-query IIIII
-SELECT g, MIN(h), MAX(h), SUM(h), FIRST(h) FROM hugeints GROUP BY g ORDER BY 1;
-----
-1 -12 42 30 42
-2 -439847238974238975238975 1267650600228229401496703205376 1267650160380990427257727966401 1267650600228229401496703205376
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_arithmetic.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_arithmetic.test
deleted file mode 100644
index 64512fb..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_arithmetic.test
+++ /dev/null
@@ -1,193 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_arithmetic.test
-# description: Test arithmetic with huge integers
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-# negation
-query II
-SELECT -(100::HUGEINT), -(-(50::HUGEINT));
-----
--100 50
-
-# negate 0
-query I
-SELECT -(0::HUGEINT)
-----
-0
-
-# negation with large numbers
-query II
-SELECT -(100000000000000000000::HUGEINT), -(-(100000000000000000000::HUGEINT));
-----
--100000000000000000000 100000000000000000000
-
-# addition
-# simple addition: small values
-query I
-SELECT 42::HUGEINT + 42::HUGEINT;
-----
-84
-
-# negative values
-query III
-SELECT 42::HUGEINT + -42::HUGEINT, -42::HUGEINT + 100::HUGEINT, -42::HUGEINT+-42::HUGEINT;
-----
-0 58 -84
-
-# large values
-query I
-SELECT '100000000000000000000'::HUGEINT + '100000000000000000000'::HUGEINT;
-----
-200000000000000000000
-
-# large negative values
-query I
-SELECT '100000000000000000000'::HUGEINT + '-1000000000000000000000'::HUGEINT;
-----
--900000000000000000000
-
-query I
-SELECT '5'::HUGEINT + '-10000000000000000002'::HUGEINT;
-----
--9999999999999999997
-
-# overflow in addition
-statement error
-SELECT '170141183460469231731687303715884105727'::HUGEINT + '170141183460469231731687303715884105727'::HUGEINT;
-
-statement error
-SELECT '170141183460469231731687303715884105727'::HUGEINT + '10'::HUGEINT;
-
-# almost overflowing but not quite
-query I
-SELECT '170141183460469231731687303715884105727'::HUGEINT - 10::HUGEINT + 10::HUGEINT
-----
-170141183460469231731687303715884105727
-
-query I
-SELECT '-170141183460469231731687303715884105727'::HUGEINT + 10::HUGEINT - 10::HUGEINT
-----
--170141183460469231731687303715884105727
-
-# overflowing
-statement error
-SELECT '170141183460469231731687303715884105727'::HUGEINT - 10::HUGEINT + 11::HUGEINT
-
-statement error
-SELECT '-170141183460469231731687303715884105727'::HUGEINT + 10::HUGEINT - 11::HUGEINT
-
-# subtraction
-query II
-SELECT 100::HUGEINT - 42::HUGEINT, 3::HUGEINT - 5::HUGEINT;
-----
-58 -2
-
-# negative combinations
-query III
-SELECT -100::HUGEINT - 42::HUGEINT, -3::HUGEINT - 5::HUGEINT, 12::HUGEINT-(-12::HUGEINT);
-----
--142 -8 24
-
-# large subtraction
-query I
-SELECT '-10000000000000000002'::HUGEINT - '-10000000000000000002'::HUGEINT;
-----
-0
-
-# underflow in subtraction
-statement error
-SELECT '-170141183460469231731687303715884105727'::HUGEINT - '170141183460469231731687303715884105727'::HUGEINT;
-
-statement error
-SELECT '170141183460469231731687303715884105727'::HUGEINT - '-170141183460469231731687303715884105727'::HUGEINT;
-
-# multiplication
-query I
-SELECT 100::HUGEINT * 50::HUGEINT;
-----
-5000
-
-# negative multiplication
-query III
-SELECT 100::HUGEINT * -50::HUGEINT, -100::HUGEINT * 50::HUGEINT, -100::HUGEINT * -50::HUGEINT;
-----
--5000 -5000 5000
-
-# multiplying large numbers
-query II
-SELECT '1701411834604692317'::HUGEINT * '2'::HUGEINT, '100000000000000000000'::HUGEINT * '1000000000000000000'::HUGEINT
-----
-3402823669209384634 100000000000000000000000000000000000000
-
-query I
-SELECT '170141183460469231731687303715884105727'::HUGEINT * 1::HUGEINT
-----
-170141183460469231731687303715884105727
-
-# overflow in multiplication
-statement error
-SELECT '170141183460469231731687303715884105727'::HUGEINT * 2::HUGEINT
-
-statement error
-SELECT '1701411834604692317'::HUGEINT * '131687303715884105727'::HUGEINT
-
-# division
-query II
-SELECT 100::HUGEINT / 20::HUGEINT, 90::HUGEINT / 20::HUGEINT
-----
-5 4
-
-# negative values
-query III
-SELECT -100::HUGEINT / 20::HUGEINT, 100::HUGEINT / -20::HUGEINT, -100::HUGEINT / -20::HUGEINT
-----
--5 -5 5
-
-# division by zero
-query I
-SELECT 100::HUGEINT / 0::HUGEINT
-----
-NULL
-
-# large values
-query II
-SELECT '100000000000000000000000000000000000000'::HUGEINT / '10000000000000'::HUGEINT, '100000000000000000000000000000000000000'::HUGEINT / '2'::HUGEINT
-----
-10000000000000000000000000 50000000000000000000000000000000000000
-
-# modulo
-query II
-SELECT 100::HUGEINT % 20::HUGEINT, 90::HUGEINT % 20::HUGEINT
-----
-0 10
-
-# negative values
-query III
-SELECT -90 % 20, 90 % -20, -90 % -20
-----
--10 10 -10
-
-query III
-SELECT -90::HUGEINT % 20::HUGEINT, 90::HUGEINT % -20::HUGEINT, -90::HUGEINT % -20::HUGEINT
-----
--10 10 -10
-
-# modulo by zero
-query I
-SELECT 100::HUGEINT % 0::HUGEINT
-----
-NULL
-
-# large values
-query II
-SELECT '100000000000000000000000000000000000000'::HUGEINT % '6587689457689375689735'::HUGEINT, '100000000000000000000000000000000000000'::HUGEINT % '3'::HUGEINT
-----
-5396771390320972230850 1
-
-# abs
-query II
-SELECT ABS('100'::HUGEINT), ABS('-100'::HUGEINT);;
-----
-100 100
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_auto_cast.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_auto_cast.test
deleted file mode 100644
index a66aa48..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_auto_cast.test
+++ /dev/null
@@ -1,32 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_auto_cast.test
-# description: Test hugeint auto cast
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-# test auto cast of all integer types to hugeint
-query IIII
-SELECT 10000000000000000000::HUGEINT + 100::TINYINT, 10000000000000000000::HUGEINT + 100::SMALLINT, 10000000000000000000::HUGEINT + 100::INTEGER, 10000000000000000000::HUGEINT + 100::BIGINT;
-----
-10000000000000000100
-10000000000000000100
-10000000000000000100
-10000000000000000100
-
-# test auto cast of HUGEINT -> DOUBLE
-query I
-SELECT 100::HUGEINT + 0.5
-----
-100.5
-
-query I
-SELECT COS(100::HUGEINT)
-----
-0.862318872287684
-
-# test auto cast of HUGEINT -> VARCHAR
-query I
-SELECT CONCAT('hello number ', 100::HUGEINT)
-----
-hello number 100
\ No newline at end of file
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_bitwise.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_bitwise.test
deleted file mode 100644
index 2bfcf10..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_bitwise.test
+++ /dev/null
@@ -1,137 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_bitwise.test
-# description: Test bitwise operations of huge int type
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-# left-shift
-query I
-SELECT 1::HUGEINT << 3
-----
-8
-
-query I
-SELECT 27::HUGEINT << 0
-----
-27
-
-query I
-SELECT -27::HUGEINT << 1
-----
-0
-
-# large shifts
-query II
-select 1::HUGEINT << 50, 1::HUGEINT << 100;
-----
-1125899906842624 1267650600228229401496703205376
-
-# shift chains
-query II
-select (((((1::HUGEINT << 50) << 50) << 2) << 3) << 8), (1::HUGEINT)<<50<<20<<7<<18<<3<<6<<9
-----
-10384593717069655257060992658440192 10384593717069655257060992658440192
-
-query I
-select 1::HUGEINT << 64;
-----
-18446744073709551616
-
-
-# out of bounds shifts
-query II
-select 1::HUGEINT << 200, '1329227995784915872903807060280344576'::HUGEINT << 50;
-----
-0 0
-
-query II
-SELECT 27::HUGEINT << -1, 100::HUGEINT << '1329227995784915872903807060280344576'::HUGEINT
-----
-0 0
-
-# right-shift
-query I
-SELECT 8::HUGEINT >> 3
-----
-1
-
-query I
-SELECT 27::HUGEINT >> 0
-----
-27
-
-query I
-SELECT -27::HUGEINT >> 1
-----
-0
-
-query I
-SELECT 27::HUGEINT >> -1
-----
-0
-
-# large shifts
-query II
-select (1::HUGEINT << 100) >> 50, (1::HUGEINT << 120)>>108;
-----
-1125899906842624 4096
-
-query I
-SELECT '1329227995784915872903807060280344576'::HUGEINT >> 200
-----
-0
-
-query I
-SELECT '1329227995784915872903807060280344576'::HUGEINT >> 64
-----
-72057594037927936
-
-query I
-SELECT '1329227995784915872903807060280344576'::HUGEINT >> 4 >> 5 >> 7 >> 9 >> 12 >> 13
-----
-1180591620717411303424
-
-# bitwise &
-query I
-select 1::HUGEINT & 3::HUGEINT
-----
-1
-
-query I
-select 51290852742897895128414::HUGEINT & 4923847238975289723895239078235::HUGEINT
-----
-40291148384447586808154
-
-# bitwise |
-query I
-select 1::HUGEINT | 2::HUGEINT
-----
-3
-
-query I
-select 51290852742897895128414::HUGEINT | 4923847238975289723895239078235::HUGEINT
-----
-4923847249974994082345547398495
-
-# bitwise xor
-query I
-select xor(1::HUGEINT, 3::HUGEINT)
-----
-2
-
-query I
-select xor(51290852742897895128414::HUGEINT, 4923847238975289723895239078235::HUGEINT)
-----
-4923847209683845697897960590341
-
-# bitwise not
-query I
-select ~(1::HUGEINT)
-----
--2
-
-query I
-select ~(4923847238975289723895239078235::HUGEINT)
-----
--4923847238975289723895239078236
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_conversion.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_conversion.test
deleted file mode 100644
index 3bc813a..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_conversion.test
+++ /dev/null
@@ -1,167 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_conversion.test
-# description: Test hugeint conversion
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-# small numbers in hugeint
-query III
-SELECT '7'::HUGEINT, '130'::HUGEINT, '924829852'::HUGEINT
-----
-7 130 924829852
-
-# zero
-query II
-SELECT '0'::HUGEINT, '-0'::HUGEINT
-----
-0 0
-
-# small negative numbers
-query III
-SELECT '-7'::HUGEINT, '-130'::HUGEINT, '-924829852'::HUGEINT
-----
--7 -130 -924829852
-
-query I
-SELECT '10000000000000000000000000000'::HUGEINT;
-----
-10000000000000000000000000000
-
-# huge numbers in hugeint
-query II
-SELECT '1267650600228229401496703205376'::HUGEINT, '17014118346046923173168730371588410572'::HUGEINT;
-----
-1267650600228229401496703205376 17014118346046923173168730371588410572
-
-# huge negative numbers in hugeint
-query II
-SELECT '-1267650600228229401496703205376'::HUGEINT, '-17014118346046923173168730371588410572'::HUGEINT;
-----
--1267650600228229401496703205376 -17014118346046923173168730371588410572
-
-
-# string -> hugeint conversion throws error on overflow
-statement error
-SELECT '1701411834604692317316873037158841057200'::HUGEINT;
-
-statement error
-SELECT '-1701411834604692317316873037158841057200'::HUGEINT;
-
-# test the exact boundaries
-# these work
-query II
-SELECT '170141183460469231731687303715884105727'::HUGEINT, '-170141183460469231731687303715884105727'::HUGEINT;
-----
-170141183460469231731687303715884105727 -170141183460469231731687303715884105727
-
-# these don't
-statement error
-SELECT '170141183460469231731687303715884105728'::HUGEINT;
-
-statement error
-SELECT '-170141183460469231731687303715884105728'::HUGEINT;
-
-# cast various types to hugeint
-query IIIIII
-SELECT 42::TINYINT::HUGEINT, 42::SMALLINT::HUGEINT, 42::INTEGER::HUGEINT, 42::BIGINT::HUGEINT, 42::FLOAT::HUGEINT, 42::DOUBLE::HUGEINT;
-----
-42 42 42 42 42 42
-
-# negative values
-query IIIIII
-SELECT (-42)::TINYINT::HUGEINT, (-42)::SMALLINT::HUGEINT, (-42)::INTEGER::HUGEINT, (-42)::BIGINT::HUGEINT, (-42)::FLOAT::HUGEINT, (-42)::DOUBLE::HUGEINT;
-----
--42 -42 -42 -42 -42 -42
-
-# cast hugeint to various types
-query IIIIRR
-SELECT 42::HUGEINT::TINYINT, 42::HUGEINT::SMALLINT, 42::HUGEINT::INTEGER, 42::HUGEINT::BIGINT, 42::HUGEINT::FLOAT, 42::HUGEINT::DOUBLE;
-----
-42 42 42 42 42 42
-
-# negative values
-query IIIIRR
-SELECT (-42)::HUGEINT::TINYINT, (-42)::HUGEINT::SMALLINT, (-42)::HUGEINT::INTEGER, (-42)::HUGEINT::BIGINT, (-42)::HUGEINT::FLOAT, (-42)::HUGEINT::DOUBLE;
-----
--42 -42 -42 -42 -42 -42
-
-# overflow in hugeint -> integer conversion
-# test the exact boundaries for each type
-statement error
-SELECT 1000::HUGEINT::TINYINT;
-
-# TINYINT
-statement error
-SELECT 128::HUGEINT::TINYINT;
-
-statement error
-SELECT -128::HUGEINT::TINYINT;
-
-statement ok
-SELECT 127::HUGEINT::TINYINT, -127::HUGEINT::TINYINT;
-
-# SMALLINT
-statement error
-SELECT 100000::HUGEINT::SMALLINT;
-
-statement error
-SELECT 32768::HUGEINT::SMALLINT;
-
-statement error
-SELECT -32768::HUGEINT::SMALLINT;
-
-statement ok
-SELECT 32767::HUGEINT::SMALLINT, -32767::HUGEINT::SMALLINT;
-
-# INTEGER
-statement error
-SELECT 100000000000::HUGEINT::INTEGER;
-
-statement error
-SELECT 2147483648::HUGEINT::INTEGER;
-
-statement error
-SELECT -2147483648::HUGEINT::INTEGER;
-
-statement ok
-SELECT 2147483647::HUGEINT::INTEGER, -2147483647::HUGEINT::INTEGER;
-
-# BIGINT
-statement error
-SELECT 10000000000000000000::HUGEINT::BIGINT;
-
-statement error
-SELECT '9223372036854775808'::HUGEINT::BIGINT;
-
-statement error
-SELECT '-9223372036854775808'::HUGEINT::BIGINT;
-
-statement ok
-SELECT 9223372036854775807::HUGEINT::BIGINT, -9223372036854775807::HUGEINT::BIGINT;
-
-# overflow in double -> hugeint conversion
-statement error
-SELECT 1e100::FLOAT::HUGEINT;
-
-statement error
-SELECT 1e100::DOUBLE::HUGEINT;
-
-# typeof large constant is hugeint, as long as it fits
-query TTTTT
-SELECT typeof(10), typeof(10000000000), typeof(170141183460469231731687303715884105727), typeof(170141183460469231731687303715884105728), typeof(170141183460469231731687303715884105728000)
-----
-INTEGER BIGINT HUGEINT DOUBLE DOUBLE
-
-# exponents are always double
-query III
-select 1e30, 1e100, 1e-1
-----
-1000000000000000000000000000000
-10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
-0.1
-
-query III
-select typeof(1e30), typeof(1e100), typeof(1e-1)
-----
-DOUBLE DOUBLE DOUBLE
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_functions.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_functions.test
deleted file mode 100644
index c5341cd..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_functions.test
+++ /dev/null
@@ -1,45 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_functions.test
-# description: Test various functions on huge integers
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-# abs
-query III
-select abs(1::HUGEINT), abs('-1329227995784915872903807060280344576'::HUGEINT), abs(0::HUGEINT)
-----
-1 1329227995784915872903807060280344576 0
-
-# sign
-query III
-select sign(1::HUGEINT), sign('-1329227995784915872903807060280344576'::HUGEINT), sign(0::HUGEINT)
-----
-1 -1 0
-
-# round/floor/ceil
-query III
-select round(1::HUGEINT, 0), round('-1329227995784915872903807060280344576'::HUGEINT, 0), round(0::HUGEINT, 0)
-----
-1 -1329227995784915872903807060280344576 0
-
-query III
-select floor(1::HUGEINT), floor('-1329227995784915872903807060280344576'::HUGEINT), floor(0::HUGEINT)
-----
-1 -1329227995784915872903807060280344576 0
-
-query III
-select ceil(1::HUGEINT), ceil('-1329227995784915872903807060280344576'::HUGEINT), ceil(0::HUGEINT)
-----
-1 -1329227995784915872903807060280344576 0
-
-# least/greatest
-query I
-select LEAST(1::HUGEINT, '-1329227995784915872903807060280344576'::HUGEINT, 0::HUGEINT)
-----
--1329227995784915872903807060280344576
-
-query I
-select GREATEST(1::HUGEINT, '-1329227995784915872903807060280344576'::HUGEINT, 0::HUGEINT)
-----
-1
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_null_value.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_null_value.test
deleted file mode 100644
index 3bbc3c7..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_null_value.test
+++ /dev/null
@@ -1,48 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_null_value.test
-# description: Test hugeint null value handling
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-query I
-SELECT NULL::HUGEINT
-----
-NULL
-
-statement ok
-CREATE TABLE hugeints(id INTEGER, h HUGEINT)
-
-statement ok
-INSERT INTO hugeints VALUES (1, NULL), (1, 1), (1, 2)
-
-query II
-SELECT id, FIRST(h) FROM hugeints WHERE h IS NULL GROUP BY id
-----
-1 NULL
-
-query II
-SELECT h, SUM(id) FROM hugeints GROUP BY h ORDER BY 1
-----
-NULL 1
-1 1
-2 1
-
-query III
-SELECT id, h1.h, h2.h FROM hugeints h1 JOIN hugeints h2 USING (id) WHERE h1.h IS NULL AND h2.h IS NULL
-----
-1 NULL NULL
-
-query I
-SELECT (SELECT h1.h) FROM hugeints h1 ORDER BY 1
-----
-NULL
-1
-2
-
-query I
-SELECT h1.h NOT IN (SELECT h1.h+h2.h FROM hugeints h2) FROM hugeints h1 ORDER BY 1
-----
-NULL
-NULL
-NULL
diff --git a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_ops.test b/modules/calcite/src/test/sql/types/hugeint/test_hugeint_ops.test
deleted file mode 100644
index 9fb97ce..0000000
--- a/modules/calcite/src/test/sql/types/hugeint/test_hugeint_ops.test
+++ /dev/null
@@ -1,75 +0,0 @@
-# name: test/sql/types/hugeint/test_hugeint_ops.test
-# description: Test various huge integer ops
-# group: [hugeint]
-
-statement ok
-PRAGMA enable_verification
-
-# test storage of the HUGEINT type
-statement ok
-CREATE TABLE hugeints(h HUGEINT);
-
-statement ok
-INSERT INTO hugeints VALUES (42::HUGEINT), ('1267650600228229401496703205376'::HUGEINT);
-
-# out of range conversion
-# statement error
-# SELECT h::INTEGER FROM hugeints
-
-# filter before cast works
-query I
-SELECT h::INTEGER FROM hugeints WHERE h < 100
-----
-42
-
-# test different comparison ops
-query I
-SELECT COUNT(*) FROM hugeints WHERE h = 42::HUGEINT
-----
-1
-
-query I
-SELECT COUNT(*) FROM hugeints WHERE h <> '1267650600228229401496703205376'::HUGEINT
-----
-1
-
-query I
-SELECT COUNT(*) FROM hugeints WHERE h < '1267650600228229401496703205376'::HUGEINT
-----
-1
-
-query I
-SELECT COUNT(*) FROM hugeints WHERE h <= '1267650600228229401496703205376'::HUGEINT
-----
-2
-
-query I
-SELECT COUNT(*) FROM hugeints WHERE h > '1267650600228229401496703205375'::HUGEINT
-----
-1
-
-query I
-SELECT COUNT(*) FROM hugeints WHERE h >= 42::HUGEINT
-----
-2
-
-# joins
-statement ok
-CREATE TABLE hugeints2(h HUGEINT);
-INSERT INTO hugeints2 VALUES (42::HUGEINT);
-
-query I
-SELECT * FROM hugeints JOIN hugeints2 USING (h);
-----
-42
-
-query II
-SELECT * FROM hugeints t1 JOIN hugeints2 t2 ON t1.h <> t2.h
-----
-1267650600228229401496703205376 42
-
-query II
-SELECT * FROM hugeints t1 JOIN hugeints2 t2 ON t1.h >= t2.h ORDER BY 1 LIMIT 2
-----
-42 42
-1267650600228229401496703205376 42
diff --git a/modules/calcite/src/test/sql/types/map/test_map.test b/modules/calcite/src/test/sql/types/map/test_map.test_ignored
similarity index 90%
rename from modules/calcite/src/test/sql/types/map/test_map.test
rename to modules/calcite/src/test/sql/types/map/test_map.test_ignored
index 718475a..4c9f27a 100644
--- a/modules/calcite/src/test/sql/types/map/test_map.test
+++ b/modules/calcite/src/test/sql/types/map/test_map.test_ignored
@@ -1,6 +1,7 @@
# name: test/sql/types/map/test_map.test
# description: Test basic casting of maps
# group: [map]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14596
statement ok
PRAGMA enable_verification
diff --git a/modules/calcite/src/test/sql/types/null/test_boolean_null.test b/modules/calcite/src/test/sql/types/null/test_boolean_null.test
index f24d297..ef034a8 100644
--- a/modules/calcite/src/test/sql/types/null/test_boolean_null.test
+++ b/modules/calcite/src/test/sql/types/null/test_boolean_null.test
@@ -7,27 +7,27 @@ PRAGMA enable_verification
# AND
query TTTTTTTTT
-SELECT 0 AND 0, 0 AND 1, 1 AND 0, 1 AND 1, NULL AND 0, NULL AND 1, 0 AND NULL, 1 AND NULL, NULL AND NULL
+SELECT FALSE AND FALSE, FALSE AND TRUE, TRUE AND FALSE, TRUE AND TRUE, NULL AND FALSE, NULL AND TRUE, FALSE AND NULL, TRUE AND NULL, NULL AND NULL
----
-0 0 0 1 0 NULL 0 NULL NULL
+false false false true false NULL false NULL NULL
# OR
query TTTTTTTTT
-SELECT 0 OR 0, 0 OR 1, 1 OR 0, 1 OR 1, NULL OR 0, NULL OR 1, 0 OR NULL, 1 OR NULL, NULL OR NULL
+SELECT FALSE OR FALSE, FALSE OR TRUE, TRUE OR FALSE, TRUE OR TRUE, NULL OR FALSE, NULL OR TRUE, FALSE OR NULL, TRUE OR NULL, NULL OR NULL
----
-0 1 1 1 NULL 1 NULL 1 NULL
+false true true true NULL true NULL true NULL
# NOT
query TTT
-SELECT NOT(0), NOT(1), NOT(NULL)
+SELECT NOT(FALSE), NOT(TRUE), NOT(NULL)
----
-1 0 NULL
+true false NULL
# IS NULL
query TTTT
SELECT NULL IS NULL, NULL IS NOT NULL, 42 IS NULL, 42 IS NOT NULL
----
-1 0 0 1
+true false false true
# Comparisions
query TTTT
@@ -44,7 +44,7 @@ INSERT INTO test VALUES (11, 22), (NULL, 21), (13, 22), (12, NULL), (16, NULL)
query IIRII
SELECT b, COUNT(a), SUM(a), MIN(a), MAX(a) FROM test GROUP BY b ORDER BY b
----
-NULL 2 28.000000 12 16
21 0 NULL NULL NULL
22 2 24.000000 11 13
+NULL 2 28.000000 12 16
diff --git a/modules/calcite/src/test/sql/types/null/test_is_null.test b/modules/calcite/src/test/sql/types/null/test_is_null.test
index ac78618..6cd3323 100644
--- a/modules/calcite/src/test/sql/types/null/test_is_null.test
+++ b/modules/calcite/src/test/sql/types/null/test_is_null.test
@@ -10,15 +10,15 @@ INSERT INTO test VALUES (11, 1), (NULL, 2), (13, 3)
# IS NULL/IS NOT NULL
query TTTT
-SELECT a IS NULL, a IS NOT NULL, rowid IS NULL, (a = NULL) IS NULL FROM test ORDER BY b
+SELECT a IS NULL, a IS NOT NULL, _key IS NULL, (a = NULL) IS NULL FROM test ORDER BY b
----
-0 1 0 1
-1 0 0 1
-0 1 0 1
+false true false true
+true false false true
+false true false true
query TTTT
-SELECT a IS NULL, a IS NOT NULL, rowid IS NULL, (a = NULL) IS NULL FROM test WHERE b != 1 ORDER BY b
+SELECT a IS NULL, a IS NOT NULL, _key IS NULL, (a = NULL) IS NULL FROM test WHERE b <> 1 ORDER BY b
----
-1 0 0 1
-0 1 0 1
+true false false true
+false true false true
diff --git a/modules/calcite/src/test/sql/types/null/test_null.test b/modules/calcite/src/test/sql/types/null/test_null.test
index 9d682de..9f8ce2c 100644
--- a/modules/calcite/src/test/sql/types/null/test_null.test
+++ b/modules/calcite/src/test/sql/types/null/test_null.test
@@ -34,12 +34,6 @@ SELECT 1 + (NULL + NULL)
----
NULL
-# division by zero
-query I
-SELECT 4 / 0
-----
-NULL
-
statement ok
CREATE TABLE test (a INTEGER, b INTEGER);
@@ -48,41 +42,25 @@ INSERT INTO test VALUES (11, 22), (NULL, 21), (13, 22)
# NULL selection
query I
-SELECT a FROM test
+SELECT a FROM test ORDER BY a;
----
11
-NULL
13
+NULL
# cast NULL
query I
-SELECT cast(a AS BIGINT) FROM test;
+SELECT cast(a AS BIGINT) FROM test ORDER BY a;
----
11
-NULL
13
-
-# division by constant zero is NULL
-query I
-SELECT a / 0 FROM test;
-----
-NULL
-NULL
-NULL
-
-# division by non-constant zero as well
-query I
-SELECT a / (a - a) FROM test;
-----
-NULL
-NULL
NULL
# NULL addition results in NULL
query I
-SELECT a + b FROM test
+SELECT a + b FROM test ORDER BY a;
----
33
-NULL
35
+NULL
diff --git a/modules/calcite/src/test/sql/types/null/test_null_aggr.test b/modules/calcite/src/test/sql/types/null/test_null_aggr.test
index 9bde583..b29a0e5 100644
--- a/modules/calcite/src/test/sql/types/null/test_null_aggr.test
+++ b/modules/calcite/src/test/sql/types/null/test_null_aggr.test
@@ -36,9 +36,9 @@ INSERT INTO test VALUES (12, NULL), (16, NULL)
query IIRII
SELECT b, COUNT(a), SUM(a), MIN(a), MAX(a) FROM test GROUP BY b ORDER BY b
----
-NULL 2 28.000000 12 16
21 0 NULL NULL NULL
22 2 24.000000 11 13
+NULL 2 28.000000 12 16
# NULL values should be ignored entirely in the aggregation
statement ok
@@ -47,7 +47,7 @@ INSERT INTO test VALUES (NULL, NULL), (NULL, 22)
query IIRII
SELECT b, COUNT(a), SUM(a), MIN(a), MAX(a) FROM test GROUP BY b ORDER BY b
----
-NULL 2 28.000000 12 16
21 0 NULL NULL NULL
22 2 24.000000 11 13
+NULL 2 28.000000 12 16
diff --git a/modules/calcite/src/test/sql/types/struct/lineitem_struct.test_slow b/modules/calcite/src/test/sql/types/struct/lineitem_struct.test_slow
deleted file mode 100644
index 80b9299..0000000
--- a/modules/calcite/src/test/sql/types/struct/lineitem_struct.test_slow
+++ /dev/null
@@ -1,38 +0,0 @@
-# name: test/sql/types/struct/lineitem_struct.test_slow
-# description: Test packing and unpacking lineitem into structs
-# group: [struct]
-
-require tpch
-
-statement ok
-PRAGMA enable_verification
-
-statement ok
-CALL dbgen(sf=0.01, suffix='_org')
-
-statement ok
-CREATE VIEW lineitem AS
-SELECT STRUCT_EXTRACT(struct, 'orderkey') l_orderkey,
- STRUCT_EXTRACT(struct, 'partkey') l_partkey,
- STRUCT_EXTRACT(struct, 'suppkey') l_suppkey,
- STRUCT_EXTRACT(struct, 'linenumber') l_linenumber,
- STRUCT_EXTRACT(struct, 'quantity') l_quantity,
- STRUCT_EXTRACT(struct, 'extendedprice') l_extendedprice,
- STRUCT_EXTRACT(struct, 'discount') l_discount,
- STRUCT_EXTRACT(struct, 'tax') l_tax,
- STRUCT_EXTRACT(struct, 'returnflag') l_returnflag,
- STRUCT_EXTRACT(struct, 'linestatus') l_linestatus,
- STRUCT_EXTRACT(struct, 'shipdate') l_shipdate,
- STRUCT_EXTRACT(struct, 'commitdate') l_commitdate,
- STRUCT_EXTRACT(struct, 'receiptdate') l_receiptdate,
- STRUCT_EXTRACT(struct, 'shipinstruct') l_shipinstruct,
- STRUCT_EXTRACT(struct, 'shipmode') l_shipmode,
- STRUCT_EXTRACT(struct, 'comment') l_comment
-FROM
- (SELECT STRUCT_PACK(quantity := l_quantity , extendedprice := l_extendedprice , discount := l_discount , tax := l_tax , returnflag := l_returnflag , linestatus := l_linestatus , shipdate := l_shipdate , commitdate := l_commitdate , receiptdate := l_receiptdate , shipinstruct := l_shipinstruct , shipmode := l_shipmode , COMMENT := l_comment , orderkey := l_orderkey , partkey := l_partkey , suppkey := l_suppkey , linenumber := l_linenumber) as struct
- FROM lineitem_org) structs
-
-query I
-PRAGMA tpch(1)
-----
-<FILE>:extension/tpch/dbgen/answers/sf0.01/q01.csv
diff --git a/modules/calcite/src/test/sql/types/struct/struct_aggregates.test b/modules/calcite/src/test/sql/types/struct/struct_aggregates.test
deleted file mode 100644
index 2077664..0000000
--- a/modules/calcite/src/test/sql/types/struct/struct_aggregates.test
+++ /dev/null
@@ -1,16 +0,0 @@
-# name: test/sql/types/struct/struct_aggregates.test
-# description: Test structs with aggregations
-# group: [struct]
-
-statement ok
-PRAGMA enable_verification
-
-query III
-select min(struct_pack(i := i, j := i + 2)), max(struct_pack(i := i, j := i + 2)), first(struct_pack(i := i, j := i + 2)) from range(10) tbl(i);
-----
-<i: 0, j: 2> <i: 9, j: 11> <i: 0, j: 2>
-
-query I
-select string_agg(struct_pack(i := i, j := i + 2), ',') from range(10) tbl(i);
-----
-<i: 0, j: 2>,<i: 1, j: 3>,<i: 2, j: 4>,<i: 3, j: 5>,<i: 4, j: 6>,<i: 5, j: 7>,<i: 6, j: 8>,<i: 7, j: 9>,<i: 8, j: 10>,<i: 9, j: 11>
diff --git a/modules/calcite/src/test/sql/types/struct/test_struct.test b/modules/calcite/src/test/sql/types/struct/test_struct.test
deleted file mode 100644
index 042fb15..0000000
--- a/modules/calcite/src/test/sql/types/struct/test_struct.test
+++ /dev/null
@@ -1,177 +0,0 @@
-# name: test/sql/types/struct/test_struct.test
-# description: Test filter and projection of nested struct
-# group: [struct]
-
-statement ok
-PRAGMA enable_verification
-
-statement ok
-CREATE TABLE struct_data (g INTEGER, e INTEGER)
-
-statement ok
-INSERT INTO struct_data VALUES (1, 1), (1, 2), (2, 3), (2, 4), (2, 5), (3, 6), (5, NULL)
-
-query T
-SELECT STRUCT_PACK(a := 42, b := 43)
-----
-<a: 42, b: 43>
-
-query IT
-SELECT e, STRUCT_PACK(e) FROM struct_data ORDER BY e LIMIT 2
-----
-NULL <e: NULL>
-1 <e: 1>
-
-query T
-SELECT STRUCT_PACK(a := 42, b := 43) as struct
-----
-<a: 42, b: 43>
-
-# FIXME: this is borked
-mode skip
-
-query I
-select null::row(a integer);
-----
-<a: NULL>
-
-mode unskip
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), 'xx') as ee FROM struct_data
-----
-1 1
-2 2
-3 3
-4 4
-5 5
-6 6
-NULL NULL
-
-query II
-SELECT e, (STRUCT_PACK(xx := e, yy := g)).xx as ee FROM struct_data
-----
-1 1
-2 2
-3 3
-4 4
-5 5
-6 6
-NULL NULL
-
-query II
-SELECT e, (a).xx as ee FROM (SELECT e, STRUCT_PACK(xx := e, yy := g) FROM struct_data) tbl(e, a)
-----
-1 1
-2 2
-3 3
-4 4
-5 5
-6 6
-NULL NULL
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), 'xx') as s FROM struct_data WHERE e > 4
-----
-5 5
-6 6
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), 'xx') as s FROM struct_data WHERE e IS NULL
-----
-NULL NULL
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(xx := e/2), 'xx') as s FROM struct_data WHERE e > 4
-----
-5 2
-6 3
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(xx := e/2), 'xx')*2 as s FROM struct_data WHERE e > 4
-----
-5 4
-6 6
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), 'xx') as ee FROM struct_data ORDER BY e DESC
-----
-NULL NULL
-6 6
-5 5
-4 4
-3 3
-2 2
-1 1
-
-query II
-SELECT e, STRUCT_EXTRACT(STRUCT_PACK(a := e, b := ROWID, c := 42), 'c') as ee FROM struct_data ORDER BY ROWID
-----
-1 42
-2 42
-3 42
-4 42
-5 42
-6 42
-NULL 42
-
-query I
-SELECT STRUCT_EXTRACT(STRUCT_PACK(a := 42, b := 43), 'a') FROM struct_data
-----
-42
-42
-42
-42
-42
-42
-42
-
-query I
-SELECT STRUCT_EXTRACT(STRUCT_PACK(a := 42, b := 43), 'a') s
-----
-42
-
-query T
-SELECT STRUCT_EXTRACT(STRUCT_EXTRACT(STRUCT_PACK(a := STRUCT_PACK(x := 'asdf', y := NULL), b := 43), 'a'), 'x') s
-----
-asdf
-
-
-statement error
-SELECT STRUCT_PACK() FROM struct_data
-
-statement error
-SELECT STRUCT_PACK(e+1) FROM struct_data
-
-statement error
-SELECT STRUCT_PACK(a := e, a := g) FROM struct_data
-
-statement error
-SELECT STRUCT_PACK(e, e) FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT(e, 'e') FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT(e) FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT('e') FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT() FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), 'zz') FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g)) FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), g) FROM struct_data
-
-statement error
-SELECT STRUCT_EXTRACT(STRUCT_PACK(xx := e, yy := g), '42') FROM struct_data
-
-statement error
-CREATE TABLE test AS SELECT e, STRUCT_PACK(e) FROM struct_data
diff --git a/modules/calcite/src/test/sql/types/unsigned/test_unsigned_arithmetic.test b/modules/calcite/src/test/sql/types/unsigned/test_unsigned_arithmetic.test_ignored
similarity index 96%
rename from modules/calcite/src/test/sql/types/unsigned/test_unsigned_arithmetic.test
rename to modules/calcite/src/test/sql/types/unsigned/test_unsigned_arithmetic.test_ignored
index 012796b..5c4ad03 100644
--- a/modules/calcite/src/test/sql/types/unsigned/test_unsigned_arithmetic.test
+++ b/modules/calcite/src/test/sql/types/unsigned/test_unsigned_arithmetic.test_ignored
@@ -1,6 +1,7 @@
# name: test/sql/types/unsigned/test_unsigned_arithmetic.test
# description: Test various operations with unsigned
# group: [unsigned]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14632
statement ok
PRAGMA enable_verification
diff --git a/modules/calcite/src/test/sql/types/unsigned/test_unsigned_auto_cast.test b/modules/calcite/src/test/sql/types/unsigned/test_unsigned_auto_cast.test_ignored
similarity index 97%
rename from modules/calcite/src/test/sql/types/unsigned/test_unsigned_auto_cast.test
rename to modules/calcite/src/test/sql/types/unsigned/test_unsigned_auto_cast.test_ignored
index cf153a3..d1a3521 100644
--- a/modules/calcite/src/test/sql/types/unsigned/test_unsigned_auto_cast.test
+++ b/modules/calcite/src/test/sql/types/unsigned/test_unsigned_auto_cast.test_ignored
@@ -1,6 +1,7 @@
# name: test/sql/types/unsigned/test_unsigned_auto_cast.test
# description: Test unsigned auto cast
# group: [unsigned]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14632
statement ok
PRAGMA enable_verification
diff --git a/modules/calcite/src/test/sql/types/unsigned/test_unsigned_conversion.test b/modules/calcite/src/test/sql/types/unsigned/test_unsigned_conversion.test_ignored
similarity index 99%
rename from modules/calcite/src/test/sql/types/unsigned/test_unsigned_conversion.test
rename to modules/calcite/src/test/sql/types/unsigned/test_unsigned_conversion.test_ignored
index 9c40375..3659ac8 100644
--- a/modules/calcite/src/test/sql/types/unsigned/test_unsigned_conversion.test
+++ b/modules/calcite/src/test/sql/types/unsigned/test_unsigned_conversion.test_ignored
@@ -1,6 +1,7 @@
# name: test/sql/types/unsigned/test_unsigned_conversion.test
# description: Test unsigned conversion
# group: [unsigned]
+# Ignored: https://issues.apache.org/jira/browse/IGNITE-14632
statement ok
PRAGMA enable_verification