i'm using amazon aws rds mysql, , have set lower_case_table_names=1 (not believe setting should make difference in case).
i'm executing query looking this:
insert trades.fills set version=@version, instanceid=@instanceid, etc and getting error back:
table 'trades.fills' doesn't exist note change of 'f' 'f'.
trades.fills exist in database, trades.fills not.
if "select * trades.fills" doesn't exist error (correct), , works if "select * trades.fills" (also correct).
any idea why change case of query, or else causing problem?
the problem here table called fills (capital f). had changed table name fills, there triggers still referred fills.
Comments
Post a Comment