int fid, total, who;
char *entity, ftype[32], *access;
int var_phys_id = 0;
+ short int total_null;
EXEC SQL END DECLARE SECTION;
type = argv[2];
total = 0;
EXEC SQL REPEATED DELETE FROM quota
WHERE type = 'ANY' AND filsys_id = :fid;
- EXEC SQL SELECT SUM (quota) INTO :total FROM quota
+ EXEC SQL SELECT SUM (quota) INTO :total:total_null FROM quota
WHERE filsys_id = :fid AND phys_id != 0;
if (ingres_errno) return(mr_errcode);
- if (total != 0) {
+ if (!total_null && (total != 0)) {
/*
* append quota (quota = total, filsys_id = fid,
* phys_id = 0, entity_id = 0, type = "ANY",
EXEC SQL set lockmode session where readlock = system;
#endsql
#endif
+ return(MR_SUCCESS);
}