search

chuntungho / mybatis-builder

An IDEA plugin integrated with MyBatis Generator, compatible with IntelliJ IDEA CE
https://mybatis.chuntung.com
MIT License
42 stars 20 forks source link

‘Copy as Executable SQL’ have a bug #4

Closed CNAHYZ closed 4 years ago

CNAHYZ commented 4 years ago

2020-06-23 10 : 39 : 21.367 [ DEBUG ] nm.examResult.listExamResultExport - ==> Preparing : SELECT * FROM (SELECT * FROM exam_result_data a WHERE op_orgnz_id LIKE concat(?, '%' ) AND date_format( exam_date, '%Y-%m-%d' ) >= ? AND ? >= date_format( exam_date, '%Y-%m-%d' ) ) erd LEFT JOIN student_info si ON erd.stu_id = si.stu_id WHERE si.stu_id IS NOT NULL GROUP BY erd.stu_id, erd.SUBJECT, erd.exam_date ORDER BY erd.exam_date DESC, CONVERT ( erd.stu_name USING gbk ) ASC 2020-06-23 10:39:21.367 [DEBUG] nm.examResult.listExamResultExport - ==> Parameters: xxxxjx(String), 2020-06-23(String), 2020-06-23(String) 2020-06-23 10:39:21.387 [DEBUG] nm.examResult.listExamResultExport - <== Total: 0

this will copy as :

图片

the second 2020-06-23 not a String

CNAHYZ commented 4 years ago

The above SQL statement is simplified

chuntungho commented 4 years ago

fixed for Windows