Results 1 to 4 of 4
Thread: Strange MySQL query anomaly
Aug 2, 2011, 00:07 #1
Strange MySQL query anomaly
I have two MySQL servers, one's a test the other's development. This query;
select * from pr_stops as Stop where stop.id = 1
Unfortunately this query is generated by the CakePHP framework, so I can't just edit the query manually.
test: MySQL 5.5.14
dev: MySQL 5.5.8
Can anyone help? Thanks.
Aug 2, 2011, 01:49 #2
- Join Date
- Aug 2000
- Philadephia, PA
- 1 Post(s)
- 0 Thread(s)
MySQL :: MySQL 5.0 Reference Manual :: 8.2.2 Identifier Case Sensitivity
In short, the case-sensitivity of the underlying operating system determines case-sensitivity of identifiers in queries.Try Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more
Aug 2, 2011, 02:45 #3
That makes sense, one is Windows and the other is Linux. Thank you so much for the link, I'll follow it up!
Aug 2, 2011, 03:14 #4
In case anyone else stumbles across this post with the same problem, here's how I solved it.
It turned out that I could change the query. In one of my controllers I was querying the model like this;
$this->Stop->find('first',array( 'conditions' => array( 'stop.id' => $id ) ) );