From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <tarantool-patches-bounce@freelists.org>
Received: from localhost (localhost [127.0.0.1])
	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 875E326D13
	for <tarantool-patches@freelists.org>; Tue, 20 Aug 2019 07:59:08 -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 R-oItJ1ZUv6D for <tarantool-patches@freelists.org>;
	Tue, 20 Aug 2019 07:59:08 -0400 (EDT)
Received: from smtp3.mail.ru (smtp3.mail.ru [94.100.179.58])
	(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 7D3C1263B4
	for <tarantool-patches@freelists.org>; Tue, 20 Aug 2019 07:59:07 -0400 (EDT)
Date: Tue, 20 Aug 2019 14:59:05 +0300
From: Konstantin Osipov <kostja@tarantool.org>
Subject: [tarantool-patches] Re: [PATCH 2/2] sql: allow to specify engine in CREATE TABLE stmt
Message-ID: <20190820115905.GG8932@atlas>
References: <cover.1566223966.git.korablev@tarantool.org>
 <31336993247e9b53cf3c41f1cdb2bba14a61e31a.1566223966.git.korablev@tarantool.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <31336993247e9b53cf3c41f1cdb2bba14a61e31a.1566223966.git.korablev@tarantool.org>
Sender: tarantool-patches-bounce@freelists.org
Errors-to: tarantool-patches-bounce@freelists.org
Reply-To: tarantool-patches@freelists.org
List-Help: <mailto:ecartis@freelists.org?Subject=help>
List-Unsubscribe: <mailto:tarantool-patches-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: tarantool-patches <tarantool-patches.freelists.org>
List-Subscribe: <mailto:tarantool-patches-request@freelists.org?Subject=subscribe>
List-Owner: <mailto:>
List-post: <mailto:tarantool-patches@freelists.org>
List-Archive: <http://www.freelists.org/archives/tarantool-patches>
To: Nikita Pettik <korablev@tarantool.org>
Cc: tarantool-patches@freelists.org, v.shpilevoy@tarantool.org

* Nikita Pettik <korablev@tarantool.org> [19/08/19 17:54]:
> @TarantoolBot document
> Title: Introduce <WITH ENGINE> clause for CREATE TABLE statement
> 
> To allow user to specify engine as per table option, CREATE TABLE
> statement has been extended with optional <WITH ENGINE = engine_name>
> clause. This clause comes at the end of CREATE TABLE statement.
> For instance:
> 
> CREATE TABLE t_vinyl (id INT PRIMARY KEY) WITH ENGINE = 'vinyl';
> 
> Name of engine is considered to be string literal ergo should be
> enclosed in single quotation marks and be lower-cased. Note that engine
> specified in WITH ENGINE clause overwrites default engine, which is set
> via 'pragma sql_default_engine'.

the wording should not contain word 'with'. 

-- 
Konstantin Osipov, Moscow, Russia