词法解析出现了一些问题

[jd-zhang]

*Issue migrated from trac ticket # 875 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-05 12:03:03: vito@zettadb.com created the issue

---

sql code:
1.
CREATE TABLE tab_bytea(a bytea,b bytea);
INSERT INTO tab_bytea VALUES('\047',E'\xF');

ERROR:  flex scanner jammed

UPDATE tab_bytea set a='\134' where a='\047';

ERROR:  flex scanner jammed

SELECT rolname, regexp_replace(rolpassword, '(SCRAM-SHA-256)$(\d+):([a-zA-Z0-9+/=]+)$([a-zA-Z0-9+=/]+):([a-zA-Z0-9+/=]+)', '\1$\2:$:') as rolpassword_masked
FROM pg_authid
WHERE rolname LIKE 'regress_passwd%'
ORDER BY rolname, rolpassword;

ERROR:  flex scanner jammed

create or replace function strtest() returns text as $$
begin
raise notice 'foo\bar\041baz';
return 'foo\bar\041baz';
end
$$ language plpgsql;

ERROR:  flex scanner jammed

select 'bbbbb' ~ '^([bc])\1*$' as t;

ERROR:  flex scanner jammed

[jd-zhang]

2022-07-05 12:04:18: vito@zettadb.com commented

---

http://192.168.0.104:8080/job/enterprise_centos_dailytest_oneshard/169/consoleText

相关的sql文件
regex.sql
password.sql
datatypes_simple.sql
plpgsql.sql

[jd-zhang]

2022-07-05 19:16:03: zhaowei@zettadb.com changed owner from david to kunlun

[jd-zhang]

2022-07-05 19:16:03: zhaowei@zettadb.com changed status from assigned to accepted