Modify ↓

Ticket #43 (closed defect: fixed)

Opened 5 years ago

Last modified 21 months ago

Column renames in mysql don't handle default value types correctly

Reported by: muffinresearchlabs@… Owned by: andrew
Priority: major Milestone:
Component: databaseapi Version: 0.6-pre
Keywords: mysql Cc:

Description

An example of this issue is that renaming a column doesn't quote strings at all causing the following syntax error:

_mysql_exceptions.ProgrammingError?: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rst' at line 1")

This seems to be partly because of how the query is composed it doesn't allow the db api to carry out it's own handling of values.

I've written a patch to make use of the db parameterization for the default value.

Attachments

mysql_db_parameterization.patch​ (1.3 KB) - added by muffinresearchlabs@… 5 years ago.
patch for mysql parameterization

Change History

Changed 5 years ago by muffinresearchlabs@…

patch for mysql parameterization

comment:1 Changed 5 years ago by andrew

  • Status changed from new to closed
  • Resolution set to fixed

Fixed in [94].

View ↑

Add a comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

Attachments ↑
 
Note: See TracTickets for help on using tickets.