From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7F63422B9F for ; Mon, 2 Jul 2018 11:51:59 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HgbbiKyo_czF for ; Mon, 2 Jul 2018 11:51:59 -0400 (EDT) Received: from smtp60.i.mail.ru (smtp60.i.mail.ru [217.69.128.40]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id C7EBF21282 for ; Mon, 2 Jul 2018 11:51:58 -0400 (EDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\)) Subject: [tarantool-patches] Re: [PATCH] sql: remove support of partial indexes from parser From: "n.pettik" In-Reply-To: Date: Mon, 2 Jul 2018 18:51:56 +0300 Content-Transfer-Encoding: quoted-printable Message-Id: <5F9DC699-08EE-4C3B-9491-114772B589B7@tarantool.org> References: <20180702110824.28899-1-korablev@tarantool.org> Sender: tarantool-patches-bounce@freelists.org Errors-to: tarantool-patches-bounce@freelists.org Reply-To: tarantool-patches@freelists.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: tarantool-patches List-subscribe: List-owner: List-post: List-archive: To: tarantool-patches@freelists.org Cc: Vladislav Shpilevoy > 1. The error is caused by typo in the request, not by lack of > partial indexes. Forgot to place =E2=80=98;=E2=80=99 at the end of statement: @@ -291,14 +291,16 @@ test:do_eqp_test( -- }) =20 +-- gh-2165 Currently, Tarantool lacks support of partial indexes, +-- so temporary we removed processing of their syntax from parser. +-- test:do_catchsql_test( - "index7-6.5", + "index7-7.1", [[ - CREATE INDEX t5a ON t5(a) WHERE a=3D#1; + CREATE TABLE t1 (a INTEGER PRIMARY KEY, b INTEGER); + CREATE UNIQUE INDEX i ON t1 (a) WHERE a =3D 3; ]], { - -- - 1, [[near "#1": syntax error]] - -- + 1, "keyword \"WHERE\" is reserved"=