Anyone seen this error ?
v10.2.0
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
It's when a subselect is happening inside the select clause.
select c_amka_asqenh=m.c_amka,
d_episkep=a.d_episkep,
d_egrafhs=a.d_egrafhs,
eid_epis=0,
c_grnoe_bi_id =
(select squeeze(bi_id) from grnoe
where grnoe.c_grnoe = a.c_grnoe),
c_amka_doctor=p.c_amka,
kat_prog=0,
kleidi=concat(a.c_grnoe, squeeze(varchar(replace(varchar(a.d_episkep),' ',''))))
from epexa a inner join masqe m on
a.am_asqenh = m.am_asqenh
left join mypal p on
a.am_ypal = p.am_ypal
where a.c_grnoe = ? and
a.d_episkep = ? and
a.iatreio = ? and
a.end_yper = ?
The curious thing is that the query runs fine from isql but when run through a Perl program it throws.
The same program and sql query were running fine before the update to 10.2.0.After the update it broke.
the installation is unpatched so I asked for it to be patched in hope that this was an Ingres bug.
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
It's when a subselect is happening inside the select clause.
select c_amka_asqenh=m.c_amka,
d_episkep=a.d_episkep,
d_egrafhs=a.d_egrafhs,
eid_epis=0,
c_grnoe_bi_id =
(select squeeze(bi_id) from grnoe
where grnoe.c_grnoe = a.c_grnoe),
c_amka_doctor=p.c_amka,
kat_prog=0,
kleidi=concat(a.c_grnoe, squeeze(varchar(replace(varchar(a.d_episkep),' ',''))))
from epexa a inner join masqe m on
a.am_asqenh = m.am_asqenh
left join mypal p on
a.am_ypal = p.am_ypal
where a.c_grnoe = ? and
a.d_episkep = ? and
a.iatreio = ? and
a.end_yper = ?
The curious thing is that the query runs fine from isql but when
run through a Perl program it throws. The same program and sql query
were running fine before the update to 10.2.0.After the update it
broke. the installation is unpatched so I asked for it to be patched in
hope that this was an Ingres bug.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 20:54:14 |
Calls: | 8,764 |
Calls today: | 7 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,545 |