server 启动后log报错3065 - Expression #1 of ORDER BY clause is not in SELECT list
cjo123 opened this issue · 1 comments
cjo123 commented
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 DISTINCT t.from as transFrom FROM tx_raw_data_#{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后正常启动 但是没有定时从链上获取交易数据保存到数据库
cjo123 commented
链上数据保存已修复