Limit query no longer supported?

View: New views
4 Messages — Rating Filter:   Alert me  

Limit query no longer supported?

by Rob Gansevles :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I ran the following on the latest from svn, it gives a syntax error:
Error: unexpected token: 2
SQLState:  42581
ErrorCode: -5581


sql:
create table tst (x int)

select top 2 x from tst


Is limit in select no longer supported?

Rob

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Limit query no longer supported?

by Fred Toussi-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.
 It works fine.
 
Fred
On Tue, 10 Nov 2009 09:48 +0100, "Rob Gansevles" <rgansevles@...> wrote:
Hi,

I ran the following on the latest from svn, it gives a syntax error:
Error: unexpected token: 2
SQLState:  42581
ErrorCode: -5581


sql:
create table tst (x int)

select top 2 x from tst


Is limit in select no longer supported?

Rob

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Limit query no longer supported?

by Rob Gansevles :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hmm, Can't reproduce it anymore after another svn update.

Now the change for issue 2887855 (Select keeps readlock even if
resultset is processed) seems to have gone.
I did test the other day and saw it fixed but with the latest from svn
(/svnroot/hsqldb/base/trunk) the HsqlSelectLock sample program is
hanging again.

Am i doing something wrong?

Rob


On Tue, Nov 10, 2009 at 1:10 PM, Fred Toussi
<fredt@...> wrote:

>
>  It works fine.
>
> Fred
> On Tue, 10 Nov 2009 09:48 +0100, "Rob Gansevles" <rgansevles@...> wrote:
>
> Hi,
>
> I ran the following on the latest from svn, it gives a syntax error:
> Error: unexpected token: 2
> SQLState:  42581
> ErrorCode: -5581
>
>
> sql:
> create table tst (x int)
>
> select top 2 x from tst
>
>
> Is limit in select no longer supported?
>
> Rob
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Limit query no longer supported?

by Fred Toussi-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes, today there was a report that probably the change for the read lock
resulted in some locks not releasing, so I reverted until further review
and tests.

You can try the previous revision 3280 which does not have this change.

Fred

On Tue, 10 Nov 2009 21:26 +0100, "Rob Gansevles" <rgansevles@...>
wrote:

> Hmm, Can't reproduce it anymore after another svn update.
>
> Now the change for issue 2887855 (Select keeps readlock even if
> resultset is processed) seems to have gone.
> I did test the other day and saw it fixed but with the latest from svn
> (/svnroot/hsqldb/base/trunk) the HsqlSelectLock sample program is
> hanging again.
>
> Am i doing something wrong?
>
> Rob
>
>
> On Tue, Nov 10, 2009 at 1:10 PM, Fred Toussi
> <fredt@...> wrote:
> >
> >  It works fine.
> >
> > Fred
> > On Tue, 10 Nov 2009 09:48 +0100, "Rob Gansevles" <rgansevles@...> wrote:
> >
> > Hi,
> >
> > I ran the following on the latest from svn, it gives a syntax error:
> > Error: unexpected token: 2
> > SQLState:  42581
> > ErrorCode: -5581
> >
> >
> > sql:
> > create table tst (x int)
> >
> > select top 2 x from tst
> >
> >
> > Is limit in select no longer supported?
> >
> > Rob
> >
> > ------------------------------------------------------------------------------
> > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> > trial. Simplify your report design, integration and deployment - and focus on
> > what you do best, core application coding. Discover what's new with
> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsqldb-user@...
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and
> focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user