为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server x64 V7.6.1.108-Build(2021.06.30-142705-10017)ENT
【操作系统】:Windows10
【CPU】:Intel® Core™ i3-9100 CPU @ 3.60GHz
【问题描述】*:代码在mysql可以运行;但是在dbeaver出现:[REGEXP]附近出现错误:语法分析出错
相关代码:
SELECT
ddi.id,
ddi.address,
ddi.ltu_device_id AS ltuId,
ddi.terminal_id,
ddi.data_status,
ddi.biz_org_id,
ddi.da_id,
ddi.setup_position
FROM
da_device_info AS ddi
WHERE
ddi.data_status = 0
AND (ddi.terminal_id IS NULL
OR (ddi.terminal_id IS NOT NULL
AND ddi.terminal_id NOT IN (
SELECT
dt.id
FROM
da_terminal dt
WHERE
dt.data_status = 0
AND dt.enable = 1))
OR (ddi.ltu_device_id IS NULL
AND ddi.terminal_id IN (
SELECT
dt.id
FROM
da_terminal dt
WHERE
dt.data_status = 0
AND dt.enable = 1
AND dt.group_category = ‘DA’
AND dt.device_category <> ‘LTU4G’))
OR (ddi.ltu_device_id IS NOT NULL
AND ddi.ltu_device_id NOT IN (
SELECT
id
FROM
da_device_info
WHERE
id = ddi.ltu_device_id
AND data_status = 0))
OR ddi.da_id IS NULL
OR (ddi.da_id IS NOT NULL
AND ddi.da_id NOT IN (
SELECT
TG_ID
FROM
g_tg
WHERE
TG_ID = ddi.da_id))
OR (ddi.terminal_id IN (
SELECT
id
FROM
da_terminal
WHERE
group_category = ‘DA’
AND device_category = ‘LP’
AND enable = 1)
AND NOT ddi.address REGEXP ‘[1][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]$’))
ORDER BY
ddi.created_time DESC
LIMIT 10;
0-9 ↩︎