maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #12775
Accessing read records during join for condition pushdown
-
To:
"maria-developers@xxxxxxxxxxxxxxxxxxx" <maria-developers@xxxxxxxxxxxxxxxxxxx>
-
From:
"Berrocal, Eduardo" <eduardo.berrocal@xxxxxxxxx>
-
Date:
Tue, 6 Jul 2021 23:12:39 +0000
-
Accept-language:
en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=intel.com; dmarc=pass action=none header.from=intel.com; dkim=pass header.d=intel.com; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=4Pcc3T4bWa5sLyep24JVXDu5HfDQQQob0Xw0qazLF68=; b=iYaZF03Qsg/OpuQGljVJs9J6ssfAEM0sSN5i4UyaLqeJCvpq8EsIDqfiBTaohz4A6FeBHKxtuFs/UyypTlJxkNs9MGa8lVPSd5XrqZSO7KNSvbB28y/+6qEZEZEGmqHbGMLJT3ygO9fGMjldEXOfcLXZlwR6aAQFRSXKZOR5OpNrDZYgYpvqygYSrFh7UFHrFZyKmv4K9lU6ATLD/zGdWtl3rtAEZFTL8l6iO0Knrw326vEPMcn2HgiLJThUgmPCMsk9J2SH8t1YE7ko5mwfBWSBnHj4fO4nOLA9P16d87+WDT1Piyb1tLYcCfytak/8ayBCri0PFxpyKGcMOKBmmw==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Tcr3SG2yH3KBA8FmC+PPn+n/ikba2GroEwPn7m4rWoDT4qf3wWgrsrnjnwpN1ezHfUqoSnFZ7ksk/LityUPY1ioPoDO/wpsoEa0+V0gSOlhVPe7A2M3D4tAWjtUfvr/W/gbh2ecu0QFSjo8Ifl/16HDFYQ2ElgkvW91p6i6u8BmOT+BZFjuS89C4LANzlF9xxKZ7MZqGdLvAvKoo1A10mk9k3vMcE6r6tXjPrRnqi+SRziGpQbcScl0TsAuSE0hrAkCySYGdk8mU7z7zZjw+xBtXYdJWX53YAYH5szUhNprnvlLurnPKx3FhY4LK9EHC2/CErTlU3oJoO8XpVMcd0Q==
-
Authentication-results:
lists.launchpad.net; dkim=none (message not signed) header.d=none;lists.launchpad.net; dmarc=none action=none header.from=intel.com;
-
Dlp-product:
dlpe-windows
-
Dlp-reaction:
no-action
-
Dlp-version:
11.5.1.3
-
Thread-index:
Addyu53/Di069vVzQH+2/nbHVe69JA==
-
Thread-topic:
Accessing read records during join for condition pushdown
Hello list (first email here, hopefully sending it to the right address),
I have been trying to solve this problem for a while now, and I am stuck. I wonder if what I am trying to do is even possible.
I am implementing a new storage engine which handles engine condition pushdown. Now, when MariaDB is working on a JOIN using more than one table (for simplicity, let's assume 2), how can I access the read records for table 1 when working on a condition pushdown for table 2? When joining like this: table1.field1 = table2.field1, I can see 2 Item objects of type FIELD in the condition. However, I can't find where the read records for table1 are so I can effectively filter records in table2 by those values.
Thanks a lot for your help,
[A close up of a sign Description automatically generated]
Eduardo Berrocal García de Carellán
Senior Software Engineer
Intel Corporation | intel.com<http://intel.com/>
Follow ups
