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)

Reply via email to