oceanbase/sql-lifecycle-management

[Bug]: `LEADING TRAILING` is not support

Ifffff opened this issue · 0 comments

Ifffff commented

Describe the bug
sql:

select count(*)
from is_dispatcher_conversation_intercept_list b
	inner join (
		select id, trim(leading '{' from a._reason) as restrict_reason, trim(trailing '}' from a._score) as score
		from (
			select id, substring_index(restrict_reason, ':', 1) as _reason
				, substring_index(restrict_reason, ':', -1) as _score
			from is_dispatcher_conversation_intercept_list
		) a
	) c
	on b.id = c.id