[Info-Ingres] set printrules diagnostics -
04-17-2009
, 09:16 AM
Hi All,
I've been playing with some rfps and tracing their activity using the
'set printrules' statement.
And it seems OK right upto the point that the procedure called by the
rule executes a sub procedure.
What I've noticed is that the 'parameters passed' diagnostic is
incorrectly '0' on the sub procedure.
Try this:
1. createdb bowtest
2. sql bowtest < load_stuff.sql | \
egrep -e'\<E_[A-Z]{2}[0-9A-F]{4}' | \
grep -v -e'E_US0965' -e'E_US0AC1'
3. sql bowtest << SQL_END
\r
set printrules
\p\g
/* If the problem exists then the dignostic from printrules will claim
the
* parameters passed to sub_proc will be zero, not 2.
*/
insert into test_xxx values(1,2,3);
\p\g
\q
SQL_END
Marty |