I have expirienced a strange behavior with the UPDATE statement in HSQLDB. When I update some record in my table, it changes my TIME and DATE columns to null despite the fact that I didn't mention them in the statement, e.g.:
stmt.executeUpdate("UPDATE my_table SET age=15 WHERE user_name='malcom'");
and I get column "age" changed to "15", and also columns "time" and "date" changed to null? What is goin' on? Any idea? All other data manipulation works OK?
Joined: Jan 15, 2002
In fact, I don't know what caused the problem. After restarting the server, everything had worked correctly.