[Bug c++/54213] New: please help to determine wether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[Bug c++/54213] New: please help to determine wether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

             Bug #: 54213
           Summary: please help to determine wether it is an PostgreSQL
                    error or GCC error (combobox and SQL data sorting)
    Classification: Unclassified
           Product: gcc
           Version: 4.6.1
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: P3
         Component: c++
        AssignedTo: unassigned@gcc.gnu.org
        ReportedBy: lirex.software@gmail.com


Created attachment 27968
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=27968
a c++ source file

hello,

Windows XP (I guess, that it is an OEM version) Home edition, service pack 3
installed.

I use a PostgreSQL database and manipulate data from an GCC c++ application
under Windows XP.
I use libpq-fe.h library.

and I noticed, that if I use an SQL string "... order by..." - then it could
represent data normally in an combobox element, but if I use a
second SQL query to find one field using almost the same query
then some ids from 1 and 2 queries are not equal.

I found a solution by excluding "... order by...". But it is not convient to
see surnames unsorted...

Is it a PostgreSQL error's side or GCC?
please help to determine, because I'm not professional on it.

My normal compiler options:

c++ -I"D:\Program Files\PostgreSQL\9.1\include" -L"D:\Program
Files\PostgreSQL\9.1\lib" -lpq -o %application_file% %application_file%.cpp
-Wl,--subsystem,windows -lgdi32 -lcomctl32 -D_WIN32_IE=0x0300

Compiler options to generate extra debug files:
c++ -I"D:\Program Files\PostgreSQL\9.1\include" -L"D:\Program
Files\PostgreSQL\9.1\lib" -lpq -o %application_file% %application_file%.cpp
-Wl,--subsystem,windows -lgdi32 -lcomctl32 -D_WIN32_IE=0x0300 -save-temps

Regards,
Denis Kolesnik.

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

--- Comment #1 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-09 19:56:25 UTC ---
Created attachment 27969
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=27969
additional files to source asked

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

--- Comment #2 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-09 19:57:37 UTC ---
Created attachment 27970
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=27970
object file

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

--- Comment #3 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-09 19:58:55 UTC ---
Created attachment 27971
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=27971
assembler source file

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[pinskia at gcc dot gnu.org]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

Andrew Pinski <pinskia at gcc dot gnu.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |WAITING
   Last reconfirmed|                            |2012-08-09
     Ever Confirmed|0                           |1
           Severity|enhancement                 |minor

--- Comment #4 from Andrew Pinski <pinskia at gcc dot gnu.org> 2012-08-09 20:00:56 UTC ---
Have you tried to reduce the problem to a simple source file where you only
call the PostgreSQL functions?  Try that and see what happens.  Right now your
source is huge and dependent on files most people here don't have access to.

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

Denis Kolesnik <lirex.software at gmail dot com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|WAITING                     |RESOLVED
         Resolution|                            |WORKSFORME

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

--- Comment #5 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-09 23:37:18 UTC ---
please see comments for the bug 54214, because it is the same, but with
corrected copyright notes.

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

Denis Kolesnik <lirex.software at gmail dot com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|WORKSFORME                  |DUPLICATE

--- Comment #6 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-16 22:38:19 UTC ---


*** This bug has been marked as a duplicate of bug 54214 ***

[Bug c++/54213] please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=54213

--- Comment #7 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-20 15:12:04 UTC ---
(In reply to comment #4)
> Have you tried to reduce the problem to a simple source file where you only
> call the PostgreSQL functions?  Try that and see what happens.  Right now your
> source is huge and dependent on files most people here don't have access to.

I did try to make my program to look more compact, but anyway I find my code
beautiful.