Debian Codegraph @

src/docsrc/html/changelog.html

raw
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 &#8230; 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 &gt;=
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 &#8220;big&#8221; 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&lt;Value&gt; 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 &lt;table&gt; (&lt;columns&gt;) 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 &amp; 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>