Unanswered: Null value eliminated - but no aggregate function
A colleague is running the following in ISQL (for ASA184.108.40.20627)
create variable current_transaction varchar(30);
WHERE note_type.note_type_id = note.note_type_id
AND note_type.code = 'Extra'
AND note.text = 'This Vehicle is Located In Alice Springs';
drop variable current_transaction;
(The ROLLBACK is only there until we resolve this issue)
During execution the warning comes up:
"Null value eliminated in aggregate function" (SQLCODE=109, ODBC 3 State="01003") Line 13, column 1 (on the DELETE statement).
Examining the NOTE table, it has a trigger before delete which reads as follows:
ALTER TRIGGER "tdb_note" .tdb_note before delete on auction.note
referencing old as old_del
for each row
if current remote user is null then
insert into auction.note_audit(note_id,
There are no other triggers on the table.
Selecting the rows that are supposed to be deleted shows 432 records. Using the Profiling feature shows that the INSERT statement in this trigger is called 432 times.
Any suggestions why we're getting this aggregate function warning? Similar triggers on other tables haven't caused this issue (that we're aware of!)