Tracker: Bugs

1 MERGE with constant in <search condition> fails - ID: 3602595
Last Update: Comment added ( Sergey Parhomenko )

Given a simple table like this:
CREATE TABLE q (id INT PRIMARY KEY)

And trying to run this MERGE statement:
MERGE INTO q USING (VALUES(1)) ON id = 1 WHEN MATCHED THEN UPDATE SET id = 1 WHEN NOT MATCHED THEN INSERT VALUES (1)

I receive this error: "user lacks privilege or object not found: SYSTEM_SUBQUERY".
Exactly same query used to work with HSQLDB 2.2.8 and before, but is not working both on 2.2.9 and latest 2.3.0 snapshot.

This type of queries is used by Liquibase <loadUpdateData> tag on HSQLDB (see this pull request - https://github.com/liquibase/liquibase/pull/22).


Sergey Parhomenko ( Sergey Parhomenko ) - 2013-01-29 16:01:13 PST

1

Open

Fixed

Fred Toussi

engine 2.0

current-release

Public


Comments ( 2 )

Date: 2013-02-04 01:45:48 PST
Sender: Sergey Parhomenko

Thanks a lot for the fix. Do you have any plans for a new snapshot release
any time soon?


Date: 2013-01-30 10:00:26 PST
Sender: fredtProject Admin

Thanks for reporting.

Fixed and committed to SVN.


Attached File

No Files Currently Attached

Changes ( 4 )

Field Old Value Date By
assigned_to nobody 2013-01-30 10:00:27 PST fredt
priority 5 2013-01-30 10:00:27 PST fredt
artifact_group_id None 2013-01-30 10:00:27 PST fredt
resolution_id None 2013-01-30 10:00:27 PST fredt