Hello Team,
We are having an issue when using the HXTT driver to update a CSV file.
We observed that when we use an update query followed by a PACK table statement, we can’t update the csv correctly for few scenarios,
For example,
We have below 2 queries,
Update Employee set Email = ‘abcdefgh12345678911111’ where employeeId = ‘1234’;
PACK TABLE Employee;
PACK table statement is required because if you don’t use this it inserts blank lines in the csv automatically.
If you see when a string to be updated is of length > 19 , it just blanks out that field in csv.
It works correctly when we send a string to update lesser than 19 characters.
If we don’t use the PACK statement, it updates the fields correctly for all lengths.
Is this a limitation or is there any other way to do this?
-Seema
|
Passed test with v7.1.081 for the following sqls:
#create table if not exists Employee(employeeId int, email varchar(66));
insert into Employee (employeeId , email ) values (1234,'abcde');
insert into Employee (employeeId , email ) values (1235,'abcdee');
Update Employee set Email = 'abcdefgh12345678911111' where employeeId = '1234';
PACK TABLE Employee;
|