Bug #4932
Error in reports after upgrade from H2 1.4.197 to 1.4.200
Start date:
Due date:
% Done:
100%
billable:
No
vendor_id:
GCD
case_num:
History
#1 Updated by Roger Borrello over 3 years ago
The below error occurs running reports:
rpt-no-front:
[java] EXPRESSION EXECUTION ERROR:
[java] ---------------------------
[java] rw.initializeDatabase(appAdminPass)
[java] ^ { Error preparing database }
[java] ---------------------------
[java] java.lang.RuntimeException: ERROR! Active Rule:
[java] -----------------------
[java] RULE REPORT
[java] -----------------------
[java] Rule Type : INIT
[java] Source AST: null
[java] Copy AST : null
[java] Condition : rw.initializeDatabase(appAdminPass)
[java] Loop : false
[java] --- END RULE REPORT ---
[java]
[java]
[java]
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1079)
[java] Elapsed job time: 00:00:01.140 at com.goldencode.p2j.report.ReportDriver.patternEngine(ReportDriver.java:168)
[java] at com.goldencode.p2j.report.ReportDriver.main(ReportDriver.java:460)
[java] Caused by: com.goldencode.expr.ExpressionException: Expression execution error @1:4
[java]
[java] at com.goldencode.expr.Expression.execute(Expression.java:484)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:497)
[java] at com.goldencode.p2j.pattern.Rule.executeActions(Rule.java:745)
[java] at com.goldencode.p2j.pattern.Rule.coreProcessing(Rule.java:712)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:534)
[java] at com.goldencode.p2j.pattern.PatternEngine.applyGlobal(PatternEngine.java:1681)
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1015)
[java] ... 2 more
[java] Caused by: java.lang.RuntimeException: Error preparing database
[java] at com.goldencode.p2j.report.ReportWorker.createDatabaseTables(ReportWorker.java:784)
[java] at com.goldencode.p2j.report.ReportWorker.access$000(ReportWorker.java:250)
[java] at com.goldencode.p2j.report.ReportWorker$Library.initializeDatabase(ReportWorker.java:1100)
[java] at com.goldencode.expr.CE7.execute(Unknown Source)
[java] at com.goldencode.expr.Expression.execute(Expression.java:391)
[java] ... 8 more
[java] Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE REPORT_CELL (RCID BIGINT, ROW[*] INT, TEXT VARCHAR, NUM DOUBLE, CONSTRAINT FK_RPTCELL_RCID FOREIGN KEY(RCID) REFERENCES REPORT_COLUMN(ID))"; expected "identifier"; SQL statement:
[java] create table report_cell (rcid bigint, row int, text varchar, num double, constraint fk_rptcell_rcid foreign key(rcid) references report_column(id)) [42001-200]
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
[java] at org.h2.message.DbException.getSyntaxError(DbException.java:243)
[java] at org.h2.command.Parser.readColumnIdentifier(Parser.java:4982)
[java] at org.h2.command.Parser.parseTableColumnDefinition(Parser.java:8449)
[java] at org.h2.command.Parser.parseCreateTable(Parser.java:8391)
[java] at org.h2.command.Parser.parseCreate(Parser.java:6282)
[java] at org.h2.command.Parser.parsePrepared(Parser.java:903)
[java] at org.h2.command.Parser.parse(Parser.java:843)
[java] at org.h2.command.Parser.parse(Parser.java:815)
[java] at org.h2.command.Parser.prepareCommand(Parser.java:738)
[java] at org.h2.engine.Session.prepareLocal(Session.java:657)
[java] at org.h2.engine.Session.prepareCommand(Session.java:595)
[java] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
[java] at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:212)
[java] at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201)
[java] at com.goldencode.p2j.report.ReportWorker.createDatabaseTables(ReportWorker.java:718)
[java] ... 12 more
[java] Elapsed job time: 00:00:01.061
[java] EXPRESSION EXECUTION ERROR:
[java] ---------------------------
[java] rw.prepareDatabaseStatements(incremental)
[java] ^ { Error preparing database statements }
[java] ---------------------------
[java] java.lang.RuntimeException: ERROR! Active Rule:
[java] -----------------------
[java] RULE REPORT
[java] -----------------------
[java] Rule Type : INIT
[java] Source AST: null
[java] Copy AST : null
[java] Condition : rw.prepareDatabaseStatements(incremental)
[java] Loop : false
[java] --- END RULE REPORT ---
[java]
[java]
[java]
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1079)
[java] at com.goldencode.p2j.report.ReportDriver.patternEngine(ReportDriver.java:168)
[java] at com.goldencode.p2j.report.ReportDriver.main(ReportDriver.java:460)
[java] Caused by: com.goldencode.expr.ExpressionException: Expression execution error @1:4
[java] at com.goldencode.expr.Expression.execute(Expression.java:484)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:497)
[java] at com.goldencode.p2j.pattern.PatternEngine.applyGlobal(PatternEngine.java:1681)
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1015)
[java] ... 2 more
[java] Caused by: java.lang.RuntimeException: Error preparing database statements
[java] at com.goldencode.p2j.report.ReportWorker.prepareStatements(ReportWorker.java:944)
[java] at com.goldencode.p2j.report.ReportWorker.access$200(ReportWorker.java:250)
[java] at com.goldencode.p2j.report.ReportWorker$Library.prepareDatabaseStatements(ReportWorker.java:1214)
[java] at com.goldencode.expr.CE7.execute(Unknown Source)
[java] at com.goldencode.expr.Expression.execute(Expression.java:391)
[java] ... 5 more
[java] Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "REPORT_CELL" not found; SQL statement:
[java] insert into report_cell(rcid, row, text, num) values (?, ?, ?, ?) [42102-200]
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
[java] at org.h2.message.DbException.get(DbException.java:205)
[java] at org.h2.message.DbException.get(DbException.java:181)
[java] at org.h2.command.Parser.readTableOrView(Parser.java:7637)
[java] at org.h2.command.Parser.readTableOrView(Parser.java:7608)
[java] at org.h2.command.Parser.parseInsert(Parser.java:1747)
[java] at org.h2.command.Parser.parsePrepared(Parser.java:954)
[java] at org.h2.command.Parser.parse(Parser.java:843)
[java] at org.h2.command.Parser.parse(Parser.java:815)
[java] at org.h2.command.Parser.prepareCommand(Parser.java:738)
[java] at org.h2.engine.Session.prepareLocal(Session.java:657)
[java] at org.h2.engine.Session.prepareCommand(Session.java:595)
[java] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
[java] at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
[java] at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1157)
[java] at com.goldencode.p2j.report.ReportWorker.prepareStatements(ReportWorker.java:881)
[java] ... 9 more
[echo] Report generation finished.
BUILD SUCCESSFUL
Total time: 253 minutes 6 seconds
#2 Updated by Roger Borrello over 3 years ago
Version 1.4.200 (2019-10-14)
PR #2168: Add non-standard SNAPSHOT isolation level to MVStore databases
Issue #2165: Problem with secondary index on SERIALIZABLE isolation level
Issue #2161: Remove undocumented PageStore-only FILE_LOCK=SERIALIZED
PR #2155: Reduce code duplication
Issue #1894: Confusing error message when database creation is disallowed
Issue #2123: Random failures in TestTransactionStore
Issue #2153: Different behavior in SET LOCK_TIMEOUT after 1.4.197
Issue #2150: Remove MULTI_THREADED setting and use multi-threaded MVStore and single-threaded PageStore backends
Issue #216: Support READ UNCOMMITTED isolation level in MVStore mode
Issue #678: Support REPEATABLE READ isolation level in MVStore mode
Issue #174: Support SERIALIZABLE isolation level in MVStore mode
Issue #2144: MVStore: read uncommitted doesn't see committed rows
Issue #2142: CURRVAL / CURRENT VALUE FOR should return the value for the current session
Issue #2136: ConstraintCheck concurrency regression
PR #2137: Don't use SYSTEM_RANGE for SELECT without a FROM
PR #2134: Assorted fixes and other changes in DateTimeUtils
PR #2133: Optimize COUNT([ALL] constant) and other changes
PR #2132: Typo and another bug in MVStore.readStoreHeader()
Issue #2130: Group-sorted query returns invalid results with duplicate grouped columns in select list
Issue #2120: Add IF EXISTS clause to column name in ALTER TABLE ALTER COLUMN statement
Issue #521: Add support for the TIME WITH TIME ZONE data type
PR #2127: Fix race condition / performance issue during snapshotting
Issue #2124: MVStore build is broken
PR #2122: Add support for LMT in time zones and fix large years in datetime values
Issue #2067: Incorrect chunk space allocation during chunks movement
PR #2066: Not so happy path - "four alternatives" implementation
PR #2121: Reduce code duplication for datetime API with custom Calendar instances
PR #2119: SQL: statement read consistency
Issue #2116: Empty IN() operator should result in error (MSSQL)
Issue #2036: CAST from TIME to TIMESTAMP returns incorrect result
PR #2114: Assorted changes
PR #2113: Add feature F411: Time zone specification
PR #2111: CURRENT_CATALOG, SET CATALOG and other changes
Issue #2109: IW date formatting does not produce proper output
PR #2104: Fix ordinary grouping set with parentheses and empty grouping set in GROUP BY
Issue #2103: Add QUOTE_IDENT() function to enquote an identifier in SQL
Issue #2075: Add EXECUTE IMMEDIATE implementation
PR #2101: Fix infinite loop in Schema.removeChildrenAndResources()
Issue #2096: Convert LEFT and RIGHT to keywords and disallow comma before closing parenthesis
PR #2098: Fix typos
Issue #1305 / PR #2097: Remove unused and outdated website translation infrastructure
PR #2093: CURRENT VALUE FOR and other sequence-related changes
PR #2092: Allow to simulate usage of multiple catalogs by one connection
PR #2091: Oracle mode now uses DECIMAL with NEXTVAL
Issue #2088: Division by zero caused by evaluation of global conditions before local conditions
Issue #2086: TCP_QUICKACK on server socket
Issue #2073: TableLink should not pass queries to DatabaseMetaData.getColumns()
Issue #2074: MySQL and MSSQLServer Mode: TRUNCATE TABLE should always RESTART IDENTITY
Issue #2063: MySQL mode: "drop foreign key if exists" support
PR #2061: Use VirtualTable as a base class for RangeTable
PR #2059: Parse IN predicate with multiple subqueries correctly
PR #2057: Fix TestCrashAPI failure with Statement.enquoteIdentifier()
PR #2056: Happy path: speed up database opening
Issue #2051: The website shows outdated information about the storage engine
PR #2049: bugfix - mvstore data lost issue when partial write occurs
PR #2047: File maintenance
PR #2046: Recovery mode
Issue #2044: setTransactionIsolation always call commit() even if transaction is auto-commit
Issue #2042: Add possibility to specify generated columns for query in web console
Issue #2040: INFORMATION_SCHEMA.SETTINGS contains irrelevant settings
PR #2038: MVMap: lock reduction on updates
PR #2037: Fix SYS_GUID, RAWTOHEX, and HEXTORAW in Oracle mode
Issue #2016: ExpressionColumn.mapColumns() performance complexity is quadratic
Issue #2028: Sporadic inconsistent state after concurrent UPDATE in 1.4.199
PR #2033: Assorted changes
Issue #2025: Incorrect query result when (OFFSET + FETCH) > Integer.MAX_VALUE
PR #2023: traverseDown() code deduplication
PR #2022: Mvmap minor cleanup
Issue #2020: Wrong implementation of IN predicate with subquery
PR #2003: Change dead chunks determination algorithm
Issue #2013: DECIMAL is casted to double in ROUND function
PR #2011: ZonedDateTime and (INTERVAL / INTERVAL)
Issue #1997: TestRandomSQL failure with ClassCastException
Issue #2007: PostgreSQL compatibility mode: support ON CONFLICT DO NOTHING
Issue #1927: Do not allow commit() when auto-commit is enabled
PR #1998: Reduce TxCounter memory footprint
PR #1999: Make RootReference lock re-entrant
PR #2001: Test improvements, OOME elimination
Issue #1995: Obscure condition in MVPrimaryIndex.extractPKFromRow()
Issue #1975: Add client ip address to information_schema
PR #1982: Hindi language translation added
Issue #1985: Add thread number to TCP server thread names
Do not allow empty password for management DB
Issue #1978: getGeneratedKeys() can use the same rules as FINAL TABLE
PR #1977: Change JSON literals and add support for compound character literals
PR #1974: Use proleptic Gregorian calendar for datetime values
Issue #1847: Add support for data change delta tables
PR #1971: Add maximum cardinality parameter to ARRAY data type
PR #1970: Switch from log map rename to "committed" marker log record
PR #1969: Add unique predicate
Issue #1963: Expression.addFilterConditions() with outer joins
PR #1966: Add standard CURRENT_SCHEMA function
PR #1964: Add Feature T571: Truth value tests
PR #1962: Fix data types of optimized conditions
PR #1961: Failure to open DB after improper shutdown
Issue #1957: NullPointerException with DISTINCT and ORDER BY CASE
PR #1956: Fix row value handling in the null predicate
PR #1955: Add standard UNKNOWN literal
Issue #1952: Connection.setSchema doesn't work with query cache
PR #1951: Assorted changes
PR #1950: Fix NULL handling in ARRAY_AGG
PR #1949: Extract aggregate and window functions into own pages in documentation
PR #1948: Add standard LOG() function with two arguments
Issue #1935: Improve file locking on shared filesystems like SMB
PR #1946: Reimplement table value constructor on top of Query
PR #1945: Fix IN (SELECT UNION with OFFSET/FETCH)
Issue #1942: MySQL Mode: convertInsertNullToZero should be turned off by default?
Issue #1940: MySQL Mode: Modify column from NOT NULL to NULL syntax
PR #1941: Extract OFFSET / FETCH handling from Select and SelectUnion to Query
Issue #1938: Regression with CREATE OR REPLACE VIEW. Causes "Duplicate column name" exception.
PR #1937: Get rid of FunctionCursorResultSet
Issue #1932: Incoherence between DbSettings.mvStore and getSettings()
PR #1931: Fix wildcard expansion for multiple schemas
PR #1930: Move PageStore table engine into own package
PR #1929: Initial implementation of type predicate and other changes
PR #1926: Assorted improvements for BINARY data type
Issue #1925: Support SQL Server binary literal syntax
Issue #1918: MySQL: CREATE TABLE with both CHARSET and COMMENT failed
Issue #1913: MySQL: auto_increment changing SQL not supported
Issue #1585: The translate function on DB2 mode could have parameters order changed
PR #1914: Change storage and network format of JSON to byte[]
Issue #1911: Foreign key constraint does not prevent table being dropped
PR #1909: Add JSON_OBJECTAGG and JSON_ARRAYAGG aggregate functions
PR #1908: Cast VARCHAR to JSON properly and require FORMAT JSON in literals
PR #1906: Add JSON_OBJECT and JSON_ARRAY functions
Issue #1887: Infinite recursion in ConditionAndOr.java
Issue #1903: MSSQLServer Mode - Support Update TOP(X)
Issue #1900: Support SQLServer stored procedure execution syntax
PR #1898: Add IS JSON predicate
Issue #1896: MSSQLServer compatibility mode - GETDATE() incorrectly omits time
PR #1895: Add standard array concatenation operation
Issue #1892: Window aggregate functions return incorrect result without window ordering and with ROWS unit
Issue #1890: ArrayIndexOutOfBoundsException in MVSortedTempResult.getKey
Issue #308: Mode MySQL and LAST_INSERT_ID with argument
Issue #1883: Suspicious code in Session.getLocks()
Issue #1878: OPTIMIZE_REUSE_RESULTS causes incorrect result after rollback since 1.4.198
PR #1880: Collation names like CHARSET_* recognition
Issue #1844: MySQL Compatibility: create table error when primary key has comment
PR #1873: Concurrency in database metadata
Issue #1864: Failing to format NotSerializableException corrupting the database
PR #1868: add more checking to TestFileLock
Issue #1819: Trace.db file exceed file size limit (64MB)
Issue #1861: Use COALESCE in named columns join for some data types
PR #1860: Additional fix for deadlock on shutdown (exclusively in PageStore mode)
Issue #1855: Wrong qualified asterisked projections in named column join
Issue #1854: Wrong asterisked projection and result in named column right outer join
Issue #1852: Named column joins doesn't work with the VALUES constructor and derived column lists
Issue #1851: Wrong asterisked projection in named column joins
PR #1850: Duplicate map identifiers
PR #1849: Reimplement MVStore.findOldChunks() with PriorityQueue
PR #1848: Reimplement MVStore.findChunksToMove() with PriorityQueue
Issue #1843: Named columns join syntax is not supported
Issue #1841: Deadlock during concurrent shutdown attempts with 1.4.199
Issue #1834: NUMERIC does not preserve its scale for some values
PR #1838: Implement conversion from JSON to GEOMETRY
PR #1837: Implement conversion from GEOMETRY to JSON
PR #1836: Add LSHIFT and RSHIFT function
PR #1833: Add BITNOT function
PR #1832: JSON validation and normalization
PR #1829: MVStore chunks occupancy rate calculation fixes
PR #1828: Basis for implementation of SQL/JSON standard
PR #1827: Add support for Lucene 8.0.0
Issue #1820: Performance problem on commit
Issue #1822: Use https:// in h2database.com hyperlinks
PR #1817: Assorted minor changes in documentation and other places
PR #1812: An IllegalStateException that wraps EOFException is thrown when partial writes happens
Version 1.4.199 (2019-03-13)
PR #1807: Reduce code duplication and remove h2.mixedGeometries
PR #1806: Improve SELECT FOR UPDATE documentation
PR #1804: Lift limit of 10 characters on enum value (1.4.198 regression)
PR #1803: Do not rely on index sorting in SELECT FOR UPDATE
Issue #1800: Remove experimental status from window functions
PR #1799: Fire triggers after row locking and remove some leftovers
PR #1798: Reuse some string builders, remove StatementBuilder and other minor changes
Issue #1795: 1.4.198 regression with batch updates and transactions
PR #1794: Ask password in Shell in secure way and improve database creation information in tutorial
PR #1791: Move commands to commands.html and other changes
Issue #1774: H2 Browser configuration is unclear and fails on KUbuntu
PR #1790: Do not convert standard TRIM function to non-standard functions
Issue #1787: Non-standard MERGE throws LOCK_TIMEOUT_1 on violation of some constraints
PR #1784: improve database not found error
Issue #1740: Enhancement Request: h2 server: do not swallow exceptions
Issue #1616: Metadata and scripts should be persisted with unconditionally quoted identifiers
PR #1779: Improve isSimpleIdentifier() and enquoteIdentifier()
PR #1776: Improve DATABASE_TO_LOWER handling
Issue #1771: NPE in Comparison.createIndexConditions
PR #1772: Fix newlines in test scripts
Issue #1762: NullPointerException in Parser. Introduced in 1.4.198
PR #1768: Add more context-sensitive keywords
Issue #1758: sequence restart issue with 1.4.198
Issue #1759: SELECT … FOR UPDATE returns old data in 1.4.198
PR #1756: Fix DISTINCT ON in presence of ORDER BY
PR #1754: Fix window functions in JOIN with ON condition
Issue #1751: making it easier to open console and create local databases
Issue #1750: JOIN t ON t.col IN (SELECT ...) throws AssertionError
Version 1.4.198 (2019-02-22)
Issue #1746: Infinite loop in TestConcurrent.testConcurrentChangeAndGetVersion()
Issue #1739: Table and view names not case sensitive when using DATABASE_TO_UPPER=FALSE
Issue #848: H2 PostgreSQL Compatibility Mode: lowercase metadata
Issue #485: Problem is in invalid case for schema's IGNORECASE=true;DATABASE_TO_UPPER=false
Issue #1742, PR #1743: Assorted small changes
PR #1738: Reduce memory allocation in getSQL() methods
PR #1737: more javadoc updates
Issue #1735: Creating views with DATABASE_TO_UPPER=FALSE fails
Issue #1732: source.html does not work
Issue #1730: Show error in H2 Console if specified driver is not compatible with URL
Issue #1590: Error on executing "DELETE FROM table1 WHERE ID = ?; DELETE FROM table2 WHERE ID = ?;"
Issue #1727: Support ISODOW as identifier for the extract function additional to ISO_DAY_OF_WEEK
PR #1580, #1726: Disable remote database creation by default
PR #1725: Add partial implementation of standard LISTAGG aggregate function
PR #1722: Fix window definition lookup in some queries
PR #1721: Fix derived column list in complex queries
Issue #1718: Window function and values clause don't work well together
Issue #1592: Index out of bounds exception in Page.getKey()
PR #1716: Improve documentation of some DML commands
Issue #1715: Postgres mode: Domain "regproc" already exists
PR #1714: Assorted changes
PR #1713: Remove DataType.defaultDisplaySize and fix display size in TypeInfo
PR #1711: Add QUALIFY clause to SELECT command
Issue #1708: CREATE TABLE AS doesn't support column lists without data types
PR #1707: Fix sort order and ENUM data type in external results
PR #1706: Add hypothetical set functions
PR #1705: Fix GROUP_CONCAT with variable separator
PR #1704: Fix return type of PERCENTILE_CONT and MEDIAN
PR #1701: Add PERCENTILE_CONT and PERCENTILE_DISC inverse distribution functions
Issues #1297, #1697: Failure on concurrent session closure
Issue #1297: removeOldTempIndexes on PageStore causes NullPointerException
Issue #1354: TestCrashAPI: another NPE
PR #1695: Reduce memory for TestMVTempResult to 64m
Issue #1691: Append mode causes OOME in MVPlainTempResult
PR #1692: Use MVTempResult unconditionally
Issue #1689: Use separate constants for data types in Data, ValueDataType, and Transfer
PR #1687: MVMap minor cleanup
PR #1686: Fix a regression with ENUM data type
PR #1685: Fix CHAR in PostgreSQL mode and refactor some code
Issue #1681: IN () doesn't work with row values when data types are not exactly the same
Issue #1320: OOME / GC overhead in IndexCursor.nextCursor()
PR #1680: Assorted fixes for ALTER TABLE ALTER COLUMN
PR #1679: Use TestScript for testSimple
Issue #1677: Unable to use VALUES keyword in WHERE clause
Issue #1672: Deadlock on MVStore close in TestOutOfMemory
Issue #1665: TestCrashAPI: NPE with ENUM in MINUS operator
Issue #1602: Combine type, precision, scale, display size and extTypeInfo into one object
PR #1671: Assorted changes
Issue #1668: MySQL compatibility DATE() function should return NULL on error
Issue #1604: TestCrashAPI: PreparedStatement.getGeneratedKeys() is already closed
PR #1667: Detect NULL values and overflow in window frame bounds
PR #1664: Allow any expressions in window frames
Issue #1576: H2 Console should not display precision and scale for data types that don't have them
PR #1662: Fix Alter Table Drop Column In View when table name is wrapped by Double Quotes
PR #1660: Optimize window aggregates with AND UNBOUNDED FOLLOWING and no exclusions
PR #1658: Assorted small changes
PR #1657: Failure to stop background thread
PR #1656: Optimize window aggregates with ORDER BY + UNBOUNDED PRECEDING + no exclusions
Issue #1654: OOM in TestMemoryUsage, in big mode
Issue #1651: TIMESTAMP values near DST may be changed in MVStore database due to UTC-based PageStore format in some temporary storages
PR #1650: Fix race in MVStore.close()
Issue #1212: TestDiskFull: The file is locked
PR #1648: Add functions ARRAY_CAT(), ARRAY_APPEND() and ARRAY_SLICE()
PR #1646: In preparation to a release
PR #1643: more javadoc update
PR #1642: update javadoc
PR #1641: Update copyright years
PR #1640: Suggest ANY(?) instead of variable IN() again
PR #1638: Add support for Java 11 to test suite
PR #1637: Remove explicit unboxing
PR #1635: Optimize UUID to VARCHAR conversion and use correct time check in Engine.openSession()
Issue #1632: TestMVTableEngine failure
PR #1631: Prepare to release: javadoc cleanup
PR #1630: fix duplicate words typos in comments and javadoc
PR #1627: Use lock to protect append buffer
Issue #1618: GROUP BY does not work with two identical columns in selected expressions
Issue #1619: Two-phase commit regression in MASTER
PR #1626: fix doc
PR #1625: Prepare to release: javadoc cleanup, fix maven build, fix javadoc build
Issue #1620: UUIDs are unexpectedly sorted as signed
PR #1614: Use bulk .addAll() operation
PR #1613: Add explicit table query
Issue #1608: ARRAY and row value expression should not be the same
Issue #1606: Quantified comparison predicate doesn't work correctly on primary key column
Issue #1057: Very slow execution with subquery and connection parameter LAZY_QUERY_EXECUTION=1
Issue #1072: Very slow execution with join and connection parameter LAZY_QUERY_EXECUTION=1
PR #1601: Return BIGINT from ROWNUM(), ROW_NUMBER() and rank functions
PR #1599: cleanup StringUtils.cache
PR #1598: Minor changes in parser and documentation
PR #1597: Remove SysProperties.CHECK preconditions around simple assertions
PR #1596: Improve SQL Standard compliance in LOB precision parsing
Issue #1594: DBSettings.optimizeIsNull and dead code in IndexCursor.getMax()
PR #1591: Use multi-catch java 7 language construction to simplify code
Issue #1582: h2 not using best index for >=
PR #1588: Add support for java.time.Period
Issue #446: FILE_READ from classpath not working because of 0 byte file length
PR #1579: fix unintentional append mode disruption
Issue #1573: DELETE FROM w/ ROWNUM and subquery
Issue #187: SHUTDOWN DEFRAG corrupts splitted file database
PR #1571: Optimizing ConditionAndOr queries
Issue #1565: SOME / ANY conflict
PR #1564: Refactor Expression implementations
Issue #1561: Incorrect documentation and strange fallback value of SysProperties.FILE_ENCODING
Issue #1566: MVStore implements Closeable/AutoCloseable
Issue #1550: OutOfMemoryError during "shutdown defrag"
Issue #1440: OOM when executing "shutdown compact" in server mode
Issue #1561: Incorrect documentation and strange fallback value of SysProperties.FILE_ENCODING
PR #1557: increase lock timeout to TestConcurrentUpdate due to Travis failures
Issue #1554: REGEXP_REPLACE - accept 'g' flag in PostgreSQL compatibility mode
Issue #950: Comparison between databases in README.md and in features.html
Issue #1549: [RFE] Implement locking modes (select for update)
PR #1548: Add AsynchronousFileChannel-based experimental FilePathAsync
PR #1547: Speedup unused chunks collection
PR #1546: Tiny optimization: use `System.arraycopy` when possible
PR #1545: Export datetime value functions to SQL using standard syntax
Issue #1371: NPE in CacheLRU
Issue #1534: Typo in message
Issue #1527: Parser performance: Excessive use of regular expressions to validate column names
PR #1543: MVStore assorted re-factorings
PR #1538: Add support for newer Lucene versions without recompilation
Issue #1536: CURRENT_TIMESTAMP result doesn't change under Transactions
Issue #239: Consider supporting Lucene 5 indexes
PR #1520: Fixes bug in PutIfAbsentDecisionMaker
Issue #1518: ENUM and VIEW with filtering on enum column
Issue #1516: Array element reference array[index] should be 1-based
Issue #1512: TestMVTableEngine.testLowRetentionTime(): NPE in VersionedValue.Type
PR #1513: Assorted minor changes
PR #1510: Add optional EXCEPT clause to wildcards
PR #1509: Use domain term everywhere
Issue #1507: Add INFORMATION_SCHEMA.COLUMNS.COLUMN_TYPE qualification for domains
Issue #1499: TestScript::envelope.sql failure in “big” mode
Issue #1498: NPE in SimpleResultSet.getColumnCount()
Issue #1495: MERGE statement doesn't affect any rows when Oracle UPDATE .. WHERE .. DELETE .. WHERE is used
Issue #1493: MERGE statement fails when it updates more than one row
Issue #1492: Unnecessary restriction on MERGE USING statement when ON clause doesn't reference any target table columns
Issue #1491: Unnecessary restriction on MERGE USING statement when ON predicate doesn't match inserted row
Issue #1490: NullPointerException when running invalid MERGE statement
Issue #1489: MERGE USING documentation has misleading railroad diagram
Issue #1488: Improve documentation of window and some other functions
Issue #1485: Default window frame in presence of ORDER BY is RANGE .., not ROWS
PR #1484: New tests, reimplemented EXCLUDE clause, and assorted changes
Issue #1338: MSSQLServer compatibility enhancements
PR #1480: Update Maven build instruction and fix some problems
PR #1478: Upgrade maven-surefire-plugin
PR #1476: Add TransactionStore to MVStore jar
Issue #1475: Dropping column used by a view produces misleading error message
Issue #1473: TestScript needs better detection of sorted result
PR #1471: issue 1350: TestCrashAPI: PageStore.freeListPagesPerList
PR #1470: Fix window functions in queries with HAVING
PR #1469: Forbid incorrect nesting of aggregates and window functions
Issue #1437: Generated as Identity has a different behaviour.
PR #1467: Fix subtraction of timestamps
PR #1464: Assorted minor changes in window processing code
PR #1463: Fix some window aggregates and reduce amount of collecting implementations
PR #1462: Separate aggregate and window code in some places
PR #1461: Add WINDOW clause support
Issue #1427: Scalability problem in MVSpatialIndex
PR #1459: Improve window clause correctness checks
PR #1457: Add NTILE(), LEAD() and LAG() window functions
PR #1456: Add experimental implementation of remaining types of window frames
PR #1454: Add FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE()
PR #1453, Issue #1161: Add ROW_NUMBER(), RANK(), DENSE_RANK(), PERCENT_RANK(), and CUME_DIST() window functions
PR #1452: Reset aggregates before reuse
PR #1451: Add experimental support for aggregates with OVER (ORDER BY *)
PR #1450: Evaluate window aggregates only once for each partition
PR #1449: Move more code from Aggregate and JavaAggregate to AbstractAggregate
PR #1448: Add experimental implementation of grouped window queries
PR #1447: Refactor OVER() processing code and fix some issues
PR #1446: fix : The French messages are bad generated (not contain DB message)
PR #1445: Use PostGIS-compatible format for SRID-only constraint in GEOMETRY
PR #1444: Add experimental unoptimized support for OVER ([PARTITION BY ...]) in aggregates
PR #1442: Bugfix - Release MVStore lock and file resources rightly even if errors when compacting database
PR #1441: Add GEOMETRY type subtypes with type and SRID constraints
PR #1434: Add support for ENUM in CAST and other changes
PR #1431: Fix some inconsistencies in documentation and improve mvn build
PR #1428: Add support for M and ZM dimensions to GEOMETRY data type
Issue #1405: Introduce LocalResult factory
PR #1422: Add ENVELOPE aggregate function
Issue #1421: Remove old-style outer join
PR #1419: Assorted minor changes
PR #1414: DEFRAG and COMPACT mixup
PR #1413: improvements to MVStore garbage collection
PR #1412: Added org.h2.store.fs package to exported osgi bundles
PR #1409: Map all remaining error codes to custom exception classes
Issue #1407: Add a MODE() aggregate function
PR #1402: Duplicate conditions in column check constraint
PR #1399: Add more subclasses of SQLException and use it for some error codes
PR #1397: Add DATEADD return type detection
Issue #1393: Add INFORMATION_SCHEMA.COLUMNS.IS_VISIBLE
PR #1392: Some refactoring and assorted minor optimizations
PR #1388: Extract UnaryOperation from Operation and other changes
PR #1386: DISK_SPACE_USED() for MVStore and other minor changes
PR #1385: split up the rather large convertTo method
PR #1384: Throw exception if unknown mode is specified in database URL
Issue #1365, PR #1382: Parse more date-time literals for compatibility with other databases
PR #1381: Minor fixes for INTERVAL data type
PR #1380: Improve documentation of intervals
Issue #1189: "Merge into using" parameters aren't found
Issue #1377: org.h2.api.Interval and TIME leftovers
PR #1376: TestMultiThreadedKernel is back
PR #1373: INTERVAL data type
Issue #1369: In MSSQL Server Mode generated UUID fields need NEWID() function
Issue #756: FunctionsMySql is not in the main jar
PR #1368: Parse BINARY VARYING, BINARY LARGE OBJECT, and CHARACTER LARGE OBJECT
PR #1367: Assorted changes with SELECT output limitation clauses
Issue #1363: Why H2 requires random own packages in OSGi bundle description?
Issue #1192: Add an Automatic-Module-Name
Issue #1361, PR #1362: Add limited support for MONEY and SMALLMONEY in compatibility modes
Issue #1327: mvn build misses some resources
PR #1359: Add system property to return OffsetDateTime from ResultSet.getObject()
PR #1357: Simplify execution flow in some places
PR #1356: Fix NPE in Query.initExpression()
PR #1355: Assorted changes in MetaTable
Issue #1352: TestCrashAPI: Prepared.getObjectId() was called before
PR #1349: Changes is conversion and comparison methods of Value
Issue #1346: Exception when using IN condition for enums
PR #1345: Replace some init methods with constructors
PR #1344: Streamline last chunk verification on startup
PR #1341: Optimize MVSecondaryIndex.convertToKey()
PR #1340: NoSuchElementException instead of returning null
PR #1339: Add support of TIMESTAMP WITH TIME ZONE to addition and subtraction operators
PR #1337: Streamline Value comparison
PR #1336: Minor refactorings
Issue #1332: Constraint name not set correctly
Rename fields to reflect actual type
Issue #1331: Regression in Database.updateMeta()
Issue #1323: Slow update after altering table in 1.4.197
PR #1326: Add support of PERCENT in FETCH and TOP clauses
PR #1325: Optimize WITH TIES in some queries and specify data types for KEY_COLUMN_USAGE
PR #1321: Do not add rows before OFFSET to result if possible
PR #1319: Treat NEXTVAL as an auto-generated key
PR #1318: Mode append fo MVPlainTempResult
PR #1314: Add ALTER VIEW RENAME command
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
PR #1312: Add Java 9+ support to NIO_CLEANER_HACK
PR #1311: Fix minor issues with ResultSet.getObject(..., Class) and WITH TIES
Issue #1298: TestKillRestartMulti: A map named undoLog.2 already exists
Issue #1307: Invalid value "null" for parameter "calendar" [90008-193]
PR #1306: Add initial implementation of WITH TIES clause
PR #1304: Update changelog and fix building of documentation
PR #1302: Use OpenJDK instead of OracleJDK 10 in Travis builds due to Travis problem
Issue #1032: Error when executing "SELECT DISTINCT ON"
Issue #1295: ConditionInSelect violates requirements of LocalResult
PR #1296: Assorted minor changes
PR #1293: Move HELP and SHOW tests into own files
PR #1291: Fix update count for REPLACE and move some SQL tests into separate files
PR #1290: Do not load the whole LOBs into memory for comparison operation
Issue #408: DISTINCT does not properly work with ORDER BY on function like LOWER
PR #1286: Fix MVTempResult implementations for results with invisible columns
Issue #1284: Nanoseconds of timestamps from old H2 versions are not read properly
PR #1283: Clean up interaction between LocalResult and ResultExternal
Issue #1265: OOME is not handled properly in TraceObject.logAndConvert()
Issue #1061: Regression: Braces after WITH clause not allowed anymore
PR #1277: Assorted changes in Parser
PR #1276: Improve support of ARRAY and SQLXML in JDBC layer
PR #1275: Do not quote other lower case characters
PR #1274: Use token type in Parser instead of string comparisons
PR #1272: Reduce code duplication in Parser
PR #1271: Minor memory leak
PR #1270: drop TableView isPersistent field
PR #1269: Eliminate commit of empty batch in some tests
Issue #1266: Add INFORMATION_SCHEMA.COLUMNS.DATETIME_PRECISION
Issue #1261: How to discover stored enum types through INFORMATION_SCHEMA
Issue #1258: Failing to remove index when using schema.table
PR #1256: misc tiny refactorings
PR #1255: Minor changes in MERGE USING, DATE_TRUNC, and EXTRACT
Issue #1214: Internal compiler believes that "3 warnings" is an error
PR #1252: Assorted minor changes
PR #1251: Fix SQL representation of CAST for types with fractional seconds precision
PR #1250: Batch append mode for MVMap
PR #1248: StringIndexOutOfBoundsException due to undoLog map
PR #1246: Detect disabled tests
PR #1242: Add implementation of SQLXML interface
PR #1241: Various tweaks in attempting to fix TestDiskFull test
PR #1240: Optimise ValueLobDB comparison methods
PR #1239: Don't try to find tools.jar on Java 9+
PR #1238: remove unfinished android API
PR #1237: remove JaQu
PR #1236: remove STORE_LOCAL_TIME code
PR #1235: Do not use deprecated Class.newInstance()
PR #1234: Fix NPE in Parser.parseMergeUsing()
PR #1233: Simplify old lob ValueLob class
Issue 1227: lob growth in pagestore mode
PR #1230: clean up some javadoc and some throws clauses
PR #1229: Create UndoLog only when necessary and remove outdated code
PR #1228: Remove some PageStore+MVCC leftovers
PR #1226: Fix inconsistencies in checks for transaction isolation level
PR #1224: Enable Java 10 testing on Travis
PR #1223: Fix issues with testing on latest Java versions
PR #1222: Leftovers handling
Issue #1220: JDK-9 build fails due to usage of java.xml.bind in external authentication
PR #1218: Test utilities only once during TestAll
PR #1217: Postpone session.endStatement() until after commit
PR #1213: KillRestart fix
PR #1211: Assorted minor changes
Issue #1204: Always use MVCC with MVStore and never use it with PageStore
PR #1206: Forbid reconnects in non-regular modes in TestScript
PR #1205: Misc test fixes
Issue 1198: Enable MULTI_THREADED by default for MVStore mode
Issue #1195: Calling setBytes to set VARCHAR field fails
PR #1197: Fix or suppress errors in tests
PR #1194: TestKillRestartMulti: A map named undoLog-1 already exists
PR #1193: enable TestRandomSQL on non-memory databases
PR #1191: External authentication with datasource issue
PR #1188: Undo log split to reduce contention
PR #1186: TransactionMap::sizeAsLong() optimized - temp map eliminated
PR #1185: Improve naming of the object id field in Prepared
Issue #1196: Feature request for MS SQL Server Compatibility Mode
Issue #1177: Resource leak in Recover tool
PR #1183: Improve concurrency of connection pool with wait-free implement
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"]
PR #1179: Drop TransactionMap.readLogId
PR #1181: Improve CURRENT_TIMESTAMP and add LOCALTIME and LOCALTIMESTAMP
PR #1176: Magic value replacement with constant
PR #1171: Introduce last committed value into a VersionedValue
PR #1175: tighten test conditions - do not ignore any exceptions
PR #1174: Remove mapid
PR #1173: protect first background exception encountered and relate it to clients
PR #1172: Yet another attempt to tighten that testing loop
PR #1170: Add support of CONTINUE | RESTART IDENTITY to TRUNCATE TABLE
Issue #1168: ARRAY_CONTAINS() returning incorrect results when inside subquery with Long elements.
PR #1167: MVStore: Undo log synchronization removal
PR #1166: Add SRID support to EWKT format
PR #1165: Optimize isTargetRowFound() and buildColumnListFromOnCondition() in MergeUsing
PR #1164: More fixes for parsing of MERGE USING and other changes in Parser
PR #1154: Support for external authentication
PR #1162: Reduce allocation of temporary strings
PR #1158: make fields final
Issue #1129: TestCrashAPI / TestFuzzOptimizations throw OOME on Travis in PageStore mode
PR #1156: Add support for SQL:2003 WITH [NO] DATA to CREATE TABLE AS
PR #1149: fix deadlock between OnExitDatabaseCloser.DATABASES and Engine.DATABASES
PR #1152: skip intermediate DbException object when creating SQLException
PR #1144: Add missing schema name with recursive view
Issue #1091: get rid of the "New" class
PR #1147: Assorted minor optimizations
PR #1145: Reduce code duplication
PR #1142: Misc small fixes
PR #1141: Assorted optimizations and fixes
PR #1138, #1139: Fix a memory leak caused by DatabaseCloser objects
PR #1137: Step toward making transaction commit atomic
PR #1136: Assorted minor optimizations
PR #1134: Detect possible overflow in integer division and optimize some code
PR #1133: Implement Comparable<Value> in CompareMode and optimize ValueHashMap.keys()
PR #1132: Reduce allocation of ExpressionVisitor instances
PR #1130: Improve TestScript and TestCrashAPI
PR #1128: Fix ON DUPLICATE KEY UPDATE with ENUM
PR #1127: Update JdbcDatabaseMetaData.getSQLKeywords() and perform some minor optimizations
PR #1126: Fix an issue with code coverage and building of documentation
PR #1123: Fix TCP version check
PR #1122: Assorted changes
PR #1121: Add some protection to ValueHashMap against hashes with the same less significant bits
Issue #1097: H2 10x slower than HSQLDB and 6x than Apache Derby for specific query with GROUP BY and DISTINCT subquery
Issue #1093: Use temporary files for ResultSet buffer tables in MVStore
PR #1117: Fix sorting with distinct in ResultTempTable
Issue #1095: Add support for INSERT IGNORE INTO <table> (<columns>) SELECT in MySQL Mode
PR #1114: Minor cleanup and formatting fixes
PR #1112: Improve test scripts
PR #1111: Use a better fix for issue with SRID
Issue #1107: Restore support of DATETIME2 with specified fractional seconds precision
Issue #1106: Get rid of SwitchSource
PR #1105: Assorted minor changes
Issue #1102: CREATE SYNONYM rejects valid definition
PR #1103: Remove redundant synchronization
Issue #1048: 1.4.197 regression. org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS"
PR #1101: Move some tests in better place and add an additional test for 2PC
PR #1100: Fix Insert.prepareUpdateCondition() for PageStore
PR #1098: Fix some issues with NULLS FIRST / LAST
Issue #1089: Parser does not quote words INTERSECTS, DUAL, TOP
Issue #230: Renaming a column does not update foreign key constraint
Issue #1091 Get rid if the New class
PR #1087: improve performance of planning large queries
PR #1085: Add tests for simple one-column index sorting
PR #1084: re-enable some pagestore testing
PR #1083: Assorted changes
Issue #394: Recover tool places COLLATION and BINARY_COLLATION after temporary tables
PR #1081: Session.getTransactionId should return a more distinguishing value
Improve the script-based unit testing to check the error code of the exception thrown.
Issue #1041: Support OR syntax while creating trigger
Issue #1023: MVCC and existing page store file
Issue #1003: Decrypting database with incorrect password renders the database corrupt
Issue #873: No error when `=` in equal condition when column is not of array type
Issue #1069: Failed to add DATETIME(3) column since 1.4.197
Issue #456: H2 table privileges referring to old schema after schema rename
Issue #1062: Concurrent update in table "SYS" caused by Analyze.analyzeTable()
Yet another fix to Page memory accounting
Replace MVStore.ASSERT variable with assertions
Issue #1063: Leftover comments about enhanced for loops
PR #1059: Assorted minor changes
PR #1058: Txcommit atomic
Issue #1038: ora_hash function implementation off by one
PR #1054: Introduce overflow bit in tx state
Issue #1047: Support DISTINCT in custom aggregate functions
PR #1051: Atomic change of transaction state
PR #1046: Split off Transaction TransactionMap VersionedValue
PR #1045: TransactionStore move into separate org.h2.mvstore.tx package
PR #1044: Encapsulate TransactionStore.store field in preparation to a move
PR #1040: generate less garbage for String substring+trim
PR #1035: Minor free space accounting changes
Issue #1034: MERGE USING should not require the same column count in tables
PR #1033: Fix issues with BUILTIN_ALIAS_OVERRIDE=1
PR #1031: Drop schema rights together with schema
PR #1029: No need to remove orphaned LOBs when the db is read-only
Issue #1027: Add support for fully qualified names in MySQL compatibility mode
Issue #178: INSERT ON DUPLICATE KEY UPDATE returns wrong generated key
PR #1025: Remove BitField and replace its usages with BitSet
Issue #1019: Console incorrectly sorts BigDecimal columns alphanumerically
PR #1021: Update JdbcDatabaseMetaData to JDBC 4.1 (Java 7)
Issue #992: 1.4.197 client cannot use DatabaseMetaData with 1.4.196 and older server
Issue #1016: ResultSet.getObject() should return enum value, not ordinal
Issue #1012: NPE when querying INFORMATION_SCHEMA.COLUMNS on a view that references an ENUM column
Issue #1010: MERGE USING table not found with qualified table
PR #1009: Fix ARRAY_AGG with ORDER BY and refactor aggregates
Issue #1006: "Empty enums are not allowed" in 1.4.197 (mode=MYSQL)
PR #1007: Copy also SRID in ValueGeometry.getGeometry()
PR #1004: Preserve type names in more places especially for UUID
Issue #1000: Regression in INFORMATION_SCHEMA.CONSTRAINTS.CONSTRAINT_TYPE content
Issue #997: Can not delete from tables with enums
Issue #994: Too much column in result set for GENERATED_KEYS on table with DEFAULT
PR #993: Fix some compiler warnings and improve assert*() methods
PR #991: Generate shorter queries in JdbcDatabaseMetaData.getTables() and remove some dead code
PR #989: Fix more issues with range table and improve its documentation
#3 Updated by Roger Borrello over 3 years ago
Seems to be rooted in this error:
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE REPORT_CELL ( RCID BIGINT, ROW[*] INT, TEXT VARCHAR, NUM DOUBLE, CONSTRAINT FK_RPTCELL_RCID FOREIGN KEY(RCID) REFERENCES REPORT_COLUMN(ID))"; expected "identifier"; SQL statement: create table report_cell ( rcid bigint, row int, text varchar, num double, constraint fk_rptcell_rcid foreign key(rcid) references report_column(id)) [42001-200]
So something is broken in ROW[*] INT syntax?
#4 Updated by Eric Faulhaber over 3 years ago
Roger Borrello wrote:
Seems to be rooted in this error:
[...]So something is broken in
ROW[*] INTsyntax?
The [*] in the error message indicates the word on which the H2 statement parser had a problem, it is not part of the syntax. In this case, it doesn't like the word ROW. I think they probably made it a reserved keyword between 1.4.197 and 1.4.200. The fix is to change our column name in the report_cell table from row to something else. This may be in a number of places.
#5 Updated by Roger Borrello over 3 years ago
Is that something I can find through the source with a grep?
#6 Updated by Eric Faulhaber over 3 years ago
- Status changed from New to Test
- Assignee set to Eric Faulhaber
- % Done changed from 0 to 100
Fixed in 3821c/11642.
I changed the name of the row column in the report_cell table to rowpos. Apparently, rownum also was made reserved, since I tried that first and it failed the same way. I successfully generated reports for the Hotel GUI sample application with the fix.
#7 Updated by Roger Borrello over 3 years ago
Thank you for handling that. I am restarting my reports.
Is there a concept of "incremental build" with reports, or should they always start clean?
#8 Updated by Greg Shah over 3 years ago
Always clean. There is no incremental.