Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
5.5.37
-
None
-
Hardware architecture: x86
Operating system: Red Hat 7.0 GA
MySQL Python connector version: 1.2.3
Description
If i run the following command in Python command line:
import MySQLdb
|
connArgs={"host": <server_url>,
|
"user": <user>,
|
"passwd": <password>,
|
"db": <database_name>}
|
conn = MySQLdb.connect(**connArgs)
|
conn.autocommit = True
|
cursor = conn.cursor(MySQLdb.cursors.DictCursor)
|
query = <insert_sql_query>
|
cursor.execute(query)
|
and then check the MariaDB database, the inserted tuple does not show up in a SELECT query output. If I commit as shown below, the new tuple shows up in SELECT query output.
conn.commit()
This works correctly in MySQL server 5.1.66, same MySQLdb module version.