brittneybrinsfield / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Advanced filter doesn't remove @ when it generates a query #1803

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Open any table
2. CMD + SHIFT + F to open the advanced query editor
3. Change default operator to an incorrect format, e.g. LIKE `%%`
4. Change editor back to correct format, e.g. LIKE '@'
5. Select a column, type in anything. e.g. asd

What is the expected output? WHERE query should say `column` LIKE 'asd'
What do you see instead? WHERE query says `column` LIKE 'asd@'

What version of Sequel Pro are you using?
1.0.2 build 4096 (issue showed up in past builds, too.

What version of OS X are you using?
10.6.8

What version of MySQL are you connecting to on the server?
5.1.70-cll

Please provide any additional information below.
I've also tried variations (@  `@` '%@%' etc.). They all create the same error.

Original issue reported on code.google.com by busin...@floydandpartners.com on 5 Sep 2013 at 3:34

Attachments: