The LIKE "%SSL%" pattern gives only 44 results but actualy there are 1000 SSL text present in each column.
I have tried it with SQLite database as well which gives exactly 1000 rows. I have observed that the data posted below is not getting matched with LIKE. Kindly help me to solve this. Please note that I haven't used any database connection properties.
**Query used: ** SELECT Message FROM csvfile WHERE Message LIKE '%SSL%'
The LIKE "%SSL%" pattern gives only 44 results but actualy there are 1000 SSL text present in each column.
I have tried it with SQLite database as well which gives exactly 1000 rows. I have observed that the data posted below is not getting matched with LIKE. Kindly help me to solve this. Please note that I haven't used any database connection properties.
**Query used: ** SELECT Message FROM csvfile WHERE Message LIKE '%SSL%'
CSV Sample Data:
"Id","Error_Code","Message"
"a0d3100000DshABAAZ","-1200","An SSL error has occurred and a secure connection to the server cannot be made. - {
""dataSync"" : {
""DataOfflineLastModifiedById"" : ""005i0100005GtPA"",
""OfflineLastModifiedByID"" : ""005i000005GtPA"",
""Data"" : ""{\n \""OfflineLastModifiedByID\"" : \""005i0010005GtDA\"",\n \""Product\"" : \""a18i0000000vMucAAE\"",\n \""Account\"" : \""001i001010sUMerABG\"",\n \""Product_Discussion_Topic\"" : \""a17i0000002zPgdAAE\"",\n \""Id\"" : \""Pre_Call_Objective__c-005i0001005GtPA-20150601133239-ch5sk\"",\n \""OfflineCreatedDate\"" : \""2015-06-01T05:32:42.318+0000\"",\n \""Call\"" : \""a0M3100100FOoEVEA1\"",\n \""OfflineLastModifiedDate\"" : \""2015-06-01T05:32:42.318+0000\"",\n \""OfflineUniqueID\"" : \""Pre_Call_Objective__c-005i0010005GtPA-20160601133239-ch5sk\"",\n \""OfflineCreatedByID\"" : \""005i0010005GtPA\""\n}"",
""DataOfflineLastModifiedDate"" : ""2015-01-01T05:32:42.318+0000"",
""IsDeletedOffline"" : 0,
""Sobject_API"" : ""Pre_Call_Objective__c"",
""OfflineCreatedDate"" : ""2015-06-01T05:32:42.390+0000"",
""OfflineUniqueID"" : ""a0U3100000ZjgBgEAJ-Pre_Call_Objective__c-005i0001005GtPA-20160601133239-ch5sk"",
""OfflineLastModifiedDate"" : ""2015-06-01T05:32:42.390+0000"",
""Data_Sync_Transaction"" : ""a0U3101000ZjgBgEAK"",
""DataUniqueId"" : ""Pre_Call_Objective__c-005i0001005GtPA-20160601133239-cj5sk"",
""OfflineCreatedByID"" : ""005i0010005GtOA""
}
}"
Logged and fixed as CsvJdbc bug 124, LIKE does not match multi-line strings
https://sourceforge.net/p/csvjdbc/bugs/124/
A new csvjdbc.jar will be created automatically on Jenkins CI server on 09.06.2016.
https://csvjdbc.ci.cloudbees.com/
Thanks Simon.