[
https://issues.apache.org/jira/browse/DERBY-7170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-7170:
--
Description:
On a fresh database connection using org.apache.derby.jdbc.EmbeddedDriver,
using username
Lukas Eder created DERBY-7170:
-
Summary: Error [3] [42Y07]: Schema 'SA' does not exist when
joining SYS.SYSTABLES to SYS.SYSSCHEMAS when aliasing the SYSCHEMAS table
Key: DERBY-7170
URL: https://issues.apache.org/
Lukas Eder created DERBY-7164:
-
Summary: Wrong result from EXISTS aggregate subquery that counts
zero rows
Key: DERBY-7164
URL: https://issues.apache.org/jira/browse/DERBY-7164
Project: Derby
Is
[
https://issues.apache.org/jira/browse/DERBY-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635335#comment-17635335
]
Lukas Eder commented on DERBY-7148:
---
A workaround is to cast the COALESCE expression to
Lukas Eder created DERBY-7148:
-
Summary: SQL Error [2] [38000]: The exception
'java.lang.NoSuchMethodError: 'boolean
org.apache.derby.iapi.types.DataValueDescriptor.equals(boolean)'' was thrown
while evaluating an expression.
Ke
[
https://issues.apache.org/jira/browse/DERBY-7146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-7146:
--
Description:
Try this:
{code:sql}
create table x (
i int,
c varchar(10),
primary key (i)
);
mer
Lukas Eder created DERBY-7146:
-
Summary: NullPointerException when executing MERGE statement with
NULL value in INSERT clause
Key: DERBY-7146
URL: https://issues.apache.org/jira/browse/DERBY-7146
Project:
Lukas Eder created DERBY-7139:
-
Summary: Boolean expressions cannot be passed to COALESCE function
Key: DERBY-7139
URL: https://issues.apache.org/jira/browse/DERBY-7139
Project: Derby
Issue Type:
[
https://issues.apache.org/jira/browse/DERBY-2072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17154473#comment-17154473
]
Lukas Eder commented on DERBY-2072:
---
For the record, this can be circumvented by castin
[
https://issues.apache.org/jira/browse/DERBY-7009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16633688#comment-16633688
]
Lukas Eder commented on DERBY-7009:
---
{quote}Other than being puzzling, can you think of
[
https://issues.apache.org/jira/browse/DERBY-7009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-7009:
--
Description:
In the manual, there is a claim that the maximum precision for the DECIMAL data
type is 3
Lukas Eder created DERBY-7009:
-
Summary: DECIMAL(33, 3) Type cannot be used in CAST expression,
but can appear in views
Key: DERBY-7009
URL: https://issues.apache.org/jira/browse/DERBY-7009
Project: Derby
Lukas Eder created DERBY-7008:
-
Summary: Add support for COMMENT ON [ object ] IS '...' statements
Key: DERBY-7008
URL: https://issues.apache.org/jira/browse/DERBY-7008
Project: Derby
Issue Type:
[
https://issues.apache.org/jira/browse/DERBY-6983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16381758#comment-16381758
]
Lukas Eder commented on DERBY-6983:
---
I see, thanks a lot for the clarification. Indeed,
[
https://issues.apache.org/jira/browse/DERBY-6983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16377397#comment-16377397
]
Lukas Eder commented on DERBY-6983:
---
Thanks for your comment, Rick. I'm well aware of th
Lukas Eder created DERBY-6984:
-
Summary: Cannot use UNION in correlated subquery or derived table
when first UNION subquery is parenthesised
Key: DERBY-6984
URL: https://issues.apache.org/jira/browse/DERBY-6984
Lukas Eder created DERBY-6983:
-
Summary: Support SELECT * for IN predicate subqueries when it is
"obvious" that the asterisk expands to exactly one column
Key: DERBY-6983
URL: https://issues.apache.org/jira/browse/DER
[
https://issues.apache.org/jira/browse/DERBY-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16265485#comment-16265485
]
Lukas Eder commented on DERBY-4842:
---
In many years of working with SQL, I have never fel
[
https://issues.apache.org/jira/browse/DERBY-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16264302#comment-16264302
]
Lukas Eder commented on DERBY-4842:
---
This would be really useful. PostgreSQL and MySQL w
[
https://issues.apache.org/jira/browse/DERBY-6952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16095985#comment-16095985
]
Lukas Eder commented on DERBY-6952:
---
Thanks for linking. Of course, the soundest solutio
Lukas Eder created DERBY-6953:
-
Summary: Support the SQL Standard
Key: DERBY-6953
URL: https://issues.apache.org/jira/browse/DERBY-6953
Project: Derby
Issue Type: Improvement
Components
Lukas Eder created DERBY-6952:
-
Summary: Regression on Statement.getGeneratedKeys() on UPDATE
statements
Key: DERBY-6952
URL: https://issues.apache.org/jira/browse/DERBY-6952
Project: Derby
Issu
[
https://issues.apache.org/jira/browse/DERBY-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16077722#comment-16077722
]
Lukas Eder commented on DERBY-6948:
---
I see, thanks [~rhillegas]. Unfortunately, I cannot
[
https://issues.apache.org/jira/browse/DERBY-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16075961#comment-16075961
]
Lukas Eder commented on DERBY-6948:
---
I see, thanks for linking, Rick. Is there any SQL-b
[
https://issues.apache.org/jira/browse/DERBY-6948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16074772#comment-16074772
]
Lukas Eder commented on DERBY-6948:
---
>From the description, I wasn't sure if this issue
Lukas Eder created DERBY-6948:
-
Summary: INSERT .. SELECT produces NULL for getGeneratedKeys()
Key: DERBY-6948
URL: https://issues.apache.org/jira/browse/DERBY-6948
Project: Derby
Issue Type: Bug
[
https://issues.apache.org/jira/browse/DERBY-6947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-6947:
--
Description:
{code}
select
X1.A as A1,
X2.A as A2
from (
select *
from (
select 1 as A
Lukas Eder created DERBY-6947:
-
Summary: Simple query runs forever
Key: DERBY-6947
URL: https://issues.apache.org/jira/browse/DERBY-6947
Project: Derby
Issue Type: Bug
Components: SQL
[
https://issues.apache.org/jira/browse/DERBY-6813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14567613#comment-14567613
]
Lukas Eder commented on DERBY-6813:
---
[~bryanpendleton]: Thanks for the hints. I'm just h
Lukas Eder created DERBY-6813:
-
Summary: Undocumented ON DELETE SET DEFAULT is parsed, accepted,
but not enforced
Key: DERBY-6813
URL: https://issues.apache.org/jira/browse/DERBY-6813
Project: Derby
Lukas Eder created DERBY-6812:
-
Summary: Make "RESTRICT" an optional keyword in "DROP SEQUENCE"
Key: DERBY-6812
URL: https://issues.apache.org/jira/browse/DERBY-6812
Project: Derby
Issue Type: Im
[
https://issues.apache.org/jira/browse/DERBY-6757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder closed DERBY-6757.
-
Resolution: Not a Problem
> Driver.connect() returns null when using file-based URL
>
[
https://issues.apache.org/jira/browse/DERBY-6757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173365#comment-14173365
]
Lukas Eder commented on DERBY-6757:
---
Hmm, interesting - I had realised my mistake and I
[
https://issues.apache.org/jira/browse/DERBY-6758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder closed DERBY-6758.
-
Resolution: Invalid
> Driver.connect() returns null when using file-based URL
> --
[
https://issues.apache.org/jira/browse/DERBY-6758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14160341#comment-14160341
]
Lukas Eder commented on DERBY-6758:
---
Oh man. I just now realised that I wasn't using
{c
Lukas Eder created DERBY-6757:
-
Summary: Driver.connect() returns null when using file-based URL
Key: DERBY-6757
URL: https://issues.apache.org/jira/browse/DERBY-6757
Project: Derby
Issue Type: B
Lukas Eder created DERBY-6758:
-
Summary: Driver.connect() returns null when using file-based URL
Key: DERBY-6758
URL: https://issues.apache.org/jira/browse/DERBY-6758
Project: Derby
Issue Type: B
[
https://issues.apache.org/jira/browse/DERBY-1576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13985423#comment-13985423
]
Lukas Eder commented on DERBY-1576:
---
Very nice, I wasn't aware of this interpretation of
[
https://issues.apache.org/jira/browse/DERBY-1576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13985333#comment-13985333
]
Lukas Eder commented on DERBY-1576:
---
Hmm, apart from MS Access (which doesn't have a CAS
[
https://issues.apache.org/jira/browse/DERBY-1576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13985333#comment-13985333
]
Lukas Eder edited comment on DERBY-1576 at 4/30/14 9:48 AM:
Hm
Lukas Eder created DERBY-6489:
-
Summary: Add support for the SQL Standard ALTER SEQUENCE statement
Key: DERBY-6489
URL: https://issues.apache.org/jira/browse/DERBY-6489
Project: Derby
Issue Type:
[
https://issues.apache.org/jira/browse/DERBY-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13903113#comment-13903113
]
Lukas Eder commented on DERBY-896:
--
That is great, thank you very much, guys!
> Cast date
[
https://issues.apache.org/jira/browse/DERBY-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13899283#comment-13899283
]
Lukas Eder commented on DERBY-896:
--
I can reproduce this issue with
{code}
select current
Lukas Eder created DERBY-6444:
-
Summary: Add support for INSERT INTO table DEFAULT VALUES syntax
Key: DERBY-6444
URL: https://issues.apache.org/jira/browse/DERBY-6444
Project: Derby
Issue Type: I
[
https://issues.apache.org/jira/browse/DERBY-4138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13666467#comment-13666467
]
Lukas Eder commented on DERBY-4138:
---
See also DERBY-6228, where adding an ORDER BY claus
Lukas Eder created DERBY-6228:
-
Summary: DisconnectException when executing an SELECT [LOB column]
ORDER BY [...] statement with TYPE_SCROLL_[IN]SENSITIVE and CONCUR_UPDATABLE
Key: DERBY-6228
URL: https://issues.apach
[
https://issues.apache.org/jira/browse/DERBY-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428647#comment-13428647
]
Lukas Eder edited comment on DERBY-5893 at 8/4/12 5:39 PM:
---
Yes,
[
https://issues.apache.org/jira/browse/DERBY-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428647#comment-13428647
]
Lukas Eder edited comment on DERBY-5893 at 8/4/12 5:39 PM:
---
Yes,
[
https://issues.apache.org/jira/browse/DERBY-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428647#comment-13428647
]
Lukas Eder commented on DERBY-5893:
---
Yes, it's different in the way it handles NULLs. Fo
Lukas Eder created DERBY-5893:
-
Summary: Add support for the SQL:2008 standard IS [ NOT ] DISTINCT
FROM predicate
Key: DERBY-5893
URL: https://issues.apache.org/jira/browse/DERBY-5893
Project: Derby
Lukas Eder created DERBY-5837:
-
Summary: Add support for SQL standard DATE, TIME, TIMESTAMP
literals
Key: DERBY-5837
URL: https://issues.apache.org/jira/browse/DERBY-5837
Project: Derby
Issue Ty
Support for RPAD, LPAD, REPEAT string functions
---
Key: DERBY-5320
URL: https://issues.apache.org/jira/browse/DERBY-5320
Project: Derby
Issue Type: Improvement
Components: SQL
Affect
[
https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder closed DERBY-5005.
-
> Error when fully qualifying a field from a view in an ORDER BY clause
> ---
[
https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13033611#comment-13033611
]
Lukas Eder commented on DERBY-5005:
---
Works for me in 10.8. Thanks guys
> Error when ful
Add support for GREATEST and LEAST functions
Key: DERBY-5216
URL: https://issues.apache.org/jira/browse/DERBY-5216
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Vers
[
https://issues.apache.org/jira/browse/DERBY-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13028205#comment-13028205
]
Lukas Eder commented on DERBY-3893:
---
I think so too, this would be very useful
> Implem
Make DATETIME arithmetic functions easier to use
Key: DERBY-5214
URL: https://issues.apache.org/jira/browse/DERBY-5214
Project: Derby
Issue Type: Improvement
Components: JDBC, SQL
[
https://issues.apache.org/jira/browse/DERBY-4379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13011803#comment-13011803
]
Lukas Eder commented on DERBY-4379:
---
I am missing this feature as well. Many databases s
[
https://issues.apache.org/jira/browse/DERBY-5130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13007057#comment-13007057
]
Lukas Eder commented on DERBY-5130:
---
Hmm, you're right. I agree that it is consistent wi
Allow for LONG VARCHAR to be compared to LONG VARCHAR
-
Key: DERBY-5130
URL: https://issues.apache.org/jira/browse/DERBY-5130
Project: Derby
Issue Type: Improvement
Components: SQ
[
https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12994245#comment-12994245
]
Lukas Eder commented on DERBY-5005:
---
Should I verify the correctness of the fix before c
[
https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12992506#comment-12992506
]
Lukas Eder commented on DERBY-5005:
---
Excellent guys! That was really quick! :-)
> Error
[
https://issues.apache.org/jira/browse/DERBY-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12991490#comment-12991490
]
Lukas Eder commented on DERBY-5006:
---
Thanks for the insight! I am sure that SQL is a bea
[
https://issues.apache.org/jira/browse/DERBY-5006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12991400#comment-12991400
]
Lukas Eder commented on DERBY-5006:
---
Hi Rick! Thanks for your feedback. I'm happy if I c
Handle NULL literals like any other database
Key: DERBY-5006
URL: https://issues.apache.org/jira/browse/DERBY-5006
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Vers
[
https://issues.apache.org/jira/browse/DERBY-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukas Eder updated DERBY-5005:
--
Description:
I have a strange issue that can be reproduced easily with the following objects
in schema
Error when fully qualifying a field from a view in an ORDER BY clause
-
Key: DERBY-5005
URL: https://issues.apache.org/jira/browse/DERBY-5005
Project: Derby
Issue Type: Bug
[
https://issues.apache.org/jira/browse/DERBY-2374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12990938#comment-12990938
]
Lukas Eder edited comment on DERBY-2374 at 2/5/11 8:41 AM:
---
Than
[
https://issues.apache.org/jira/browse/DERBY-2374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12990938#comment-12990938
]
Lukas Eder commented on DERBY-2374:
---
Thanks for all the detailed analyses. This would be
69 matches
Mail list logo
