This is an automated email from the ASF dual-hosted git repository.
alamb pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new b46e80c6a4 Update tests and resolve TODOs after arrow update (#13538)
b46e80c6a4 is described below
commit b46e80c6a4b9af92976b5152fd202f0b2cba3d96
Author: Piotr Findeisen <[email protected]>
AuthorDate: Mon Nov 25 22:31:46 2024 +0100
Update tests and resolve TODOs after arrow update (#13538)
---
.../test_files/string/dictionary_utf8.slt | 37 -------
.../test_files/string/init_data.slt.part | 2 +-
.../test_files/string/large_string.slt | 39 +------
.../sqllogictest/test_files/string/string.slt | 46 ++------
.../test_files/string/string_query.slt.part | 121 ++++++++++++++++++---
.../sqllogictest/test_files/string/string_view.slt | 16 ---
6 files changed, 118 insertions(+), 143 deletions(-)
diff --git a/datafusion/sqllogictest/test_files/string/dictionary_utf8.slt
b/datafusion/sqllogictest/test_files/string/dictionary_utf8.slt
index c16cfc2ca3..01071f03dc 100644
--- a/datafusion/sqllogictest/test_files/string/dictionary_utf8.slt
+++ b/datafusion/sqllogictest/test_files/string/dictionary_utf8.slt
@@ -42,43 +42,6 @@ SELECT arrow_cast('', 'Dictionary(Int32, Utf8)');
----
(empty)
-# TODO: move it back to `string_query.slt.part` after fixing the issue
-# see detail: https://github.com/apache/datafusion/issues/12637
-# Test pattern with wildcard characters
-query TTBBBB
-select ascii_1, unicode_1,
- ascii_1 like 'An%' as ascii_like,
- unicode_1 like '%ion数据%' as unicode_like,
- ascii_1 ilike 'An%' as ascii_ilike,
- unicode_1 ilike '%ion数据%' as unicode_ilik
-from test_basic_operator;
-----
-Andrew datafusion📊🔥 true false true false
-Xiangpeng datafusion数据融合 false true false true
-Raphael datafusionДатаФусион false false false false
-under_score un iść core false false false false
-percent pan Tadeusz ma iść w kąt false false false false
-(empty) (empty) false false false false
-% (empty) false false false false
-_ (empty) false false false false
-NULL NULL NULL NULL NULL NULL
-NULL NULL NULL NULL NULL NULL
-
-# TODO: move it back to `string_query.slt.part` after fixing the issue
-# see issue https://github.com/apache/datafusion/issues/13329
-query IIII
-select bit_length(ascii_1), bit_length(ascii_2), bit_length(unicode_1),
bit_length(unicode_2) from test_basic_operator;
-----
-48 8 144 32
-72 72 176 176
-56 8 240 64
-88 88 104 256
-56 24 216 288
-0 8 0 0
-8 16 0 0
-8 16 0 0
-NULL 8 NULL NULL
-NULL 8 NULL 32
#
# common test for string-like functions and operators
diff --git a/datafusion/sqllogictest/test_files/string/init_data.slt.part
b/datafusion/sqllogictest/test_files/string/init_data.slt.part
index 9cdeff1977..06b65ff8e7 100644
--- a/datafusion/sqllogictest/test_files/string/init_data.slt.part
+++ b/datafusion/sqllogictest/test_files/string/init_data.slt.part
@@ -15,7 +15,6 @@
# specific language governing permissions and limitations
# under the License.
-# TODO (https://github.com/apache/datafusion/issues/12637): add a row with
'%%' pattern
statement ok
create table test_source as values
('Andrew', 'X', 'datafusion📊🔥', '🔥'),
@@ -24,6 +23,7 @@ create table test_source as values
('under_score', 'un_____core', 'un iść core', 'chrząszcz na łące w 東京都'),
('percent', 'p%t', 'pan Tadeusz ma iść w kąt', 'Pan Tadeusz ma frunąć stąd w
kąt'),
('', '%', '', ''),
+ ('', '%%', '', ''),
('%', '\%', '', ''),
('_', '\_', '', ''),
(NULL, '%', NULL, NULL),
diff --git a/datafusion/sqllogictest/test_files/string/large_string.slt
b/datafusion/sqllogictest/test_files/string/large_string.slt
index 35fc5694df..84f1e8382e 100644
--- a/datafusion/sqllogictest/test_files/string/large_string.slt
+++ b/datafusion/sqllogictest/test_files/string/large_string.slt
@@ -44,49 +44,12 @@ Raphael R datafusionДатаФусион аФус
under_score un_____core un iść core chrząszcz na łące w 東京都
percent p%t pan Tadeusz ma iść w kąt Pan Tadeusz ma frunąć stąd w kąt
(empty) % (empty) (empty)
+(empty) %% (empty) (empty)
% \% (empty) (empty)
_ \_ (empty) (empty)
NULL % NULL NULL
NULL R NULL 🔥
-# TODO: move it back to `string_query.slt.part` after fixing the issue
-# see detail: https://github.com/apache/datafusion/issues/12637
-# Test pattern with wildcard characters
-query TTBBBB
-select ascii_1, unicode_1,
- ascii_1 like 'An%' as ascii_like,
- unicode_1 like '%ion数据%' as unicode_like,
- ascii_1 ilike 'An%' as ascii_ilike,
- unicode_1 ilike '%ion数据%' as unicode_ilik
-from test_basic_operator;
-----
-Andrew datafusion📊🔥 true false true false
-Xiangpeng datafusion数据融合 false true false true
-Raphael datafusionДатаФусион false false false false
-under_score un iść core false false false false
-percent pan Tadeusz ma iść w kąt false false false false
-(empty) (empty) false false false false
-% (empty) false false false false
-_ (empty) false false false false
-NULL NULL NULL NULL NULL NULL
-NULL NULL NULL NULL NULL NULL
-
-# TODO: move it back to `string_query.slt.part` after fixing the issue
-# see issue https://github.com/apache/datafusion/issues/13329
-query IIII
-select bit_length(ascii_1), bit_length(ascii_2), bit_length(unicode_1),
bit_length(unicode_2) from test_basic_operator;
-----
-48 8 144 32
-72 72 176 176
-56 8 240 64
-88 88 104 256
-56 24 216 288
-0 8 0 0
-8 16 0 0
-8 16 0 0
-NULL 8 NULL NULL
-NULL 8 NULL 32
-
#
# common test for string-like functions and operators
#
diff --git a/datafusion/sqllogictest/test_files/string/string.slt
b/datafusion/sqllogictest/test_files/string/string.slt
index db2b67d663..55f0c034f5 100644
--- a/datafusion/sqllogictest/test_files/string/string.slt
+++ b/datafusion/sqllogictest/test_files/string/string.slt
@@ -34,27 +34,7 @@ statement ok
create table test_substr as
select arrow_cast(col1, 'Utf8') as c1 from test_substr_base;
-# TODO: move it back to `string_query.slt.part` after fixing the issue
-# see detail: https://github.com/apache/datafusion/issues/12637
-# Test pattern with wildcard characters
-query TTBBBB
-select ascii_1, unicode_1,
- ascii_1 like 'An%' as ascii_like,
- unicode_1 like '%ion数据%' as unicode_like,
- ascii_1 ilike 'An%' as ascii_ilike,
- unicode_1 ilike '%ion数据%' as unicode_ilik
-from test_basic_operator;
-----
-Andrew datafusion📊🔥 true false true false
-Xiangpeng datafusion数据融合 false true false true
-Raphael datafusionДатаФусион false false false false
-under_score un iść core false false false false
-percent pan Tadeusz ma iść w kąt false false false false
-(empty) (empty) false false false false
-% (empty) false false false false
-_ (empty) false false false false
-NULL NULL NULL NULL NULL NULL
-NULL NULL NULL NULL NULL NULL
+
#
# common test for string-like functions and operators
@@ -80,6 +60,9 @@ SELECT unicode_2, 'is NOT LIKE', ascii_2 FROM
test_basic_operator WHERE unicode_
(empty) is LIKE %
(empty) is LIKE %
(empty) is LIKE %
+(empty) is LIKE %%
+(empty) is LIKE %%
+(empty) is LIKE %%
(empty) is NOT LIKE \%
(empty) is NOT LIKE \%
(empty) is NOT LIKE \_
@@ -115,6 +98,7 @@ FROM test_basic_operator
----
% \% (empty) (empty) true true false false
(empty) % (empty) (empty) true false true true
+(empty) %% (empty) (empty) true false true true
Andrew X datafusion📊🔥 🔥 false false false false
NULL % NULL NULL NULL NULL NULL NULL
NULL R NULL 🔥 NULL NULL NULL false
@@ -143,6 +127,9 @@ SELECT unicode_2, 'is NOT ILIKE', ascii_2 FROM
test_basic_operator WHERE unicode
(empty) is ILIKE %
(empty) is ILIKE %
(empty) is ILIKE %
+(empty) is ILIKE %%
+(empty) is ILIKE %%
+(empty) is ILIKE %%
(empty) is NOT ILIKE \%
(empty) is NOT ILIKE \%
(empty) is NOT ILIKE \_
@@ -178,6 +165,7 @@ FROM test_basic_operator
----
% \% (empty) (empty) true true false false
(empty) % (empty) (empty) true false true true
+(empty) %% (empty) (empty) true false true true
Andrew X datafusion📊🔥 🔥 false false false false
NULL % NULL NULL NULL NULL NULL NULL
NULL R NULL 🔥 NULL NULL NULL false
@@ -187,21 +175,7 @@ _ \_ (empty) (empty) true false false false
percent p%t pan Tadeusz ma iść w kąt Pan Tadeusz ma frunąć stąd w kąt true
false true true
under_score un_____core un iść core chrząszcz na łące w 東京都 true false true
false
-# TODO: move it back to `string_query.slt.part` after fixing the issue
-# see issue https://github.com/apache/datafusion/issues/13329
-query IIII
-select bit_length(ascii_1), bit_length(ascii_2), bit_length(unicode_1),
bit_length(unicode_2) from test_basic_operator;
-----
-48 8 144 32
-72 72 176 176
-56 8 240 64
-88 88 104 256
-56 24 216 288
-0 8 0 0
-8 16 0 0
-8 16 0 0
-NULL 8 NULL NULL
-NULL 8 NULL 32
+
#
# Clean up
diff --git a/datafusion/sqllogictest/test_files/string/string_query.slt.part
b/datafusion/sqllogictest/test_files/string/string_query.slt.part
index c42a9384c5..80fcc01028 100644
--- a/datafusion/sqllogictest/test_files/string/string_query.slt.part
+++ b/datafusion/sqllogictest/test_files/string/string_query.slt.part
@@ -29,6 +29,7 @@ Raphael R datafusionДатаФусион аФус
under_score un_____core un iść core chrząszcz na łące w 東京都
percent p%t pan Tadeusz ma iść w kąt Pan Tadeusz ma frunąć stąd w kąt
(empty) % (empty) (empty)
+(empty) %% (empty) (empty)
% \% (empty) (empty)
_ \_ (empty) (empty)
NULL % NULL NULL
@@ -51,6 +52,7 @@ Raphael R
under_score un_____core
percent p%t
(empty) %
+(empty) %%
% \%
_ \_
@@ -61,6 +63,7 @@ datafusion数据融合 datafusion数据融合
(empty) (empty)
(empty) (empty)
(empty) (empty)
+(empty) (empty)
query TT
select unicode_1, unicode_2 from test_basic_operator where unicode_1 <>
unicode_2
@@ -74,6 +77,7 @@ query TT
select ascii_1, unicode_1 from test_basic_operator where ascii_1 = unicode_1
----
(empty) (empty)
+(empty) (empty)
query TT
select ascii_1, unicode_1 from test_basic_operator where ascii_1 <> unicode_1
@@ -106,6 +110,7 @@ Raphael R datafusionДатаФусион аФус false true false true
false tr
under_score un_____core un iść core chrząszcz na łące w 東京都 false true false
true false true
percent p%t pan Tadeusz ma iść w kąt Pan Tadeusz ma frunąć stąd w kąt false
true false true false true
(empty) % (empty) (empty) false true true false true false
+(empty) %% (empty) (empty) false true true false true false
% \% (empty) (empty) false true true false false true
_ \_ (empty) (empty) false true true false false true
NULL % NULL NULL NULL NULL NULL NULL NULL NULL
@@ -129,6 +134,7 @@ Raphael datafusionДатаФусион false true false true
under_score un iść core false true false true
percent pan Tadeusz ma iść w kąt false true false true
(empty) (empty) false true false true
+(empty) (empty) false true false true
% (empty) false true false true
_ (empty) false true false true
NULL NULL NULL NULL NULL NULL
@@ -152,6 +158,7 @@ Raphael datafusionДатаФусион false true false true
under_score un iść core false true false true
percent pan Tadeusz ma iść w kąt false true false true
(empty) (empty) false true false true
+(empty) (empty) false true false true
% (empty) false true false true
_ (empty) false true false true
NULL NULL NULL NULL NULL NULL
@@ -175,6 +182,7 @@ Raphael datafusionДатаФусион false true false true
under_score un iść core false true false true
percent pan Tadeusz ma iść w kąt false true false true
(empty) (empty) false true false true
+(empty) (empty) false true false true
% (empty) false true false true
_ (empty) false true false true
NULL NULL NULL NULL NULL NULL
@@ -223,6 +231,7 @@ Rap R dat аФу
und un_ un chr
per p%t pan Pan
(empty) % (empty) (empty)
+(empty) %% (empty) (empty)
% \% (empty) (empty)
_ \_ (empty) (empty)
NULL % NULL NULL
@@ -256,6 +265,7 @@ GROUP BY ascii_2;
1 1
1 1
1 1
+1 1
query II rowsort
SELECT
@@ -293,6 +303,7 @@ false false false false
false true true false
false true true false
false true true false
+false true true false
NULL NULL NULL NULL
NULL NULL NULL NULL
@@ -312,6 +323,7 @@ false false false false
false false false false
false false false false
false false false false
+false false false false
NULL false NULL NULL
NULL false NULL false
@@ -330,6 +342,7 @@ Raphael
under_scrre
percent
(empty)
+(empty)
%
_
NULL
@@ -348,6 +361,7 @@ pan Tadeusz ma iść w kąt
(empty)
(empty)
(empty)
+(empty)
NULL
NULL
@@ -367,6 +381,7 @@ Raphafl
undfr_score
pfrcent
(empty)
+(empty)
%
_
NULL
@@ -384,6 +399,7 @@ Raphafl
undfr_score
pfrcent
(empty)
+(empty)
%
_
NULL
@@ -403,6 +419,7 @@ bar
bar
bar
bar
+bar
NULL
NULL
@@ -420,6 +437,7 @@ bar
bar
bar
bar
+bar
NULL
NULL
@@ -444,6 +462,7 @@ Raphael Datafusionдатафусион
Under_Score Un Iść Core
Percent Pan Tadeusz Ma Iść W KąT
(empty) (empty)
+(empty) (empty)
% (empty)
_ (empty)
NULL NULL
@@ -470,6 +489,7 @@ FROM test_basic_operator;
117 117 117 99
112 112 112 80
0 37 0 0
+0 37 0 0
37 92 0 0
95 92 0 0
NULL 37 NULL NULL
@@ -496,6 +516,7 @@ Raphael Raphael NULL datafusionДатаФусион
datafusionДатаФусио
under_score under_score NULL un iść core un iść core NULL
percent percent NULL pan Tadeusz ma iść w kąt pan Tadeusz ma iść w kąt NULL
(empty) (empty) NULL (empty) (empty) NULL
+(empty) (empty) NULL (empty) (empty) NULL
% % NULL (empty) (empty) NULL
_ _ NULL (empty) (empty) NULL
NULL NULL NULL NULL NULL NULL
@@ -522,6 +543,7 @@ Raphael aphael NULL datafusionДатаФусион NULL
datafusionДатаФус
under_score der_score NULL un iść core NULL un iść core
percent ercent NULL pan Tadeusz ma iść w kąt NULL pan Tadeusz ma iść w kąt
(empty) (empty) NULL (empty) NULL (empty)
+(empty) (empty) NULL (empty) NULL (empty)
% (empty) NULL (empty) NULL (empty)
_ (empty) NULL (empty) NULL (empty)
NULL NULL NULL NULL NULL NULL
@@ -547,6 +569,7 @@ Raphael Raphael Raphael NULL datafusionДатаФусион
under_sco under_s under_score NULL un iść core
percent percen percent NULL pan Tadeusz ma iść w kąt
(empty) (empty) (empty) NULL (empty)
+(empty) (empty) (empty) NULL (empty)
% (empty) % NULL (empty)
_ (empty) _ NULL (empty)
NULL NULL NULL NULL NULL
@@ -574,6 +597,7 @@ false false NULL false NULL false
false false NULL true NULL false
false false NULL true NULL false
false false NULL true NULL false
+false false NULL true NULL false
NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL
@@ -590,6 +614,7 @@ raphael datafusionдатафусион
under_score un iść core
percent pan tadeusz ma iść w kąt
(empty) (empty)
+(empty) (empty)
% (empty)
_ (empty)
NULL NULL
@@ -608,6 +633,7 @@ RAPHAEL DATAFUSIONДАТАФУСИОН
UNDER_SCORE UN IŚĆ CORE
PERCENT PAN TADEUSZ MA IŚĆ W KĄT
(empty) (empty)
+(empty) (empty)
% (empty)
_ (empty)
NULL NULL
@@ -639,6 +665,7 @@ Raphael:Data RaphaelR Raphael RaphaeldatafusionДатаФусион
RaphaelаФ
under_score:Data under_scoreun_____core under_score under_scoreun iść core
under_scorechrząszcz na łące w 東京都 un iść coreunder_score un iść corechrząszcz
na łące w 東京都 un iść core un iść core🔥 🔥 (empty) under_score,un iść core
percent:Data percentp%t percent percentpan Tadeusz ma iść w kąt percentPan
Tadeusz ma frunąć stąd w kąt pan Tadeusz ma iść w kątpercent pan Tadeusz ma iść
w kątPan Tadeusz ma frunąć stąd w kąt pan Tadeusz ma iść w kąt pan Tadeusz ma
iść w kąt🔥 🔥 (empty) percent,pan Tadeusz ma iść w kąt
:Data % (empty) (empty) (empty) (empty) (empty) (empty) 🔥 🔥 (empty) ,
+:Data %% (empty) (empty) (empty) (empty) (empty) (empty) 🔥 🔥 (empty) ,
%:Data %\% % % % % (empty) (empty) 🔥 🔥 (empty) %,
_:Data _\_ _ _ _ _ (empty) (empty) 🔥 🔥 (empty) _,
:Data % (empty) (empty) (empty) (empty) (empty) (empty) 🔥 🔥 (empty) ,
@@ -666,6 +693,7 @@ pfooent pfooTadeusz ma iść w kąt p🔥rcent p🔥n Tadeusz ma iść
w kąt NU
foo foo 🔥 🔥 NULL NULL
foo foo 🔥 🔥 NULL NULL
foo foo 🔥 🔥 NULL NULL
+foo foo 🔥 🔥 NULL NULL
NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL
@@ -689,6 +717,7 @@ Raphael baraphael NULL datafusionДатbarион NULL
datafusionДатаФуси
under_score under_score NULL un iść core NULL un iść core
percent percent NULL pan Tadeusz ma iść w kąt NULL pan Tadeusz ma iść w kąt
(empty) (empty) NULL bar NULL (empty)
+(empty) (empty) NULL bar NULL (empty)
% % NULL bar NULL (empty)
_ _ NULL bar NULL (empty)
NULL NULL NULL NULL NULL NULL
@@ -714,6 +743,7 @@ ael (empty) hael ион (empty) afusionДатаФусион
ore (empty) er_score ore (empty) iść core
ent (empty) cent kąt (empty) Tadeusz ma iść w kąt
(empty) (empty) (empty) (empty) (empty) (empty)
+(empty) (empty) (empty) (empty) (empty) (empty)
% (empty) (empty) (empty) (empty) (empty)
_ (empty) (empty) (empty) (empty) (empty)
NULL NULL NULL NULL NULL NULL
@@ -740,6 +770,7 @@ Rap (empty) Raph dat (empty) datafusionДатаФус
und (empty) under_sc un (empty) un iść c
per (empty) perc pan (empty) pan Tadeusz ma iść w
(empty) (empty) (empty) (empty) (empty) (empty)
+(empty) (empty) (empty) (empty) (empty) (empty)
% (empty) (empty) (empty) (empty) (empty)
_ (empty) (empty) (empty) (empty) (empty)
NULL NULL NULL NULL NULL NULL
@@ -763,6 +794,7 @@ R Raph datafusionД datafusionДат
under_score under_score un iść core un iść core
percent percent pan Tadeusz ma iść w kąt pan Tadeusz ma iść w kąt
(empty) (empty) (empty) (empty)
+(empty) (empty) (empty) (empty)
% % (empty) (empty)
_ _ (empty) (empty)
NULL NULL NULL NULL
@@ -788,6 +820,7 @@ FROM test_basic_operator;
0 0 0 0
0 0 0 0
0 0 0 0
+0 0 0 0
NULL NULL NULL NULL
NULL NULL NULL NULL
@@ -811,6 +844,7 @@ Raphaelfoo Raphael🔥 datafusionДатаФусионfoo datafusionДатаФу
under_scorefoo under_score🔥 un iść corefoo un iść core🔥
percentfoo percent🔥 pan Tadeusz ma iść w kątfoo pan Tadeusz ma iść w kąt🔥
foo 🔥 foo 🔥
+foo 🔥 foo 🔥
%foo %🔥 foo 🔥
_foo _🔥 foo 🔥
NULL NULL NULL NULL
@@ -832,6 +866,7 @@ RaphaelR RaphaelаФус datafusionДатаФусионR datafusionДатаФу
under_scoreun_____core under_scorechrząszcz na łące w 東京都 un iść
coreun_____core un iść corechrząszcz na łące w 東京都
percentp%t percentPan Tadeusz ma frunąć stąd w kąt pan Tadeusz ma iść w kątp%t
pan Tadeusz ma iść w kątPan Tadeusz ma frunąć stąd w kąt
% (empty) % (empty)
+%% (empty) %% (empty)
%\% % \% (empty)
_\_ _ \_ (empty)
NULL NULL NULL NULL
@@ -855,6 +890,7 @@ false false
false false
false false
false false
+false false
NULL NULL
NULL NULL
@@ -872,6 +908,7 @@ false false
false false
false false
false false
+false false
NULL NULL
NULL NULL
@@ -889,6 +926,7 @@ true true
true true
true true
true true
+true true
NULL NULL
NULL NULL
@@ -906,6 +944,7 @@ true true
true true
true true
true true
+true true
NULL NULL
NULL NULL
@@ -928,6 +967,7 @@ Raphael nice Raphael and R datafusionДатаФусион cool
datafusionДат
under_score nice under_score and un_____core un iść core cool un iść core and
chrząszcz na łące w 東京都 under_score 🔥 un iść core
percent nice percent and p%t pan Tadeusz ma iść w kąt cool pan Tadeusz ma iść
w kąt and Pan Tadeusz ma frunąć stąd w kąt percent 🔥 pan Tadeusz ma iść w kąt
nice and % cool and 🔥
+ nice and %% cool and 🔥
% nice % and \% cool and % 🔥
_ nice _ and \_ cool and _ 🔥
NULL NULL NULL NULL NULL
@@ -937,21 +977,27 @@ NULL NULL NULL NULL NULL
# Test LIKE / ILIKE
# --------------------------------------
-# TODO: StringView has wrong behavior for LIKE/ILIKE. Enable this after fixing
the issue
-# see issue: https://github.com/apache/datafusion/issues/12637
# Test pattern with wildcard characters
-#query TTBBBB
-#select ascii_1, unicode_1,
-# ascii_1 like 'An%' as ascii_like,
-# unicode_1 like '%ion数据%' as unicode_like,
-# ascii_1 ilike 'An%' as ascii_ilike,
-# unicode_1 ilike '%ion数据%' as unicode_ilik
-#from test_basic_operator;
-#----
-#Andrew datafusion📊🔥 true false true false
-#Xiangpeng datafusion数据融合 false true false true
-#Raphael datafusionДатаФусион false false false false
-#NULL NULL NULL NULL NULL NULL
+query TTBBBB
+select ascii_1, unicode_1,
+ ascii_1 like 'An%' as ascii_like,
+ unicode_1 like '%ion数据%' as unicode_like,
+ ascii_1 ilike 'An%' as ascii_ilike,
+ unicode_1 ilike '%ion数据%' as unicode_ilik
+from test_basic_operator;
+----
+Andrew datafusion📊🔥 true false true false
+Xiangpeng datafusion数据融合 false true false true
+Raphael datafusionДатаФусион false false false false
+under_score un iść core false false false false
+percent pan Tadeusz ma iść w kąt false false false false
+(empty) (empty) false false false false
+(empty) (empty) false false false false
+% (empty) false false false false
+_ (empty) false false false false
+NULL NULL NULL NULL NULL NULL
+NULL NULL NULL NULL NULL NULL
+
query TTBBBB
SELECT ascii_1, unicode_1,
@@ -967,6 +1013,7 @@ Raphael datafusionДатаФусион true true true true
under_score un iść core true true true true
percent pan Tadeusz ma iść w kąt true true true true
(empty) (empty) true true true true
+(empty) (empty) true true true true
% (empty) true true true true
_ (empty) true true true true
NULL NULL NULL NULL NULL NULL
@@ -986,6 +1033,7 @@ Raphael datafusionДатаФусион false false false false
under_score un iść core false false false false
percent pan Tadeusz ma iść w kąt false false false false
(empty) (empty) false false false false
+(empty) (empty) false false false false
% (empty) false false false false
_ (empty) false false false false
NULL NULL NULL NULL NULL NULL
@@ -1000,6 +1048,7 @@ Raphael
under_score
percent
(empty)
+(empty)
%
_
@@ -1022,6 +1071,7 @@ Raphael datafusionДатаФусион false false false false
under_score un iść core false false false false
percent pan Tadeusz ma iść w kąt false false false false
(empty) (empty) false false false false
+(empty) (empty) false false false false
% (empty) false false false false
_ (empty) false false false false
NULL NULL NULL NULL NULL NULL
@@ -1044,11 +1094,32 @@ FROM
11 11
7 24
0 0
+0 0
1 0
1 0
NULL NULL
NULL NULL
+# --------------------------------------
+# Test BIT_LENGTH
+# --------------------------------------
+
+query IIII
+select bit_length(ascii_1), bit_length(ascii_2), bit_length(unicode_1),
bit_length(unicode_2) from test_basic_operator;
+----
+48 8 144 32
+72 72 176 176
+56 8 240 64
+88 88 104 256
+56 24 216 288
+0 8 0 0
+0 16 0 0
+8 16 0 0
+8 16 0 0
+NULL 8 NULL NULL
+NULL 8 NULL 32
+
+
# --------------------------------------
# Test Start_With
# --------------------------------------
@@ -1069,6 +1140,7 @@ false false NULL NULL
false false NULL NULL
false false NULL NULL
false false NULL NULL
+false false NULL NULL
NULL NULL NULL NULL
NULL NULL NULL NULL
@@ -1092,6 +1164,7 @@ false false NULL NULL
false false NULL NULL
false false NULL NULL
false false NULL NULL
+false false NULL NULL
NULL NULL NULL NULL
NULL NULL NULL NULL
@@ -1115,6 +1188,7 @@ FROM test_basic_operator;
6 14 NULL NULL
6 14 NULL NULL
6 14 NULL NULL
+6 14 NULL NULL
NULL NULL NULL NULL
NULL NULL NULL NULL
@@ -1136,6 +1210,7 @@ xxxxxxxxxxxxxRaphael NULL datafusionДатаФусион NULL
xxxxxxxxxunder_score NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥un iść core NULL
xxxxxxxxxxxxxpercent NULL pan Tadeusz ma iść w NULL
xxxxxxxxxxxxxxxxxxxx NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
+xxxxxxxxxxxxxxxxxxxx NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
xxxxxxxxxxxxxxxxxxx% NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
xxxxxxxxxxxxxxxxxxx_ NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
NULL NULL NULL NULL
@@ -1154,6 +1229,7 @@ FROM test_basic_operator;
under_score un iść core |
percent pan Tadeusz ma iść w |
|
+ |
% |
_ |
NULL NULL |
@@ -1177,6 +1253,7 @@ Raphaelxxxxxxxxxxxxx NULL datafusionДатаФусион NULL
under_scorexxxxxxxxx NULL un iść core🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
percentxxxxxxxxxxxxx NULL pan Tadeusz ma iść w NULL
xxxxxxxxxxxxxxxxxxxx NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
+xxxxxxxxxxxxxxxxxxxx NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
%xxxxxxxxxxxxxxxxxxx NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
_xxxxxxxxxxxxxxxxxxx NULL 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 NULL
NULL NULL NULL NULL
@@ -1194,6 +1271,7 @@ Raphael datafusionДатаФусион
under_score un iść core
percent pan Tadeusz ma iść w
+
%
_
NULL NULL
@@ -1225,6 +1303,7 @@ false false NULL NULL false false NULL NULL
false false NULL NULL false false NULL NULL
false false NULL NULL false false NULL NULL
false false NULL NULL false false NULL NULL
+false false NULL NULL false false NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL
@@ -1256,6 +1335,7 @@ NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL
+NULL NULL NULL NULL NULL NULL NULL NULL
# --------------------------------------
# Test REPEAT
@@ -1273,6 +1353,7 @@ RaphaelRaphaelRaphael
datafusionДатаФусионdatafusionДатаФусио
under_scoreunder_scoreunder_score un iść coreun iść coreun iść core
percentpercentpercent pan Tadeusz ma iść w kątpan Tadeusz ma iść w kątpan
Tadeusz ma iść w kąt
(empty) (empty)
+(empty) (empty)
%%% (empty)
___ (empty)
NULL NULL
@@ -1298,6 +1379,7 @@ Rapha l NULL datafusionДатаФус он NULL
und r_scor NULL un iść core (empty) NULL
p rc NULL pan Tadeusz ma iść w kąt (empty) NULL
(empty) (empty) NULL (empty) (empty) NULL
+(empty) (empty) NULL (empty) (empty) NULL
% (empty) NULL (empty) (empty) NULL
_ (empty) NULL (empty) (empty) NULL
NULL NULL NULL NULL NULL NULL
@@ -1319,6 +1401,7 @@ leahpaR ноисуФатаДnoisufatad
erocs_rednu eroc ćśi nu
tnecrep tąk w ćśi am zsuedaT nap
(empty) (empty)
+(empty) (empty)
% (empty)
_ (empty)
NULL NULL
@@ -1346,6 +1429,7 @@ FROM test_basic_operator;
0 0 NULL 0 0 NULL
0 0 NULL 0 0 NULL
0 0 NULL 0 0 NULL
+0 0 NULL 0 0 NULL
NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL
@@ -1369,6 +1453,7 @@ Rapha Raphael NULL datafusionДатаФус datafusionДатаФусион
NULL
und under_score NULL un iść core un iść core NULL
p percent NULL pan Tadeusz ma iść w kąt pan Tadeusz ma iść w kąt NULL
(empty) (empty) NULL (empty) (empty) NULL
+(empty) (empty) NULL (empty) (empty) NULL
% % NULL (empty) (empty) NULL
_ _ NULL (empty) (empty) NULL
NULL NULL NULL NULL NULL NULL
@@ -1387,6 +1472,7 @@ select md5(ascii_1) from test_basic_operator;
e0c4c75d58916b22a41b6ea9bc46231f
354f047ba64552895b016bbdd60ab174
d41d8cd98f00b204e9800998ecf8427e
+d41d8cd98f00b204e9800998ecf8427e
0bcef9c45bd8a48eda1b26eb0c61c869
b14a7b8059d9c055954c92674ce60032
NULL
@@ -1405,6 +1491,7 @@ abd8be3961e5dbe324bc67f9a0211d5f7d81e556baadaff6218e4bfa
8f6caa44143a080541f083bb762107ce12224b271bfa8b36ece002ab
951336d101e034714ba1ca0535688f0300613e235814ed938cd25115
d14a028c2a3a2bc9476102bb288234c415a2b01f828ea62ac5b3e42f
+d14a028c2a3a2bc9476102bb288234c415a2b01f828ea62ac5b3e42f
fda2a4d4c5fb67cfd7fc817f59b543ae42f650aa4abd79934ca5ac55
d365e3c7512c311d0df0528a850e6c827cbe508d13235fa91b545389
NULL
@@ -1423,6 +1510,7 @@
ec792d2e89af0d5b05c88ee1e5fe041ce2db94f84c3aabac4f7cfe20f00cd032
d8071166bbe6131a0acaf86019eeeca31c87ee4fda23b80eda0d094dbffee521
fd86717aca41c558c78c19ab2b50691179a57ba5200bc7e3317be70efd4043ad
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
+e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
bbf3f11cb5b43e700273a78d12de55e4a7eab741ed2abf13787a4d2dc832b8ec
d2e2adf7177b7a8afddbc12d1634cf23ea1a71020f6a1308070a16400fb68fde
NULL
@@ -1441,6 +1529,7 @@ select sha384(ascii_1) from test_basic_operator;
fe417fcff1b9b8cdbc4fba45fedcd882ccbeef438497647052809fd73f43bcf1a6214f543a91e7183d56c6ae8e7cb30e
7791b34dcc841235a8a074052bc12aa7090c0d72f09ec41b1521a67fa09b026a9c02d159b42428d7b528aa5ff7598fd4
38b060a751ac96384cd9327eb1b1e36a21fdb71114be07434c0cc7bf63f6e1da274edebfe76f65fbd51ad2f14898b95b
+38b060a751ac96384cd9327eb1b1e36a21fdb71114be07434c0cc7bf63f6e1da274edebfe76f65fbd51ad2f14898b95b
bba987e661a4158451c5e9870fe91f483064574a0d7485caef40f48d7846579859c7dddebd418cbc99ccaa1ebd3619ea
586b0fd9f8ec935c69a7dceb5560742f368962833023906d30fe1cf49c96ea6d22cea8c2b63cd18e7af08fbf9e47c3f9
NULL
@@ -1460,6 +1549,7 @@
f02c73afb1e433d6cc7e9137bb4ed40791e8c6e7877ae26e7a1edc4ce98a945a61bdf883d985adbc
cafc51edc3a949179a74a805be8d0c7991bfc849b01f773f4bcd5e7dbe51b6d71d65921d8025d375d501af6a1c1026ab76cd7f4811b91bb4544f7dcbb710fa1f
2f845edf0e9c9728fae627d4678dc8c35c9a7f22809d355aa5ddf96d9ca3539973ac7ff96bfc6720ce6a973f93b716e265ad719ee38a85e44d9316ac1b6c89a4
cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e
+cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e
91972aa34055bca20ddb643b9f817a547e5d4ad49b7ff16a7f828a8d72c4cb4a5679cff4da00f9fb6b2833de7eb3480b3b4a7c7c7b85a39028de55acaf2d8812
bbbe7f2559c7953d281fba7f25258063dbc8a55c5b9fdfcd334ecd64a8d7d8980c6f6ee0457bf496bcff747991f741446f1814222678dfa7457f1ad3a6f848b3
NULL
@@ -1478,7 +1568,8 @@
ec792d2e89af0d5b05c88ee1e5fe041ce2db94f84c3aabac4f7cfe20f00cd032
d8071166bbe6131a0acaf86019eeeca31c87ee4fda23b80eda0d094dbffee521
fd86717aca41c558c78c19ab2b50691179a57ba5200bc7e3317be70efd4043ad
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
+e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
bbf3f11cb5b43e700273a78d12de55e4a7eab741ed2abf13787a4d2dc832b8ec
d2e2adf7177b7a8afddbc12d1634cf23ea1a71020f6a1308070a16400fb68fde
NULL
-NULL
\ No newline at end of file
+NULL
diff --git a/datafusion/sqllogictest/test_files/string/string_view.slt
b/datafusion/sqllogictest/test_files/string/string_view.slt
index 166a5978da..ebabaf7655 100644
--- a/datafusion/sqllogictest/test_files/string/string_view.slt
+++ b/datafusion/sqllogictest/test_files/string/string_view.slt
@@ -37,22 +37,6 @@ select arrow_cast(col1, 'Utf8View') as c1 from
test_substr_base;
statement ok
drop table test_source
-# TODO: Revisit this issue after upgrading to the arrow-rs version that
includes apache/arrow-rs#6671.
-# see issue https://github.com/apache/datafusion/issues/13329
-query IIII
-select bit_length(ascii_1), bit_length(ascii_2), bit_length(unicode_1),
bit_length(unicode_2) from test_basic_operator;
-----
-48 8 144 32
-72 72 176 176
-56 8 240 64
-88 88 104 256
-56 24 216 288
-0 8 0 0
-8 16 0 0
-8 16 0 0
-NULL 8 NULL NULL
-NULL 8 NULL 32
-
#
# common test for string-like functions and operators
#
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
