From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-ua1-x929.google.com (mail-ua1-x929.google.com [IPv6:2607:f8b0:4864:20::929]) by sourceware.org (Postfix) with ESMTPS id 1D3F43858D35 for ; Wed, 27 Dec 2023 07:13:07 +0000 (GMT) DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 1D3F43858D35 Authentication-Results: sourceware.org; dmarc=pass (p=none dis=none) header.from=gmail.com Authentication-Results: sourceware.org; spf=pass smtp.mailfrom=gmail.com ARC-Filter: OpenARC Filter v1.0.0 sourceware.org 1D3F43858D35 Authentication-Results: server2.sourceware.org; arc=none smtp.remote-ip=2607:f8b0:4864:20::929 ARC-Seal: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1703661188; cv=none; b=AucynnkobqefUqdgCf8Qbwxh2OvpptLOwu4gQmBzDe1DsmVLMocOPgRqV6/GDLSEhNcfAzzYTMbTLYo7SzR9LFRhvSjwTxn77/FrukhnsrwunMLs7uSBglKE8CShJs+euezLX4zW5tePYedWzrspw7rSjGVmHB3Aat4P/nwlhiM= ARC-Message-Signature: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1703661188; c=relaxed/simple; bh=dCg+fkKu8qkbefb+Dh5Ndb406Vhim8g2TIrlTZRefoA=; h=DKIM-Signature:MIME-Version:From:Date:Message-ID:Subject:To; b=qHAP1NQbp/Ux/oD7gsCWvn6JvT5HRqrbZyPK2Z0a8Ke2s2/OTOJ/T4ql9LwO8WIa4gDF2nuwK3+q0DiUZ/t3r81Qh/Jln+zNBWGOFF+t1BiI7ym1XRDIzWkyVx+P7N1bpe56eJWhROjh44HLhfFeDkxAmjj6KzQg6uNpaNi5CiM= ARC-Authentication-Results: i=1; server2.sourceware.org Received: by mail-ua1-x929.google.com with SMTP id a1e0cc1a2514c-7ccdb4b764cso407514241.2 for ; Tue, 26 Dec 2023 23:13:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1703661186; x=1704265986; darn=sourceware.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=dCg+fkKu8qkbefb+Dh5Ndb406Vhim8g2TIrlTZRefoA=; b=Nr8gD8uIRKjTzxufluYJm87+mxvvc71kTMlhMUJ+4N0CIcWNwbL+dUhFRvy6RVgA9d BSP1FSSopLMmcAHQKpEPJm6o2QOVHD/smBhNvV9dz6UALXK1MbxOEWZDVGGgf+tC+bQ6 CxiRpdUNQ2cmJDQWLLO/N48GKefCuqou5oWwyPUZIrkMhXhGPkIHjX2ltuTyjBn/V6DA o6bMfXeg5HGpsewRyvx/qVIarkgsKg0JuTL692+GXx5lS47N/dlBE0EpzGgoX8fw4jSO 4YOgzwZ+VUw8JYiFCu+EVo5xKceboRCJCIl2fzaAOjh41n0+fEyydVRhtFxhFbhSO2Ia wxlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1703661186; x=1704265986; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=dCg+fkKu8qkbefb+Dh5Ndb406Vhim8g2TIrlTZRefoA=; b=q9G0T6rNrlbJllBoODfhYRkShuwwSKL+z90282eEoat5JlD8dXbluvmVHXNCzEvUbX aCac+16uGkkMHM1gnIDYUhdFI42OhAT/SNJZwfLNIm5VYFluJJTupTlqNIlR0wtSByWF xCFQTIlz1aql5SsYfltoSxi+nvwCoVE88JkaxXMpwr7+IKwakr+a+XSjoXpSGjFyalMZ wtWZSMzUbzNKFMWlofUwrCqHhUoaiRNoaX9mftmO7LmIIPNXNHIWjQR6NTcUcEgK4Ncm iuRN11MA6dPIA4+sF71bruAqeoM3d8abPljwwBz9oUc9HnrpSUKg3bcZn5l+1oHh8CUA GFmA== X-Gm-Message-State: AOJu0YxmxzYDLhMZmM18kADAoY11lKH66QOVou18D7YND6vEy6OvGUyo XSXmn4ailecUAXj/7uraDV3PFm3Vxi0AkeZNDWgxFmHfwW1NQw== X-Google-Smtp-Source: AGHT+IHUhHX+QSH08T5CcmyIoSsgDY89yr0zL7Z+ZDTZhLPbsVYdwPfwQK9N2YDS6fdr00Br2g1fHAa9qFTooYVYwkE= X-Received: by 2002:a05:6102:3a0a:b0:467:d0e:cc4d with SMTP id b10-20020a0561023a0a00b004670d0ecc4dmr1177845vsu.33.1703661186040; Tue, 26 Dec 2023 23:13:06 -0800 (PST) MIME-Version: 1.0 From: Lisa Ze Date: Tue, 26 Dec 2023 23:12:55 -0800 Message-ID: Subject: Is there any changes of "order by" in postgre sql with collate "en_US.utf8" between ldd (GNU libc) 2.17 and 2.34? To: libc-help@sourceware.org Content-Type: multipart/alternative; boundary="000000000000cfca22060d788722" X-Spam-Status: No, score=-0.4 required=5.0 tests=BAYES_00,DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_HELO_NONE,SPF_PASS,TXREP,T_SCC_BODY_TEXT_LINE autolearn=ham autolearn_force=no version=3.4.6 X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on server2.sourceware.org List-Id: --000000000000cfca22060d788722 Content-Type: text/plain; charset="UTF-8" Hi all I upgrade my glibc version from 2.17 to 2.34. I found that my postgre "order by" sql has the different order list. select * from t1 order by name asc. Before results: glibc 2.17 A2 A_2 After results: glibc 2.34 A_2 A2 Could you help me to find the reasons for this? Thanks! Lisa --000000000000cfca22060d788722--