Errors: Here's what happens: A user tries to log on to the acs
system after having registered.... Say he decides not to wait for the
email and tries to log in. ... server error!
Error is in first select statement in /register/awaiting-email-
verification.tcl
Error 1: Postgresql doesn't use rowid so the Select needs
to be re-written as
... oid as rowid ...
Error 2: Multiple rows returned because in pseudocode
Select... user_id = 9 and user_state =... or user_state= ...
THis is fixed with parens to make the logic right.
Select... user_id = 9 and (user_state =... or user_state= ...)
This was reported in sdm as Bug 949
Discussion:
I am somewhat surprised to find this error in 3.2.4. I would have
expected that it would have been found in earlier versions.
So, the first error is a difference between Oracle and Postgresql
The Second error is a logic error and probably has been there for
years...
I know there are other errors like this and I'll look for more but,
wouldn't be helpful for the SDM to have a "within package text
SEARCH?" I would love to search for "rowid" and see if this was a
reported bug, perhaps in another module etc...
I'm looking forward to 3.2.5. Will there be versions like 3.2.6
or are we on to the 4.x series ?
4x is a major rewrite and being software will have simular bugs...
OR
is this just "A Programmer's Life: bugs will always be found?
-Bob