[Bug c++/54214] New: (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or GCC error (combobox and SQL data sorting)

[Bug c++/54214] New: (corrected copyright notes in source file)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=54214

             Bug #: 54214
           Summary: (corrected copyright notes in source file)please help
                    to determine whether 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 27972
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=27972
a c++ source file

hello,

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.

Regards,
Denis Kolesnik.

[Bug c++/54214] (corrected copyright notes in source file)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=54214

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

[Bug c++/54214] (corrected copyright notes in source file)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=54214

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

[Bug c++/54214] (corrected copyright notes in source file)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=54214

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

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #4 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-09 20:22:40 UTC ---
operation system is Windows XP Home Edition(I guessit is an OEM version) with
Service Pack 3 installed.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #5 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-09 20:24:54 UTC ---
my operation system is Windows XP Home Edition(I guess it is an OEM version)
with Service Pack 3 installed.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[redi at gcc dot gnu.org]

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

--- Comment #6 from Jonathan Wakely <redi at gcc dot gnu.org> 2012-08-09 21:50:59 UTC ---
Why is this marked "enhancement" ?

Is this the same issue as PR 54213 ? If so please close that one.

What exactly is your question and why do you think it's anything to do with
GCC?

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #7 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-16 22:38:19 UTC ---
*** Bug 54213 has been marked as a duplicate of this bug. ***

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #8 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-18 21:19:51 UTC ---
my command line for compile:

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

-save-temps - this option I use to have all files included(assembler source,
etc...)

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #9 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-18 21:41:05 UTC ---
(In reply to comment #6)
> Why is this marked "enhancement" ?
> 
> Is this the same issue as PR 54213 ? If so please close that one.
> 
> What exactly is your question and why do you think it's anything to do with
> GCC?

I want to be last names sorted in a combobox alphabetically and use for it
"...order by str_last_name...".

Then I use one line returning SQL request, which helps to determine with wich
table id it is(by using SQL "...offset..." and combobox item number) and data
represented with table id not equals with id returned by the second SQL query.

The problem is solved if I do not use "...order by str_last_name..." but it is
not convenient to have data unsorted...

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |INVALID

--- Comment #10 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-18 22:09:22 UTC ---
I'm sorry. That is my falut and the problem was that I overflowed variables
size causing undefined behaviour. Now I kwon what it is.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|INVALID                     |

--- Comment #11 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-18 22:13:31 UTC ---
(In reply to comment #10)
> I'm sorry. That is my falut and the problem was that I overflowed variables
> size causing undefined behaviour. Now I kwon what it is.

sorry, this comment was for the bug 54180

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #12 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-18 22:15:40 UTC ---
> > What exactly is your question and why do you think it's anything to do with
> > GCC?

that is one of my questions. Whether it is a GCC bug or PstgreSQL. Or even
againg my errors in my code.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[redi at gcc dot gnu.org]

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

Jonathan Wakely <redi at gcc dot gnu.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |DUPLICATE
           Severity|enhancement                 |normal

--- Comment #13 from Jonathan Wakely <redi at gcc dot gnu.org> 2012-08-18 22:18:28 UTC ---
This line contains a bug:

strcpy(SQL1,"select id, ' ', regexp_replace(str_last_name,' ','') as lastname,
' ', regexp_replace(str_first_name,' ','') as firstname, ' ', age(dt_birth) as
age from tbl_owners_individual;");

SQL1 only has capacity for 150 chars, but you write more than 170 to it. This
is a serious bug in your program (not in GCC or postgresql).

When you use the "order by" clause you write even more characters to the array,
which is still a bug.

Either learn to use dynamically-allocated memory or ensure your arrays are big
enough to hold the strings you write to them.

This is the same issue as PR 54180

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

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|DUPLICATE                   |

--- Comment #14 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-19 00:44:57 UTC ---
(In reply to comment #13)
> This line contains a bug:
> 
> strcpy(SQL1,"select id, ' ', regexp_replace(str_last_name,' ','') as lastname,
> ' ', regexp_replace(str_first_name,' ','') as firstname, ' ', age(dt_birth) as
> age from tbl_owners_individual;");
> 
> SQL1 only has capacity for 150 chars, but you write more than 170 to it. This
> is a serious bug in your program (not in GCC or postgresql).
> 
> When you use the "order by" clause you write even more characters to the array,
> which is still a bug.
> 
> Either learn to use dynamically-allocated memory or ensure your arrays are big
> enough to hold the strings you write to them.
> 
> This is the same issue as PR 54180
> 
> *** This bug has been marked as a duplicate of bug 54180 ***

now my CHAR SQL1[350] as you see is 350 characters long, but the problem is the
same:

if I choose a filed from the combobox with the id 1 in the database table
the second query, which also ends with the clause "...order by
str_last_name..."
returns the field with the id 111(if I remember correct), but should with 1.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #15 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-19 00:45:56 UTC ---
(In reply to comment #13)
> This line contains a bug:
> 
> strcpy(SQL1,"select id, ' ', regexp_replace(str_last_name,' ','') as lastname,
> ' ', regexp_replace(str_first_name,' ','') as firstname, ' ', age(dt_birth) as
> age from tbl_owners_individual;");
> 
> SQL1 only has capacity for 150 chars, but you write more than 170 to it. This
> is a serious bug in your program (not in GCC or postgresql).
> 
> When you use the "order by" clause you write even more characters to the array,
> which is still a bug.
> 
> Either learn to use dynamically-allocated memory or ensure your arrays are big
> enough to hold the strings you write to them.
> 
> This is the same issue as PR 54180
> 
> *** This bug has been marked as a duplicate of bug 54180 ***

now my CHAR SQL1[350] as you see is 350 characters long, but the problem is the
same:

if I choose a field from the combobox with the id 1 in the database table
the second query, which also ends with the clause "...order by
str_last_name..."
returns the field with the id 111(if I remember correct), but should with 1.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #27972|0                           |1
        is obsolete|                            |

--- Comment #16 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-19 00:51:37 UTC ---
Created attachment 28047
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=28047
a newer c++ source file

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #17 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-19 00:54:19 UTC ---
(In reply to comment #10)
> I'm sorry. That is my falut and the problem was that I overflowed variables
> size causing undefined behaviour. Now I kwon what it is.

sorry for my bad english - know

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[redi at gcc dot gnu.org]

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

Jonathan Wakely <redi at gcc dot gnu.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |INVALID

--- Comment #18 from Jonathan Wakely <redi at gcc dot gnu.org> 2012-08-19 10:54:13 UTC ---
Gcc cannot alter results of an SQL query, it's a bug in your program. This is
the wrong place to get help debugging your code.

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #19 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-19 18:15:49 UTC ---
(In reply to comment #18)
> Gcc cannot alter results of an SQL query, it's a bug in your program. This is
> the wrong place to get help debugging your code.

You are right: I consider now, that it is a PostgreSQL SQL bug.

limit 1 offset ... order byt str_last_name
filters data wrong...

[Bug c++/54214] (corrected copyright notes in source file)please help to determine whether it is an PostgreSQL error or a GCC error (combobox and SQL data sorting)

[lirex.software at gmail dot com]

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

--- Comment #20 from Denis Kolesnik <lirex.software at gmail dot com> 2012-08-19 18:21:08 UTC ---
sure: I found, that the bug is if I use "limit 1" clause.

It is surelly a bug.