3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'db_browser_test.t.block_height' which is not in SELECT list; this is incompatible with DISTINCT
路径：src/main/resources/mapper/TransactionMapper.xml
<select id="getTransFormByGroup" parameterType="java.lang.Integer"
resultType="org.bcos.browser.entity.dto.Transaction">
SELECT DISTINCT t.from as transFrom FROM tx_rawdata#{groupId} t
WHERE NOT EXISTS (
SELECT 1 FROM tb_chain_user WHERE group_id = #{groupId} AND address = t.from
) ORDER BY t.block_height DESC,t.tx_index DESC
cjo123
commented
2 years ago
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'db_browser_test.t.block_height' which is not in SELECT list; this is incompatible with DISTINCT
路径：src/main/resources/mapper/TransactionMapper.xml <select id="getTransFormByGroup" parameterType="java.lang.Integer" resultType="org.bcos.browser.entity.dto.Transaction"> SELECT DISTINCT t.
fromas transFrom FROM tx_rawdata#{groupId} t WHERE NOT EXISTS ( SELECT 1 FROM tb_chain_user WHERE group_id = #{groupId} AND address = t.from) ORDER BY t.block_height DESC,t.tx_index DESC修改sql后正常启动 但是没有定时从链上获取交易数据保存到数据库