为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:7.3.5
【操作系统】:Linux
【CPU】:
【问题描述】*:
执行SQL报异常:SQL 错误 [22000]: 数据未找到
MERGE
INTO
HYDRO.ST_RSVR_R t1
USING(
SELECT
'614K0042' stcd,
'2023-08-08 15:54:00' tm,
899.830 rz,
NULL inq,
NULL wstcp,
NULL otq,
NULL rwchrcd,
NULL rwptn,
NULL inqdr,
NULL msqmt
FROM
dual ) t2 ON
(t1.stcd = t2.stcd
AND t1.tm = t2.tm )
WHEN NOT MATCHED THEN
INSERT
(stcd,
tm,
rz,
inq,
wstcp,
otq,
rwchrcd,
rwptn,
inqdr,
msqmt,
dtuptm)
VALUES (t2.stcd,
t2.tm,
t2.rz,
t2.inq,
t2.wstcp,
t2.otq,
t2.rwchrcd,
t2.rwptn,
t2.inqdr,
msqmt,
sysdate())
WHEN MATCHED THEN
UPDATE
SET
t1.rz = t2.rz,
t1.inq = t2.inq,
t1.wstcp = t2.wstcp,
t1.otq = t2.otq,
t1.rwchrcd = t2.rwchrcd,
t1.rwptn = t2.rwptn,
t1.inqdr = t2.inqdr,
t1.msqmt = t2.msqmt,
t1.dtuptm = sysdate()
org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [22000]: 数据未找到 at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:509) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:440) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:168) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:427) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:812) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3226) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:168) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4516) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: dm.jdbc.driver.DMException: 数据未找到 at dm.jdbc.driver.DBError.throwException(SourceFile:711) at dm.jdbc.a.a.x.i(SourceFile:615) at dm.jdbc.a.a.f.i(SourceFile:137) at dm.jdbc.a.a.x.q(SourceFile:550) at dm.jdbc.a.a.x.x(SourceFile:531) at dm.jdbc.a.a.a(SourceFile:271) at dm.jdbc.a.a.a(SourceFile:762) at dm.jdbc.driver.DmdbStatement.executeInner(SourceFile:730) at dm.jdbc.driver.DmdbStatement.do_execute(SourceFile:189) at dm.jdbc.driver.DmdbStatement.do_execute(SourceFile:181) at dm.jdbc.driver.DmdbStatement.execute(SourceFile:1300) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:327) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130) ... 12 more
这块?
