FreeTDS Development Group

[Jeff Dahl <jddahl AT micron.com>]

Why does this query

   CREATE TABLE #data( myID varchar( 25 ))
   INSERT into #data select myID from myTable where myID = 'data1'
   INSERT into #data select myID from myTable where myID = 'data2'
   CREATE index myindex on #data (myID)
   SELECT myID
   FROM #data, myTable
   WHERE ( #data.myID = myTable.myID )
   DROP TABLE #data

generate this error:

   SQL_STATE: 24000
   NATIVE_ERROR: 0
   MSG: [FreeTDS][SQL Server]Invalid cursor state
   MSG_LEN: 41

I've tried this with both 0.63 and the latest CVS version.  Only the CVS
version gives the error.  Version 0.63 doesn't return anything.

Thanks,
Jeff Dahl