Hi All,
The follow command sequence will crash msql - it also crashes a java app so the problem may lay in the jdbc or kernel level.
msql system/manager@jdbc:polite:TEST
Oracle MSQL Version 1.0.0.0.2
(c) Copyright 2001 Oracle Corporation. All rights reserved
Connected to: Oracle9i Lite ORDBMS
Database Name: TEST (Read Write)
Database Version: 4.0.3.12.0
Auto Commit: off
Driver Name: oracle.lite.poljdbc.POLJDBCDriver (OLite 4.0)
SQL> create sequence test ;
Sequence created
SQL> create public synonym test for test;
Synonym created
SQL> drop sequence test;
Sequence dropped
SQL> commit;
Commit complete
SQL> select test.nextval from dual;
msql crashes out at this point, wheras I would have expected something along the lines of "Synonym translation no longer valid".
Is this a known issue?
Andy