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 1sq6N0-006tUc-9n for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Sep 2024 07:42:03 +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 1sq6My-00DScz-77 for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Sep 2024 07:42:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sq6BU-00DL1Z-FE for pgsql-bugs@lists.postgresql.org; Mon, 16 Sep 2024 07:30:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sq6BR-001PQU-Io for pgsql-bugs@lists.postgresql.org; Mon, 16 Sep 2024 07:30:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Pk0/rWdJh4tS1/x6NdF4/A/kFyDTdn5dYt3ivCh+I0Y=; b=DoLetyYPRObMLp4B5fVBoSsaNq vrPF7PWKgNRilldhqXVzJnpZTe5dQ/MGQQWR69ijZtQ12uelycGKwTGHc6w8zXzCL87wbigEzWRdR +80/yGFktLAJpVU9eF/JPCamd6MR+C/l0V+yAqPgQtYY54VQySBcoDF9AR+nT5H5nA99mEWjp2r9M +Dr3fH1KZe/sZdoj6d9JO4FFmr7JlTCp95tyq4dn6f+Ys0rkCemY2fn8/OPLIggSHF5JoVKWr3Lyj D5Y24VM9ZwaNMIyebSOZUPgqgh5ySG08ri+lZpa6web5ZBtICaR47YxiOKViaY6fNOh6x4raVLG1N b0LzOnwg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sq6BQ-004fiK-CQ for pgsql-bugs@lists.postgresql.org; Mon, 16 Sep 2024 07:30:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sq6BP-00AYff-8G for pgsql-bugs@lists.postgresql.org; Mon, 16 Sep 2024 07:30:03 +0000 Content-Type: multipart/mixed; boundary="===============3848882429163114525==" MIME-Version: 1.0 Subject: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: gcso@sqliteonline.com Reply-To: gcso@sqliteonline.com, pgsql-bugs@lists.postgresql.org Date: Mon, 16 Sep 2024 07:29:54 +0000 Message-ID: <18619-fc593e84ad9763fb@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3848882429163114525== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODYxOQpMb2dnZWQgYnk6ICAgICAgICAgIEtpcmlsbCBOCkVtYWlsIGFk ZHJlc3M6ICAgICAgZ2Nzb0BzcWxpdGVvbmxpbmUuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTdy YzEKT3BlcmF0aW5nIHN5c3RlbTogICBkb2NrZXIgMTdyYzEKRGVzY3JpcHRpb246ICAgICAgICAK CkhlbGxvLCANCg0KSWYgeW91IGNyZWF0ZSBhIHRhYmxlIHdpdGggZmllbGQgbmFtZXMgaW4gdXBw ZXJjYXNlIGFuZCBwdXQgdGhlbSBpbgpxdW90YXRpb24gbWFya3MuDQp0aGVuIHN1Y2ggZmllbGRz IGNhbiBiZSBhY2Nlc3NlZCBvbmx5IHdpdGggcXVvdGF0aW9uIG1hcmtzLiANCg0KcG9zdGdyZXM9 IyBjcmVhdGUgdGFibGUgYSAoImIiIGludCwgIkMiIGludCk7DQpDUkVBVEUgVEFCTEUNCnBvc3Rn cmVzPSMgc2VsZWN0IGIgZnJvbSBhOw0KIGIgDQotLS0NCigwIHJvd3MpDQoNCnBvc3RncmVzPSMg c2VsZWN0IGMgZnJvbSBhOw0KRVJST1I6ICBjb2x1bW4gImMiIGRvZXMgbm90IGV4aXN0DQpMSU5F IDE6IHNlbGVjdCBjIGZyb20gYTsNCiAgICAgICAgICAgICAgIF4NCnBvc3RncmVzPSMgc2VsZWN0 IEMgZnJvbSBhOw0KRVJST1I6ICBjb2x1bW4gImMiIGRvZXMgbm90IGV4aXN0DQpMSU5FIDE6IHNl bGVjdCBDIGZyb20gYTsNCiAgICAgICAgICAgICAgIF4NCnBvc3RncmVzPSMgc2VsZWN0ICJjIiBm cm9tIGE7DQpFUlJPUjogIGNvbHVtbiAiYyIgZG9lcyBub3QgZXhpc3QNCkxJTkUgMTogc2VsZWN0 ICJjIiBmcm9tIGE7DQogICAgICAgICAgICAgICBeDQpwb3N0Z3Jlcz0jIHNlbGVjdCAiQyIgZnJv bSBhOw0KIEMgDQotLS0NCigwIHJvd3MpDQoNCg0KDQpUaGUgdGFibGUgc3RydWN0dXJlIGlzIHJl dHVybmVkIHdpdGhvdXQgcXVvdGF0aW9uIG1hcmtzDQoNCnBvc3RncmVzPSMgU0VMRUNUIA0KICAg IHQudGFibGVfc2NoZW1hLA0KICAgIHQudGFibGVfbmFtZSwNCiAgICBjLmNvbHVtbl9uYW1lLA0K ICAgIGMuZGF0YV90eXBlDQpGUk9NIA0KICAgIGluZm9ybWF0aW9uX3NjaGVtYS50YWJsZXMgdA0K Sk9JTiANCiAgICBpbmZvcm1hdGlvbl9zY2hlbWEuY29sdW1ucyBjDQpPTiANCiAgICB0LnRhYmxl X3NjaGVtYSA9IGMudGFibGVfc2NoZW1hDQogICAgQU5EIHQudGFibGVfbmFtZSA9IGMudGFibGVf bmFtZQ0KV0hFUkUgDQogICAgdC50YWJsZV90eXBlID0gJ0JBU0UgVEFCTEUnDQogICAgQU5EIHQu dGFibGVfc2NoZW1hIE5PVCBJTiAoJ2luZm9ybWF0aW9uX3NjaGVtYScsICdwZ19jYXRhbG9nJykg IC0tCtCY0YHQutC70Y7Rh9Cw0LXQvCDRgdC40YHRgtC10LzQvdGL0LUg0YHRhdC10LzRiw0KT1JE RVIgQlkgDQogICAgdC50YWJsZV9zY2hlbWEsDQogICAgdC50YWJsZV9uYW1lLA0KICAgIGMub3Jk aW5hbF9wb3NpdGlvbjsNCiB0YWJsZV9zY2hlbWEgfCB0YWJsZV9uYW1lIHwgIGNvbHVtbl9uYW1l ICB8ICAgICBkYXRhX3R5cGUgICAgIA0KLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tDQogcHVibGljICAgICAgIHwgYSAgICAgICAg ICB8IGIgICAgICAgICAgICAgfCBpbnRlZ2VyDQogcHVibGljICAgICAgIHwgYSAgICAgICAgICB8 IEMgICAgICAgICAgICAgfCBpbnRlZ2VyCgo= --===============3848882429163114525==--