Jack Klebanoff wrote:
RPost wrote:
...
Anyway, I think you meant to compare UNION (or UNION ALL) and
INTERSECT here (as you did EXCEPT/INTERSECT below this) to illustrate
the higher precedence of INTERSECT.
Yes. I included the UNION/UNION ALL example because it is important to
get the associa
[ http://issues.apache.org/jira/browse/DERBY-155?page=history ]
Jeremy Boynes resolved DERBY-155:
-
Resolution: Fixed
Fix Version: 10.1.0.0
Sendingjava\engine\org\apache\derby\impl\sql\compile\sqlgrammar.jj
Sending
java\testing\o
Hi,
Don't know why the system was coded to throw exception for duplicate
columns but it seems like it has been around in Cloudscape from very
beginning.
I only looked at this briefly, so please don't take this as the final word or anything--but here's one reason why we
might want to throw an erro
On Mon, 28 Feb 2005 19:57:59 +0100 (CET), Bernd Ruehlicke (JIRA)
wrote:
> [
> http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_59875 ]
>
> Bernd Ruehlicke commented on DERBY-147:
> ---
>
> Ok I made the changes and build Derby - and tes
[ http://issues.apache.org/jira/browse/DERBY-155?page=history ]
Jeremy Boynes reassigned DERBY-155:
---
Assign To: Jeremy Boynes
> Add DISTINCT keyword support to INTERSECT and EXCEPT
>
>
> Key
Daniel John Debrunner wrote:
Jeremy Boynes wrote:
Reserving additional words from the second group poses a bigger issue as
users' may have databases out there already using these words as
identifiers. The smoothest path is probably to give people an indication
of which words will need to be reserv
[ http://issues.apache.org/jira/browse/DERBY-152?page=history ]
Daniel John Debrunner updated DERBY-152:
type: Wish (was: Bug)
> ERROR 42X01: Syntax error: Encountered "commit" at line 1, column 1.
> -
Jeremy Boynes wrote:
>
> Reserving additional words from the second group poses a bigger issue as
> users' may have databases out there already using these words as
> identifiers. The smoothest path is probably to give people an indication
> of which words will need to be reserved at some point a
On Mon, 21 Feb 2005 11:58:36 -0800, Mamta Satoor <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have addressed the comments made by Dan for performance. Here is the
> new patch. Let me know what you all think.
>
> The comments made by Dan can be found in following thread
> http://mail-archives.eu.apache.
Shreyas Kaushik wrote:
> Please see below for my replies.
>
> ~ Shreyas
>
> Daniel John Debrunner wrote:
>> I think a detailed explanation of what you believe cancel and
>> setQueryTimeout functionality should be would be very useful. I'm not
>> sure closing the activation actually results in th
Any idea if many more queries will now spill to disk? I am worried that
many more will, and now queries will run slower. Seems like there
should be a better connection between the optimizer estimate to use
in memory hash and what actually is done in memory. As I understand it
now the Optimizer
[
http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_59875 ]
Bernd Ruehlicke commented on DERBY-147:
---
Ok I made the changes and build Derby - and tested it - seams to work.
We may consider to make this change permanent.
Any rea
Add DISTINCT keyword support to INTERSECT and EXCEPT
Key: DERBY-155
URL: http://issues.apache.org/jira/browse/DERBY-155
Project: Derby
Type: Improvement
Components: SQL
Versions: 10.1.0.0
Reporter:
Jack Klebanoff wrote:
RPost wrote:
>Jack Klebanoff wrote:
>The syntax is (roughly):
/>queryExpression/ INTERSECT [ALL] /queryExpression/
/>queryExpression/ EXCEPT [ALL] /queryExpression/
Although DISTINCT is implicit if ALL is not specified the SQL standard
also allows the DISTINCT operator to
RPost wrote:
>Jack Klebanoff wrote:
>The syntax is (roughly):
/>queryExpression/ INTERSECT [ALL] /queryExpression/
/>queryExpression/ EXCEPT [ALL] /queryExpression/
Although DISTINCT is implicit if ALL is not specified the SQL standard
also allows the DISTINCT operator to be specified explicitl
I'm pleased to announce that Jeremy Boynes has joined the Derby PPMC.
regards,
-jean
16 matches
Mail list logo
