You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2018/12/27 19:18:00 UTC
[jira] [Commented] (DERBY-7025) Capturar valor Null en Resulset de
Netbeans
[ 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
{noformat}
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
{noformat}
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: 10.14.2.0
> 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
(v7.6.3#76005)