manticore-projects

Apologies for turning this into a kind of discussion: 1) the full rewrite would look like ```sql -- provided select to_number('$ 2,012,454.88', 'L 9,999,999.99') AS number; -- expected SELECT Cast(...

Greetings. [Both statements get parsed and no error message is thrown.](http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20LTAECUFMAcBsEMDGlQHcCWAXAFqAngPYCuATqAIIDCAKgKrkAyokAHvALZyQBQAIuAHkACqABitAHI0AkgImhpo0AFEAGtIDK1DaABEAM3QA7XQDpdJSAGdMBSwH19RIwBN7L+Jni6AFLuOOzm7oLrqgxpgAHACUANzc3JTgyuTUyqAC4BDKQgxU6eJS1LLyBsZmFta2Dk6u7p7efgG1waHhRlHR3Ml04BI6utAA5vaIDbAEQxUAbvAkiNhzYeQ6ACQAQgK8AJqrfMqUecncoKDs1lbwQygAauTglAAS9-GnBNCQRqCWiKOkr6BEBMrChoCQCAArezGfQEP4kAEAKmRKORJ2yvXkAHIrEREMgrFYsfFlBJeKANltdtw8hIAOL0OnpODDKwAR1goBuAjyxQYykSAi0oAAjAAGMWxIA) What exactly is the challenge please?

The query fails after 52 seconds: `CAST( expression AS DATE FORMAT char_literal)` is not supported.

```java void testIssue1983() throws JSQLParserException { String sqlStr = "INSERT INTO\n" + "C01_INDIV_TELBK_CUST_INFO_H_T2 (PARTY_ID, PARTY_SIGN_STAT_CD, SIGN_TM, CLOSE_TM)\n" + "SELECT\n" + "A1.PARTY_ID,\n" + "A1.PARTY_SIGN_STAT_CD,\n" + "CAST(\n" + "(\n" + "CASE\n" +...

Seems to be [Google BigQuery](https://cloud.google.com/bigquery/docs/reference/standard-sql/conversion_functions#cast_as_date). Lucky you as I am going to implement this special `FORMAT` clause.

I have implemented Google BigQuery `CAST` with `FORMAT` clause and in the result the query does not fail anymore after 1 minute. Instead it literally runs forever, likely because of...

I really don't know, you can only try out by yourself.

I am glad that you like it. One thing: The pure [Java PNG Encoder](https://github.com/pngencoder/pngencoder) (last entry in the list) supports a "Parallel/Multi-Core" mode which is blazing fast, especially for large...

No problem at all. My usecase is specifically on "many smaller PNGs" (like a kind of screen recording), so I don't need the multi-threaded mode. I just wanted to point...

I have replaced the slow/bad/expensive Java 4Byte ABGR to RGBA translation with SSE bit shuffling calls. (AVX was slower, likely due to the 32 bit alignment requirement). Now, FPNGE Java...