fenway

Can you post the sql-mode of each server?

Please post the solution, even it's not mysql.

FULLTEXT search as handled natively by mysql is basically broken... sphinx is much, much better.

Make a third table linking the two...

If you read the refman page on FULLTEXT, you'll see that it doesn't always return "everything" you would expect. If you don't have a large record set, of if your query matches too many records, you'll get unexpected output.

SQL-99 date format is YYYY-MM-DD HH:MM:SS.

That's a wildly misformated date.

Did you make a single fulltext index on all 3 columns, of a fulltext index on each column? You need the former, not the latter.

Then take a quite peek at the refman....

What about the second thought... about the spaces?

I'm fairly sure the information_schema has a "routines" table.... EDIT: wait, are you sure you didn't have a space between the function name and the open paren? There's an sql mode that buggers that up....

I'm saying don't use ZEROFILL... use LPAD() whenever you want to format your ID.

I mean that maybe someone has made a UDF that's broken. That error message you're getting is funny.

You can, but you don't want to... simply format the ID however you'd like on output.

Well, are they "related" to each other or just "duplicates"?

That's a VERY BAD idea.

What if you just try a simple ATAN2() call? Like the one from the refman? Also, please dump the existing list of function that you've created as mysql 5 objects.

Well, you need to get back LAST_INSERT_ID() from each of these inserts, and then insert it into the link table.

Also, if you're not using transactions, you statement isn't thread safe.

Why?

Also, don't ever actually send the password in the query... you can always check this in application code. Especially if you're not hashing your passwords...

Prepared statements aren't great for performance, though... they're per-connection. Also, if you properly escape special characters -- with mysql_real_escape_string() or your own personal function -- it doesn't get any *safer*.

How are you calling this? ATAN2() is an internal function....

Well, you don't have the SUPER privilege, apparently....

Why wouldn't the content be in mysql anyway?