On Thu, Mar 18, 2010 at 5:33 PM, Paul McCullagh
<[email protected]> wrote:
>
> On Mar 18, 2010, at 1:17 AM, Arjen Lentz wrote:
>
>> Hi Brian
>>
>> On 18/03/2010, at 4:04 AM, Brian Aker wrote:
>>>
>>> So Drizzle is case insensitive all the world around. AKA we follow the
>>> standard in this regard no matter the operating system (with MySQL by
>>> default the UNIX world is case sensitive,.. legacy of everything be based on
>>> the file system).
>>>
>>> Drizzle accomplishes this by doing case folding, aka we lower case
>>> everything internally. All upper case make me THINK YOU ARE YELLING.
>>>
>>> Here is the thing though, right now to make DD/IS look right I have to
>>> play with case. Internally we see things as lower case, but externally it
>>> seems like UPPER case for those table names seems correct.
>>>
>>> This is really bikeshed to me. People's thoughts on the display?
>>>
>>> There is BTW no requirement that a table function be upper case, I just
>>> have done that when doing the create object. So no matter what table
>>> functions will be whatever ever the author/creator calls them.
>>
>> I prefer uppercase for keywords and lowercase for identifiers.
>> Is there a necessity to have infoschema uppercase? I find it hideously
>> unreadable.
>
> Ditto on that!
>
> Does the SQL standard state that uppercase names must be used?
Found this in the SQL 92 Section 5.2 <token> and <separator>:
' 10)The <identifier body> of a <regular identifier> is equivalent
to an <identifier body> in which every letter that is a lower-
case letter is replaced by the equivalent upper-case letter
or letters. This treatment includes determination of equiva-
lence, representation in the Information and Definition Schemas,
representation in the diagnostics area, and similar uses.
...
12)Two <regular identifier>s are equivalent if their <identifier
body>s, considered as the repetition of a <character string
literal> that specifies a <character set specification> of
SQL_TEXT, compare equally according to the comparison rules
in Subclause 8.2, "<comparison predicate>". '
I'd vote for uppercase for both keywords and I_S views.
>
> That would be typical. Probably suggested by some Oracle guy because Oracle
> only uses uppercase because it was invented before computers had lowercase
> letters ;)
>
>> Regards,
>> Arjen.
>> --
>> Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
>> Exceptional Services for MySQL at a fixed budget.
>>
>> Follow our blog at http://openquery.com/blog/
>> OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~drizzle-discuss
>> Post to : [email protected]
>> Unsubscribe : https://launchpad.net/~drizzle-discuss
>> More help : https://help.launchpad.net/ListHelp
>
>
>
> --
> Paul McCullagh
> PrimeBase Technologies
> www.primebase.org
> www.blobstreaming.org
> pbxt.blogspot.com
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to : [email protected]
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help : https://help.launchpad.net/ListHelp
>
--
Cheers.
- Biping MENG
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
