A Newbie question about make and the term.c file
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: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:949: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:950: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:952: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:953: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:955: warning: passing argument 1 of ‘tgetnum’ discards qualifiers from pointer target type term.c:956: warning: passing argument 1 of ‘tgetnum’ discards qualifiers from pointer target type make[2]: *** [term.o] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive] Error 1 I can't figure out what it means or how to fix it. Help please. Peter
Re: A Newbie question about make and the term.c file
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 peter.schr...@gmail.comwrote: 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: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:949: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:950: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:952: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:953: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:955: warning: passing argument 1 of ‘tgetnum’ discards qualifiers from pointer target type term.c:956: warning: passing argument 1 of ‘tgetnum’ discards qualifiers from pointer target type make[2]: *** [term.o] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive] Error 1 I can't figure out what it means or how to fix it. Help please. Peter -- - michael dykman - mdyk...@gmail.com May the Source be with you.
MySQL fora overrun by spam
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A Newbie question about make and the term.c file
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 binary for ppc and then try upgrading. About the error, I am sure it is harmless, but I can't get past it, which means I can't use mysql. Peter On Oct 8, 2011, at 7:54 AM, Michael Dykman mdyk...@gmail.com wrote: 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 peter.schr...@gmail.comwrote: 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: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:949: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:950: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:952: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:953: warning: passing argument 1 of ‘tgetflag’ discards qualifiers from pointer target type term.c:955: warning: passing argument 1 of ‘tgetnum’ discards qualifiers from pointer target type term.c:956: warning: passing argument 1 of ‘tgetnum’ discards qualifiers from pointer target type make[2]: *** [term.o] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive] Error 1 I can't figure out what it means or how to fix it. Help please. Peter -- - michael dykman - mdyk...@gmail.com May the Source be with you.
optimizer in function
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 that expression were within a function called from the same spot, would the optimizer look into the function and see the same effectiv constant? or is it better to make it an argument to the function? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: optimizer in function
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 | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } - michael dykman 2011/10/8 Halász Sándor h...@tbbs.net 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 that expression were within a function called from the same spot, would the optimizer look into the function and see the same effectiv constant? or is it better to make it an argument to the function? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you.