#122 GetInsertSQL cannot handle database.table

open
nobody
None
5
2011-04-28
2011-04-28
Andrew Collins
No

When passing a DATABASE.TABLE (string) to GetInsertSQL() in the $rs var, GetInsertSQL causes the following:

mysqli error: [1103: Incorrect table name 'DATABASE.TABLE'] in EXECUTE("SHOW COLUMNS FROM `DATABASE.TABLE`")

It appears GetInsertSQL is not passing the DATABASE.TABLE value and then wrapping each chunk, but rather wrapping backticks around the full string.

Discussion

  • Andrew Collins
    Andrew Collins
    2011-04-28

    Bug appears in both v5.10 and v5.11.
    Also driver is mysqli