Re: Stripping white-space in SELECT statments

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: Stripping white-space in SELECT statments
Дата
Msg-id 200209191942.54258.andreak@officenet.no
обсуждение исходный текст
Ответ на Re: Stripping white-space in SELECT statments  (Thorbjörn Eriksson <thorbjorn.eriksson@ec.se>)
Список pgsql-sql
On Thursday 19 September 2002 13:41, Thorbjörn Eriksson wrote:
> By "our system" I mean the software that uses the database. It is a quit
> old software written in C that has been ported a couple of times to
> different *NIX platforms using different DBMS's. It uses in-house developed
> functions that, depending on parameters, creates a variety of SQL
> statements that in the end gets executed by PQexec (from libpq i guess).
[snip]
> > > artnrgrpmtrln_1<='201901  ÿ'

This looks like to me that your C software doesn't '\0' terminate its strings
proparly and some random byte gets in the query.

--
Andreas Joseph Krogh <andreak@officenet.no>



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How To Get Bytea Data Instead Of Its Oid
Следующее
От: "Michael Paesold"
Дата:
Сообщение: Re: Table Copy.