Test Build:CUBRID 2008 R4.1 (8.4.1.0559) (64bit release build for linux_gnu)
OS: Linux 64
Description: CUBRID 2008 R4.1 (8.4.1.0559) (64bit release build for linux_gnu)
Repro Steps:
python execute_rollback.py pydb 33012
Statements in execute_rollback.py
{noformat}
dbname=sys.argv[1]
port=sys.argv[2]
url='CUBRID:localhost:' + port + : + dbname+::?autocommit=false
print url
con=CUBRIDdb.connect(url)
#con=CUBRIDdb.connect(CUBRID:localhost:33012:pydb:dba::?autocommit=false)
cursor=con.cursor()
cursor.execute (DROP TABLE IF EXISTS rollback_tb)
cursor.execute ( CREATE TABLE rollback_tb(id int primary key, a int) )
con.commit()
cursor.execute ( insert into rollback_tb values(22, 222222) )
con.rollback()
cursor.execute (select * from rollback_tb )
result_set = cursor.fetchall ()
for row in result_set:
print %s, %s % (row[0], row[1])
print rollback and close
{noformat}
Actual result:
{noformat}
Connect to db
CUBRID:localhost:33012:pydb::?autocommit=false
22, 222222
rollback and close
reconnect
22, 222222
{noformat}
Expect result:
the result of inquiring is empty