Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cTwUH-0004U7-3z for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jan 2017 20:05:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cTwUG-0001qq-LE for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jan 2017 20:05:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cTwSp-0007JU-Ut for pgsql-hackers@postgresql.org; Wed, 18 Jan 2017 20:04:12 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cTwSm-0006x6-GQ for pgsql-hackers@postgresql.org; Wed, 18 Jan 2017 20:04:10 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 6E05021C2940 for ; Wed, 18 Jan 2017 23:04:06 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from [10.100.236.30] (unknown [195.82.154.27]) by mail.postgrespro.ru (Postfix) with ESMTPSA id B0F9F21C292E for ; Wed, 18 Jan 2017 23:04:05 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1484769845; bh=jDWi0PsW7lYeEmFT1adsqlgLgQOIbdx5gNr58Wbyu5c=; h=To:From:Subject:Date; b=mnaJRND+rfeegW4u8ove854zWTOZ+StdeknoC4Ak/MEqUEMdv/1Hjg+zU6yAppZTR 2dZk8aWxmGr7faVCsEh4jYlPcmcIEEA16YSv0+SYjsh6L7sns63/UjgRUq82lxlS6R p8TcMeDutySvyq/Z4LtkNy8OiHurIXZCRoJFy7yw= To: PostgreSQL mailing lists From: Nikita Glukhov Subject: [PATCH] fix typo in commit a4523c5 Organization: Postgres Professional Message-ID: <8b70135d-ad38-bdd8-ac92-71e2b3c273cf@postgrespro.ru> Date: Wed, 18 Jan 2017 23:01:54 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.5.1 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------2A488706702D3F17FFD6144E" X-Pg-Spam-Score: -5.2 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------2A488706702D3F17FFD6144E Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Attached patch fixes typo in regression test src/test/regress/sql/create_index.sql that was introduced in commit a4523c5 ("Improve planning of btree index scans using ScalarArrayOpExpr quals."). In this commit the following lines were added to create_index.sql: SET enable_indexonlyscan = OFF; ... RESET enable_indexscan; Obviously, the last line should be RESET enable_indexonlyscan; -- Nikita Glukhov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --------------2A488706702D3F17FFD6144E Content-Type: text/x-patch; name="fix-typo-in-commit-a4523c5.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="fix-typo-in-commit-a4523c5.patch" diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index c6dfb26..e519fdb 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -2940,7 +2940,7 @@ ORDER BY thousand; 1 | 1001 (2 rows) -RESET enable_indexscan; +RESET enable_indexonlyscan; -- -- Check elimination of constant-NULL subexpressions -- diff --git a/src/test/regress/sql/create_index.sql b/src/test/regress/sql/create_index.sql index 822c34a..1648072 100644 --- a/src/test/regress/sql/create_index.sql +++ b/src/test/regress/sql/create_index.sql @@ -1001,7 +1001,7 @@ SELECT thousand, tenthous FROM tenk1 WHERE thousand < 2 AND tenthous IN (1001,3000) ORDER BY thousand; -RESET enable_indexscan; +RESET enable_indexonlyscan; -- -- Check elimination of constant-NULL subexpressions --------------2A488706702D3F17FFD6144E Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------2A488706702D3F17FFD6144E--