#1279 MERGE with constant in <search condition> fails

current-release
closed-fixed
1
2013-12-30
2013-01-30
Anonymous
No

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\).

Discussion

  • Fred Toussi

    Fred Toussi - 2013-01-30

    Thanks for reporting.

    Fixed and committed to SVN.

     
  • Fred Toussi

    Fred Toussi - 2013-01-30
    • assigned_to: nobody --> fredt
    • priority: 5 --> 1
    • milestone: --> current-release
    • status: open --> open-fixed
     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2013-02-04

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

     
  • Fred Toussi

    Fred Toussi - 2013-12-30
    • status: open-fixed --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks