db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-7025) Capturar valor Null en Resulset de Netbeans
Date Thu, 27 Dec 2018 19:18:00 GMT

    [ https://issues.apache.org/jira/browse/DERBY-7025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16729795#comment-16729795

Rick Hillegas commented on DERBY-7025:

I'm afraid that I don't understand the problem you are describing. The following script shows
the NULL-handling behavior of the SUM aggregate, as described at http://db.apache.org/derby/docs/10.14/ref/rrefsqlj13083.html

ij> connect 'jdbc:derby:memory:db;create=true';
ij> create table t(a int, b int, c int);
0 rows inserted/updated/deleted
ij> insert into t values (1, 1, null), (100, null, null);
2 rows inserted/updated/deleted
ij> select sum(a), sum(b), sum(c) from t;
1          |2          |3          
101        |1          |NULL       
WARNING 01003: Null values were eliminated from the argument of a column function.

1 row selected

Can you describe more exactly what you are trying to accomplish with your query and what value
you expect the SUM aggregate to return?

> Capturar valor Null en Resulset de Netbeans
> -------------------------------------------
>                 Key: DERBY-7025
>                 URL: https://issues.apache.org/jira/browse/DERBY-7025
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>         Environment: Netbeans.
>            Reporter: Jonathan Alvarado Murillo
>            Priority: Major
> Hi, I have a trouble trying to capture the null value of a resultset at Netbeans, if
i do this "select SUM(APP.TBLOBJECONT.leccObje) as leccionesAsignadas from APP.TBLOBJECONT
where tblobjecont.tablaId="+idTabla", it doesnt send me null value, send me a blank record,
no null nor " ", i'm trying to capture this value but i can't. What i have to capture?

This message was sent by Atlassian JIRA

View raw message