Jailer full changelog

QL Console: new result tab "Pivot" next to "Chart". It shows a cross table of the rows:
The fields are chosen in a side bar. Row fields and column fields can be nested (e.g.
DEPTNO, then JOB), with subtotals per group. "Totals of single-element groups" also shows
subtotals of groups with only one subgroup.
Several values, each with its own aggregate function: Count, Count distinct, Sum, Avg, Min
or Max. "(rows)" counts the rows.
Totals are computed from the rows themselves, so that they are also correct for Avg and
Count distinct.
The values of a row or column field can be filtered (filter button next to the field).
Filtered rows are not counted, also not in the totals.
Double-clicking a cell selects its rows in the "Rows" tab and sorts the rows accordingly.
"Chart" shows the pivot table as chart (the groups, without subtotals and totals).
"SQL..." generates the SQL statement that computes the pivot table.
"Copy" copies the pivot table with header to the clipboard, "Save as CSV..." saves it as
CSV file.
"Save as Excel..." saves an Excel workbook (.xlsx, can also be opened with LibreOffice)
with an Excel PivotTable, the pivot table as formulas over the rows (with collapsible
groups and AutoFilter), and the rows themselves.
Fixed: SQL scripts exported for SQLite, HSQLDB, Firebird, Sybase, Informix, Derby or Cloudscape
could not be imported reliably if a text value contained line breaks. Inside such a value,
a line ending with ";" broke the statement, and blank lines, leading and trailing blanks and
lines starting with "--" got lost. Carriage returns (CR) were dropped as well.
For SQLite, HSQLDB, Firebird, Sybase and Informix, line breaks are now exported as
char(10)/char(13) expressions, so each value stays on one line of the script.
The import now keeps multi-line string literals unchanged, including carriage returns. This
also makes scripts exporte

Rows can now be compared column by column. The new submenu "Compare" in the context menu of a row offers the comparisons below. It compares the selected rows, while the submenu "Compare" of the menu of a table browser and the context menu of a result tab of the SQL Console compare all rows. Differences are highlighted, columns present on one side only are shown as such, and "Only differences" hides the equal columns. The column comparison has a full text search (Ctrl+F) covering all rows of the overview; it selects the next row containing the search text when needed, and the column "Matches" of the overview shows the number of matches per row. The column names can be sorted. Comparisons with the rows in a database ("Compare with other Database...", "Compare with Current Data") can be repeated with "Refresh" without closing the dialog. Values are compared independent of the DBMS they have been read from: a date equals the timestamp at midnight of that day, a boolean equals 1 or 0, and trailing blanks (padding of CHAR columns) are ignored.
For rows of a table with a primary key, the button "Synchronize..." creates a SQL script that makes the rows of one side equal to the other one: it inserts the missing rows and updates the different columns, the primary key and LOBs are left unchanged. The script can be executed directly, after which the comparison is repeated. For results of the SQL Console it is available if they are rows of a table of the data model, for "Compare with..." if both results are rows of the same table.
"Compare with Each Other" compares two selected rows of a table browser or of a result of the SQL Console. "Synchronize..." makes either row equal to the other one.
"Compare with other Database..." reads the rows having the same primary key from the database of another connection, for instance the target database of a subset, and comp

Fixed: Session was not closed on exception in Importer.execute().
Fixed resource leaks: streams and writers are now properly closed via try-with-resources
In ExtractionModel, RestrictionModel, CommandLineParser, ModelBuilder,
IntraDatabaseEntityGraph and SQLConsole.
Fixed: InterruptedException in shutdown hook now restores the interrupt flag and exits the wait loop.
Fixed: LOB insert methods (insertClob, insertSQLXML) refactored to eliminate duplicate code;resource leak in stream handling corrected.

Minor improvements to the user interface.

Copying individual columns in the "single row view" in the data browser is now possible.
The "Outline" feature in the SQL console has been improved.

Tooltips for column types and constraints are now also shown in the column view of a table.

Feature "#131 Add an extra statement after insert blocks"

Support for "DateTimeOffset #129"
Fixed a bug that occurred infrequently in the data browser concerning the column value search function.
Improved estimation of the row count in the SQL console.

In-place editing in single-row views did not work correctly after reloading.

Fix: "#55 Fix row counter sql generation"