manticore-projects
manticore-projects
Greetings, after applying PR #1666 your `INSERT` example should work like that: ```java String providedSql ="INSERT INTO example (num, name, address, tel) VALUES (1, 'name', 'test ', '1234-1234')"; String expectedSql...
Postgres implicit casts are not supported. Explicit casts will work fine. Duplicate of #1344.
Yes, this is how I saw and I have changed that already. For this particular Test Case, the answer would be: 3 while the second Statement would be null. This...
Not supported in JSQLParser (and if you ask me, Postgres should not support this either). I can only guess that this an Ingres heritage. You best bet would be to...
Greetings! I do not think that the PostgreSQL specific `ON CONFLICT ... DO ...` clause is supported. You would need to amend the `INSERT` production and send a PR please.
Technically this is an `UPSERT`, which is actually supported by JSQLParser: http://217.160.215.75:8080/jsqlformatter/_static/railroad_diagram.xhtml#Upsert However, PostgreSQL does not seem to support `UPSERT` explicitly, but having these `INSERT ... ON CONFLICT ...` syntax...
`INSERT ... ON DUPLICATE ...` is supported as well: http://217.160.215.75:8080/jsqlformatter/_static/railroad_diagram.xhtml#Insert So it all boils down to ammending the `INSERT` production and to allow the `ON CONFLICT` instead.
Greetings! Clickhouse's specific `GLOBAL JOIN` is not supported yet, but your contribution/PR will be very welcome.
Greetings. please what exactly does ```sql limit 1 by exp_id, uid, retain_days ``` represent? Please point me on the SQL specification you are following here. If you relate to [Clickhouse...
MySQL CONVERT() character sets is not supported. https://www.w3schools.com/mysql/func_mysql_convert.asp Please change the Caption of this issues to point on the correct problem.