| 1 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> |
| 2 |
<!-- |
| 3 |
Copyright 2004-2019 H2 Group. Multiple-Licensed under the MPL 2.0, |
| 4 |
and the EPL 1.0 (http://h2database.com/html/license.html). |
| 5 |
Initial Developer: H2 Group |
| 6 |
--> |
| 7 |
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en"> |
| 8 |
<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> |
| 9 |
<meta name="viewport" content="width=device-width, initial-scale=1" /> |
| 10 |
<title> |
| 11 |
Change Log |
| 12 |
</title> |
| 13 |
<link rel="stylesheet" type="text/css" href="stylesheet.css" /> |
| 14 |
<!-- [search] { --> |
| 15 |
<script type="text/javascript" src="navigation.js"></script> |
| 16 |
</head><body onload="frameMe();"> |
| 17 |
<table class="content"><tr class="content"><td class="content"><div class="contentDiv"> |
| 18 |
<!-- } --> |
| 19 |
|
| 20 |
<h1>Change Log</h1> |
| 21 |
|
| 22 |
<h2>Next Version (unreleased)</h2> |
| 23 |
<ul> |
| 24 |
<li>- |
| 25 |
</li> |
| 26 |
</ul> |
| 27 |
|
| 28 |
<h2>Version 1.4.199 (2019-03-13)</h2> |
| 29 |
<ul> |
| 30 |
<li>PR #1807: Reduce code duplication and remove h2.mixedGeometries |
| 31 |
</li> |
| 32 |
<li>PR #1806: Improve SELECT FOR UPDATE documentation |
| 33 |
</li> |
| 34 |
<li>PR #1804: Lift limit of 10 characters on enum value (1.4.198 regression) |
| 35 |
</li> |
| 36 |
<li>PR #1803: Do not rely on index sorting in SELECT FOR UPDATE |
| 37 |
</li> |
| 38 |
<li>Issue #1800: Remove experimental status from window functions |
| 39 |
</li> |
| 40 |
<li>PR #1799: Fire triggers after row locking and remove some leftovers |
| 41 |
</li> |
| 42 |
<li>PR #1798: Reuse some string builders, remove StatementBuilder and other minor changes |
| 43 |
</li> |
| 44 |
<li>Issue #1795: 1.4.198 regression with batch updates and transactions |
| 45 |
</li> |
| 46 |
<li>PR #1794: Ask password in Shell in secure way and improve database creation information in tutorial |
| 47 |
</li> |
| 48 |
<li>PR #1791: Move commands to commands.html and other changes |
| 49 |
</li> |
| 50 |
<li>Issue #1774: H2 Browser configuration is unclear and fails on KUbuntu |
| 51 |
</li> |
| 52 |
<li>PR #1790: Do not convert standard TRIM function to non-standard functions |
| 53 |
</li> |
| 54 |
<li>Issue #1787: Non-standard MERGE throws LOCK_TIMEOUT_1 on violation of some constraints |
| 55 |
</li> |
| 56 |
<li>PR #1784: improve database not found error |
| 57 |
</li> |
| 58 |
<li>Issue #1740: Enhancement Request: h2 server: do not swallow exceptions |
| 59 |
</li> |
| 60 |
<li>Issue #1616: Metadata and scripts should be persisted with unconditionally quoted identifiers |
| 61 |
</li> |
| 62 |
<li>PR #1779: Improve isSimpleIdentifier() and enquoteIdentifier() |
| 63 |
</li> |
| 64 |
<li> PR #1776: Improve DATABASE_TO_LOWER handling |
| 65 |
</li> |
| 66 |
<li>Issue #1771: NPE in Comparison.createIndexConditions |
| 67 |
</li> |
| 68 |
<li>PR #1772: Fix newlines in test scripts |
| 69 |
</li> |
| 70 |
<li>Issue #1762: NullPointerException in Parser. Introduced in 1.4.198 |
| 71 |
</li> |
| 72 |
<li>PR #1768: Add more context-sensitive keywords |
| 73 |
</li> |
| 74 |
<li>Issue #1758: sequence restart issue with 1.4.198 |
| 75 |
</li> |
| 76 |
<li>Issue #1759: SELECT … FOR UPDATE returns old data in 1.4.198 |
| 77 |
</li> |
| 78 |
<li>PR #1756: Fix DISTINCT ON in presence of ORDER BY |
| 79 |
</li> |
| 80 |
<li>PR #1754: Fix window functions in JOIN with ON condition |
| 81 |
</li> |
| 82 |
<li>Issue #1751: making it easier to open console and create local databases |
| 83 |
</li> |
| 84 |
<li>Issue #1750: JOIN t ON t.col IN (SELECT ...) throws AssertionError |
| 85 |
</li> |
| 86 |
</ul> |
| 87 |
|
| 88 |
<h2>Version 1.4.198 (2019-02-22)</h2> |
| 89 |
<ul> |
| 90 |
<li>Issue #1746: Infinite loop in TestConcurrent.testConcurrentChangeAndGetVersion() |
| 91 |
</li> |
| 92 |
<li>Issue #1739: Table and view names not case sensitive when using DATABASE_TO_UPPER=FALSE |
| 93 |
</li> |
| 94 |
<li>Issue #848: H2 PostgreSQL Compatibility Mode: lowercase metadata |
| 95 |
</li> |
| 96 |
<li>Issue #485: Problem is in invalid case for schema's IGNORECASE=true;DATABASE_TO_UPPER=false |
| 97 |
</li> |
| 98 |
<li>Issue #1742, PR #1743: Assorted small changes |
| 99 |
</li> |
| 100 |
<li>PR #1738: Reduce memory allocation in getSQL() methods |
| 101 |
</li> |
| 102 |
<li>PR #1737: more javadoc updates |
| 103 |
</li> |
| 104 |
<li>Issue #1735: Creating views with DATABASE_TO_UPPER=FALSE fails |
| 105 |
</li> |
| 106 |
<li>Issue #1732: source.html does not work |
| 107 |
</li> |
| 108 |
<li>Issue #1730: Show error in H2 Console if specified driver is not compatible with URL |
| 109 |
</li> |
| 110 |
<li>Issue #1590: Error on executing "DELETE FROM table1 WHERE ID = ?; DELETE FROM table2 WHERE ID = ?;" |
| 111 |
</li> |
| 112 |
<li>Issue #1727: Support ISODOW as identifier for the extract function additional to ISO_DAY_OF_WEEK |
| 113 |
</li> |
| 114 |
<li>PR #1580, #1726: Disable remote database creation by default |
| 115 |
</li> |
| 116 |
<li>PR #1725: Add partial implementation of standard LISTAGG aggregate function |
| 117 |
</li> |
| 118 |
<li>PR #1722: Fix window definition lookup in some queries |
| 119 |
</li> |
| 120 |
<li>PR #1721: Fix derived column list in complex queries |
| 121 |
</li> |
| 122 |
<li>Issue #1718: Window function and values clause don't work well together |
| 123 |
</li> |
| 124 |
<li>Issue #1592: Index out of bounds exception in Page.getKey() |
| 125 |
</li> |
| 126 |
<li>PR #1716: Improve documentation of some DML commands |
| 127 |
</li> |
| 128 |
<li>Issue #1715: Postgres mode: Domain "regproc" already exists |
| 129 |
</li> |
| 130 |
<li>PR #1714: Assorted changes |
| 131 |
</li> |
| 132 |
<li>PR #1713: Remove DataType.defaultDisplaySize and fix display size in TypeInfo |
| 133 |
</li> |
| 134 |
<li>PR #1711: Add QUALIFY clause to SELECT command |
| 135 |
</li> |
| 136 |
<li>Issue #1708: CREATE TABLE AS doesn't support column lists without data types |
| 137 |
</li> |
| 138 |
<li>PR #1707: Fix sort order and ENUM data type in external results |
| 139 |
</li> |
| 140 |
<li>PR #1706: Add hypothetical set functions |
| 141 |
</li> |
| 142 |
<li>PR #1705: Fix GROUP_CONCAT with variable separator |
| 143 |
</li> |
| 144 |
<li>PR #1704: Fix return type of PERCENTILE_CONT and MEDIAN |
| 145 |
</li> |
| 146 |
<li>PR #1701: Add PERCENTILE_CONT and PERCENTILE_DISC inverse distribution functions |
| 147 |
</li> |
| 148 |
<li>Issues #1297, #1697: Failure on concurrent session closure |
| 149 |
</li> |
| 150 |
<li>Issue #1297: removeOldTempIndexes on PageStore causes NullPointerException |
| 151 |
</li> |
| 152 |
<li>Issue #1354: TestCrashAPI: another NPE |
| 153 |
</li> |
| 154 |
<li>PR #1695: Reduce memory for TestMVTempResult to 64m |
| 155 |
</li> |
| 156 |
<li>Issue #1691: Append mode causes OOME in MVPlainTempResult |
| 157 |
</li> |
| 158 |
<li>PR #1692: Use MVTempResult unconditionally |
| 159 |
</li> |
| 160 |
<li>Issue #1689: Use separate constants for data types in Data, ValueDataType, and Transfer |
| 161 |
</li> |
| 162 |
<li>PR #1687: MVMap minor cleanup |
| 163 |
</li> |
| 164 |
<li>PR #1686: Fix a regression with ENUM data type |
| 165 |
</li> |
| 166 |
<li>PR #1685: Fix CHAR in PostgreSQL mode and refactor some code |
| 167 |
</li> |
| 168 |
<li>Issue #1681: IN () doesn't work with row values when data types are not exactly the same |
| 169 |
</li> |
| 170 |
<li>Issue #1320: OOME / GC overhead in IndexCursor.nextCursor() |
| 171 |
</li> |
| 172 |
<li>PR #1680: Assorted fixes for ALTER TABLE ALTER COLUMN |
| 173 |
</li> |
| 174 |
<li>PR #1679: Use TestScript for testSimple |
| 175 |
</li> |
| 176 |
<li>Issue #1677: Unable to use VALUES keyword in WHERE clause |
| 177 |
</li> |
| 178 |
<li>Issue #1672: Deadlock on MVStore close in TestOutOfMemory |
| 179 |
</li> |
| 180 |
<li>Issue #1665: TestCrashAPI: NPE with ENUM in MINUS operator |
| 181 |
</li> |
| 182 |
<li>Issue #1602: Combine type, precision, scale, display size and extTypeInfo into one object |
| 183 |
</li> |
| 184 |
<li>PR #1671: Assorted changes |
| 185 |
</li> |
| 186 |
<li>Issue #1668: MySQL compatibility DATE() function should return NULL on error |
| 187 |
</li> |
| 188 |
<li>Issue #1604: TestCrashAPI: PreparedStatement.getGeneratedKeys() is already closed |
| 189 |
</li> |
| 190 |
<li>PR #1667: Detect NULL values and overflow in window frame bounds |
| 191 |
</li> |
| 192 |
<li>PR #1664: Allow any expressions in window frames |
| 193 |
</li> |
| 194 |
<li>Issue #1576: H2 Console should not display precision and scale for data types that don't have them |
| 195 |
</li> |
| 196 |
<li>PR #1662: Fix Alter Table Drop Column In View when table name is wrapped by Double Quotes |
| 197 |
</li> |
| 198 |
<li>PR #1660: Optimize window aggregates with AND UNBOUNDED FOLLOWING and no exclusions |
| 199 |
</li> |
| 200 |
<li>PR #1658: Assorted small changes |
| 201 |
</li> |
| 202 |
<li>PR #1657: Failure to stop background thread |
| 203 |
</li> |
| 204 |
<li>PR #1656: Optimize window aggregates with ORDER BY + UNBOUNDED PRECEDING + no exclusions |
| 205 |
</li> |
| 206 |
<li>Issue #1654: OOM in TestMemoryUsage, in big mode |
| 207 |
</li> |
| 208 |
<li>Issue #1651: TIMESTAMP values near DST may be changed in MVStore database due to UTC-based PageStore format in some |
| 209 |
temporary storages |
| 210 |
</li> |
| 211 |
<li>PR #1650: Fix race in MVStore.close() |
| 212 |
</li> |
| 213 |
<li>Issue #1212: TestDiskFull: The file is locked |
| 214 |
</li> |
| 215 |
<li>PR #1648: Add functions ARRAY_CAT(), ARRAY_APPEND() and ARRAY_SLICE() |
| 216 |
</li> |
| 217 |
<li>PR #1646: In preparation to a release |
| 218 |
</li> |
| 219 |
<li>PR #1643: more javadoc update |
| 220 |
</li> |
| 221 |
<li>PR #1642: update javadoc |
| 222 |
</li> |
| 223 |
<li>PR #1641: Update copyright years |
| 224 |
</li> |
| 225 |
<li>PR #1640: Suggest ANY(?) instead of variable IN() again |
| 226 |
</li> |
| 227 |
<li>PR #1638: Add support for Java 11 to test suite |
| 228 |
</li> |
| 229 |
<li>PR #1637: Remove explicit unboxing |
| 230 |
</li> |
| 231 |
<li>PR #1635: Optimize UUID to VARCHAR conversion and use correct time check in Engine.openSession() |
| 232 |
</li> |
| 233 |
<li>Issue #1632: TestMVTableEngine failure |
| 234 |
</li> |
| 235 |
<li>PR #1631: Prepare to release: javadoc cleanup |
| 236 |
</li> |
| 237 |
<li>PR #1630: fix duplicate words typos in comments and javadoc |
| 238 |
</li> |
| 239 |
<li>PR #1627: Use lock to protect append buffer |
| 240 |
</li> |
| 241 |
<li>Issue #1618: GROUP BY does not work with two identical columns in selected expressions |
| 242 |
</li> |
| 243 |
<li>Issue #1619: Two-phase commit regression in MASTER |
| 244 |
</li> |
| 245 |
<li>PR #1626: fix doc |
| 246 |
</li> |
| 247 |
<li>PR #1625: Prepare to release: javadoc cleanup, fix maven build, fix javadoc build |
| 248 |
</li> |
| 249 |
<li>Issue #1620: UUIDs are unexpectedly sorted as signed |
| 250 |
</li> |
| 251 |
<li>PR #1614: Use bulk .addAll() operation |
| 252 |
</li> |
| 253 |
<li>PR #1613: Add explicit table query |
| 254 |
</li> |
| 255 |
<li>Issue #1608: ARRAY and row value expression should not be the same |
| 256 |
</li> |
| 257 |
<li>Issue #1606: Quantified comparison predicate doesn't work correctly on primary key column |
| 258 |
</li> |
| 259 |
<li>Issue #1057: Very slow execution with subquery and connection parameter LAZY_QUERY_EXECUTION=1 |
| 260 |
</li> |
| 261 |
<li>Issue #1072: Very slow execution with join and connection parameter LAZY_QUERY_EXECUTION=1 |
| 262 |
</li> |
| 263 |
<li>PR #1601: Return BIGINT from ROWNUM(), ROW_NUMBER() and rank functions |
| 264 |
</li> |
| 265 |
<li>PR #1599: cleanup StringUtils.cache |
| 266 |
</li> |
| 267 |
<li>PR #1598: Minor changes in parser and documentation |
| 268 |
</li> |
| 269 |
<li>PR #1597: Remove SysProperties.CHECK preconditions around simple assertions |
| 270 |
</li> |
| 271 |
<li>PR #1596: Improve SQL Standard compliance in LOB precision parsing |
| 272 |
</li> |
| 273 |
<li>Issue #1594: DBSettings.optimizeIsNull and dead code in IndexCursor.getMax() |
| 274 |
</li> |
| 275 |
<li>PR #1591: Use multi-catch java 7 language construction to simplify code |
| 276 |
</li> |
| 277 |
<li>Issue #1582: h2 not using best index for >= |
| 278 |
</li> |
| 279 |
<li>PR #1588: Add support for java.time.Period |
| 280 |
</li> |
| 281 |
<li>Issue #446: FILE_READ from classpath not working because of 0 byte file length |
| 282 |
</li> |
| 283 |
<li>PR #1579: fix unintentional append mode disruption |
| 284 |
</li> |
| 285 |
<li>Issue #1573: DELETE FROM w/ ROWNUM and subquery |
| 286 |
</li> |
| 287 |
<li>Issue #187: SHUTDOWN DEFRAG corrupts splitted file database |
| 288 |
</li> |
| 289 |
<li>PR #1571: Optimizing ConditionAndOr queries |
| 290 |
</li> |
| 291 |
<li>Issue #1565: SOME / ANY conflict |
| 292 |
</li> |
| 293 |
<li>PR #1564: Refactor Expression implementations |
| 294 |
</li> |
| 295 |
<li>Issue #1561: Incorrect documentation and strange fallback value of SysProperties.FILE_ENCODING |
| 296 |
</li> |
| 297 |
<li>Issue #1566: MVStore implements Closeable/AutoCloseable |
| 298 |
</li> |
| 299 |
<li>Issue #1550: OutOfMemoryError during "shutdown defrag" |
| 300 |
</li> |
| 301 |
<li>Issue #1440: OOM when executing "shutdown compact" in server mode |
| 302 |
</li> |
| 303 |
<li>Issue #1561: Incorrect documentation and strange fallback value of SysProperties.FILE_ENCODING |
| 304 |
</li> |
| 305 |
<li>PR #1557: increase lock timeout to TestConcurrentUpdate due to Travis failures |
| 306 |
</li> |
| 307 |
<li>Issue #1554: REGEXP_REPLACE - accept 'g' flag in PostgreSQL compatibility mode |
| 308 |
</li> |
| 309 |
<li>Issue #950: Comparison between databases in README.md and in features.html |
| 310 |
</li> |
| 311 |
<li>Issue #1549: [RFE] Implement locking modes (select for update) |
| 312 |
</li> |
| 313 |
<li>PR #1548: Add AsynchronousFileChannel-based experimental FilePathAsync |
| 314 |
</li> |
| 315 |
<li>PR #1547: Speedup unused chunks collection |
| 316 |
</li> |
| 317 |
<li>PR #1546: Tiny optimization: use `System.arraycopy` when possible |
| 318 |
</li> |
| 319 |
<li>PR #1545: Export datetime value functions to SQL using standard syntax |
| 320 |
</li> |
| 321 |
<li>Issue #1371: NPE in CacheLRU |
| 322 |
</li> |
| 323 |
<li>Issue #1534: Typo in message |
| 324 |
</li> |
| 325 |
<li>Issue #1527: Parser performance: Excessive use of regular expressions to validate column names |
| 326 |
</li> |
| 327 |
<li>PR #1543: MVStore assorted re-factorings |
| 328 |
</li> |
| 329 |
<li>PR #1538: Add support for newer Lucene versions without recompilation |
| 330 |
</li> |
| 331 |
<li>Issue #1536: CURRENT_TIMESTAMP result doesn't change under Transactions |
| 332 |
</li> |
| 333 |
<li>Issue #239: Consider supporting Lucene 5 indexes |
| 334 |
</li> |
| 335 |
<li>PR #1520: Fixes bug in PutIfAbsentDecisionMaker |
| 336 |
</li> |
| 337 |
<li>Issue #1518: ENUM and VIEW with filtering on enum column |
| 338 |
</li> |
| 339 |
<li>Issue #1516: Array element reference array[index] should be 1-based |
| 340 |
</li> |
| 341 |
<li>Issue #1512: TestMVTableEngine.testLowRetentionTime(): NPE in VersionedValue.Type |
| 342 |
</li> |
| 343 |
<li>PR #1513: Assorted minor changes |
| 344 |
</li> |
| 345 |
<li>PR #1510: Add optional EXCEPT clause to wildcards |
| 346 |
</li> |
| 347 |
<li>PR #1509: Use domain term everywhere |
| 348 |
</li> |
| 349 |
<li>Issue #1507: Add INFORMATION_SCHEMA.COLUMNS.COLUMN_TYPE qualification for domains |
| 350 |
</li> |
| 351 |
<li>Issue #1499: TestScript::envelope.sql failure in “big” mode |
| 352 |
</li> |
| 353 |
<li>Issue #1498: NPE in SimpleResultSet.getColumnCount() |
| 354 |
</li> |
| 355 |
<li>Issue #1495: MERGE statement doesn't affect any rows when Oracle UPDATE .. WHERE .. DELETE .. WHERE is used |
| 356 |
</li> |
| 357 |
<li>Issue #1493: MERGE statement fails when it updates more than one row |
| 358 |
</li> |
| 359 |
<li>Issue #1492: Unnecessary restriction on MERGE USING statement when ON clause doesn't reference any target table columns |
| 360 |
</li> |
| 361 |
<li>Issue #1491: Unnecessary restriction on MERGE USING statement when ON predicate doesn't match inserted row |
| 362 |
</li> |
| 363 |
<li>Issue #1490: NullPointerException when running invalid MERGE statement |
| 364 |
</li> |
| 365 |
<li>Issue #1489: MERGE USING documentation has misleading railroad diagram |
| 366 |
</li> |
| 367 |
<li>Issue #1488: Improve documentation of window and some other functions |
| 368 |
</li> |
| 369 |
<li>Issue #1485: Default window frame in presence of ORDER BY is RANGE .., not ROWS |
| 370 |
</li> |
| 371 |
<li>PR #1484: New tests, reimplemented EXCLUDE clause, and assorted changes |
| 372 |
</li> |
| 373 |
<li>Issue #1338: MSSQLServer compatibility enhancements |
| 374 |
</li> |
| 375 |
<li>PR #1480: Update Maven build instruction and fix some problems |
| 376 |
</li> |
| 377 |
<li>PR #1478: Upgrade maven-surefire-plugin |
| 378 |
</li> |
| 379 |
<li>PR #1476: Add TransactionStore to MVStore jar |
| 380 |
</li> |
| 381 |
<li>Issue #1475: Dropping column used by a view produces misleading error message |
| 382 |
</li> |
| 383 |
<li>Issue #1473: TestScript needs better detection of sorted result |
| 384 |
</li> |
| 385 |
<li>PR #1471: issue 1350: TestCrashAPI: PageStore.freeListPagesPerList |
| 386 |
</li> |
| 387 |
<li>PR #1470: Fix window functions in queries with HAVING |
| 388 |
</li> |
| 389 |
<li>PR #1469: Forbid incorrect nesting of aggregates and window functions |
| 390 |
</li> |
| 391 |
<li>Issue #1437: Generated as Identity has a different behaviour. |
| 392 |
</li> |
| 393 |
<li>PR #1467: Fix subtraction of timestamps |
| 394 |
</li> |
| 395 |
<li>PR #1464: Assorted minor changes in window processing code |
| 396 |
</li> |
| 397 |
<li>PR #1463: Fix some window aggregates and reduce amount of collecting implementations |
| 398 |
</li> |
| 399 |
<li>PR #1462: Separate aggregate and window code in some places |
| 400 |
</li> |
| 401 |
<li>PR #1461: Add WINDOW clause support |
| 402 |
</li> |
| 403 |
<li>Issue #1427: Scalability problem in MVSpatialIndex |
| 404 |
</li> |
| 405 |
<li>PR #1459: Improve window clause correctness checks |
| 406 |
</li> |
| 407 |
<li>PR #1457: Add NTILE(), LEAD() and LAG() window functions |
| 408 |
</li> |
| 409 |
<li>PR #1456: Add experimental implementation of remaining types of window frames |
| 410 |
</li> |
| 411 |
<li>PR #1454: Add FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE() |
| 412 |
</li> |
| 413 |
<li>PR #1453, Issue #1161: Add ROW_NUMBER(), RANK(), DENSE_RANK(), PERCENT_RANK(), and CUME_DIST() window functions |
| 414 |
</li> |
| 415 |
<li>PR #1452: Reset aggregates before reuse |
| 416 |
</li> |
| 417 |
<li>PR #1451: Add experimental support for aggregates with OVER (ORDER BY *) |
| 418 |
</li> |
| 419 |
<li>PR #1450: Evaluate window aggregates only once for each partition |
| 420 |
</li> |
| 421 |
<li>PR #1449: Move more code from Aggregate and JavaAggregate to AbstractAggregate |
| 422 |
</li> |
| 423 |
<li>PR #1448: Add experimental implementation of grouped window queries |
| 424 |
</li> |
| 425 |
<li>PR #1447: Refactor OVER() processing code and fix some issues |
| 426 |
</li> |
| 427 |
<li>PR #1446: fix : The French messages are bad generated (not contain DB message) |
| 428 |
</li> |
| 429 |
<li>PR #1445: Use PostGIS-compatible format for SRID-only constraint in GEOMETRY |
| 430 |
</li> |
| 431 |
<li>PR #1444: Add experimental unoptimized support for OVER ([PARTITION BY ...]) in aggregates |
| 432 |
</li> |
| 433 |
<li>PR #1442: Bugfix - Release MVStore lock and file resources rightly even if errors when compacting database |
| 434 |
</li> |
| 435 |
<li>PR #1441: Add GEOMETRY type subtypes with type and SRID constraints |
| 436 |
</li> |
| 437 |
<li>PR #1434: Add support for ENUM in CAST and other changes |
| 438 |
</li> |
| 439 |
<li>PR #1431: Fix some inconsistencies in documentation and improve mvn build |
| 440 |
</li> |
| 441 |
<li>PR #1428: Add support for M and ZM dimensions to GEOMETRY data type |
| 442 |
</li> |
| 443 |
<li>Issue #1405: Introduce LocalResult factory |
| 444 |
</li> |
| 445 |
<li>PR #1422: Add ENVELOPE aggregate function |
| 446 |
</li> |
| 447 |
<li>Issue #1421: Remove old-style outer join |
| 448 |
</li> |
| 449 |
<li>PR #1419: Assorted minor changes |
| 450 |
</li> |
| 451 |
<li>PR #1414: DEFRAG and COMPACT mixup |
| 452 |
</li> |
| 453 |
<li>PR #1413: improvements to MVStore garbage collection |
| 454 |
</li> |
| 455 |
<li>PR #1412: Added org.h2.store.fs package to exported osgi bundles |
| 456 |
</li> |
| 457 |
<li>PR #1409: Map all remaining error codes to custom exception classes |
| 458 |
</li> |
| 459 |
<li>Issue #1407: Add a MODE() aggregate function |
| 460 |
</li> |
| 461 |
<li>PR #1402: Duplicate conditions in column check constraint |
| 462 |
</li> |
| 463 |
<li>PR #1399: Add more subclasses of SQLException and use it for some error codes |
| 464 |
</li> |
| 465 |
<li>PR #1397: Add DATEADD return type detection |
| 466 |
</li> |
| 467 |
<li>Issue #1393: Add INFORMATION_SCHEMA.COLUMNS.IS_VISIBLE |
| 468 |
</li> |
| 469 |
<li>PR #1392: Some refactoring and assorted minor optimizations |
| 470 |
</li> |
| 471 |
<li>PR #1388: Extract UnaryOperation from Operation and other changes |
| 472 |
</li> |
| 473 |
<li>PR #1386: DISK_SPACE_USED() for MVStore and other minor changes |
| 474 |
</li> |
| 475 |
<li>PR #1385: split up the rather large convertTo method |
| 476 |
</li> |
| 477 |
<li>PR #1384: Throw exception if unknown mode is specified in database URL |
| 478 |
</li> |
| 479 |
<li>Issue #1365, PR #1382: Parse more date-time literals for compatibility with other databases |
| 480 |
</li> |
| 481 |
<li>PR #1381: Minor fixes for INTERVAL data type |
| 482 |
</li> |
| 483 |
<li>PR #1380: Improve documentation of intervals |
| 484 |
</li> |
| 485 |
<li>Issue #1189: "Merge into using" parameters aren't found |
| 486 |
</li> |
| 487 |
<li>Issue #1377: org.h2.api.Interval and TIME leftovers |
| 488 |
</li> |
| 489 |
<li>PR #1376: TestMultiThreadedKernel is back |
| 490 |
</li> |
| 491 |
<li>PR #1373: INTERVAL data type |
| 492 |
</li> |
| 493 |
<li>Issue #1369: In MSSQL Server Mode generated UUID fields need NEWID() function |
| 494 |
</li> |
| 495 |
<li>Issue #756: FunctionsMySql is not in the main jar |
| 496 |
</li> |
| 497 |
<li>PR #1368: Parse BINARY VARYING, BINARY LARGE OBJECT, and CHARACTER LARGE OBJECT |
| 498 |
</li> |
| 499 |
<li>PR #1367: Assorted changes with SELECT output limitation clauses |
| 500 |
</li> |
| 501 |
<li>Issue #1363: Why H2 requires random own packages in OSGi bundle description? |
| 502 |
</li> |
| 503 |
<li>Issue #1192: Add an Automatic-Module-Name |
| 504 |
</li> |
| 505 |
<li>Issue #1361, PR #1362: Add limited support for MONEY and SMALLMONEY in compatibility modes |
| 506 |
</li> |
| 507 |
<li>Issue #1327: mvn build misses some resources |
| 508 |
</li> |
| 509 |
<li>PR #1359: Add system property to return OffsetDateTime from ResultSet.getObject() |
| 510 |
</li> |
| 511 |
<li>PR #1357: Simplify execution flow in some places |
| 512 |
</li> |
| 513 |
<li>PR #1356: Fix NPE in Query.initExpression() |
| 514 |
</li> |
| 515 |
<li>PR #1355: Assorted changes in MetaTable |
| 516 |
</li> |
| 517 |
<li>Issue #1352: TestCrashAPI: Prepared.getObjectId() was called before |
| 518 |
</li> |
| 519 |
<li>PR #1349: Changes is conversion and comparison methods of Value |
| 520 |
</li> |
| 521 |
<li>Issue #1346: Exception when using IN condition for enums |
| 522 |
</li> |
| 523 |
<li>PR #1345: Replace some init methods with constructors |
| 524 |
</li> |
| 525 |
<li>PR #1344: Streamline last chunk verification on startup |
| 526 |
</li> |
| 527 |
<li>PR #1341: Optimize MVSecondaryIndex.convertToKey() |
| 528 |
</li> |
| 529 |
<li>PR #1340: NoSuchElementException instead of returning null |
| 530 |
</li> |
| 531 |
<li>PR #1339: Add support of TIMESTAMP WITH TIME ZONE to addition and subtraction operators |
| 532 |
</li> |
| 533 |
<li>PR #1337: Streamline Value comparison |
| 534 |
</li> |
| 535 |
<li>PR #1336: Minor refactorings |
| 536 |
</li> |
| 537 |
<li>Issue #1332: Constraint name not set correctly |
| 538 |
</li> |
| 539 |
<li>Rename fields to reflect actual type |
| 540 |
</li> |
| 541 |
<li>Issue #1331: Regression in Database.updateMeta() |
| 542 |
</li> |
| 543 |
<li>Issue #1323: Slow update after altering table in 1.4.197 |
| 544 |
</li> |
| 545 |
<li>PR #1326: Add support of PERCENT in FETCH and TOP clauses |
| 546 |
</li> |
| 547 |
<li>PR #1325: Optimize WITH TIES in some queries and specify data types for KEY_COLUMN_USAGE |
| 548 |
</li> |
| 549 |
<li>PR #1321: Do not add rows before OFFSET to result if possible |
| 550 |
</li> |
| 551 |
<li>PR #1319: Treat NEXTVAL as an auto-generated key |
| 552 |
</li> |
| 553 |
<li>PR #1318: Mode append fo MVPlainTempResult |
| 554 |
</li> |
| 555 |
<li>PR #1314: Add ALTER VIEW RENAME command |
| 556 |
</li> |
| 557 |
<li>PR #1313, issue #1315: Bugfix - using default locale encoding issue in conversion between varchar and varbinary value, and checking javac output text issue in SourceCompiler |
| 558 |
</li> |
| 559 |
<li>PR #1312: Add Java 9+ support to NIO_CLEANER_HACK |
| 560 |
</li> |
| 561 |
<li>PR #1311: Fix minor issues with ResultSet.getObject(..., Class) and WITH TIES |
| 562 |
</li> |
| 563 |
<li>Issue #1298: TestKillRestartMulti: A map named undoLog.2 already exists |
| 564 |
</li> |
| 565 |
<li>Issue #1307: Invalid value "null" for parameter "calendar" [90008-193] |
| 566 |
</li> |
| 567 |
<li>PR #1306: Add initial implementation of WITH TIES clause |
| 568 |
</li> |
| 569 |
<li>PR #1304: Update changelog and fix building of documentation |
| 570 |
</li> |
| 571 |
<li>PR #1302: Use OpenJDK instead of OracleJDK 10 in Travis builds due to Travis problem |
| 572 |
</li> |
| 573 |
<li>Issue #1032: Error when executing "SELECT DISTINCT ON" |
| 574 |
</li> |
| 575 |
<li>Issue #1295: ConditionInSelect violates requirements of LocalResult |
| 576 |
</li> |
| 577 |
<li>PR #1296: Assorted minor changes |
| 578 |
</li> |
| 579 |
<li>PR #1293: Move HELP and SHOW tests into own files |
| 580 |
</li> |
| 581 |
<li>PR #1291: Fix update count for REPLACE and move some SQL tests into separate files |
| 582 |
</li> |
| 583 |
<li>PR #1290: Do not load the whole LOBs into memory for comparison operation |
| 584 |
</li> |
| 585 |
<li>Issue #408: DISTINCT does not properly work with ORDER BY on function like LOWER |
| 586 |
</li> |
| 587 |
<li>PR #1286: Fix MVTempResult implementations for results with invisible columns |
| 588 |
</li> |
| 589 |
<li>Issue #1284: Nanoseconds of timestamps from old H2 versions are not read properly |
| 590 |
</li> |
| 591 |
<li>PR #1283: Clean up interaction between LocalResult and ResultExternal |
| 592 |
</li> |
| 593 |
<li>Issue #1265: OOME is not handled properly in TraceObject.logAndConvert() |
| 594 |
</li> |
| 595 |
<li>Issue #1061: Regression: Braces after WITH clause not allowed anymore |
| 596 |
</li> |
| 597 |
<li>PR #1277: Assorted changes in Parser |
| 598 |
</li> |
| 599 |
<li>PR #1276: Improve support of ARRAY and SQLXML in JDBC layer |
| 600 |
</li> |
| 601 |
<li>PR #1275: Do not quote other lower case characters |
| 602 |
</li> |
| 603 |
<li>PR #1274: Use token type in Parser instead of string comparisons |
| 604 |
</li> |
| 605 |
<li>PR #1272: Reduce code duplication in Parser |
| 606 |
</li> |
| 607 |
<li>PR #1271: Minor memory leak |
| 608 |
</li> |
| 609 |
<li>PR #1270: drop TableView isPersistent field |
| 610 |
</li> |
| 611 |
<li>PR #1269: Eliminate commit of empty batch in some tests |
| 612 |
</li> |
| 613 |
<li>Issue #1266: Add INFORMATION_SCHEMA.COLUMNS.DATETIME_PRECISION |
| 614 |
</li> |
| 615 |
<li>Issue #1261: How to discover stored enum types through INFORMATION_SCHEMA |
| 616 |
</li> |
| 617 |
<li>Issue #1258: Failing to remove index when using schema.table |
| 618 |
</li> |
| 619 |
<li>PR #1256: misc tiny refactorings |
| 620 |
</li> |
| 621 |
<li>PR #1255: Minor changes in MERGE USING, DATE_TRUNC, and EXTRACT |
| 622 |
</li> |
| 623 |
<li>Issue #1214: Internal compiler believes that "3 warnings" is an error |
| 624 |
</li> |
| 625 |
<li>PR #1252: Assorted minor changes |
| 626 |
</li> |
| 627 |
<li>PR #1251: Fix SQL representation of CAST for types with fractional seconds precision |
| 628 |
</li> |
| 629 |
<li>PR #1250: Batch append mode for MVMap |
| 630 |
</li> |
| 631 |
<li>PR #1248: StringIndexOutOfBoundsException due to undoLog map |
| 632 |
</li> |
| 633 |
<li>PR #1246: Detect disabled tests |
| 634 |
</li> |
| 635 |
<li>PR #1242: Add implementation of SQLXML interface |
| 636 |
</li> |
| 637 |
<li>PR #1241: Various tweaks in attempting to fix TestDiskFull test |
| 638 |
</li> |
| 639 |
<li>PR #1240: Optimise ValueLobDB comparison methods |
| 640 |
</li> |
| 641 |
<li>PR #1239: Don't try to find tools.jar on Java 9+ |
| 642 |
</li> |
| 643 |
<li>PR #1238: remove unfinished android API |
| 644 |
</li> |
| 645 |
<li>PR #1237: remove JaQu |
| 646 |
</li> |
| 647 |
<li>PR #1236: remove STORE_LOCAL_TIME code |
| 648 |
</li> |
| 649 |
<li>PR #1235: Do not use deprecated Class.newInstance() |
| 650 |
</li> |
| 651 |
<li>PR #1234: Fix NPE in Parser.parseMergeUsing() |
| 652 |
</li> |
| 653 |
<li>PR #1233: Simplify old lob ValueLob class |
| 654 |
</li> |
| 655 |
<li>Issue 1227: lob growth in pagestore mode |
| 656 |
</li> |
| 657 |
<li>PR #1230: clean up some javadoc and some throws clauses |
| 658 |
</li> |
| 659 |
<li>PR #1229: Create UndoLog only when necessary and remove outdated code |
| 660 |
</li> |
| 661 |
<li>PR #1228: Remove some PageStore+MVCC leftovers |
| 662 |
</li> |
| 663 |
<li>PR #1226: Fix inconsistencies in checks for transaction isolation level |
| 664 |
</li> |
| 665 |
<li>PR #1224: Enable Java 10 testing on Travis |
| 666 |
</li> |
| 667 |
<li>PR #1223: Fix issues with testing on latest Java versions |
| 668 |
</li> |
| 669 |
<li>PR #1222: Leftovers handling |
| 670 |
</li> |
| 671 |
<li>Issue #1220: JDK-9 build fails due to usage of java.xml.bind in external authentication |
| 672 |
</li> |
| 673 |
<li>PR #1218: Test utilities only once during TestAll |
| 674 |
</li> |
| 675 |
<li>PR #1217: Postpone session.endStatement() until after commit |
| 676 |
</li> |
| 677 |
<li>PR #1213: KillRestart fix |
| 678 |
</li> |
| 679 |
<li>PR #1211: Assorted minor changes |
| 680 |
</li> |
| 681 |
<li>Issue #1204: Always use MVCC with MVStore and never use it with PageStore |
| 682 |
</li> |
| 683 |
<li>PR #1206: Forbid reconnects in non-regular modes in TestScript |
| 684 |
</li> |
| 685 |
<li>PR #1205: Misc test fixes |
| 686 |
</li> |
| 687 |
<li>Issue 1198: Enable MULTI_THREADED by default for MVStore mode |
| 688 |
</li> |
| 689 |
<li>Issue #1195: Calling setBytes to set VARCHAR field fails |
| 690 |
</li> |
| 691 |
<li>PR #1197: Fix or suppress errors in tests |
| 692 |
</li> |
| 693 |
<li>PR #1194: TestKillRestartMulti: A map named undoLog-1 already exists |
| 694 |
</li> |
| 695 |
<li>PR #1193: enable TestRandomSQL on non-memory databases |
| 696 |
</li> |
| 697 |
<li>PR #1191: External authentication with datasource issue |
| 698 |
</li> |
| 699 |
<li>PR #1188: Undo log split to reduce contention |
| 700 |
</li> |
| 701 |
<li>PR #1186: TransactionMap::sizeAsLong() optimized - temp map eliminated |
| 702 |
</li> |
| 703 |
<li>PR #1185: Improve naming of the object id field in Prepared |
| 704 |
</li> |
| 705 |
<li>Issue #1196: Feature request for MS SQL Server Compatibility Mode |
| 706 |
</li> |
| 707 |
<li>Issue #1177: Resource leak in Recover tool |
| 708 |
</li> |
| 709 |
<li>PR #1183: Improve concurrency of connection pool with wait-free implement |
| 710 |
</li> |
| 711 |
<li>Issue #1073: H2 v1.4.197 fails to open an existing database with the error [Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"] |
| 712 |
</li> |
| 713 |
<li>PR #1179: Drop TransactionMap.readLogId |
| 714 |
</li> |
| 715 |
<li>PR #1181: Improve CURRENT_TIMESTAMP and add LOCALTIME and LOCALTIMESTAMP |
| 716 |
</li> |
| 717 |
<li>PR #1176: Magic value replacement with constant |
| 718 |
</li> |
| 719 |
<li>PR #1171: Introduce last committed value into a VersionedValue |
| 720 |
</li> |
| 721 |
<li>PR #1175: tighten test conditions - do not ignore any exceptions |
| 722 |
</li> |
| 723 |
<li>PR #1174: Remove mapid |
| 724 |
</li> |
| 725 |
<li>PR #1173: protect first background exception encountered and relate it to clients |
| 726 |
</li> |
| 727 |
<li>PR #1172: Yet another attempt to tighten that testing loop |
| 728 |
</li> |
| 729 |
<li>PR #1170: Add support of CONTINUE | RESTART IDENTITY to TRUNCATE TABLE |
| 730 |
</li> |
| 731 |
<li>Issue #1168: ARRAY_CONTAINS() returning incorrect results when inside subquery with Long elements. |
| 732 |
</li> |
| 733 |
<li>PR #1167: MVStore: Undo log synchronization removal |
| 734 |
</li> |
| 735 |
<li>PR #1166: Add SRID support to EWKT format |
| 736 |
</li> |
| 737 |
<li>PR #1165: Optimize isTargetRowFound() and buildColumnListFromOnCondition() in MergeUsing |
| 738 |
</li> |
| 739 |
<li>PR #1164: More fixes for parsing of MERGE USING and other changes in Parser |
| 740 |
</li> |
| 741 |
<li>PR #1154: Support for external authentication |
| 742 |
</li> |
| 743 |
<li>PR #1162: Reduce allocation of temporary strings |
| 744 |
</li> |
| 745 |
<li>PR #1158: make fields final |
| 746 |
</li> |
| 747 |
<li>Issue #1129: TestCrashAPI / TestFuzzOptimizations throw OOME on Travis in PageStore mode |
| 748 |
</li> |
| 749 |
<li>PR #1156: Add support for SQL:2003 WITH [NO] DATA to CREATE TABLE AS |
| 750 |
</li> |
| 751 |
<li>PR #1149: fix deadlock between OnExitDatabaseCloser.DATABASES and Engine.DATABASES |
| 752 |
</li> |
| 753 |
<li>PR #1152: skip intermediate DbException object when creating SQLException |
| 754 |
</li> |
| 755 |
<li>PR #1144: Add missing schema name with recursive view |
| 756 |
</li> |
| 757 |
<li>Issue #1091: get rid of the "New" class |
| 758 |
</li> |
| 759 |
<li>PR #1147: Assorted minor optimizations |
| 760 |
</li> |
| 761 |
<li>PR #1145: Reduce code duplication |
| 762 |
</li> |
| 763 |
<li>PR #1142: Misc small fixes |
| 764 |
</li> |
| 765 |
<li>PR #1141: Assorted optimizations and fixes |
| 766 |
</li> |
| 767 |
<li>PR #1138, #1139: Fix a memory leak caused by DatabaseCloser objects |
| 768 |
</li> |
| 769 |
<li>PR #1137: Step toward making transaction commit atomic |
| 770 |
</li> |
| 771 |
<li>PR #1136: Assorted minor optimizations |
| 772 |
</li> |
| 773 |
<li>PR #1134: Detect possible overflow in integer division and optimize some code |
| 774 |
</li> |
| 775 |
<li>PR #1133: Implement Comparable<Value> in CompareMode and optimize ValueHashMap.keys() |
| 776 |
</li> |
| 777 |
<li>PR #1132: Reduce allocation of ExpressionVisitor instances |
| 778 |
</li> |
| 779 |
<li>PR #1130: Improve TestScript and TestCrashAPI |
| 780 |
</li> |
| 781 |
<li>PR #1128: Fix ON DUPLICATE KEY UPDATE with ENUM |
| 782 |
</li> |
| 783 |
<li>PR #1127: Update JdbcDatabaseMetaData.getSQLKeywords() and perform some minor optimizations |
| 784 |
</li> |
| 785 |
<li>PR #1126: Fix an issue with code coverage and building of documentation |
| 786 |
</li> |
| 787 |
<li>PR #1123: Fix TCP version check |
| 788 |
</li> |
| 789 |
<li>PR #1122: Assorted changes |
| 790 |
</li> |
| 791 |
<li>PR #1121: Add some protection to ValueHashMap against hashes with the same less significant bits |
| 792 |
</li> |
| 793 |
<li>Issue #1097: H2 10x slower than HSQLDB and 6x than Apache Derby for specific query with GROUP BY and DISTINCT subquery |
| 794 |
</li> |
| 795 |
<li>Issue #1093: Use temporary files for ResultSet buffer tables in MVStore |
| 796 |
</li> |
| 797 |
<li>PR #1117: Fix sorting with distinct in ResultTempTable |
| 798 |
</li> |
| 799 |
<li>Issue #1095: Add support for INSERT IGNORE INTO <table> (<columns>) SELECT in MySQL Mode |
| 800 |
</li> |
| 801 |
<li>PR #1114: Minor cleanup and formatting fixes |
| 802 |
</li> |
| 803 |
<li>PR #1112: Improve test scripts |
| 804 |
</li> |
| 805 |
<li>PR #1111: Use a better fix for issue with SRID |
| 806 |
</li> |
| 807 |
<li>Issue #1107: Restore support of DATETIME2 with specified fractional seconds precision |
| 808 |
</li> |
| 809 |
<li>Issue #1106: Get rid of SwitchSource |
| 810 |
</li> |
| 811 |
<li>PR #1105: Assorted minor changes |
| 812 |
</li> |
| 813 |
<li>Issue #1102: CREATE SYNONYM rejects valid definition |
| 814 |
</li> |
| 815 |
<li>PR #1103: Remove redundant synchronization |
| 816 |
</li> |
| 817 |
<li>Issue #1048: 1.4.197 regression. org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS" |
| 818 |
</li> |
| 819 |
<li>PR #1101: Move some tests in better place and add an additional test for 2PC |
| 820 |
</li> |
| 821 |
<li>PR #1100: Fix Insert.prepareUpdateCondition() for PageStore |
| 822 |
</li> |
| 823 |
<li>PR #1098: Fix some issues with NULLS FIRST / LAST |
| 824 |
</li> |
| 825 |
<li>Issue #1089: Parser does not quote words INTERSECTS, DUAL, TOP |
| 826 |
</li> |
| 827 |
<li>Issue #230: Renaming a column does not update foreign key constraint |
| 828 |
</li> |
| 829 |
<li>Issue #1091 Get rid if the New class |
| 830 |
</li> |
| 831 |
<li>PR #1087: improve performance of planning large queries |
| 832 |
</li> |
| 833 |
<li>PR #1085: Add tests for simple one-column index sorting |
| 834 |
</li> |
| 835 |
<li>PR #1084: re-enable some pagestore testing |
| 836 |
</li> |
| 837 |
<li>PR #1083: Assorted changes |
| 838 |
</li> |
| 839 |
<li>Issue #394: Recover tool places COLLATION and BINARY_COLLATION after temporary tables |
| 840 |
</li> |
| 841 |
<li>PR #1081: Session.getTransactionId should return a more distinguishing value |
| 842 |
</li> |
| 843 |
<li>Improve the script-based unit testing to check the error code of the exception thrown. |
| 844 |
</li> |
| 845 |
<li>Issue #1041: Support OR syntax while creating trigger |
| 846 |
</li> |
| 847 |
<li>Issue #1023: MVCC and existing page store file |
| 848 |
</li> |
| 849 |
<li>Issue #1003: Decrypting database with incorrect password renders the database corrupt |
| 850 |
</li> |
| 851 |
<li>Issue #873: No error when `=` in equal condition when column is not of array type |
| 852 |
</li> |
| 853 |
<li>Issue #1069: Failed to add DATETIME(3) column since 1.4.197 |
| 854 |
</li> |
| 855 |
<li>Issue #456: H2 table privileges referring to old schema after schema rename |
| 856 |
</li> |
| 857 |
<li>Issue #1062: Concurrent update in table "SYS" caused by Analyze.analyzeTable() |
| 858 |
</li> |
| 859 |
<li>Yet another fix to Page memory accounting |
| 860 |
</li> |
| 861 |
<li>Replace MVStore.ASSERT variable with assertions |
| 862 |
</li> |
| 863 |
<li>Issue #1063: Leftover comments about enhanced for loops |
| 864 |
</li> |
| 865 |
<li>PR #1059: Assorted minor changes |
| 866 |
</li> |
| 867 |
<li>PR #1058: Txcommit atomic |
| 868 |
</li> |
| 869 |
<li>Issue #1038: ora_hash function implementation off by one |
| 870 |
</li> |
| 871 |
<li>PR #1054: Introduce overflow bit in tx state |
| 872 |
</li> |
| 873 |
<li>Issue #1047: Support DISTINCT in custom aggregate functions |
| 874 |
</li> |
| 875 |
<li>PR #1051: Atomic change of transaction state |
| 876 |
</li> |
| 877 |
<li>PR #1046: Split off Transaction TransactionMap VersionedValue |
| 878 |
</li> |
| 879 |
<li>PR #1045: TransactionStore move into separate org.h2.mvstore.tx package |
| 880 |
</li> |
| 881 |
<li>PR #1044: Encapsulate TransactionStore.store field in preparation to a move |
| 882 |
</li> |
| 883 |
<li>PR #1040: generate less garbage for String substring+trim |
| 884 |
</li> |
| 885 |
<li>PR #1035: Minor free space accounting changes |
| 886 |
</li> |
| 887 |
<li>Issue #1034: MERGE USING should not require the same column count in tables |
| 888 |
</li> |
| 889 |
<li>PR #1033: Fix issues with BUILTIN_ALIAS_OVERRIDE=1 |
| 890 |
</li> |
| 891 |
<li>PR #1031: Drop schema rights together with schema |
| 892 |
</li> |
| 893 |
<li>PR #1029: No need to remove orphaned LOBs when the db is read-only |
| 894 |
</li> |
| 895 |
<li>Issue #1027: Add support for fully qualified names in MySQL compatibility mode |
| 896 |
</li> |
| 897 |
<li>Issue #178: INSERT ON DUPLICATE KEY UPDATE returns wrong generated key |
| 898 |
</li> |
| 899 |
<li>PR #1025: Remove BitField and replace its usages with BitSet |
| 900 |
</li> |
| 901 |
<li>Issue #1019: Console incorrectly sorts BigDecimal columns alphanumerically |
| 902 |
</li> |
| 903 |
<li>PR #1021: Update JdbcDatabaseMetaData to JDBC 4.1 (Java 7) |
| 904 |
</li> |
| 905 |
<li>Issue #992: 1.4.197 client cannot use DatabaseMetaData with 1.4.196 and older server |
| 906 |
</li> |
| 907 |
<li>Issue #1016: ResultSet.getObject() should return enum value, not ordinal |
| 908 |
</li> |
| 909 |
<li>Issue #1012: NPE when querying INFORMATION_SCHEMA.COLUMNS on a view that references an ENUM column |
| 910 |
</li> |
| 911 |
<li>Issue #1010: MERGE USING table not found with qualified table |
| 912 |
</li> |
| 913 |
<li>PR #1009: Fix ARRAY_AGG with ORDER BY and refactor aggregates |
| 914 |
</li> |
| 915 |
<li>Issue #1006: "Empty enums are not allowed" in 1.4.197 (mode=MYSQL) |
| 916 |
</li> |
| 917 |
<li>PR #1007: Copy also SRID in ValueGeometry.getGeometry() |
| 918 |
</li> |
| 919 |
<li>PR #1004: Preserve type names in more places especially for UUID |
| 920 |
</li> |
| 921 |
<li>Issue #1000: Regression in INFORMATION_SCHEMA.CONSTRAINTS.CONSTRAINT_TYPE content |
| 922 |
</li> |
| 923 |
<li>Issue #997: Can not delete from tables with enums |
| 924 |
</li> |
| 925 |
<li>Issue #994: Too much column in result set for GENERATED_KEYS on table with DEFAULT |
| 926 |
</li> |
| 927 |
<li>PR #993: Fix some compiler warnings and improve assert*() methods |
| 928 |
</li> |
| 929 |
<li>PR #991: Generate shorter queries in JdbcDatabaseMetaData.getTables() and remove some dead code |
| 930 |
</li> |
| 931 |
<li>PR #989: Fix more issues with range table and improve its documentation |
| 932 |
</li> |
| 933 |
</ul> |
| 934 |
|
| 935 |
<h2>Version 1.4.197 (2018-03-18)</h2> |
| 936 |
<ul> |
| 937 |
<li>PR #988: Fix RangeTable.getRowCount() for non-default step |
| 938 |
</li> |
| 939 |
<li>PR #987: ValueBoolean constants are not cleared and may be used directly |
| 940 |
</li> |
| 941 |
<li>PR #986: Check parameters in JdbcPreparedStatement.addBatch() |
| 942 |
</li> |
| 943 |
<li>PR #984: Minor refactorings in Parser |
| 944 |
</li> |
| 945 |
<li>PR #983: Code cleanups via IntelliJ IDEA inspections |
| 946 |
</li> |
| 947 |
<li>Issue #960: Implement remaining time unit in "date_trunc" function |
| 948 |
</li> |
| 949 |
<li>Issue #933: MVStore background writer endless loop |
| 950 |
</li> |
| 951 |
<li>PR #981: Reorganize date-time functions |
| 952 |
</li> |
| 953 |
<li>PR #980: Add Parser.toString() method for improved debugging experience |
| 954 |
</li> |
| 955 |
<li>PR #979: Remove support of TCP protocol versions 6 and 7 |
| 956 |
</li> |
| 957 |
<li>PR #977: Add database versions to javadoc of TCP protocol versions and update dictionary.txt |
| 958 |
</li> |
| 959 |
<li>PR #976: Add and use incrementDateValue() and decrementDateValue() |
| 960 |
</li> |
| 961 |
<li>Issue #974: Inline PRIMARY KEY definition loses its name |
| 962 |
</li> |
| 963 |
<li>PR #972: Add META-INF/versions to all non-Android jars that use Bits |
| 964 |
</li> |
| 965 |
<li>PR #971: Update ASM from 6.1-beta to 6.1 |
| 966 |
</li> |
| 967 |
<li>PR #970: Added support for ENUM in prepared statement where clause |
| 968 |
</li> |
| 969 |
<li>PR #968: Assorted changes |
| 970 |
</li> |
| 971 |
<li>PR #967: Adds ARRAY_AGG function |
| 972 |
</li> |
| 973 |
<li>PR #966: Do not include help and images in client jar |
| 974 |
</li> |
| 975 |
<li>PR #965: Do not include mvstore.DataUtils in client jar and other changes |
| 976 |
</li> |
| 977 |
<li>PR #964: Fix TestFunctions.testToCharFromDateTime() |
| 978 |
</li> |
| 979 |
<li>PR #963 / Issue #962: Improve documentation of compatibility modes and fix ssl URL description |
| 980 |
</li> |
| 981 |
<li>Issue #219: H2 mode MySQL- ON UPDATE CURRENT_TIMESTAMP not supported |
| 982 |
</li> |
| 983 |
<li>PR #958: More fixes for PgServer |
| 984 |
</li> |
| 985 |
<li>PR #957: Update database size information and links in README.md |
| 986 |
</li> |
| 987 |
<li>PR #956: Move tests added in 821117f1db120a265647a063dca13ab5bee98efc to a proper place |
| 988 |
</li> |
| 989 |
<li>PR #955: Support getObject(?, Class) in generated keys |
| 990 |
</li> |
| 991 |
<li>PR #954: Avoid incorrect reads in iterators of TransactionMap |
| 992 |
</li> |
| 993 |
<li>PR #952: Optimize arguments for MVMap.init() |
| 994 |
</li> |
| 995 |
<li>PR #949: Fix table borders in PDF and other changes |
| 996 |
</li> |
| 997 |
<li>PR #948: Fix some grammar descriptions and ALTER TABLE DROP COLUMN parsing |
| 998 |
</li> |
| 999 |
<li>PR #947: Fix building of documentation and use modern names of Java versions |
| 1000 |
</li> |
| 1001 |
<li>PR #943: Assorted changes in documentation and a fix for current-time.sql |
| 1002 |
</li> |
| 1003 |
<li>PR #942: Fix page numbers in TOC in PDF and move System Tables into own HTML / section in PDF |
| 1004 |
</li> |
| 1005 |
<li>PR #941: Use >> syntax in median.sql and move out more tests from testScript.sql |
| 1006 |
</li> |
| 1007 |
<li>PR #940: add Support for MySQL: DROP INDEX index_name ON tbl_name |
| 1008 |
</li> |
| 1009 |
<li>PR #939: Short syntax for SQL tests |
| 1010 |
</li> |
| 1011 |
<li>Issue #935: The "date_trunc" function is not recognized for 'day' |
| 1012 |
</li> |
| 1013 |
<li>PR #936: Fix font size, line length, TOC, and many broken links in PDF |
| 1014 |
</li> |
| 1015 |
<li>PR #931: Assorted changes in documentation |
| 1016 |
</li> |
| 1017 |
<li>PR #930: Use Math.log10() and remove Mode.getOracle() |
| 1018 |
</li> |
| 1019 |
<li>PR #929: Remove Mode.supportOffsetFetch |
| 1020 |
</li> |
| 1021 |
<li>PR #928: Show information about office configuration instead of fallback PDF generation mode |
| 1022 |
</li> |
| 1023 |
<li>PR #926: Describe datetime fields in documentation |
| 1024 |
</li> |
| 1025 |
<li>PR #925: Fix time overflow in DATEADD |
| 1026 |
</li> |
| 1027 |
<li>Issue #416: Add support for DROP SCHEMA x { RESTRICT | CASCADE } |
| 1028 |
</li> |
| 1029 |
<li>PR #922: Parse and treat fractional seconds precision as described in SQL standard |
| 1030 |
</li> |
| 1031 |
<li>Issue #919: Add support for mixing adding constraints and columns in multi-add ALTER TABLE statement |
| 1032 |
</li> |
| 1033 |
<li>PR #916: Implement TABLE_CONSTRAINTS and REFERENTIAL_CONSTRAINTS from the SQL standard |
| 1034 |
</li> |
| 1035 |
<li>PR #915: Implement INFORMATION_SCHEMA.KEY_COLUMN_USAGE from SQL standard |
| 1036 |
</li> |
| 1037 |
<li>PR #914: don't allow null values in ConcurrentArrayList |
| 1038 |
</li> |
| 1039 |
<li>PR #913: Assorted changes in tests and documentation |
| 1040 |
</li> |
| 1041 |
<li>Issue #755: Missing FLOAT(precision)? |
| 1042 |
</li> |
| 1043 |
<li>PR #911: Add support for MySQL-style ALTER TABLE ADD ... FIRST |
| 1044 |
</li> |
| 1045 |
<li>Issue #409: Support derived column list syntax on table alias |
| 1046 |
</li> |
| 1047 |
<li>PR #908: remove dead code |
| 1048 |
</li> |
| 1049 |
<li>PR #907: Nest joins only if required and fix some issues with complex joins |
| 1050 |
</li> |
| 1051 |
<li>PR #906: Fix obscure error on non-standard SELECT * FROM A LEFT JOIN B NATURAL JOIN C |
| 1052 |
</li> |
| 1053 |
<li>PR #805: Move some JOIN tests from testScript.sql to own file |
| 1054 |
</li> |
| 1055 |
<li>PR #804: Remove unused parameters from readJoin() and readTableFilter() |
| 1056 |
</li> |
| 1057 |
<li>Issue #322: CSVREAD WHERE clause containing ORs duplicates number of rows |
| 1058 |
</li> |
| 1059 |
<li>PR #902: Remove DbSettings.nestedJoins |
| 1060 |
</li> |
| 1061 |
<li>PR #900: Convert duplicate anonymous classes in TableFilter to nested for reuse |
| 1062 |
</li> |
| 1063 |
<li>PR #899: Fix ON DUPLICATE KEY UPDATE for inserts with multiple rows |
| 1064 |
</li> |
| 1065 |
<li>PR #898: Parse TIME WITHOUT TIME ZONE and fix TIMESTAMP as column name |
| 1066 |
</li> |
| 1067 |
<li>PR #897: Update JTS to version 1.15.0 from LocationTech |
| 1068 |
</li> |
| 1069 |
<li>PR #896: Assorted changes in help.csv |
| 1070 |
</li> |
| 1071 |
<li>PR #895: Parse more variants of timestamps with time zones |
| 1072 |
</li> |
| 1073 |
<li>PR #893: TIMESTAMP WITHOUT TIME ZONE, TIMEZONE_HOUR, and TIMEZONE_MINUTE |
| 1074 |
</li> |
| 1075 |
<li>PR #892: Assorted minor changes in Parser |
| 1076 |
</li> |
| 1077 |
<li>PR #891: Update documentation of date-time types and clean up related code a bit |
| 1078 |
</li> |
| 1079 |
<li>PR #890: Implement conversions for TIMESTAMP WITH TIME ZONE |
| 1080 |
</li> |
| 1081 |
<li>PR #888: Fix two-phase commit in MVStore |
| 1082 |
</li> |
| 1083 |
<li>Issue #884: Wrong test Resources path in pom.xml |
| 1084 |
</li> |
| 1085 |
<li>PR #886: Fix building of documentation |
| 1086 |
</li> |
| 1087 |
<li>PR #883: Add support for TIMESTAMP WITH TIME ZONE to FORMATDATETIME |
| 1088 |
</li> |
| 1089 |
<li>PR #881: Reimplement dateValueFromDate() and nanosFromDate() without a Calendar |
| 1090 |
</li> |
| 1091 |
<li>PR #880: Assorted date-time related changes |
| 1092 |
</li> |
| 1093 |
<li>PR #879: Reimplement TO_DATE without a Calendar and fix a lot of bugs an incompatibilities |
| 1094 |
</li> |
| 1095 |
<li>PR #878: Fix IYYY in TO_CHAR and reimplement TRUNCATE without a Calendar |
| 1096 |
</li> |
| 1097 |
<li>PR #877: Reimplement TO_CHAR without a Calendar and fix 12 AM / 12 PM in it |
| 1098 |
</li> |
| 1099 |
<li>PR #876: Test out of memory |
| 1100 |
</li> |
| 1101 |
<li>PR #875: Improve date-time related parts of documentation |
| 1102 |
</li> |
| 1103 |
<li>PR #872: Assorted date-time related changes |
| 1104 |
</li> |
| 1105 |
<li>PR #871: Fix OOME in Transfer.readValue() with large CLOB V2 |
| 1106 |
</li> |
| 1107 |
<li>PR #867: TestOutOfMemory stability |
| 1108 |
</li> |
| 1109 |
<li>Issue #834: Add support for the SQL standard FILTER clause on aggregate functions |
| 1110 |
</li> |
| 1111 |
<li>PR #864: Minor changes in DateUtils and Function |
| 1112 |
</li> |
| 1113 |
<li>PR #863: Polish: use isEmpty() to check whether the collection is empty or not. |
| 1114 |
</li> |
| 1115 |
<li>PR #862: Convert constraint type into enum |
| 1116 |
</li> |
| 1117 |
<li>PR #861: Avoid resource leak |
| 1118 |
</li> |
| 1119 |
<li>PR #860: IndexCursor inList |
| 1120 |
</li> |
| 1121 |
<li>PR #858 / Issue #690 and others: Return all generated rows and columns from getGeneratedKeys() |
| 1122 |
</li> |
| 1123 |
<li>Make the JDBC client independent of the database engine |
| 1124 |
</li> |
| 1125 |
<li>PR #857: Do not write each SQL error multiple times in TestScript |
| 1126 |
</li> |
| 1127 |
<li>PR #856: Fix TestDateTimeUtils.testDayOfWeek() and example with ANY(? |
| 1128 |
</li> |
| 1129 |
<li>PR #855: Reimplement DATEADD without a Calendar and fix some incompatibilities |
| 1130 |
</li> |
| 1131 |
<li>PR #854: Improve test stability |
| 1132 |
</li> |
| 1133 |
<li>PR #851: Reimplement DATEDIFF without a Calendar |
| 1134 |
</li> |
| 1135 |
<li>Issue #502: SQL "= ANY (?)" supported? |
| 1136 |
</li> |
| 1137 |
<li>PR #849: Encode date and time in fast and proper way in PgServerThread |
| 1138 |
</li> |
| 1139 |
<li>PR #847: Reimplement remaining parts of EXTRACT, ISO_YEAR, etc without a Calendar |
| 1140 |
</li> |
| 1141 |
<li>PR #846: Read known fields directly in DateTimeUtils.getDatePart() |
| 1142 |
</li> |
| 1143 |
<li>Issue #832: Extract EPOCH from a timestamp |
| 1144 |
</li> |
| 1145 |
<li>PR #844: Add simple implementations of isWrapperFor() and unwrap() to JdbcDataSource |
| 1146 |
</li> |
| 1147 |
<li>PR #843: Add MEDIAN to help.csv and fix building of documentation |
| 1148 |
</li> |
| 1149 |
<li>PR #841: Support indexes with nulls last for MEDIAN aggregate |
| 1150 |
</li> |
| 1151 |
<li>PR #840: Add MEDIAN aggregate |
| 1152 |
</li> |
| 1153 |
<li>PR #839: TestTools should not leave testing thread in interrupted state |
| 1154 |
</li> |
| 1155 |
<li>PR #838: (tests) Excessive calls to Runtime.getRuntime().gc() cause OOM for no reason |
| 1156 |
</li> |
| 1157 |
<li>Don't use substring when doing StringBuffer#append |
| 1158 |
</li> |
| 1159 |
<li>PR #837: Use StringUtils.replaceAll() in Function.replace() |
| 1160 |
</li> |
| 1161 |
<li>PR #836: Allow to read invalid February 29 dates with LocalDate as March 1 |
| 1162 |
</li> |
| 1163 |
<li>PR #835: Inline getTimeTry() into DateTimeUtils.getMillis() |
| 1164 |
</li> |
| 1165 |
<li>PR #827: Use dateValueFromDate() and nanosFromDate() in parseTimestamp() |
| 1166 |
</li> |
| 1167 |
<li>Issue #115: to_char fails with pattern FM0D099 |
| 1168 |
</li> |
| 1169 |
<li>PR #825: Merge code for parsing and formatting timestamp values |
| 1170 |
</li> |
| 1171 |
<li>Enums for ConstraintActionType, UnionType, and OpType |
| 1172 |
</li> |
| 1173 |
<li>PR 824: Add partial support for INSERT IGNORE in MySQL mode |
| 1174 |
</li> |
| 1175 |
<li>PR #823: Use ValueByte.getInt() and ValueShort.getInt() in convertTo() |
| 1176 |
</li> |
| 1177 |
<li>PR #820: Fix some compiler warnings |
| 1178 |
</li> |
| 1179 |
<li>PR #818: Fixes for remaining issues with boolean parameters |
| 1180 |
</li> |
| 1181 |
<li>Use enum for file lock method |
| 1182 |
</li> |
| 1183 |
<li>PR #817: Parse also 1 as true and 0 as false in Utils.parseBoolean() |
| 1184 |
</li> |
| 1185 |
<li>PR #815: Fix count of completed statements |
| 1186 |
</li> |
| 1187 |
<li>PR #814: Method.isVarArgs() is available on all supported platforms |
| 1188 |
</li> |
| 1189 |
<li>Issue #812: TIME values should be in range 0:00:00.000000000 23:59:59.999999999? |
| 1190 |
</li> |
| 1191 |
<li>PR #811: Issues with Boolean.parseBoolean() |
| 1192 |
</li> |
| 1193 |
<li>PR #809: Use type constants from LocalDateTimeUtils directly |
| 1194 |
</li> |
| 1195 |
<li>PR #808: Use HmacSHA256 provided by JRE |
| 1196 |
</li> |
| 1197 |
<li>PR #807: Use SHA-256 provided by JRE / Android and use rotateLeft / Right in Fog |
| 1198 |
</li> |
| 1199 |
<li>PR #806: Implement setBytes() and setString() with offset and len |
| 1200 |
</li> |
| 1201 |
<li>PR #805: Improve support of TIMESTAMP WITH TIME ZONE |
| 1202 |
</li> |
| 1203 |
<li>PR #803: Use new ArrayList(Collection) and assertThrows() |
| 1204 |
</li> |
| 1205 |
<li>PR #802: Use Arrays.copyOf() and Arrays.copyOfRange() |
| 1206 |
</li> |
| 1207 |
<li>PR #801: Fix NULL support in PgServer for primitive types too |
| 1208 |
</li> |
| 1209 |
<li>PR #800: More fixes in date-time types for ODBC drivers |
| 1210 |
</li> |
| 1211 |
<li>PR #798: Add partial support of DATE, TIME, and TIMESTAMP data types to PgServer |
| 1212 |
</li> |
| 1213 |
<li>PR #799: Use result of ArrayList.remove() |
| 1214 |
</li> |
| 1215 |
<li>PR #797: Add ceilingKey() and floorKey() to TransactionMap (version 2) |
| 1216 |
</li> |
| 1217 |
<li>PR #796: Add MDY to DateStyle in PgServerThread |
| 1218 |
</li> |
| 1219 |
<li>PR #794: Sort files in generated jars |
| 1220 |
</li> |
| 1221 |
<li>PR #793: Change return type of Value.getBoolean() to boolean (unwrapped) |
| 1222 |
</li> |
| 1223 |
<li>PR #792: Inherit classpath from parent process |
| 1224 |
</li> |
| 1225 |
<li>PR #791: Switch to JaCoCo code coverage |
| 1226 |
</li> |
| 1227 |
<li>PR #788: Update lists of keywords |
| 1228 |
</li> |
| 1229 |
<li>PR #789: Map DATE in Oracle mode to ValueTimestamp |
| 1230 |
</li> |
| 1231 |
<li>PR #787: Assorted changes |
| 1232 |
</li> |
| 1233 |
<li>PR #785: Optimize NULL handling in MVSecondaryIndex.add() |
| 1234 |
</li> |
| 1235 |
<li>PR #783: Add Bits implementation for Java 9 and later versions |
| 1236 |
</li> |
| 1237 |
<li>PR #784: Hardcoded port numbers should not be used in unit tests |
| 1238 |
</li> |
| 1239 |
<li>PR #780: Close JavaFileManager after use. |
| 1240 |
</li> |
| 1241 |
<li>PR #782: Leftover shared lock after release |
| 1242 |
</li> |
| 1243 |
<li>PR #781: Locks left behind after commit |
| 1244 |
</li> |
| 1245 |
<li>PR #778: Reduce code duplication |
| 1246 |
</li> |
| 1247 |
<li>PR #775: Fix building of documentation and zip |
| 1248 |
</li> |
| 1249 |
<li>PR #774: Assorted changes |
| 1250 |
</li> |
| 1251 |
<li>PR #773: Better checks for arguments of partial LOB reading methods |
| 1252 |
</li> |
| 1253 |
<li>PR #772: getBinaryStream() and getCharacterStream() with pos and length |
| 1254 |
</li> |
| 1255 |
<li>Issue #754: Make NUMERIC type read as NUMERIC |
| 1256 |
</li> |
| 1257 |
<li>PR #768: Add DataUtils.parseChecksummedMap() |
| 1258 |
</li> |
| 1259 |
<li>PR #769: Do not copy result of DataUtils.parseMap() to a new maps |
| 1260 |
</li> |
| 1261 |
<li>PR #766: Minor clean up of DateTimeUtils |
| 1262 |
</li> |
| 1263 |
<li>PR #764: Make use of try-with-resources statement |
| 1264 |
</li> |
| 1265 |
<li>Issue #406: Return from ResultSet.getObject not in line with JDBC specification |
| 1266 |
</li> |
| 1267 |
<li>Issue #710: Misleading exception message when INSERT has no value for self referential 'AS' column |
| 1268 |
</li> |
| 1269 |
<li>PR #763: Add DataUtils.getMapName() |
| 1270 |
</li> |
| 1271 |
<li>PR #762: Add row deletion confirmation to web console |
| 1272 |
</li> |
| 1273 |
<li>PR #760: Assorted minor optimizations |
| 1274 |
</li> |
| 1275 |
<li>PR #759: Improve the look of error messages in web console |
| 1276 |
</li> |
| 1277 |
<li>PR #758: Allocate less amount of garbage |
| 1278 |
</li> |
| 1279 |
<li>PR #757: Fix handling of UUID in Datatype.readValue() |
| 1280 |
</li> |
| 1281 |
<li>PR #753: Optimize StringUtils.trim() and remove StringUtils.equals() |
| 1282 |
</li> |
| 1283 |
<li>PR #752: Use predefined charsets instead of names where possible |
| 1284 |
</li> |
| 1285 |
<li>PR #750: Use AtomicIntegerArray and StandardCharsets |
| 1286 |
</li> |
| 1287 |
<li>PR #749: Fix some build checks in sources |
| 1288 |
</li> |
| 1289 |
<li>Issue #740: TestWeb hangups if webSSL=true specified in configuration |
| 1290 |
</li> |
| 1291 |
<li>Issue #736: Copyright years in sources |
| 1292 |
</li> |
| 1293 |
<li>Issue #744: TestFile failure on Java 9 and Java 10 |
| 1294 |
</li> |
| 1295 |
<li>PR #741: More cleanups in LocalDateTimeUtils and other minor changes |
| 1296 |
</li> |
| 1297 |
<li>PR #743: Change REGEXP_REPLACE mode for MariaDB and PostgreSQL |
| 1298 |
</li> |
| 1299 |
<li>Issue#646 NPE in CREATE VIEW WITH RECURSIVE & NON_RECURSIVE CTE |
| 1300 |
</li> |
| 1301 |
<li>PR #738: Copy javadoc to *BackwardsCompat to fix building of documentation |
| 1302 |
</li> |
| 1303 |
<li>PR #735: Add support of java.time.Instant V2 |
| 1304 |
</li> |
| 1305 |
<li>PR #733: Remove JPA/ORM configuration txt files as they're already integrated |
| 1306 |
</li> |
| 1307 |
<li>PR #732: Fix == |
| 1308 |
</li> |
| 1309 |
<li>PR #730: Implement enquoteIdentifier() and isSimpleIdentifier() from JDBC 4.3 |
| 1310 |
</li> |
| 1311 |
<li>PR #729: Grammar documentation change |
| 1312 |
</li> |
| 1313 |
<li>PR #727: Integer/Long.compare(x, y) can be used to compare primitive values |
| 1314 |
</li> |
| 1315 |
<li>PR #726: Fixes in tests |
| 1316 |
</li> |
| 1317 |
<li>Issue #725: FilePathMem.tryLock() fails since Java 9 |
| 1318 |
</li> |
| 1319 |
<li>PR #723: Clean up LocalDateTimeUtils |
| 1320 |
</li> |
| 1321 |
<li>PR #724: Use StringBuilder instead of StringBuffer |
| 1322 |
</li> |
| 1323 |
<li>PR #720: DROP TABLE RESTRICT shouldn't drop foreign keys in other tables |
| 1324 |
</li> |
| 1325 |
<li>PR #722: Assorted minor changes |
| 1326 |
</li> |
| 1327 |
<li>Issue #638: Oracle mode: incompatible regexp back-reference syntax |
| 1328 |
</li> |
| 1329 |
<li>Make ALL a reserved keyword |
| 1330 |
</li> |
| 1331 |
<li>Issue #311: Avoid calling list.toArray(new X[list.size()]) for performance |
| 1332 |
</li> |
| 1333 |
<li>PR #715: Better getObject error message |
| 1334 |
</li> |
| 1335 |
<li>PR #714: SecureRandom is already synchronized |
| 1336 |
</li> |
| 1337 |
<li>PR #712: Return properly encoded UUID from SimpleResultSet.getBytes() |
| 1338 |
</li> |
| 1339 |
<li>PR #711: TestFunctions less english dependent |
| 1340 |
</li> |
| 1341 |
<li>Issue #644: Year changing from negative -509 to a positive 510. |
| 1342 |
</li> |
| 1343 |
<li>PR #706: SIGNAL function |
| 1344 |
</li> |
| 1345 |
<li>PR #704: added Javascript support for Triggers' source |
| 1346 |
</li> |
| 1347 |
<li>Issue #694: Oracle syntax for adding NOT NULL constraint not supported. |
| 1348 |
</li> |
| 1349 |
<li>Issue #699: When using an index for sorting, the index is ignored when also using NULLS LAST/FIRST |
| 1350 |
</li> |
| 1351 |
<li>Issue #697: FilePathDisk.newInputStream fails for contextual class loading |
| 1352 |
</li> |
| 1353 |
<li>Issue #695: jdbc:postgresql protocol connection issue in H2 Console Application in case of redshift driver in classpath |
| 1354 |
</li> |
| 1355 |
<li>Fix 'file not closed' when using FILE_READ |
| 1356 |
</li> |
| 1357 |
<li>Fix bug in LinkSchema tool when object exists with same name in different schemas |
| 1358 |
</li> |
| 1359 |
<li>Issue #675: Fix date operations on Locales with non-Gregorian calendars |
| 1360 |
</li> |
| 1361 |
<li>Fix removal of LOB when rolling back transaction on a table containing more than one LOB column. |
| 1362 |
</li> |
| 1363 |
<li>Issue #654: List ENUM type values in INFORMATION_SCHEMA.COLUMNS |
| 1364 |
</li> |
| 1365 |
<li>Issue #650: Simple nested SELECT causes error for table with TIMESTAMP WITH TIMEZONE column |
| 1366 |
</li> |
| 1367 |
<li>Issue #654: List ENUM type values in INFORMATION_SCHEMA.COLUMNS |
| 1368 |
</li> |
| 1369 |
<li>Issue #668: Fail of an update command on large table with ENUM column |
| 1370 |
</li> |
| 1371 |
<li>Issue #662: column called CONSTRAINT is not properly escaped when storing to metadata |
| 1372 |
</li> |
| 1373 |
<li>Issue #660: Outdated java version mentioned on http://h2database.com/html/build.html#providing_patches |
| 1374 |
</li> |
| 1375 |
<li>Issue #643: H2 doesn't use index when I use IN and EQUAL in one query |
| 1376 |
</li> |
| 1377 |
<li>Reset transaction start timestamp on ROLLBACK |
| 1378 |
</li> |
| 1379 |
<li>Issue #632: CREATE OR REPLACE VIEW creates incorrect columns names |
| 1380 |
</li> |
| 1381 |
<li>Issue #630: Integer overflow in CacheLRU can cause unrestricted cache growth |
| 1382 |
</li> |
| 1383 |
<li>Issue #497: Fix TO_DATE in cases of 'inline' text. E.g. the "T" and "Z" in to_date('2017-04-21T00:00:00Z', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') |
| 1384 |
</li> |
| 1385 |
<li>Fix bug in MySQL/ORACLE-syntax silently corrupting the modified column in cases of setting the 'NULL'- or 'NOT NULL'-constraint. E.g. alter table T modify C NULL; |
| 1386 |
</li> |
| 1387 |
<li>Issue #570: MySQL compatibility for ALTER TABLE .. DROP INDEX |
| 1388 |
</li> |
| 1389 |
<li>Issue #537: Include the COLUMN name in message "Numeric value out of range" |
| 1390 |
</li> |
| 1391 |
<li>Issue #600: ROW_NUMBER() behaviour change in H2 1.4.195 |
| 1392 |
</li> |
| 1393 |
<li>Fix a bunch of race conditions found by vmlens.com, thank you to vmlens for giving us a license. |
| 1394 |
</li> |
| 1395 |
<li>PR #597: Support more types in getObject |
| 1396 |
</li> |
| 1397 |
<li>Issue #591: Generated SQL from WITH-CTEs does not include a table identifier |
| 1398 |
</li> |
| 1399 |
<li>PR #593: Make it possible to create a cluster without using temporary files. |
| 1400 |
</li> |
| 1401 |
<li>PR #592: "Connection is broken: "unexpected status 16777216" [90067-192]" message when using older h2 releases as client |
| 1402 |
</li> |
| 1403 |
<li>Issue #585: MySQL mode DELETE statements compatibility |
| 1404 |
</li> |
| 1405 |
<li>PR #586: remove extra tx preparation |
| 1406 |
</li> |
| 1407 |
<li>PR #568: Implement MetaData.getColumns() for synonyms. |
| 1408 |
</li> |
| 1409 |
<li>Issue #581: org.h2.tools.RunScript assumes -script parameter is part of protocol |
| 1410 |
</li> |
| 1411 |
<li>Fix a deadlock in the TransactionStore |
| 1412 |
</li> |
| 1413 |
<li>PR #579: Disallow BLOB type in PostgreSQL mode |
| 1414 |
</li> |
| 1415 |
<li>Issue #576: Common Table Expression (CTE): WITH supports INSERT, UPDATE, MERGE, DELETE, CREATE TABLE ... |
| 1416 |
</li> |
| 1417 |
<li>Issue #493: Query with distinct/limit/offset subquery returns unexpected rows |
| 1418 |
</li> |
| 1419 |
<li>Issue #575: Support for full text search in multithreaded mode |
| 1420 |
</li> |
| 1421 |
<li>Issue #569: ClassCastException when filtering on ENUM value in WHERE clause |
| 1422 |
</li> |
| 1423 |
<li>Issue #539: Allow override of builtin functions/aliases |
| 1424 |
</li> |
| 1425 |
<li>Issue #535: Allow explicit paths on Windows without drive letter |
| 1426 |
</li> |
| 1427 |
<li>Issue #549: Removed UNION ALL requirements for CTE |
| 1428 |
</li> |
| 1429 |
<li>Issue #548: Table synonym support |
| 1430 |
</li> |
| 1431 |
<li>Issue #531: Rollback and delayed meta save. |
| 1432 |
</li> |
| 1433 |
<li>Issue #515: "Unique index or primary key violation" in TestMvccMultiThreaded |
| 1434 |
</li> |
| 1435 |
<li>Issue #458: TIMESTAMPDIFF() test failing. Handling of timestamp literals. |
| 1436 |
</li> |
| 1437 |
<li>PR #546: Fixes the missing file tree.js in the web console |
| 1438 |
</li> |
| 1439 |
<li>Issue #543: Prepare statement with regexp will not refresh parameter after metadata change |
| 1440 |
</li> |
| 1441 |
<li>PR #536: Support TIMESTAMP_WITH_TIMEZONE 2014 JDBC type |
| 1442 |
</li> |
| 1443 |
<li>Fix bug in parsing ANALYZE TABLE xxx SAMPLE_SIZE yyy |
| 1444 |
</li> |
| 1445 |
<li>Add padding for CHAR(N) values in PostgreSQL mode |
| 1446 |
</li> |
| 1447 |
<li>Issue #89: Add DB2 timestamp format compatibility |
| 1448 |
</li> |
| 1449 |
</ul> |
| 1450 |
|
| 1451 |
<h2>Version 1.4.196 (2017-06-10)</h2> |
| 1452 |
<ul> |
| 1453 |
<li>Issue#479 Allow non-recursive CTEs (WITH statements), patch from stumc |
| 1454 |
</li> |
| 1455 |
<li>Fix startup issue when using "CHECK" as a column name. |
| 1456 |
</li> |
| 1457 |
<li>Issue #423: ANALYZE performed multiple times on one table during execution of the same statement. |
| 1458 |
</li> |
| 1459 |
<li>Issue #426: Support ANALYZE TABLE statement |
| 1460 |
</li> |
| 1461 |
<li>Issue #438: Fix slow logging via SLF4J (TRACE_LEVEL_FILE=4). |
| 1462 |
</li> |
| 1463 |
<li>Issue #472: Support CREATE SEQUENCE ... ORDER as a NOOP for Oracle compatibility |
| 1464 |
</li> |
| 1465 |
<li>Issue #479: Allow non-recursive Common Table Expressions (CTE) |
| 1466 |
</li> |
| 1467 |
<li>On Mac OS X, with IPv6 and no network connection, the Console tool was not working as expected. |
| 1468 |
</li> |
| 1469 |
</ul> |
| 1470 |
|
| 1471 |
<h2>Version 1.4.195 (2017-04-23)</h2> |
| 1472 |
<ul> |
| 1473 |
<li>Lazy query execution support. |
| 1474 |
</li> |
| 1475 |
<li>Added API for handling custom data types (System property "h2.customDataTypesHandler", API org.h2.api.CustomDataTypesHandler). |
| 1476 |
</li> |
| 1477 |
<li>Added support for invisible columns. |
| 1478 |
</li> |
| 1479 |
<li>Added an ENUM data type, with syntax similar to that of MySQL. |
| 1480 |
</li> |
| 1481 |
<li>MVStore: for object data types, the cache size memory estimation |
| 1482 |
was sometimes far off in a read-only scenario. |
| 1483 |
This could result in inefficient cache usage. |
| 1484 |
</li> |
| 1485 |
</ul> |
| 1486 |
|
| 1487 |
<!-- [close] { --></div></td></tr></table><!-- } --><!-- analytics --></body></html> |