Public bug reported:
Dear Maintainer,
I am struggling with a strange issue concerning python-pymssql package,
which may be related to bux #463830 The problem questions the usability
of the module. It occurs when importing and using the native _mssql
module from the up-to-date (python-pymssql 1.0.2+dfsg-1) version of the
package.
Problems:
* It seems that only the first result set of a query is retrievable,
* The nextresult() method of the connection will always return True and will
not point to the next result set if any.
System:
$ lsb_release -rd
Description: Ubuntu 10.04.1 LTS
Release: 10.04
$ apt-cache policy python-pymssql
python-pymssql:
Installed: 1.0.2+dfsg-1
Candidate: 1.0.2+dfsg-1
Version table:
*** 1.0.2+dfsg-1 0
500 http://hu.archive.ubuntu.com/ubuntu/ lucid/universe Packages
100 /var/lib/dpkg/status
Note, I tried to compile the new version of python-pymssql from
http://code.google.com/p/pymssql/downloads/detail?name=pymssql-1.9.908.tar.gz&can=2&q=
but the cython package required and available in the distribution
conflicts in version.
The sequence of commands to generate erronous behaviour:
#####################################################
$ python
Python 2.6.5 (r265:79063, Apr 16 2010, 13:57:41)
[GCC 4.4.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import _mssql
>>> C=_mssql.connect(user='d2ruser', password='XXX', server='XXX',
>>> database='XXX')
>>> C.execute_query('SELECT current_user; SELECT GETDATE();')>>> for r in C:
>>> print r
...
{0: 'd2ruser'}
>>> C.nextresult()
1
>>> for r in C: print r
...
>>> C.nextresult()
1
>>> C.nextresult()
1
>>>
#####################################################
As a comparison the same command set works in debian lenny (with python-pymssql
1.0.1+dfsg-1):
#####################################################
$ python
Python 2.5.2 (r252:60911, Jan 4 2009, 17:40:26)
[GCC 4.3.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import _mssql
>>> C=_mssql.connect(user='d2ruser', password='XXX', server='XXX',
>>> database='XXX')
>>> C.execute_query('SELECT current_user; SELECT GETDATE();')
>>> for r in C: print r
...
{0: 'd2ruser'}
>>> C.nextresult()
1
>>>
>>> for r in C: print r
...
{0: datetime.datetime(2010, 9, 9, 9, 50, 47, 27000)}
>>> C.nextresult()
>>> print C.nextresult()
None
>>>
#####################################################
Please consider packaging a newer version of the sources.
Thanks. Kind regards,
S.J.
** Affects: pymssql (Ubuntu)
Importance: Undecided
Status: New
--
nextresult method in _mssql connect always returns True, and never points to
next result set if there is any more
https://bugs.launchpad.net/bugs/633882
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
