AcKing-Sam commented on issue #32354:
URL: https://github.com/apache/doris/issues/32354#issuecomment-2008590303
@yongjinhou Hi, could you please assign this issue to me?
I made tests on `master` and this bug still exists.
Reproduce:
```mysql
CREATE TABLE regtest (
id int,
value_col string,
pattern_col string
)
ENGINE=OLAP
DISTRIBUTED BY HASH(id) BUCKETS 4
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
INSERT INTO regtest VALUES
(0, 'prefix0_infix0_suffix0', 'prefix0'),
(1, '%prefix1_infix1_suffix1', 'prefix1'),
(2, 'prefix2_$infix2$suffix2', 'infix2'),
(3, 'prefix3^infix3_suffix3', 'infix3'),
(4, '$$$prefix4_$$$infix4%%%^^suffix4', 'suffix4'),
(5, 'prefix5%%$$$__infix5$^^^%%$$suffix5', 'suffix5'),
(6, 'prefix6__^^%%%infix6%^suffix6%', 'prefix6_^^%%%infix6%^suffix6%'),
(7, '%%%^^^$$$prefix7_infix7_suffix7%%%^^^$$$', 'prefix7_infix7_suffix7'),
(8, 'prefix8^^%%%infix8%%$$^^___suffix8', ''),
(9, 'prefix9$$%%%^^infix9&&%%$$suffix9', NULL);
```
Results:
```mysql
mysql> select * from regtest;
+------+------------------------------------------+-------------------------------+
| id | value_col | pattern_col
|
+------+------------------------------------------+-------------------------------+
| 1 | %prefix1_infix1_suffix1 | prefix1
|
| 7 | %%%^^^$$$prefix7_infix7_suffix7%%%^^^$$$ | prefix7_infix7_suffix7
|
| 0 | prefix0_infix0_suffix0 | prefix0
|
| 6 | prefix6__^^%%%infix6%^suffix6% |
prefix6_^^%%%infix6%^suffix6% |
| 2 | prefix2_$infix2$suffix2 | infix2
|
| 4 | $$$prefix4_$$$infix4%%%^^suffix4 | suffix4
|
| 8 | prefix8^^%%%infix8%%$$^^___suffix8 |
|
| 3 | prefix3^infix3_suffix3 | infix3
|
| 5 | prefix5%%$$$__infix5$^^^%%$$suffix5 | suffix5
|
| 9 | prefix9$$%%%^^infix9&&%%$$suffix9 | NULL
|
+------+------------------------------------------+-------------------------------+
10 rows in set (0.04 sec)
mysql> SELECT * FROM regtest WHERE value_col REGEXP '.*' ORDER BY id;
Empty set (0.02 sec)
mysql> SELECT * FROM regtest WHERE value_col LIKE '%' ORDER BY id;
+------+------------------------------------------+-------------------------------+
| id | value_col | pattern_col
|
+------+------------------------------------------+-------------------------------+
| 0 | prefix0_infix0_suffix0 | prefix0
|
| 1 | %prefix1_infix1_suffix1 | prefix1
|
| 2 | prefix2_$infix2$suffix2 | infix2
|
| 3 | prefix3^infix3_suffix3 | infix3
|
| 4 | $$$prefix4_$$$infix4%%%^^suffix4 | suffix4
|
| 5 | prefix5%%$$$__infix5$^^^%%$$suffix5 | suffix5
|
| 6 | prefix6__^^%%%infix6%^suffix6% |
prefix6_^^%%%infix6%^suffix6% |
| 7 | %%%^^^$$$prefix7_infix7_suffix7%%%^^^$$$ | prefix7_infix7_suffix7
|
| 8 | prefix8^^%%%infix8%%$$^^___suffix8 |
|
| 9 | prefix9$$%%%^^infix9&&%%$$suffix9 | NULL
|
+------+------------------------------------------+-------------------------------+
10 rows in set (0.02 sec)
```
--
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]
