InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Hi Ed

I wasn't able to reproduce this with a simple test. Maybe you could modify
the attached script so that it looks more like the table you're trying to
modify. Alternatively, a small self-contained java class that generates the
problem would do.

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Ed Kaltenbach <ekaltenbach@ara.com>
To: instantdb@enhydra.org <instantdb@enhydra.org>
Date: 16 August 2000 16:33
Subject: InstantDB: ALTER TABLE tableName DROP column BUG


>Hello,
>I have uncovered a bug in InstantDB.
>
>If I enter the following SQL command: "ALTER TABLE LETHALITY DROP
>Weapon2"
>then: "SELECT * FROM LETHALITY"
>I get an exception.
>It works fine with idb 3.13, but 3.14 and the newest 3.20b1 both have
>the bug.
>Any chance of getting it fixed before the final (non beta) release of
>version 3.2?
>
>Here is the exception I am getting:
>AWT-EventQueue-0 ALTER TABLE LETHALITY DROP Weapon2
>AWT-EventQueue-0 DELETE FROM qtar$db$cols WHERE ColId = 6840
>AWT-EventQueue-0 UPDATE qtar$db$cols SET offset = offset - 4 WHERE
>TableID = 1568 AND offset > 21
>AWT-EventQueue-0 Select * from LETHALITY
>AWT-EventQueue-0 java.sql.SQLException: Problem reading column,
>UNCERTAINTY, in table, LETHALITY, java.io.EOFException
>java.sql.SQLException: Problem reading column, UNCERTAINTY, in table,
>LETHALITY, java.io.EOFException
>        at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276,
>Compiled Code)
>        at
>org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235,
>Compiled Code)
>        at
>org.enhydra.instantdb.jdbc.idbStatement.executeQuery(idbStatement.java:91,
>Compiled Code)
>        at JDBCAdapter.executeQuery(JDBCAdapter.java:287, Compiled Code)
>
>        at QTAR.updateWeaponColumns(QTAR.java:8533)
>        at QTAR$1.actionPerformed(QTAR.java:725)
>        at JDBCAdapter.setValueAt(JDBCAdapter.java:1008, Compiled Code)
>        at TableSorter.setValueAt(TableSorter.java:314)
>        at javax.swing.JTable.setValueAt(JTable.java:1416)
>        at javax.swing.JTable.editingStopped(JTable.java:2544)
>        at
>javax.swing.DefaultCellEditor.fireEditingStopped(DefaultCellEditor.java:227
)
>
>        at
>javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEdi
tor.java:329)
>
>        at
>javax.swing.JTextField.fireActionPerformed(JTextField.java:409)
>        at javax.swing.JTextField.postActionEvent(JTextField.java:443)
>        at
>javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:537)
>
>        at
>javax.swing.text.JTextComponent.mapEventToAction(JTextComponent.java:966,
>Compiled Code)
>        at
>javax.swing.text.JTextComponent.processComponentKeyEvent(JTextComponent.jav
a:1431,
>Compiled Code)
>        at javax.swing.JComponent.processKeyEvent(JComponent.java:1538,
>Compiled Code)
>        at java.awt.Component.processEvent(Component.java:3008, Compiled
>Code)
>        at java.awt.Container.processEvent(Container.java:990, Compiled
>Code)
>        at java.awt.Component.dispatchEventImpl(Component.java:2394,
>Compiled Code)
>        at java.awt.Container.dispatchEventImpl(Container.java:1035,
>Compiled Code)
>        at java.awt.Component.dispatchEvent(Component.java:2307,
>Compiled Code)
>        at
>java.awt.LightweightDispatcher.processKeyEvent(Container.java:1770,
>Compiled Code)
>        at
>java.awt.LightweightDispatcher.dispatchEvent(Container.java:1740,
>Compiled Code)
>        at java.awt.Container.dispatchEventImpl(Container.java:1022,
>Compiled Code)
>        at java.awt.Window.dispatchEventImpl(Window.java:749, Compiled
>Code)
>        at java.awt.Component.dispatchEvent(Component.java:2307,
>Compiled Code)
>        at java.awt.EventQueue.dispatchEvent(EventQueue.java:287,
>Compiled Code)
>        at
>java.awt.EventDispatchThread.pumpOneEvent(EventDispatchThread.java:103,
>Compiled Code)
>        at
>java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:92)
>        at java.awt.EventDispatchThread.run(EventDispatchThread.java:83)
>
>
>
>
>
>---------------------------------------------------------------------------
--
>To unsubscribe from this mailing list, send email to majordomo@enhydra.org
>with the text "unsubscribe instantdb" in the body of the email.
>If you have other questions regarding this mailing list, send email to
>the list admin at owner-instantdb@enhydra.org.
>

d org.enhydra.instantdb.jdbc.idbDriver;
o jdbc:idb=e:\instantdb\bugs\sample.prp;

e SET EXPORT "trace.log" TRACE 6 CONSOLE;

drop table tmp;
create table tmp (int1 int, char1 char(10));
insert into tmp values (1, "hello");
insert into tmp values (2, "hello");
q select * from tmp;
alter table tmp drop int1;
q select * from tmp;

c close;
c exit;