HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

CSV query not responding when SELECT column not exits in file.	Prasad	2018-07-30 07:51:03
When we SELECT columns which is not exits in CSV file, causes stackoverflow error and we have to restart app server each time. Actual behavior: ERROR (ApplyChangesRegularThread-3109) [SystemErr] java.lang.StackOverflowError 06/27/2018 08:09:21.030 ERROR (ApplyChangesRegularThread-3109) [SystemErr] at com.hxtt.sql.d1.a(Unknown Source) Expected Behavior: Should throw exception saying that 'column UserId' does not exit in the source. Driver Used : Text_JDBC30.jar ------------ We used below query: Here UserID column not exits in CSV file. ------------------- SELECT DISTINCT ACCOUNTNAME as Account_ID, CASE WHEN (LEN(UserID) = 8 AND ((RIGHT(UserID,1) ='a') OR RIGHT(UserID,1) ='A')) THEN LEFT(UserID,7) ELSE UserID END AS UserID FROM t_my_test_ACCOUNTS_USERS Note: ----- Observed this behavior when the column selected is condition based like CASE in the query. However below query works and gives the proper error. ---------------------------------------------- SELECT DISTINCT ACCOUNTNAME as Account_ID, UserID FROM t_my_test_ACCOUNTS_USERS Kindly assist.
Re:CSV query not responding when SELECT column not exits in file.	HXTT Support	2018-07-31 01:24:03
>ELSE UserID END AS UserID It should be ELSE UserID END AS User_ID Fixed in the latest package, and it will throw "Across reference: UserID and UserID"

Email: