if ((mr_errcode = prefetch_value(q, argv, cl)) != MR_SUCCESS)
return mr_errcode;
+ /* If this is an UPDATE query, we're done. */
+ if (row == 2)
+ return MR_SUCCESS;
+
+ /* For an add query, we need to fill in the creator id. */
+ sprintf(argv[q->argc + q->vcnt + 1], "%d", cl->client_id);
return MR_SUCCESS;
}
WHERE mach_id = :id;
if (cnt > 0)
return MR_IN_USE;
+ EXEC SQL SELECT COUNT(member_id) INTO :cnt FROM imembers
+ WHERE member_type = 'MACHINE' and member_id = :id;
+ if (cnt > 0)
+ return MR_IN_USE;
EXEC SQL DELETE FROM mcmap WHERE mach_id = :id;
if (dbms_errno)
/* Don't allow Private subnets to be created without a valid billing
* number.
*/
- if (status == SNET_STATUS_PRIVATE)
+ if (status == SNET_STATUS_PRIVATE_10MBPS ||
+ status == SNET_STATUS_PRIVATE_100MBPS ||
+ status == SNET_STATUS_PRIVATE_1000MBPS)
{
EXEC SQL SELECT account_number FROM accountnumbers
WHERE account_number = :account_number;
if (cnt > 0)
return MR_IN_USE;
+ EXEC SQL SELECT count(name) INTO :cnt FROM containers
+ WHERE acl_id = :id AND acl_type = 'LIST';
+ if (cnt > 0)
+ return MR_IN_USE;
+
+ EXEC SQL SELECT count(name) INTO :cnt FROM containers
+ WHERE memacl_id = :id AND memacl_type = 'LIST';
+ if (cnt > 0)
+ return MR_IN_USE;
+
return MR_SUCCESS;
}