[ 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)