Arturo Bernal created JSPWIKI-1373:
--------------------------------------
Summary: The HSQL script that creates the user database tables
lacks the oldhashes column
Key: JSPWIKI-1373
URL: https://issues.apache.org/jira/browse/JSPWIKI-1373
Project: JSPWiki
Issue Type: Bug
Reporter: Arturo Bernal
JDBCUserDatabase writes the oldhashes column on every new user (since
JSPWIKI-1234), but hsql.ddl, the script the war ships to create the tables,
does not define it. With a database created from that script the profile of a
new user cannot be saved: the INSERT fails with "user lacks privilege or object
not found: OLDHASHES".
Checked with HSQLDB 2.7.4: the INSERT statement of JDBCUserDatabase fails
against the tables created by hsql.ddl and succeeds once the column is added.
The script of the integration tests had the same gap.
The PostgreSQL script (postgresql.ddl) has a separate problem: it uses HSQL
types and a trailing comma, so the users table is not created on PostgreSQL 16.
It is not part of this issue.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)