SQL/MX Connectivity Service Manual (SQL/MX 2.x)

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual—524944-008
3-34
Troubleshooting MFC
Known Issues
Scenario 1
MFC plans become obsolete when the base table is altered or dropped. The following
sequence of operations illustrates the issue.
Operation Expected
Result
Actual Result Remarks
Create table test-
ing(info int);
Success Success Table testing is created.
Stmt1 = Pre-
pare("select * from
testing")
Success Success Stmt1 is prepared with
MXCMP.
Stmt1.execute() Success Success Stmt1 is executed.
Stmt1.fetch() Success Success Data in the table testing
is retrieved.
Stmt1 = Pre-
pare("select * from
testing")
Success Success Compiled plan is
retrieved from MFC.
Stmt1.execute() Success Success MFC statement works
as expected.
Stmt1.executeUp-
date("drop table
testing")
Success Success The table testing is
dropped.
Stmt1.executeUp-
date("create table
testing (mycol var-
char(10))")
Success Success The table testing is cre-
ated with varchar col-
umn.
Stmt1 = Pre-
pare("select * from
testing")
Success Success Compiled plan is
retrieved from MFC,
which is not correct
because the table
datatype is changed
when the MFC plan is
created.