devanshu0987 commented on PR #19630:
URL: https://github.com/apache/datafusion/pull/19630#issuecomment-3707672424
- Results from DuckDB
```
CREATE TABLE test_source (
ascii_1 TEXT,
ascii_2 TEXT,
unicode_1 TEXT,
unicode_2 TEXT
);
INSERT INTO test_source VALUES
('Andrew', 'X', 'datafusion📊🔥', '🔥'),
('Xiangpeng', 'Xiangpeng', 'datafusion数据融合', 'datafusion数据融合'),
('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'),
('', '%', '', ''),
('', '%%', '', ''),
('%', '\%', '', ''),
('_', '\_', '', ''),
(NULL, '%', NULL, NULL),
(NULL, 'R', NULL, '🔥');
SELECT * FROM test_source;
SELECT
TRANSLATE(ascii_1, 'foo', 'bar') AS c
FROM test_source;
c |
-----------+
Andrew |
Xiangpeng |
Raphael |
under_scare|
percent |
|
|
% |
_ |
|
|
SELECT
TRANSLATE(unicode_1, 'foo', 'bar') AS c
FROM test_source;
c |
------------------------+
databusian📊🔥 |
databusian数据融合 |
databusianДатаФусион |
un iść care |
pan Tadeusz ma iść w kąt|
|
|
|
|
|
|
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
