Re: Yet another problematic query
> Our environment : Sun SparcServer 10/512 + Solaris 2.3 +
> OnLine dynamic server 6.00.UE1
skipped...
> Did any one else experience problems with such kind of queries (queries
> with grouping and a correlated subquery in the having-clause)?
Ria, I have very similar environment and have tested query
you described. I have got the same incorrect result! And here is
another strange behaviour:
CREATE PROCEDURE res001 (res LIKE "informix".systables.tabname)
DEFINE lres CHAR(10); LET lres = res[1,10];
END PROCEDURE;
When I run this script, the following error occures:
305: Subscripted column (res) is not of type CHAR, VARCHAR, TEXT nor BYTES.
But this works:
CREATE PROCEDURE res001 (res CHAR(18))
DEFINE lres CHAR(10); LET lres = res[1,10];
END PROCEDURE;
Any comments?
-------
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. Igor G.Popov . Laboratory of Open Information Systems, ltd. .
. res@lois.perm.su . Russia, Perm, b. Gagarina 49, +7-3422-486374 .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .