New Features in IJC Q2 2017¶
Customizable positioning of null values when sorting¶
The new functionality that allows custom ordering on columns that are marked for sorting in IJC. The settings for this is in Schema Settings -> Miscelanous with custom value of "Database default", ordering empty values "First" or empty values "Last".
Summarization of default values for most popular RDBMs:
| RDBMs | ORDER BY .. ASC | ORDER BY .. DESC |
|---|---|---|
| Oracle | NULLs last | NULLs first |
| MySQL | NULLs first | NULLs last |
| SQL Server | NULLs last | NULLs first |
| PostgreSQL | NULLs last | NULLs first |
| Derby | NULLs last | NULLs first |
Printing improvement¶
Printing performance and memory consumption improved. Especially noticeable while printing large data.