Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMzKJ-003mSA-8w for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jul 2023 23:14:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMzKG-009toC-Js for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jul 2023 23:14:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMzKG-009to4-8C for pgsql-hackers@lists.postgresql.org; Fri, 21 Jul 2023 23:14:20 +0000 Received: from mail-pf1-x429.google.com ([2607:f8b0:4864:20::429]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qMzKC-0011JT-0B for pgsql-hackers@postgresql.org; Fri, 21 Jul 2023 23:14:19 +0000 Received: by mail-pf1-x429.google.com with SMTP id d2e1a72fcca58-666eef03ebdso1629778b3a.1 for ; Fri, 21 Jul 2023 16:14:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=timescale.com; s=google; t=1689981254; x=1690586054; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=cx/73VRRI7vIGyxZx9rH/r/zKqOHsjIgwCRGR1hKknU=; b=feLSv3CfpQCvMgfBJDI5FgVr+jCmb4cskChO28Uppl1MNa983eEBVjW9vuID8J+fv5 tTHjXMvzy9SufocYlGfVqRk6CP56NTNwru9GGWKbqEiUZCwyWtCr6Vr61lSeIYpuFEIY uv22FUUuKAvu1bRQbdlv3K2OccnB1QIf38RS32/1vOfz4EXv/8v1yL4/2/PvIySP3W8f 4kJSVx8ydPoEKxiTib3sD1fGckbc3Xq6WOsVrWKp7SIM8pa9p30+rdnKx4TkyDkZ1e5w 7AZFQNwI3yFNU5VN4E9LF4edxX3qeV9cftJLdOg52My0xrSwKMGo+pC5r0S80CfF0yCh Yz3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689981254; x=1690586054; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=cx/73VRRI7vIGyxZx9rH/r/zKqOHsjIgwCRGR1hKknU=; b=B1cwiPMpjqzkmSXPkZzw3Fs9qhTqJKhOdUwWhYwnLwheo8+rcM2w9iuY5E9if1+6Qz 5MW82O/mAovQ9U2x0XEET0ls6ZNEVtwun6/PpSMJmAULZM1CHujHdmsmDUXIjIAHOaPN oPpYlCjiIz/pdPpzFmf8y2z4vA5Tj+XuR8q4RUYzqxvVKu8N7DpeVy37jQlw/V2UVVYD W+GqagwtmKyNp5LUpCVQpNMo7d90k7x2dvH0s3E4WcVe9zSqspsbrZG//rczJ/SjijRH mJB7B4vgftOBB07QwWqa5UarmktjL5vVFy/8niDhiFpdqcr3B1Xbe6Dm3sM4WRRldzqA 80oQ== X-Gm-Message-State: ABy/qLaKGJ3XZX/q07ORXhHvkDQSuHbq2ThiLqU5F7Nvv5yDLgUAqX1D WBgMtkmL6Nj3r8XqBi+OnhxStg== X-Google-Smtp-Source: APBJJlHdUrgw0dP5A3KLQne7cAYnoJHqBUk5ix82PDTS6372cZJS9tTHYubekW39PSkvj7ezGQ0nJQ== X-Received: by 2002:a05:6a20:7f84:b0:133:6b64:c92 with SMTP id d4-20020a056a207f8400b001336b640c92mr3184939pzj.44.1689981254328; Fri, 21 Jul 2023 16:14:14 -0700 (PDT) Received: from [192.168.1.21] ([50.53.8.205]) by smtp.gmail.com with ESMTPSA id 12-20020a170902c10c00b001bb7b0a0372sm398581pli.290.2023.07.21.16.14.13 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 21 Jul 2023 16:14:13 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------w52LaYiRZgLYNlOJe06jrjW3" Message-ID: <862cff51-eaf6-3fa1-07a5-9666c7e4e897@timescale.com> Date: Fri, 21 Jul 2023 16:14:12 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: Row pattern recognition To: Vik Fearing , Tatsuo Ishii Cc: pgsql-hackers@postgresql.org References: <90bff6fa-01b7-cf60-f4f4-3412514a7cd2@postgresfriends.org> <20230628.095819.1123345378945479712.t-ishii@sranhm.sra.co.jp> <07214b3a-5893-f6ce-ef55-0e5d24c94925@timescale.com> <20230720.141513.1986681389874528348.t-ishii@sranhm.sra.co.jp> <022a392f-2a9e-3df1-a509-a5bd51160fa5@timescale.com> <69272b9d-1985-9902-0632-e29180c158ae@postgresfriends.org> Content-Language: en-US From: Jacob Champion In-Reply-To: <69272b9d-1985-9902-0632-e29180c158ae@postgresfriends.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------w52LaYiRZgLYNlOJe06jrjW3 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit On 7/20/23 17:07, Vik Fearing wrote: > On 7/21/23 01:36, Jacob Champion wrote: >> (I've attached two failing tests against v2, to hopefully better >> illustrate, along with what I_think_ should be the correct results.) > > Almost. You are matching 07-01-2023 but the condition is "price > 100". D'oh. Correction attached. I think :) Thanks, --Jacob --------------w52LaYiRZgLYNlOJe06jrjW3 Content-Type: text/plain; charset=UTF-8; name="tests.diff.txt" Content-Disposition: attachment; filename="tests.diff.txt" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcnByLm91dCBiL3NyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcnByLm91dAppbmRleCA2YmY4ODE4OTExLi5mM2ZkMjJk ZTJhIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3Jwci5vdXQKKysr IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ycHIub3V0CkBAIC0yMzAsNiArMjMwLDc5 IEBAIFNFTEVDVCBjb21wYW55LCB0ZGF0ZSwgcHJpY2UsIHJwcihwcmljZSkgT1ZFUiB3IEZS T00gc3RvY2sKICBjb21wYW55MiB8IDA3LTEwLTIwMjMgfCAgMTMwMCB8ICAgICAKICgyMCBy b3dzKQogCistLSBtYXRjaCBldmVyeXRoaW5nCitTRUxFQ1QgY29tcGFueSwgdGRhdGUsIHBy aWNlLCBycHIocHJpY2UpIE9WRVIgdyBGUk9NIHN0b2NrCisgV0lORE9XIHcgQVMgKAorIFBB UlRJVElPTiBCWSBjb21wYW55CisgT1JERVIgQlkgdGRhdGUKKyBST1dTIEJFVFdFRU4gQ1VS UkVOVCBST1cgQU5EIFVOQk9VTkRFRCBGT0xMT1dJTkcKKyBBRlRFUiBNQVRDSCBTS0lQIFRP IE5FWFQgUk9XCisgSU5JVElBTAorIFBBVFRFUk4gKEErKQorIERFRklORQorICBBIEFTIFRS VUUKKyk7CisgY29tcGFueSAgfCAgIHRkYXRlICAgIHwgcHJpY2UgfCBycHIgCistLS0tLS0t LS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tKy0tLS0tCisgY29tcGFueTEgfCAwNy0wMS0yMDIz IHwgICAxMDAgfCAxMDAKKyBjb21wYW55MSB8IDA3LTAyLTIwMjMgfCAgIDIwMCB8ICAgIAor IGNvbXBhbnkxIHwgMDctMDMtMjAyMyB8ICAgMTUwIHwgICAgCisgY29tcGFueTEgfCAwNy0w NC0yMDIzIHwgICAxNDAgfCAgICAKKyBjb21wYW55MSB8IDA3LTA1LTIwMjMgfCAgIDE1MCB8 ICAgIAorIGNvbXBhbnkxIHwgMDctMDYtMjAyMyB8ICAgIDkwIHwgICAgCisgY29tcGFueTEg fCAwNy0wNy0yMDIzIHwgICAxMTAgfCAgICAKKyBjb21wYW55MSB8IDA3LTA4LTIwMjMgfCAg IDEzMCB8ICAgIAorIGNvbXBhbnkxIHwgMDctMDktMjAyMyB8ICAgMTIwIHwgICAgCisgY29t cGFueTEgfCAwNy0xMC0yMDIzIHwgICAxMzAgfCAgICAKKyBjb21wYW55MiB8IDA3LTAxLTIw MjMgfCAgICA1MCB8ICA1MAorIGNvbXBhbnkyIHwgMDctMDItMjAyMyB8ICAyMDAwIHwgICAg CisgY29tcGFueTIgfCAwNy0wMy0yMDIzIHwgIDE1MDAgfCAgICAKKyBjb21wYW55MiB8IDA3 LTA0LTIwMjMgfCAgMTQwMCB8ICAgIAorIGNvbXBhbnkyIHwgMDctMDUtMjAyMyB8ICAxNTAw IHwgICAgCisgY29tcGFueTIgfCAwNy0wNi0yMDIzIHwgICAgNjAgfCAgICAKKyBjb21wYW55 MiB8IDA3LTA3LTIwMjMgfCAgMTEwMCB8ICAgIAorIGNvbXBhbnkyIHwgMDctMDgtMjAyMyB8 ICAxMzAwIHwgICAgCisgY29tcGFueTIgfCAwNy0wOS0yMDIzIHwgIDEyMDAgfCAgICAKKyBj b21wYW55MiB8IDA3LTEwLTIwMjMgfCAgMTMwMCB8ICAgIAorKDIwIHJvd3MpCisKKy0tIGJh Y2t0cmFja2luZyB3aXRoIHJlY2xhc3NpZmljYXRpb24gb2Ygcm93cworU0VMRUNUIGNvbXBh bnksIHRkYXRlLCBwcmljZSwgcnByKHByaWNlKSBPVkVSIHcgRlJPTSBzdG9jaworIFdJTkRP VyB3IEFTICgKKyBQQVJUSVRJT04gQlkgY29tcGFueQorIE9SREVSIEJZIHRkYXRlCisgUk9X UyBCRVRXRUVOIENVUlJFTlQgUk9XIEFORCBVTkJPVU5ERUQgRk9MTE9XSU5HCisgQUZURVIg TUFUQ0ggU0tJUCBUTyBORVhUIFJPVworIElOSVRJQUwKKyBQQVRURVJOIChBKyBCKykKKyBE RUZJTkUKKyAgQSBBUyBwcmljZSA+IDEwMCwKKyAgQiBBUyBwcmljZSA+IDEwMAorKTsKKyBj b21wYW55ICB8ICAgdGRhdGUgICAgfCBwcmljZSB8IHJwciAgCistLS0tLS0tLS0tKy0tLS0t LS0tLS0tLSstLS0tLS0tKy0tLS0tLQorIGNvbXBhbnkxIHwgMDctMDEtMjAyMyB8ICAgMTAw IHwgICAgIAorIGNvbXBhbnkxIHwgMDctMDItMjAyMyB8ICAgMjAwIHwgIDIwMAorIGNvbXBh bnkxIHwgMDctMDMtMjAyMyB8ICAgMTUwIHwgICAgIAorIGNvbXBhbnkxIHwgMDctMDQtMjAy MyB8ICAgMTQwIHwgICAgIAorIGNvbXBhbnkxIHwgMDctMDUtMjAyMyB8ICAgMTUwIHwgICAg IAorIGNvbXBhbnkxIHwgMDctMDYtMjAyMyB8ICAgIDkwIHwgICAgIAorIGNvbXBhbnkxIHwg MDctMDctMjAyMyB8ICAgMTEwIHwgIDExMAorIGNvbXBhbnkxIHwgMDctMDgtMjAyMyB8ICAg MTMwIHwgICAgIAorIGNvbXBhbnkxIHwgMDctMDktMjAyMyB8ICAgMTIwIHwgICAgIAorIGNv bXBhbnkxIHwgMDctMTAtMjAyMyB8ICAgMTMwIHwgICAgIAorIGNvbXBhbnkyIHwgMDctMDEt MjAyMyB8ICAgIDUwIHwgICAgIAorIGNvbXBhbnkyIHwgMDctMDItMjAyMyB8ICAyMDAwIHwg MjAwMAorIGNvbXBhbnkyIHwgMDctMDMtMjAyMyB8ICAxNTAwIHwgICAgIAorIGNvbXBhbnky IHwgMDctMDQtMjAyMyB8ICAxNDAwIHwgICAgIAorIGNvbXBhbnkyIHwgMDctMDUtMjAyMyB8 ICAxNTAwIHwgICAgIAorIGNvbXBhbnkyIHwgMDctMDYtMjAyMyB8ICAgIDYwIHwgICAgIAor IGNvbXBhbnkyIHwgMDctMDctMjAyMyB8ICAxMTAwIHwgMTEwMAorIGNvbXBhbnkyIHwgMDct MDgtMjAyMyB8ICAxMzAwIHwgICAgIAorIGNvbXBhbnkyIHwgMDctMDktMjAyMyB8ICAxMjAw IHwgICAgIAorIGNvbXBhbnkyIHwgMDctMTAtMjAyMyB8ICAxMzAwIHwgICAgIAorKDIwIHJv d3MpCisKIC0tCiAtLSBFcnJvciBjYXNlcwogLS0KZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL3Jwci5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9ycHIuc3FsCmluZGV4 IDk1MWM5YWJmZTkuLmYxY2QwMzY5ZjQgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3Mv c3FsL3Jwci5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvcnByLnNxbApAQCAtOTQs NiArOTQsMzMgQEAgU0VMRUNUIGNvbXBhbnksIHRkYXRlLCBwcmljZSwgcnByKHByaWNlKSBP VkVSIHcgRlJPTSBzdG9jawogICBVUERPV04gQVMgcHJpY2UgPiBQUkVWKHByaWNlKSBBTkQg cHJpY2UgPiBORVhUKHByaWNlKQogKTsKIAorLS0gbWF0Y2ggZXZlcnl0aGluZworU0VMRUNU IGNvbXBhbnksIHRkYXRlLCBwcmljZSwgcnByKHByaWNlKSBPVkVSIHcgRlJPTSBzdG9jawor IFdJTkRPVyB3IEFTICgKKyBQQVJUSVRJT04gQlkgY29tcGFueQorIE9SREVSIEJZIHRkYXRl CisgUk9XUyBCRVRXRUVOIENVUlJFTlQgUk9XIEFORCBVTkJPVU5ERUQgRk9MTE9XSU5HCisg QUZURVIgTUFUQ0ggU0tJUCBUTyBORVhUIFJPVworIElOSVRJQUwKKyBQQVRURVJOIChBKykK KyBERUZJTkUKKyAgQSBBUyBUUlVFCispOworCistLSBiYWNrdHJhY2tpbmcgd2l0aCByZWNs YXNzaWZpY2F0aW9uIG9mIHJvd3MKK1NFTEVDVCBjb21wYW55LCB0ZGF0ZSwgcHJpY2UsIHJw cihwcmljZSkgT1ZFUiB3IEZST00gc3RvY2sKKyBXSU5ET1cgdyBBUyAoCisgUEFSVElUSU9O IEJZIGNvbXBhbnkKKyBPUkRFUiBCWSB0ZGF0ZQorIFJPV1MgQkVUV0VFTiBDVVJSRU5UIFJP VyBBTkQgVU5CT1VOREVEIEZPTExPV0lORworIEFGVEVSIE1BVENIIFNLSVAgVE8gTkVYVCBS T1cKKyBJTklUSUFMCisgUEFUVEVSTiAoQSsgQispCisgREVGSU5FCisgIEEgQVMgcHJpY2Ug PiAxMDAsCisgIEIgQVMgcHJpY2UgPiAxMDAKKyk7CisKIC0tCiAtLSBFcnJvciBjYXNlcwog LS0K --------------w52LaYiRZgLYNlOJe06jrjW3--