Well the link provided isn't really about what I originally asked about. I have not come across a SQL implementation (Postgres, MySQL, or MSSQL are the ones I have experience in) where LIKE was "by default" case sensitive with wildcards. That being said, I'm not the type to based my assertions on my own experience.
That being said, I have understood that in other implementations users/administrators have the option to specify whether LIKE is case sensitive (I saw that in the posted link) Could we have that? If we can't agree on what other databases are doing, can we at least agree that some other databases do it differently by default, and for organizations making the move from a more traditional system to hive, having the option may help their transition? On Mon, May 14, 2012 at 4:36 PM, Keith Wiley <kwi...@keithwiley.com> wrote: > Thanks for the followup. > > > ________________________________________________________________________________ > Keith Wiley kwi...@keithwiley.com keithwiley.com > music.keithwiley.com > > "I used to be with it, but then they changed what it was. Now, what I'm > with > isn't it, and what's it seems weird and scary to me." > -- Abe (Grandpa) Simpson > > ________________________________________________________________________________ > >
