DBD-mysql
DBD-mysql copied to clipboard
fix some queries with columns beginning with `limit` would fail
#288 fixes a problem in which SQL involving columns whose names end in limit cannot be generated successfully.
However, this fix caused SQL containing columns starting with limit to fail to generate successfully (e.g. SELECT * FROM table WHERE limit_by > ?).
This is because the syntax interpretation compares it to limit when it should be compared to limit which includes white space.
I have created a fix for this problem and a test code that can confirm this issue. With 4.050, modified t/35limit.t fails, but when this pull request is applied, it succeeds.
@dveeden Hello. Could you please take a look at this pull-request when you have a moment?
This seems ripe for merging - it has tests for the additional behaviour?