为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:v8
【操作系统】:windows
【CPU】:intel i7
【问题描述】*:
字段复制,报错???
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:615)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$2(SQLQueryJob.java:506)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:528)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:977)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:4176)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:123)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:192)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:121)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5154)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:117)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException: 记录超长
at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2570)
at dm.jdbc.dbaccess.Request_Response.resp_execute(Request_Response.java:1107)
at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:700)
at dm.jdbc.dbaccess.DmdbCSI.prepareSQL(DmdbCSI.java:224)
at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1738)
at dm.jdbc.driver.DmdbStatement_bs.executeInner(DmdbStatement_bs.java:2132)
at dm.jdbc.driver.DmdbStatement_bs.execute(DmdbStatement_bs.java:869)
at dm.jdbc.driver.DmdbStatement.do_execute(DmdbStatement.java:1395)
at dm.jdbc.filter.FilterChain.Statement_execute(FilterChain.java:920)
at dm.jdbc.driver.DmdbStatement.execute(DmdbStatement.java:462)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
... 11 more
要么扩大精度,要么开启超长记录,都试试
这个应该是左右两边的列长度不一样,部分数据更新放不进去列长度小的列,导致的报错,需要调整左边相关列属性列长度大小
开启表的超长记录看看
alter table wh_test1 enable using long row ;
这个么看看两个字段设置的长度是多少,不够的么扩大即可。