Re: Foreign key and uppercase / lowercase values

2012-06-18 Thread GF
http://bugs.mysql.com/bug.php?id=65648 On Fri, Jun 15, 2012 at 7:00 PM, Rick James wrote: > You are very close to a standalone test case.  Please create such.  Then post > it on bugs.mysql.com . > >> -Original Message----- >> From: GF [mailto:gan...@gmail.com] >>

Re: Foreign key and uppercase / lowercase values

2012-06-15 Thread GF
I think the following might give complete information (I removed some columns not involved in the problem) Server version: 5.1.49-3 (Debian) SET collation_connection = utf8_unicode_ci; Query OK, 0 rows affected (0.00 sec) show variables like '%colla%'; +--+-

Re: Foreign key and uppercase / lowercase values

2012-06-12 Thread GF
ank you. On Wed, May 16, 2012 at 5:35 PM, Shawn Green wrote: > Hello Ananda, > > > On 5/16/2012 6:42 AM, Ananda Kumar wrote: >> >> why are not using any where condition in the update statment >> > > WHERE clauses are not required. Performing a command withou

Foreign key and uppercase / lowercase values

2012-05-16 Thread GF
Good morning, I have an application where the user ids were stored lowercase. Some batch import, in the user table some users stored a uppercase id, and for some applicative logic, in other tables that have a foreign key to the user table, their user ids are stored lowercase. MySQL didn't throw an

VIEW and ROW_NUMBER

2008-01-03 Thread GF
SET command and using variables.. but I don't think in a VIEW I can use variables and SET. Any idea? Thanks. GF -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]