#275 Simplify LOCK TABLE syntax

open
Fred Toussi
engine (144)
1
2014-05-04
2012-03-02
Anonymous
No

The current HSQL syntax requires a LOCK statement to include several unnecessary keywords:

LOCK TABLE <my_table> READ

It would be nice to have TABLE as an optional keyword, and READ to be default mode. With this you could instead write:

LOCK <my_table>

The purpose of this is to increase compatibility with other SQL databases (like postgres).

Discussion


  • Anonymous
    2012-03-02

    • summary: Simplify LOCK syntax --> Simplify LOCK TABLE syntax
     
  • Fred Toussi
    Fred Toussi
    2012-05-13

    • priority: 5 --> 1
    • assigned_to: nobody --> fredt
     
  • Fred Toussi
    Fred Toussi
    2012-05-13

    Your Feature Request has been accepted and is pending assignment.

    Thank you for your support of the hsqldb Engine Project!!!

     
  • Fred Toussi
    Fred Toussi
    2012-05-13

    May allow this in the next version