[teiid-issues] [JBoss JIRA] (TEIID-5672) When using DateTime datatype with millisecond fractions, i.e DateTime(3) the resulting urls for the records are invalid

[ https://issues.jboss.org/browse/TEIID-5672?page=com.atlassian.jira.plugin... ] Christoph John edited comment on TEIID-5672 at 3/5/19 7:43 AM: --------------------------------------------------------------- Hello Ramesh, seems like we narrowed down the bug. But this one looks very weired. Testscenario is again with DateTime(3). I am querying the generated url from browser. https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,Ad... Then I extract queries from logfile and execute from mysql workbench console. The logfile with "org.teiid.COMMAND_LOG" is set to TRACE. Logfile is attached to this comment. As I have not found a log statement with "source-specific" I tried all queries that have been given in the output. The queries given in the logfile on line 14, 17 and 39 are correct and are working from the mysql console. However, the query at line 18 is not. Query: sourceCommand=[S ELECT g_0.`fkProfile` AS c_0, g_0.`AddedDateTime` AS c_1, g_0.`fkIdCode` AS c_2, g_0.`product_name` AS c_3, g_0.`brands` AS c_4, g_0.`DatabaseID` AS c_5, g_0.`MealNumber` AS c_6, g_0.`AmountInG` AS c_ 7 FROM `Diary` AS g_0 WHERE g_0.`fkProfile` IN (SELECT g_1.`idProfile` FROM `Account` AS g_1 WHERE g_1.`uuidUser` = ?) AND g_0.`fkProfile` = 2 AND g_0.`AddedDateTime` = {ts '2019-03-05 12:06:21.0'} OR DER BY c_0, c_1] The error in this line is the part of the statement 'uuidUser'= ? There should not be a ? but the UUID as in the two other sql queries. So this seems weird, as this has nothing to do with fraction accuracy of the DateTime object. So if the statement at line 18 is the relevant one from the log we found the problem. Is this enough info for you to narrow down the problem? If you need more let me know what you need. Thanks for your help! was (Author: cjohn001): Hello Ramesh, seems like we narrowed down the bug. But this one looks very weired. Testscenario is again with DateTime(3). I am querying the generated url from browser. https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(fkProfile=2,Ad... Then I extract queries from logfile and execute from mysql workbench console. The logfile with "org.teiid.COMMAND_LOG" is set to TRACE. Logfile is attached to this comment. As I have not found a log statement with "source-specific" I tried all queries that have been given in the output. The queries given in the logfile on line 14 and 17 are correct and are working from the mysql console. However, the query at line 18 is not. Query: sourceCommand=[S ELECT g_0.`fkProfile` AS c_0, g_0.`AddedDateTime` AS c_1, g_0.`fkIdCode` AS c_2, g_0.`product_name` AS c_3, g_0.`brands` AS c_4, g_0.`DatabaseID` AS c_5, g_0.`MealNumber` AS c_6, g_0.`AmountInG` AS c_ 7 FROM `Diary` AS g_0 WHERE g_0.`fkProfile` IN (SELECT g_1.`idProfile` FROM `Account` AS g_1 WHERE g_1.`uuidUser` = ?) AND g_0.`fkProfile` = 2 AND g_0.`AddedDateTime` = {ts '2019-03-05 12:06:21.0'} OR DER BY c_0, c_1] The error in this line is the part of the statement 'uuidUser'= ? There should not be a ? but the UUID as in the two other sql queries. So this seems weird, as this has nothing to do with fraction accuracy of the DateTime object. So if the statement at line 18 is the relevant one from the log we found the problem. Is this enough info for you to narrow down the problem? If you need more let me know what you need. Thanks for your help! -- This message was sent by Atlassian Jira (v7.12.1#712002)