No, it doesn't call any in-core code.
The following is the code in 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
);
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
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@xxxxxxxxxxx> 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
