Somewhere about Tue, 10-Aug-2004 at 02:19PM +0200 (give or take), Carsten Pedersen wrote:
|> Hi Patrick, |> |> On Tue, 2004-08-10 at 12:16, Patrick Connolly wrote: |> > Is this the most appropriate list to mention misprints? There doesn't |> > seem to be an indication where additional suggestions are to be sent. |> |> This could be a good starting place if you want to discuss something in |> general - if you have specifics that are not already mentioned in the |> Certification Study Guide Errata - |> http://www.mysql.com/training/certification/studyguides/ - then please |> send them to [EMAIL PROTECTED] |> |> > I found something that, though not exactly incorrect, works for |> > reasons other than what a reader might think, so it's misleading. |> |> Posting your thinking to the list might be a good way to raise people's |> awareness of the issues involved. That is of course said with no |> knowledge of what kind of issues you have in mind :-) I've now done that. For anyone else who is interested to know, the errata list mentions the answer to Question 8.6 (p291) wherein a WHERE statement seems to be working with an alias when we know that wouldn't work. In fact, it works because the alias is only different from what it's aliasing by virtue of its case. Since column name matching is not case sensitive, it's really the column name itself which is being referenced, and so the query doesn't fall over. A "real" alias would not match. The answer to Question 5.12c (p178) is similarly misleading. Best -- ___ Patrick Connolly {~._.~} _( Y )_ Good judgment comes from experience (:_~*~_:) Experience comes from bad judgment (_)-(_) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
