manticore-projects

Closed, since no further question has been asked.

This `DEFERRABLE` syntax is not supported. Without it your statement is parsed and you can [test it online here](http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20MIJQogggKmAEUQEIBk4GcD2BbApmgxgBY5YCGAdJrgE44A2pALgJYYB2jpARnTrABQAoWCNi06ARgD6ABwDWo0QEkAclFgqA8upUBVZMmGiANGPoAmWQuVqN2jfsOLTwTSoDKUEBFXrx08Ut5NCNFEV0VJQBFXTh+M0krU0CrWABKQQBaTIARMAAxMBBvFDBBDIBuIA+) What RDBMS uses `DEFERRABLE` please? Actually supported syntax is shown here:...

Closed when no further question has been asked.

Greetings, thank your for the report. It contains all needed information and is a fine example, how an error report should look alike. That said: those MySQL specific syntax are...

Closed, since no further question has been asked.

Duplicate of #1344, it is not about the Timezone but about casting the String. [Explicit Cast works](http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20MoUQMiDCAqAEDkAmADMgLAWgIzOwTlhwC5EBmIgVjXiKOgEkBZEYaAQUYAVYB1e6ABKwGzWAC0A8gDkQAKADcspaAgxYkNqwAUSVJhz5CyEuSrxYm4UxbsuvfkJEhx0kAEoFQA+)

Greetings, good catch! The problem here is the priority of the expressions, the `AND` belongs to the `WHERE` but not to the `ESCAPE`. I will have a look into this...

I think, that has been solved since a while. JSQLParser 4.6 Snapshot parses it just fine: ```sql -- Input select doc.fullName from XWikiDocument doc where doc.fullName like :fullName escape '/'...

Indeed, the Maven Build contains it, while the Gradle build does not. I have to check out the Gradle build and add the generated Sources there.

Fixed by PR #1382 which is pending approval. You can pull and compile in the meantime to get a working JAR.