BUG #2847: Bug with IN statement

Поиск
Список
Период
Сортировка
От Sandip
Тема BUG #2847: Bug with IN statement
Дата
Msg-id 200612210738.kBL7cqc8083976@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2847: Bug with IN statement  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2847
Logged by:          Sandip
Email address:      sandip@singapore.com
PostgreSQL version: 8.1
Operating system:   Windows XP
Description:        Bug with IN statement
Details:

this is my function:

CREATE OR REPLACE FUNCTION sp_get_phase(character varying, character
varying, character varying)
  RETURNS ret_dv_sp_get_phase AS
$BODY$
SELECT          BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID,
UPDATE_DATE,
                      AddInfo1, AddInfo2
FROM            T_PHASE
WHERE           (USER_ID = $1) AND (COMPANY_ID = $2) AND BOOK_NO IN ($3)
$BODY$
  LANGUAGE 'sql' VOLATILE;


When I run
select * from sp_get_phase ('sandip', 'oms', '4')   returns 1
record.....this works fine....

select * from sp_get_phase ('sandip', 'oms', '1')  returns 1 record.....this
also works fine... BUT

select * from sp_get_phase ('sandip', 'oms', '1,4') this return a Blank
record.

I tried to execute the SQL statement from the function

SELECT          BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID,
UPDATE_DATE,
                      AddInfo1, AddInfo2
FROM            T_PHASE
WHERE           (USER_ID = 'testUser') AND (COMPANY_ID = 'testCompany') AND
BOOK_NO IN (1,4)

----- This Works fine... returns 2 records.   What may be the problem?

Thanks in advance.
Regards,
Sandip.

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

Предыдущее
От: "Roman Kononov"
Дата:
Сообщение: BUG #2846: inconsistent and confusing handling of underflows, NaNs and INFs
Следующее
От: "Terry Askew"
Дата:
Сообщение: BUG #2853: Internal error XXOO Hangs while attempting to clear table after several successful iterations