Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:123154 X-Original-To: internals@lists.php.net Delivered-To: internals@lists.php.net Received: from php-smtp4.php.net (php-smtp4.php.net [45.112.84.5]) by qa.php.net (Postfix) with ESMTPS id 304571A009C for ; Thu, 18 Apr 2024 06:41:57 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=php.net; s=mail; t=1713422553; bh=3c81OcLALkbiW+tV/dvX4gpqUVarnxj9ZkAhvig9n5s=; h=Date:From:Subject:To:Cc:References:In-Reply-To:From; b=lrwuxNxCut04nFCbVs+KZoSQ9ZmQUxYBGKB90A8GESNnZdRLBcBPBA+XhtImo1vBE k8AeO/FI7RVAtFEgu4Cfr+1CxQZ2+HPxeJM4qLFlu9VuGPka7xQWEh8KWA5R9EppCm gvJBwZf8F72E0agtxOBQnxZC4FnDQjy/k8MCLJun77NpOHv4Z7NxqVtBSm9o7Qre2i bi7t+PcgacKjel9ulMdlpoan+KyBxakQqUQt4dm0RqGsk5L+RVHolSX/U/pHZF0In4 RnRYeMVF1X+R+bg5JzNltUcE521PwTEtFbXn/S7f/UxRHxCcVBTHwTyqRs34TmXVs5 +0GNImKgo9J4Q== Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id 12A52180062 for ; Thu, 18 Apr 2024 06:42:33 +0000 (UTC) X-Spam-Checker-Version: SpamAssassin 4.0.0 (2022-12-13) on php-smtp4.php.net X-Spam-Level: X-Spam-Status: No, score=-0.1 required=5.0 tests=BAYES_50,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,DMARC_PASS,RCVD_IN_DNSWL_LOW, SPF_HELO_NONE,SPF_PASS,T_SCC_BODY_TEXT_LINE autolearn=no autolearn_force=no version=4.0.0 X-Spam-Virus: No X-Envelope-From: Received: from fhigh8-smtp.messagingengine.com (fhigh8-smtp.messagingengine.com [103.168.172.159]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by php-smtp4.php.net (Postfix) with ESMTPS for ; Thu, 18 Apr 2024 06:42:32 +0000 (UTC) Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 2E97211400A1; Thu, 18 Apr 2024 02:41:55 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Thu, 18 Apr 2024 02:41:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=beccati.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1713422515; x=1713508915; bh=NDFju7a6EqJYxYAL/RT1SE3nUdpmJr2RxQ8kO364Eyg=; b= Xksit/MDa+1UYQNQS84aPguqaGkCOlmO+cOxi2GVBibc7uz7HIBEITAehQ5Q7ic9 pkyDZXKp+PmJ/etAjlACKpoHhNGSUK0Kcni31+86z4KN5jPVcEZxBdX3ea9N+7Lz 8xaaHcWOEHqZAJ0nonAHwkrgAYqjKA885wnY9siJRKfG/mdpqtmQCXx7NJlHAlgB ClhHG+ivOc+R9ysh8f2oE1e04e1SU/8SuqX22cSHdcI8F+97WzcK8Gz26My/2qqZ 7grxm1bSicGRJq1vQnRfZ8XGF3WgUVbXlntChHDu3+JQFiIvQzpYiGSpPXfZUW5Y SHye+IFmnAZ463uZizpQig== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1713422515; x= 1713508915; bh=NDFju7a6EqJYxYAL/RT1SE3nUdpmJr2RxQ8kO364Eyg=; b=J mUqInAhlzqpd1/H8I37bD5Vx0dc3T9nD/ZVkVzMDqxReVD/dlRAiDrgyPzRD1h1q P7BbEplJTm9UQ9ON93KVNLn+WaShTey4ehndOjwKPmUapEBemqMZQvB6+29GYXkm v6dwcGnVc5Bf06xyeoxkR+8YnV7vsDv58qsay2OeS9hH8ubQGXSxlS3THNKUWQ4e WTEuJ4pNEGrG3NKYOdKtH2iICIenHI4Adl072IOV3v8nF/GVsonG7qJuI9VzoYeK 8tdcPXS4iO26c5rHA1AK6McAidF/WeBkvlLL2Sm6f1shswum7rTRp33CU37pKYlD quemoV31YaUTxmPbSdC+g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudejledgudduudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefkffggfgfhuffvvehfjggtgfesthejredttddvjeenucfhrhhomhepofgr thhtvghouceuvggttggrthhiuceophhhphessggvtggtrghtihdrtghomheqnecuggftrf grthhtvghrnhepjeevhfetfeeihfefkeefieehuefgudeukeehjeekkefhfeefvdetjeff tefgtedvnecuffhomhgrihhnpegsvggttggrthhirdgtohhmnecuvehluhhsthgvrhfuih iivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepphhhphessggvtggtrghtihdrtgho mh X-ME-Proxy: Feedback-ID: i6f4c46c2:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 18 Apr 2024 02:41:54 -0400 (EDT) Message-ID: <96f0f05b-dd2a-4b97-8420-e7ac2357f462@beccati.com> Date: Thu, 18 Apr 2024 08:41:51 +0200 Precedence: bulk list-help: list-post: List-Id: internals.lists.php.net MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [PHP-DEV] [RFC][Discussion] PDO driver specific parsers To: Kamil Tekiela Cc: Larry Garfield , php internals References: <00079548-1799-4215-8F73-EFDCD795532F@sakiot.com> <098996d6-32e4-460c-a82a-aeef3b7e61d3@beccati.com> <9A6577BD-3BC5-41E1-965D-4B30D16CDB3D@sakiot.com> <26c47eb5-a60a-459d-89e6-16f6f0634cba@app.fastmail.com> <1d64e5c6-5a77-41a3-8d68-ae88aeed611f@beccati.com> Content-Language: it In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit From: php@beccati.com (Matteo Beccati) Hi Kamil, Il 17/04/2024 19:25, Kamil Tekiela ha scritto: > I think the question here was more about what the syntax will be after > the parameters are substituted. But if I recall correctly, the quoting > is done by PDO:: quote so the syntax will remain the same. Only the > buggy behavior would be fixed when it comes to recognizing parameters. Exactly, the parser change is all about properly recognizing parameters. Parameter substitution is taken care of by the driver. With emulated prepares (default on pdo_mysql, alas) parameters are inlined in the query after being properly "quoted". Otherwise they will be passed according to what the database client library needs (byte length + string, or any other format). It's a good point and I'll make sure to add this to the RFC. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/