pb with 'Order by'

Posted in 1995

Frederic Bouquet — 21 Jul 1995 12:18:05 -0400 — source: Informix-list mailing list archive (1991-1998)

On Informix SE 5.0, on SUN 4m Sparc with solaris 2.3 This SQL select returns the rows but not ordered. select cce_numcde,cce_solde,cce_datecde,adr_raison,cce_cptgal,cce_cptaux,sum(ccl_total) sstotal from ccentete,ccligne,adresses where cce_numcde=ccl_numcde and cce_cptgal=adr_cptgal and cce_cptaux=adr_code and cce_datecde>="01/01/95" and cce_datecde<="28/02/95" and cce_solde="N" group by cce_numcde,cce_solde,cce_datecde,adr_raison,cce_cptgal,cce_cptaux order by cce_cptgal,cce_cptaux,cce_numcde cce_numcde cce_cptgal cce_cptaux 952400003.0 N 08/02/95 ALPLOG 401000 ALPLOG 8575.0 952400004.0 N 08/02/95 SUN MICROSYSTEMS FRANCE S.A 401000 SUN69MAT 719653.0 952400005.0 N 08/02/95 SUN-EXPRESS EUROPE 401000 SUNEXPRES 78047.0 952400009.0 N 09/02/95 SUN MICROSYSTEMS FRANCE S.A 401000 SUN69MAT 396536.0 952400012.0 N 09/02/95 VITEK 401000 VITEK 18140.0 952400016.0 N 09/02/95 ISTA 401000 ISTA 1575.0 952400021.0 N 09/02/95 VITEK 401000 VITEK 9000.0 952400024.0 N 10/02/95 LOCAMESURE S.A 401000 HAMILTON 7430.0 952400025.0 N 10/02/95 LOCAMESURE S.A 401000 HAMILTON 19358.0 952400034.0 N 13/02/95 ECTRA 401000 ECTRA 1103.2 952400035.0 N 13/02/95 ECTRA 401000 ECTRA 1422.0 952400040.0 N 14/02/95 VITEK 401000 VITEK 7650.0 952400048.0 N 14/02/95 AIF SERVICES S.A 401000 AIF 2010.0 952400049.0 N 14/02/95 FABRE MESURELEC S.A 401000 FABREMESU 2133.0 952400050.0 N 14/02/95 GS TECHNOLOGIE TT 401000 GST 35785.15 952400052.0 N 14/02/95 ALMA 401000 ALMA 1840.0 952400053.0 N 14/02/95 ACCENT MONDIAL 401000 ACCENTMON 180.0 952400057.0 N 14/02/95 FINELY 401000 FINELY 16000.0 952400059.0 N 15/02/95 COMITE NATIONAL FRANCAIS 401000 CIGRE 2770.0 952400065.0 N 17/02/95 THOMSON TRAINING 401000 THOMSON 435946.0 952400076.0 N 22/02/95 XL CONSULTANT 401000 XLCONSULT 7700.0 952400081.0 N 22/02/95 DOM ALPES 401000 DOM 192.0 952400091.0 N 28/02/95 PIXEL SYSTEMS 401000 PIXELSYST 23485.96 952400093.0 N 28/02/95 ECTRA 401000 ECTRA 843.0 But this one without the "group by" return the rows ordered. select distinct cce_numcde,cce_solde,cce_datecde,adr_raison,cce_cptgal,cce_cptaux from ccentete,ccligne,adresses where cce_numcde=ccl_numcde and cce_cptgal=adr_cptgal and cce_cptaux=adr_code andcce_datecde>="01/01/95" and cce_datecde<="28/02/95" and cce_solde="N" order by cce_cptgal,cce_cptaux,cce_numcde cce_numcde cce_cptgal cce_cptaux 952400053.0 N 14/02/95 ACCENT MONDIAL 401000 ACCENTMON 952400048.0 N 14/02/95 AIF SERVICES S.A 401000 AIF 952400052.0 N 14/02/95 ALMA 401000 ALMA 952400003.0 N 08/02/95 ALPLOG 401000 ALPLOG 952400059.0 N 15/02/95 COMITE NATIONAL FRANCAIS 401000 CIGRE 952400081.0 N 22/02/95 DOM ALPES 401000 DOM 952400034.0 N 13/02/95 ECTRA 401000 ECTRA 952400035.0 N 13/02/95 ECTRA 401000 ECTRA 952400093.0 N 28/02/95 ECTRA 401000 ECTRA 952400049.0 N 14/02/95 FABRE MESURELEC S.A 401000 FABREMESU 952400057.0 N 14/02/95 FINELY 401000 FINELY 952400050.0 N 14/02/95 GS TECHNOLOGIE TT 401000 GST 952400024.0 N 10/02/95 LOCAMESURE S.A 401000 HAMILTON 952400025.0 N 10/02/95 LOCAMESURE S.A 401000 HAMILTON 952400016.0 N 09/02/95 ISTA 401000 ISTA 952400091.0 N 28/02/95 PIXEL SYSTEMS 401000 PIXELSYST 952400004.0 N 08/02/95 SUN MICROSYSTEMS FRANCE S.A 401000 SUN69MAT 952400009.0 N 09/02/95 SUN MICROSYSTEMS FRANCE S.A 401000 SUN69MAT 952400005.0 N 08/02/95 SUN-EXPRESS EUROPE 401000 SUNEXPRES 952400065.0 N 17/02/95 THOMSON TRAINING 401000 THOMSON 952400012.0 N 09/02/95 VITEK 401000 VITEK 952400021.0 N 09/02/95 VITEK 401000 VITEK 952400040.0 N 14/02/95 VITEK 401000 VITEK 952400076.0 N 22/02/95 XL CONSULTANT 401000 XLCONSULT This problem exists on ALL databases on this computer. Can you help me ? Lionel Treillefort +------------------------------------+--------------------------+ | Frederic BOUQUET | Phone : (33) 77 93 57 46 | | Cornut Informatique | Fax : (33) 77 92 51 39 | | 24, rue de la Telematique - BP 702 | AppleLink : CORNUT.INF | | 42950 St Etienne cedex 9 FRANCE | Compuserve: 100303,1061 | | frederic_bouquet@ascus.com | | +------------------------------------+--------------------------+ -------------------------------------------------------------------------- U.S.A. | AppleLink : ASCUS About Software Corporation | eWorld : ASC.US 10601, South De Anza Blvd. |America Online : ASCUS Suite 105 | Compuserve : 73243,36 Cupertino, CA 95014 | Internet : info@ascus.com general phone : (408) 725 4242 | Anonymous FTP : ftp.ascus.com sales : (800) 55 SOFTWARE | ARA Server : (408) 725 4250 tech support : (408) 725 4240 |FirstClass BBS : (408) 725 4252 fax : (408) 725 4243 | bbs.ascus.com -------------------------------------------------------------------------- FRANCE | AppleLink : ADV.SOFT ASC | Compuserve : 76034,2123 9551, route de St Laurent du Var | Internet : euro_info@ascus.com F-06610 La Gaude | Anonymous FTP : ftp.ascus.com general phone : +33 93 24 76 00 | ARA Server : +33 93 24 76 03 fax : +33 93 24 76 06 |FirstClass BBS : +33 93 24 76 13 --------------------------------------------------------------------------