[Bug 918896] Re: No data returned from MSSQL server

[Robie Basak]

Thomas,

Thank you for the debdiffs! Unfortunately pymssql is a version 1.0
source package, so I'm not sure quilt makes sense. I suppose it will
work as you have supplied it, since your debdiffs would cause the
package to ship with quilt applied. I've not seen it done this way
before though, so I'm not comfortable sponsoring it without someone
senior telling me it's OK. I would have expected the patch to just be
applied without quilt (perhaps with more information in debian/changelog
as dep3 wouldn't be available).

-- 
You received this bug notification because you are a member of Ubuntu
Sponsors Team, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/918896

Title:
  No data returned from MSSQL server

Status in pymssql package in Ubuntu:
  Confirmed
Status in pymssql source package in Precise:
  Confirmed
Status in pymssql source package in Trusty:
  Confirmed
Status in pymssql source package in Wily:
  Confirmed
Status in pymssql source package in Xenial:
  Confirmed
Status in pymssql source package in Yakkety:
  Confirmed
Status in pymssql package in Debian:
  Confirmed

Bug description:
  [Impact]

   * Due to an issue with PyMSSQL 1.0.x and the version of FreeTDX in
  the repositories, PyMSSQL no longer returns any information from MSSQL
  database queries.  This means you cannot use fetchone() or fetchall()
  or similar methods to get data back from a database query.

  [Test Case]

   * Install python-pymssql to Ubuntu.
   
   * Inside a 'python' console on the Ubuntu server, use the following python code, replacing values accordingly for your MSSQL servers.  The "print" function will return 'None' in the current code base.  When fixed, you will get either one value, or a tuple, depending on the results (but you will NOT get 'None'):

  import pymssql
  dbconn = pymssql.connect(host='FQDN_FOR_DBSERVER', user='DBUSER', password='DBPASSWORD', database='DBNAME')
  dbcur = dbconn.cursor()
  dbcur.execute('ANY_VALID_SQL_QUERY')
  dbrs = dbcur.fetchone()
  dbcur.close()
  print dbrs


  [Regression Potential]

   * The patch in the debdiffs is from pymssql upstream.  We are on a
  very old pymssql, but this patch was designed to fix the issue.

  
  [Other Info]
   
   * Test builds in https://launchpad.net/~teward/+archive/ubuntu/pymssql/+packages; these packages in that PPA are used for testing and were used to test the upstream patch.

  
  [Original Description]

  this works great in oneiric, but in precise it silently returns empty results from SQL server. The upstream project has relocated and provided a new release, I downloaded and built it and the same code I had started returning results.
  http://code.google.com/p/pymssql/downloads/list

  ProblemType: Bug
  DistroRelease: Ubuntu 12.04
  Package: python-pymssql 1.0.2+dfsg-1build1
  ProcVersionSignature: Ubuntu 3.2.0-9.16-generic 3.2.1
  Uname: Linux 3.2.0-9-generic x86_64
  ApportVersion: 1.91-0ubuntu1
  Architecture: amd64
  Date: Thu Jan 19 20:24:31 2012
  EcryptfsInUse: Yes
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
  SourcePackage: pymssql
  UpgradeStatus: Upgraded to precise on 2012-01-16 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+subscriptions