[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: Inconsistent error msgs?
From:       "Graeme St.Clair" <graeme_st_clair () charter ! net>
Date:       2004-03-27 2:52:32
Message-ID: 005d01c413a6$8d679050$4deb69cc () Presario
[Download RAW message or body]

Yes, the difference is definitely due to the number of strings in the
concatenation.

After my original post, I poked around in the documentation (and the C
header files), and found the following:-

 #define ER_CANT_AGGREGATE_3COLLATIONS 1269
 #define ER_CANT_AGGREGATE_NCOLLATIONS 1270

I appreciate there may well be difficulty in having mysql emit an error msg
describing this problem in detail within an indefinitely large concatenation
(!), but perhaps it could report the first occurrence in detail, or better
still, use format 1269 to report occurrences n-1, n and n+1 within a
concatenation if it detects the problem at item n.  IMHO, msg 1270 is so
vague as to be practically useless.

(But having msg numbers at all is still a splendid idea!)

Rgds, GStC.


----- Original Message ----- 
From: "Paul DuBois" <paul@mysql.com>
To: "Graeme St.Clair" <graeme_st_clair@charter.net>; "Win32 MySQL List"
<win32@lists.mysql.com>
Sent: Friday, March 26, 2004 9:10 PM
Subject: Re: Inconsistent error msgs?

<snip/>

> More likely just that in the second query you have more than 3 strings,
> so the error message doesn't list all the various collations.
> Try removing one of the strings from the second query, or adding
> another string to the first query.  You'll likely see the error
> messages change.
>
> -- 
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> MySQL Users Conference: April 14-16, 2004
> http://www.mysql.com/uc2004/
>
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=graeme_st_clair@charter.net
>
>



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]