mysql, PG need percent sign escaping in DDL as well

Issue #1279 resolved
Mike Bayer repo owner created an issue

this illustrated by the tests added in r5674.

Comments (4)

  1. Mike Bayer reporter

    this is mostly a ridiculous use case for those two DBs anyway, and neither psycopg2 or MySQLdb can handle the full test cases (before this change, that you can use %(foobar)s as a bind parameter name is the one psycopg2 can't do). SQLA would have to completely bend over backwards translate/detect the %(foobar)s style bindparam or that executemany() is used with a statement, working around what are essentially bugs in both dialects that I am sure have a snowball's chance in hades of ever being fixed on their end. so the test has been slightly scaled back in 0542d35f391f15e729483c3c9123158ba0923404 and that's that.

  2. Log in to comment