Concurrent Clean : MySQL

対話的に実行してもエラーになるなあ。
http://bugs.php.net/bug.php?id=29530と同じ問題なのかな？しかし、バグじゃないというだけで、全く参考にならない情報だな

• • • -

http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-prepare.html

For those of you suffering from a "1047: Unknown command" error, ensure your client and server side MySQL versions are compatible.

これかも。

• • • -

shellサーバーからmysqlコマンドで接続すると

Server version: 4.0.24_Debian-10sarge2-log

と表示されるので、4.0系の一番新しそうな4.0.27があったので、それを使ってコンパイルしてみたら・・・
mysql_stmt_prepareとかないのか！
うーむ。それはちと厳しすぎないか？

clm -nr -nt -v -ou -sl link Controller -o Controller
Linking Controller
/tmp/linkerClGJJ9: In function `main':
(.text+0x1c047): undefined reference to `mysql_sqlstate'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1c285): undefined reference to `mysql_stmt_errno'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1c295): undefined reference to `mysql_stmt_error'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1c2c0): undefined reference to `mysql_stmt_sqlstate'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1c795): undefined reference to `mysql_stmt_fetch_column'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1cb7b): undefined reference to `mysql_stmt_bind_param'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1cb8c): undefined reference to `mysql_stmt_execute'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1cbc3): undefined reference to `mysql_stmt_affected_rows'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1cbf6): undefined reference to `mysql_stmt_fetch'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d126): undefined reference to `mysql_stmt_init'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d174): undefined reference to `mysql_stmt_prepare'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d1d6): undefined reference to `mysql_stmt_param_count'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d22b): undefined reference to `mysql_stmt_result_metadata'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d324): undefined reference to `mysql_stmt_bind_result'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d39e): undefined reference to `mysql_stmt_close'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d414): undefined reference to `mysql_stmt_close'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d47e): undefined reference to `mysql_commit'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d496): undefined reference to `mysql_rollback'
/tmp/linkerClGJJ9: In function `main':
(.text+0x1d4b8): undefined reference to `mysql_autocommit'
/home/users/l/le/lethevert/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.c:(.text+0x61): undefined reference to `uncompress'
/home/users/l/le/lethevert/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
my_compress.c:(.text+0x10e): undefined reference to `compress'
/home/users/l/le/lethevert/lib/libmysqlclient.a(my_compress.o): In function `my_compress':
my_compress.c:(.text+0x1ca): undefined reference to `compress'
collect2: ld returned 1 exit status

• • • -

http://dev.mysql.com/doc/refman/4.1/en/mysql-stmt-prepare.html

This function was added in MySQL 4.1.2.

orz