odbc queries with very long strings fail with no exceptions

[leve]

BPO	1006056
Nosy	@loewis

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2004-08-10.07:34:23.000>
created_at = <Date 2004-08-09.16:17:43.000>
labels = ['invalid', 'OS-windows']
title = 'odbc queries with very long strings fail with no exceptions'
updated_at = <Date 2004-08-10.07:34:23.000>
user = 'https://bugs.python.org/leve'

bugs.python.org fields:

activity = <Date 2004-08-10.07:34:23.000>
actor = 'loewis'
assignee = 'none'
closed = True
closed_date = None
closer = None
components = ['Windows']
creation = <Date 2004-08-09.16:17:43.000>
creator = 'leve'
dependencies = []
files = []
hgrepos = []
issue_num = 1006056
keywords = []
message_count = 2.0
messages = ['22035', '22036']
nosy_count = 2.0
nosy_names = ['loewis', 'leve']
pr_nums = []
priority = 'normal'
resolution = 'not a bug'
stage = None
status = 'closed'
superseder = None
type = None
url = 'https://bugs.python.org/issue1006056'
versions = ['Python 2.3']

[leve]

#W2K MSSQL 2000

#CREATE TABLE [dbo].[Table1] (
#    [Id] [int] NULL ,
#    [Data] [int] NULL 
#)
 
import dbi, odbc
import time

myconn = odbc.odbc('DSN=ctbase2; UID=sa; PWD=')
mycursor = myconn.cursor()

updatelst = []
start = time.time()

for i in range(10000):
    updatelst.append("update table1 set id = %d, data = 
%d " % (i, i))
stri = " ".join(updatelst)
rc = mycursor.execute(stri)
myconn.commit()   
#time.sleep(100)
mycursor.close()
myconn.close()

# When running this script, a very long string is passed
to execute.
# Only a few first update commands are executed.
# (I checked it by reading the data back).
# Somehow this is timing dependant.
# If sleep is commented out - 480 commands are
executed.
# If sleep is for 10 sec. - 1600 - 1800 commands are
executed.
# If sleep is for 100 sec. - 3800 commands are executed.
# In all cases no exception is thrown and rc = 1

[loewis]

Logged In: YES
user_id=21627

Python does not provide an odbc module. Please report the
bug to the author of the odbc module you are using.