Unexpected SQLSTATE for DROP TABLE nonexistent

Using 3.23.55-nt and J/Connector, I dropped a nonexistent
table, expecting SQLSTATE 42S02. Instead, I got the totally
generic S1000 with error code 1051. The manual doesn't make
any statement about ISO 9075 or X/Open compliance for SQLSTATE.
Is this considered a bug or a feature?



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Unexpected SQLSTATE for DROP TABLE nonexistent

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Stuart Friedberg wrote:
| Using 3.23.55-nt and J/Connector, I dropped a nonexistent
| table, expecting SQLSTATE 42S02. Instead, I got the totally
| generic S1000 with error code 1051. The manual doesn't make
| any statement about ISO 9075 or X/Open compliance for SQLSTATE.
| Is this considered a bug or a feature?
|
|
|


I will take a look at fixing this. As things work now, MySQL doesn't
have SQLStates, so the JDBC driver has to do a mapping, and sometimes
not all error codes given by the server map correctly (as you've seen).

We're actively looking to add SQLStates to the server itself to solve
this problem.

- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

~ __ ___ ___ ____ __
~ / |/ /_ __/ __/ __ \/ / Mark Matthews
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~ <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+lXmatvXNTca6JD8RAsABAKCBMVHIqCiNNpTsnDceFk5+JWFuiQCf Srd2
nuyyoc7tFN5d4UCnu7M+Eow=
=y/Jc
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org