[ https://issues.jboss.org/browse/TEIID-5672?page=com.atlassian.jira.plugin... ] Christoph John edited comment on TEIID-5672 at 3/5/19 7:55 AM: --------------------------------------------------------------- Hello Ramesh, seems like we narrowed down the bug a little. But not sure how to interpret thins. If so it looks 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=[SELECT 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'} ORDER BY c_0, c_1] The error in this line is the part of the statement 'uuidUser'= ? I assume there should not be a ? but the UUID like in the three other sql queries. So this seems weird, as this has nothing to do with fraction accuracy of the DateTime object. If the statement at line 18 is the one that matters, we found the problem. However, If it is just an intermediary output and the query at line 39 is the actual relevant one we need to investigate further. Is this enough info for you to narrow down the problem? If you need more let me know what you need. As I do not see an error message or warning, this part of the output actually looks quite good for me. From the statement I would assume the error is laying somewhere else and the query at line 39 is the one that worked. 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, 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! -- This message was sent by Atlassian Jira (v7.12.1#712002)