MySQL Bugs: #45171: Connection.serverPrepareStatement() returns wrong default result set types

Bug #45171	Connection.serverPrepareStatement() returns wrong default result set types
Submitted:	28 May 2009 21:21	Modified:	23 Jun 2009 14:43
Reporter:	Mark Matthews	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S2 (Serious)
Version:		OS:	Any
Assigned to:	Mark Matthews	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Calling Connection.serverPrepareStatement() variants that don't take result set type or concurrency arguments returns statements that produce result sets with incorrect defaults, namely TYPE_SCROLL_SENSITIVE.

How to repeat:
Call Connection.serverPrepareStatement() and see what kind of statements it returns.

Now fixed.

An entry has been added to the 5.1.8 changelog:

Calling Connection.serverPrepareStatement() variants that do not take result set type or concurrency arguments returned statements that produced result sets with incorrect defaults, namely TYPE_SCROLL_SENSITIVE.