RE: LIMIT and ORDER BY in sub-queries

2016-12-21 Thread Eric Owhadi
Ah, Obviously, thanks Dave I don't know what I was thinking :), Eric From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Wednesday, December 21, 2016 2:49 PM To: user@trafodion.incubator.apache.org Subject: RE: LIMIT and ORDER BY in sub-queries I haven't tried the ANSI OLAP s

RE: LIMIT and ORDER BY in sub-queries

2016-12-21 Thread Dave Birdsall
d. >> From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Wednesday, December 21, 2016 12:30 PM To: user@trafodion.incubator.apache.org Subject: RE: LIMIT and ORDER BY in sub-queries Hi Dave, I thought about hat, but this cannot work without ORDER BY support. This will only address the

RE: LIMIT and ORDER BY in sub-queries

2016-12-21 Thread Eric Owhadi
@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: LIMIT and ORDER BY in sub-queries Hello Trafodioneers, I see that we are not supporting LIMIT inside subqueries, and that ORDER BY inside subqueries are ignored. Is there a CQD to change this default behavior? Thanks in advance f

RE: LIMIT and ORDER BY in sub-queries

2016-12-21 Thread Dave Birdsall
@trafodion.incubator.apache.org Subject: LIMIT and ORDER BY in sub-queries Hello Trafodioneers, I see that we are not supporting LIMIT inside subqueries, and that ORDER BY inside subqueries are ignored. Is there a CQD to change this default behavior? Thanks in advance for the help, Eric

LIMIT and ORDER BY in sub-queries

2016-12-21 Thread Eric Owhadi
Hello Trafodioneers, I see that we are not supporting LIMIT inside subqueries, and that ORDER BY inside subqueries are ignored. Is there a CQD to change this default behavior? Thanks in advance for the help, Eric