Valid SOQL queries display a warning saying they are invalid
Issue #2283
resolved
Version 2.2.4.9
Build 20221130115038
Build #IU-223.7571.182, built on November 29, 2022
Windows 11
Running this example SOQL Query results in the following popup warning “The SOQL query does not appear valid. Would you still like to execute it?”
Clicking yes results in a successful query. I believe the error checking on the syntax is missing something.
Comments (5)
-
repo owner
-
reporter
Sorry Scott, I was scatterbrained and didn’t paste the query.
select id, createddate from Contact where CreatedDate >= 2022-12-01T10:47:53.299852-06:00
-
repo owner
No problem. That gets me there. The issue is that IC2’s Apex/SOQL parser isn’t correctly handling a date/time literal with that level of precision in the milliseconds portion:
I’ll take care of it for the next build.
-
repo owner
Fix committed for the next build.
-
repo owner
- changed status to resolved
Delivered in 2.2.5.0.
- Log in to comment
Can you provide exact query that’s causing this? That message is raised when IC2 doesn’t parse a SOQL query properly, so it sounds like there’s something missing/wrong in its SOQL parser.