BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.
От | herbert.grohmann@vallourec.com |
---|---|
Тема | BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect. |
Дата | |
Msg-id | 20140120115411.26701.48100@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #8893: Precompiler ECPG doesn't check Var-List in
Select corrrect.
Re: BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect. |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 8893 Logged by: Herbert Grohmann Email address: herbert.grohmann@vallourec.com PostgreSQL version: 9.0.15 Operating system: Open Suse Linux 11.4 Description: EXEC SQL SELECT TO_CHAR(beginn, 'yyyy-mm-dd hh24:mi:ss'), TO_CHAR(ende, 'yyyy-mm-dd hh24:mi:ss'), tot_logisch, tot_15, stiche, laenge, anz_stangenwechsel, stoerzeit_stangenwechsel, stoerzeit_schicht, gueltig, stoerzeit_a1, stoerzeit_a2, stoerzeit_a3, stoerzeit_a4, stoerzeit_a5, stoerzeit_a6, stoerzeit_a7, stoerzeit_a8, stoerzeit_a9, stoerzeit_a10, schichtnr, meister, theor_planlaufzeit, TO_CHAR(time_1_rohr_schicht, 'yyyy-mm-dd hh24:mi:ss'), taktzeitverlust, merk_sammel_laeuft, zeit_sammelstoerung, Merker_Stangenwechsel_laeuft, Merker_Stoerung_laeuft, Merker_Handbetrieb_laeuft, Merker_Tavl_Auto_laeuft, TO_CHAR(d_stw, 'yyyy-mm-dd hh24:mi:ss'), TO_CHAR(d_sto, 'yyyy-mm-dd hh24:mi:ss'), TO_CHAR(d_han, 'yyyy-mm-dd hh24:mi:ss'), TO_CHAR(d_tav, 'yyyy-mm-dd hh24:mi:ss'), gewinn_plantakt, bem1, bem2, bem3, summe_plantakt, Id, sugru_1,sugru_2,sugru_3,sugru_4,sugru_5,sugru_6,sugru_7,sugru_8,sugru_9 stoerzeit_a11,stoerzeit_a12,stoerzeit_a13,stoerzeit_a14,stoerzeit_a15,stoerzeit_a16 INTO :s_schichtsatz FROM ww_stoerung_schichten WHERE ende = to_timestamp(:s_schichtsatz.end, 'yyyy.mm.dd hh24:mi:ss') ; Missing Komma after sugru_9 does not produce a Compiler Error! Bad Program goes in Production. Results :: PgSQL-Error from<stoerd_get_schichtsatz>/<Error Read Schichtsatz> Err=<-201>/07002 -- /<too many arguments on line 317> test_komma: Key= 2014-01-20 06:00:00| 2014-01-20 13:59:59 PgSQL-Error from<test_komm:: _get_schichtsatz>/<Error Read Schichtsatz> Err=<-201>/07002 -- /<too many arguments on line 317> test_komma: Key= 2014-01-20 06:00:00| 2014-01-20 13:59:59 test_komma: Signal received , Stop !!! This is a very old Error ad i hope, you can correct it. An Update to newer Version of PostgreSQL is very problematic. Beast regards Herbert Grohmann
В списке pgsql-bugs по дате отправления: