A Newbie question about make and the term.c file

2011-10-08 Thread Peter Schrock
I am trying to install mysql 5.1.59 on my ppc running os x and I get this error message in the term.c file. cc1: warnings being treated as errors term.c: In function ‘term_set’: term.c:946: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:947: warning:

Re: A Newbie question about make and the term.c file

2011-10-08 Thread Michael Dykman
I can't help directly with the error message (the warning seems fairly harmless), but may I inquire why you are building MySQL instead of using one of the prepared binaries? Compiling under OS/X can be pretty harrowing. - michael dykman On Sat, Oct 8, 2011 at 2:49 AM, Peter Schrock

MySQL fora overrun by spam

2011-10-08 Thread Peter Brawley
Several MySQL fora, including all the Usage fora, have been overrun by spam to the point of unusability, with no sign of effective remediation. This gives the impression that a process of letting MySQL die of neglect has begun. PB -- MySQL General Mailing List For list archives:

Re: A Newbie question about make and the term.c file

2011-10-08 Thread Peter Schrock
I can understand your point, however, as stated, I am using a ppc architecture and am not afforded the luxury of binaries in the most up to date versions. I know using 5.1.59 isn't the most up to date, but I was also having issues with the most current version. I might start with the most current

optimizer in function

2011-10-08 Thread Hal�sz S�ndor
Does the optimizer look into function called from query? In my queries the expression (SELECT hwyl FROM Stock) / (SELECT regularPayment FROM Stock), where Stock is a one-record table, often is repeated. The optimizer sees that, and makes the ratio a constant, and I can afford to be clear. If

Re: optimizer in function

2011-10-08 Thread Michael Dykman
I think the only clues the optimizer consults with regard to UDFs is the 'characteristic' provided at the time you create the routine. from http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html * * *characteristic*: COMMENT '*string*' | LANGUAGE SQL | [NOT] DETERMINISTIC | {