db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1967) UNION (ALL) contraint violation problem
Date Tue, 17 Oct 2006 23:35:36 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1967?page=comments#action_12443116 ] 
A B commented on DERBY-1967:

Thanks for the quick turn-around on this, Yip.

Your description of the problem sounds correct to me and the changes themselves match what
you say.  They also line up with DERBY-7 as the code in question was added as part of that

I confirmed that the patch applies cleanly to trunk and that the new test case fails without
your changes and passes with it.  The code comments also indicate why the change was necessary,
which is great.

It's a pretty small change, it makes sense to me, and derbayll passed.  So I vote +1 to commit...

> UNION (ALL) contraint violation problem
> ---------------------------------------
>                 Key: DERBY-1967
>                 URL: http://issues.apache.org/jira/browse/DERBY-1967
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:,
>         Environment: derby v10.1.3.1 and v10.2.1.6 on linux (FC5), jdk  1.5.0_06-b05
> and jdk  1.6.0-rc-b99.
>            Reporter: Radu Radutiu
>         Assigned To: Yip Ng
>         Attachments: derby1967-trunk-diff01.txt, derby1967-trunk-stat01.txt
> The following simple test case gives an error:
> create table a (f1 varchar(10));
> create table b (f2 varchar(10));
> insert into b values('test');
> select  nullif('x','x') as f0, f1 from a
>    union all
>    select  nullif('x','x') as f0,  nullif('x','x') as f1 from b;
> ERROR 23502: Column 'F0'  cannot accept a NULL value.
> SQLState(23502) vendor code(30000)
> However the following works ok:
> drop table a;
> drop table b;
> create table a (f1 int);
> create table b (f2 int);
> insert into b values(1);
> select  nullif('x','x') as f0, f1 from a
>    union all
>    select  nullif('x','x') as f0, nullif(1,1) as f1 from b;
> The test case is a simplification of a query generated by Hibernate
> with the table per class inheritance strategy. Both queries work ok on
> MSSQL and PostgreSQL. On Derby only the second query works, the first
> one giving a contraint violation.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message