BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.

From: herbert(dot)grohmann(at)vallourec(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.
Date: 2014-01-20 11:54:11
Message-ID: 20140120115411.26701.48100@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8893
Logged by: Herbert Grohmann
Email address: herbert(dot)grohmann(at)vallourec(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Meskes 2014-01-20 12:27:45 Re: BUG #8893: Precompiler ECPG doesn't check Var-List in Select corrrect.
Previous Message Marti Raudsepp 2014-01-20 09:55:42 Re: BUG #8891: Duplicate Primary Key