This is the mail archive of the
gcc-bugs@gcc.gnu.org
mailing list for the GCC project.
[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)
- From: "lirex.software at gmail dot com" <gcc-bugzilla at gcc dot gnu dot org>
- To: gcc-bugs at gcc dot gnu dot org
- Date: Sun, 19 Aug 2012 00:45:56 +0000
- Subject: [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)
- Auto-submitted: auto-generated
- References: <bug-54214-4@http.gcc.gnu.org/bugzilla/>
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.