------_=_NextPart_001_01C32B72.4A9EE234
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
We ran into a bug in moving an oracle application to mysql. The problem
is that table aliases are not treated as case insensitive, so:
select ta.id from mytable tA
will fail. All other databases will know that tA==ta.
------_=_NextPart_001_01C32B72.4A9EE234--
Churchill, John writes:
> We ran into a bug in moving an oracle application to mysql. The problem
> is that table aliases are not treated as case insensitive, so:
>
> select ta.id from mytable tA
>
> will fail. All other databases will know that tA==ta.
Yes, that is true.
MySQL treats table aliases as case sensitive.
We will have to check out carefully what SQL standards are saying on
this subject and change behaviour accordingly.
If we change aliases to case insensitive it will be in non-production
version, 4.1.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
This issue exists in Unix versions, Windows versions are case in-sensitive
as far as table names are concerned
Regards,
Shamit verma
http://www.vshamit.com
----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Thursday, June 05, 2003 9:15 PM
Subject: Re: mysql case sensitivity problem
> Churchill, John writes:
> > We ran into a bug in moving an oracle application to mysql. The problem
> > is that table aliases are not treated as case insensitive, so:
> >
> > select ta.id from mytable tA
> >
> > will fail. All other databases will know that tA==ta.
>
>
> Yes, that is true.
>
> MySQL treats table aliases as case sensitive.
>
> We will have to check out carefully what SQL standards are saying on
> this subject and change behaviour accordingly.
>
> If we change aliases to case insensitive it will be in non-production
> version, 4.1.
>
> --
>
> Regards,
>
> --
> For technical support contracts, go to https://order.mysql.com/?ref=msmi
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=mysql@vshamit.com
>
>
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Churchill, John writes:
> We ran into a bug in moving an oracle application to mysql. The problem
> is that table aliases are not treated as case insensitive, so:
>
> select ta.id from mytable tA
>
> will fail. All other databases will know that tA==ta.
FYI, we have already made table aliases case insensitive, but on
Windows only.
This has been implemented in version 4.1.
Are you using Windows ???
If you are, you will find that version 4.1 has case insensitive table
aliases.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Actually, yes I am using the Windows version (with a java/solaris client
but that shouldn't matter). I am using 4.0.13 so I don't have your fix.
Thanks for the rapid reply. We have already "fixed" our side of the
code.
John
-----Original Message-----
From: Sinisa Milivojevic [mailto:sinisa@mysql.com]
Sent: Thursday, June 05, 2003 11:06 AM
To: Churchill, John
Cc: bugs@lists.mysql.com
Subject: Re: mysql case sensitivity problem
Churchill, John writes:
> We ran into a bug in moving an oracle application to mysql. The
problem
> is that table aliases are not treated as case insensitive, so:
>
> select ta.id from mytable tA
>
> will fail. All other databases will know that tA==ta.
FYI, we have already made table aliases case insensitive, but on
Windows only.
This has been implemented in version 4.1.
Are you using Windows ???
If you are, you will find that version 4.1 has case insensitive table
aliases.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
John Churchill writes:
> Actually, yes I am using the Windows version (with a java/solaris client
> but that shouldn't matter). I am using 4.0.13 so I don't have your fix.
>
> Thanks for the rapid reply. We have already "fixed" our side of the
> code.
>
> John
>
>
We should thank you actually.
It turned out that table aliases should be case insensitive,
regardless of the platform.
We shall put on our TODO, for 4.1, to make them case insensitive by
default, on all platforms.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
No, thank YOU for supporting software that makes it so that I don't have
to run the oracle monster on my laptop for demos. And the thanks for the
rapid reply stands too -- oracle probably doesn't even have a bug
reporting mechanism, much less one that has an answer within 10 minutes.
John
-----Original Message-----
From: Sinisa Milivojevic [mailto:sinisa@mysql.com]
Sent: Thursday, June 05, 2003 11:21 AM
To: Churchill, John
Cc: bugs@lists.mysql.com
Subject: RE: mysql case sensitivity problem
John Churchill writes:
> Actually, yes I am using the Windows version (with a java/solaris
client
> but that shouldn't matter). I am using 4.0.13 so I don't have your
fix.
>
> Thanks for the rapid reply. We have already "fixed" our side of the
> code.
>
> John
>
>
We should thank you actually.
It turned out that table aliases should be case insensitive,
regardless of the platform.
We shall put on our TODO, for 4.1, to make them case insensitive by
default, on all platforms.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org