Recent changes to patcheshttps://sourceforge.net/p/jsqlparser/patches/2011-06-04T05:10:30ZRecent changes to patchesCASE-ELSE arithmetic function parsing issue2011-06-04T05:10:30Z2011-06-04T05:10:30ZREShttps://sourceforge.net/u/riversedgesw/https://sourceforge.net5beeb5cfc1c4388dd540d29ccaba2328b19e224f <K\_CASE>
\(
\( clause=WhenThenSearchCondition\(\) \{ whenClauses.add\(clause\); \} \)+
\[<K\_ELSE> elseExp=SimpleExpression\(\)\]
|
switchExp=PrimaryExpression\(\)
\( clause=WhenThenValue\(\) \{ whenClauses.add\(clause\); \} \)\*
\[<K\_ELSE> elseExp=SimpleExpression\(\)\]
\)
<K\_END>
"CASE" bug fix2010-07-29T11:48:46Z2010-07-29T11:48:46ZJuozas Baliukahttps://sourceforge.net/u/baliuka/https://sourceforge.netd1a2eac13cabd24411fdb004d7033e1dd5b90dd6test :
private String normalize\(String str\)\{
return str.replaceAll\("\\\s+","\t"\);
\}
public void testParseable\(\) throws JSQLParserException\{
String sql = "SELECT CASE WHEN COUNT\(NUMBER\_OF\_TEST\) = 0 THEN 0 " +
"ELSE \(CASE WHEN STATUS = 'test' THEN 0 ELSE 1 END\) / COUNT\(NUMBER\_OF\_TEST\)" +
" END AS HIT\_RATIO FROM TEST";
sql = normalize\(sql\);
Select select = \(Select\) parserManager.parse\(new StringReader\(sql\)\);
assertEquals\(sql,normalize\(select.toString\(\)\)\);
\}
Concat grammar2010-07-17T12:00:04Z2010-07-17T12:00:04ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.nete66db136577d9381deb84ece612dff63d0945493grammar file \(it was marked as binary in svn\)Concat operator2010-07-17T11:57:31Z2010-07-17T11:57:31ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net80196d98ea28a9ec31d3e35e9d71b3054a3bd128Node classConcatination operator2010-07-17T11:55:17Z2010-07-17T11:55:17ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net863f7a4ef40ac5100f627de31df50f0cf65dcf3etestconcatination operator2010-07-17T11:53:45Z2010-07-17T11:53:45ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net6fe04fd9b0026cfd3729fcc8534aa13e869f74f0this patch adds support for string concatination operator "||"