Duplicate key DmDbColumn

DmTablesMapper
public List<DmDbColumn> selectTableColumns(String schema, String tableName) {
        String sql = "SELECT DISTINCT c.COLUMN_NAME, c.DATA_TYPE, c.DATA_LENGTH, c.DATA_PRECISION, c.DATA_SCALE,  \n" +
                "       c.NULLABLE, c.DATA_DEFAULT, com.COMMENTS  \n" +
                "FROM ALL_TAB_COLUMNS c  \n" +
                "LEFT JOIN USER_COL_COMMENTS com ON c.TABLE_NAME = com.TABLE_NAME AND c.COLUMN_NAME = com.COLUMN_NAME" +
                "  \n" +
                "WHERE c.TABLE_NAME = ':tableName' \n" +
                "AND c.OWNER = ':schema';";

return DataSourceManager.useConnection(connection -> {
            return DBHelper.queryObjectList(connection, sql, new HashMap<String, Object>() {{
                put("tableName", tableName);
                put("schema", schema);
            }}, DmDbColumn.class);
        });
    } 
这个sql left join on 缺少 c.OWNER  = com.OWNER 相同的schema 会导致 java.lang.IllegalStateException: Duplicate key DmDbColumn
Caused by: java.lang.IllegalStateException: Duplicate key DmDbColumn(name=xxx, type=BIGINT, length=8, precision=null, scale=0, nullable=Y, defaultValue=null, comment=)
	at java.util.stream.Collectors.lambda$throwingMerger$0(Collectors.java:133)
	at java.util.HashMap.merge(HashMap.java:1255)
	at java.util.stream.Collectors.lambda$toMap$58(Collectors.java:1320)
	at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169)
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1384)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566)
	at org.dromara.autotable.strategy.dm.DmStrategy.compareColumnInfo(DmStrategy.java:141)
	at org.dromara.autotable.strategy.dm.DmStrategy.compareTable(DmStrategy.java:106)
	at org.dromara.autotable.strategy.dm.DmStrategy.compareTable(DmStrategy.java:37)
	at org.dromara.autotable.core.strategy.IStrategy.updateMode(IStrategy.java:283)
	at org.dromara.autotable.core.strategy.IStrategy.start(IStrategy.java:200)
	at org.dromara.autotable.core.strategy.IStrategy.start(IStrategy.java:174)
	at org.dromara.autotable.core.AutoTableBootstrap.executeStrategy(AutoTableBootstrap.java:209)
	at org.dromara.autotable.core.AutoTableBootstrap.lambda$handleAnalysis$2(AutoTableBootstrap.java:116)
	at java.util.HashMap.forEach(HashMap.java:1290)
	at org.dromara.autotable.core.AutoTableBootstrap.handleAnalysis(AutoTableBootstrap.java:84)
	at org.dromara.autotable.core.AutoTableBootstrap.start(AutoTableBootstrap.java:64)
	at org.dromara.autotable.springboot.AutoTableAutoConfig.start(AutoTableAutoConfig.java:158)
	at org.dromara.autotable.springboot.AutoTableAutoConfig.<init>(AutoTableAutoConfig.java:151)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:172)
	... 21 common frames omitted

dromara/AutoTable

内容风险标识

评论 (1)

dromara/AutoTable .gitee-modal { width: 500px !important; }

内容风险标识