DROP TABLE IF EXISTS "GenericReadList" ; CREATE TEMP TABLE "GenericReadList"( "ComputerProfileId" int NOT NULL, "Trustee" uuid NOT NULL, "AccessControlType" smallint NULL, "AceOrder" int NULL );
INSERT INTO "GenericReadList"
SELECT t1."ComputerProfileId", t1."Trustee", t1."AccessControlType", t1."AceOrder" FROM
(
SELECT a."ComputerProfileId", s."ADUser" "Trustee", a."AccessControlType", a."AceOrder" FROM "TmpResult" r
INNER JOIN "TmpTrusteeSid" s ON s."ADUser" = r."Trustee"
INNER JOIN "AccessRights" a ON a."TrusteeSid" = s."Sid" AND r."ComputerProfileId" = a."ComputerProfileId" AND a."AccessRight" = 4
) t1
On Mon, Oct 28, 2019 at 5:56 PM Michael Paquier <michael@paquier.xyz> wrote:
On Mon, Oct 28, 2019 at 09:51:07AM -0700, ZhenHua Cai wrote: > The following is the SQL statement of that function. > > DROP TABLE IF EXISTS "GenericReadList" ; > CREATE TEMP TABLE "GenericReadList"( > "ComputerProfileId" int NOT NULL, > "Trustee" uuid NOT NULL, > "AccessControlType" smallint NULL, > "AceOrder" int NULL > );
The original complain comes from a function called ComputeComputer. What does it do and where does it come from? Does it call any in-core code which would cause the failure. If the function is a SQL function, could you provide a self-contained test case? -- Michael