BUG #13557: ESQL select issue
От | haiyi_yang@163.com |
---|---|
Тема | BUG #13557: ESQL select issue |
Дата | |
Msg-id | 20150810080439.2695.98839@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #13557: ESQL select issue
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 13557 Logged by: yang Email address: haiyi_yang@163.com PostgreSQL version: 9.4.0 Operating system: Linux 6 Description: Step: 1. In postgres database create a table and insert a record. (1). create table ff (a char(20), b numeric(38,0), c date, d char(20)); (2). insert into ff values(NULL, 123, DATE'2011-02-03 04:05:06', 'AAAAAA'); 2. Edit ESQL program, use ecpg compile. EXEC SQL BEGIN DECLARE SECTION; char cv[64]; char vcv[64]; char ncv[64]; double bind; EXEC SQL END DECLARE SECTIEXEC SQL CONNECT TO 'postgres@192.168.2.119:266666' USER 'postgre' IDENTIFIED BY '123456'; EXEC SQL SELECT a, b, c, d INTO :cv, :bind, :vcv, :ncv FROM ff where b=123; printf("a = %s, b = %lf, c = %s, d = %s\n", cv, bind, vcv, ncv); EXEC SQL DISCONNECT ALL; Output: a = , b = 0.000000, c = , d =
В списке pgsql-bugs по дате отправления: