Chinaunix

标题: gcc中报错token @ is not a valid preprocessor expressions [打印本页]

作者: rsuhkoi 时间: 2008-08-29 19:01
标题: gcc中报错token @ is not a valid preprocessor expressions
最近在做移植，将Linux下的C程序移植到Windows下。程序在Linux下编译没有任何问题，当在mingw下使用gcc 3.4编译的时候，居然报错：mysql.h ：307，token “@” is not a valid preprocessor expressions。打开一看，这个头文件中压根就没有@这个字符，以为是字符集的问题，重新从Linux服务器上拿了份代码，再次编译，依然是同样的错误。没有办法，花了很大力气，将gcc升级到4.1，一编译程序，还是那个错误。
我怀疑是gcc编译选项的问题，但是不知道错在哪里了。希望高手能指点一二。

作者: freearth 时间: 2008-08-29 21:45
至少要把mysql.h文件贴出来吧。

原帖由 rsuhkoi 于 2008-8-29 19:01 发表
最近在做移植，将Linux下的C程序移植到Windows下。程序在Linux下编译没有任何问题，当在mingw下使用gcc 3.4编译的时候，居然报错：mysql.h ：307，token “@” is not a valid preprocessor expressions。打开一 ...

作者: rsuhkoi 时间: 2008-08-29 21:54
标题: 回复 #2 freearth 的帖子
/* Copyright (C) 2000-2003 MySQL AB

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; version 2 of the License.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/*
  This file defines the client API to MySQL and also the ABI of the
  dynamically linked libmysqlclient.

  The ABI should never be changed in a released product of MySQL
  thus you need to take great care when changing the file. In case
  the file is changed so the ABI is broken, you must also
  update the SHAREDLIB_MAJOR_VERSION in configure.in .

*/

#ifndef _mysql_h
#define _mysql_h

#ifdef _AIX          /* large-file support will break without this */
#include <standards.h>
#endif

#ifdef __CYGWIN__    /* CYGWIN implements a UNIX API */
#undef WIN
#undef _WIN
#undef _WIN32
#undef _WIN64
#undef __WIN__
#endif

#ifdef __cplusplus
extern "C" {
#endif

#ifndef _global_h /* If not standard header */
#include <sys/types.h>
#ifdef __LCC__
#include <winsock.h> /* For windows */
#endif
typedef char my_bool;
#if (defined(_WIN32) || defined(_WIN64)) && !defined(__WIN__)
#define __WIN__
#endif
#if !defined(__WIN__)
#define STDCALL
#else
#define STDCALL __stdcall
#endif
typedef char * gptr;

#ifndef my_socket_defined
#ifdef __WIN__
#define my_socket SOCKET
#else
typedef int my_socket;
#endif /* __WIN__ */
#endif /* my_socket_defined */
#endif /* _global_h */

#include "mysql_version.h"
#include "mysql_com.h"
#include "mysql_time.h"
#include "typelib.h"

#include "my_list.h" /* for LISTs used in 'MYSQL' and 'MYSQL_STMT' */

extern unsigned int mysql_port;
extern char *mysql_unix_port;

#define CLIENT_NET_READ_TIMEOUT 365*24*3600 /* Timeout on read */
#define CLIENT_NET_WRITE_TIMEOUT 365*24*3600 /* Timeout on write */

#ifdef __NETWARE__
#pragma pack(push,

/* 8 byte alignment */
#endif

#define IS_PRI_KEY(n) ((n) & PRI_KEY_FLAG)
#define IS_NOT_NULL(n) ((n) & NOT_NULL_FLAG)
#define IS_BLOB(n) ((n) & BLOB_FLAG)
#define IS_NUM(t) ((t) <= FIELD_TYPE_INT24 || (t) == FIELD_TYPE_YEAR || (t) == FIELD_TYPE_NEWDECIMAL)
#define IS_NUM_FIELD(f) ((f)->flags & NUM_FLAG)
#define INTERNAL_NUM_FIELD(f) (((f)->type <= FIELD_TYPE_INT24 && ((f)->type != FIELD_TYPE_TIMESTAMP || (f)->length == 14 || (f)->length ==

) || (f)->type == FIELD_TYPE_YEAR)
#define IS_LONGDATA(t) ((t) >= MYSQL_TYPE_TINY_BLOB && (t) <= MYSQL_TYPE_STRING)

typedef struct st_mysql_field {
  char *name;                /* Name of column */
  char *org_name;          /* Original column name, if an alias */
  char *table;             /* Table of column if column was a field */
  char *org_table;          /* Org table name, if table was an alias */
  char *db;                /* Database for table */
  char *catalog;       /* Catalog for table */
  char *def;                /* Default value (set by mysql_list_fields) */
  unsigned long length;    /* Width of column (create length) */
  unsigned long max_length; /* Max width for selected set */
  unsigned int name_length;
  unsigned int org_name_length;
  unsigned int table_length;
  unsigned int org_table_length;
  unsigned int db_length;
  unsigned int catalog_length;
  unsigned int def_length;
  unsigned int flags;       /* Div flags */
  unsigned int decimals;    /* Number of decimals in field */
  unsigned int charsetnr;    /* Character set */
  enum enum_field_types type; /* Type of field. See mysql_com.h for types */
} MYSQL_FIELD;

typedef char **MYSQL_ROW; /* return data as array of strings */
typedef unsigned int MYSQL_FIELD_OFFSET; /* offset to current field */

#ifndef _global_h
#if defined(NO_CLIENT_LONG_LONG)
typedef unsigned long my_ulonglong;
#elif defined (__WIN__)
typedef unsigned __int64 my_ulonglong;
#else
typedef unsigned long long my_ulonglong;
#endif
#endif

#define MYSQL_COUNT_ERROR (~(my_ulonglong) 0)

/* backward compatibility define - to be removed eventually */
#define ER_WARN_DATA_TRUNCATED WARN_DATA_TRUNCATED

typedef struct st_mysql_rows {
  struct st_mysql_rows *next; /* list of rows */
  MYSQL_ROW data;
  unsigned long length;
} MYSQL_ROWS;

typedef MYSQL_ROWS *MYSQL_ROW_OFFSET; /* offset to current row */

#include "my_alloc.h"

typedef struct embedded_query_result EMBEDDED_QUERY_RESULT;
typedef struct st_mysql_data {
  my_ulonglong rows;
  unsigned int fields;
  MYSQL_ROWS *data;
  MEM_ROOT alloc;
  /* extra info for embedded library */
  struct embedded_query_result *embedded_info;
} MYSQL_DATA;

enum mysql_option
{
  MYSQL_OPT_CONNECT_TIMEOUT, MYSQL_OPT_COMPRESS, MYSQL_OPT_NAMED_PIPE,
  MYSQL_INIT_COMMAND, MYSQL_READ_DEFAULT_FILE, MYSQL_READ_DEFAULT_GROUP,
  MYSQL_SET_CHARSET_DIR, MYSQL_SET_CHARSET_NAME, MYSQL_OPT_LOCAL_INFILE,
  MYSQL_OPT_PROTOCOL, MYSQL_SHARED_MEMORY_BASE_NAME, MYSQL_OPT_READ_TIMEOUT,
  MYSQL_OPT_WRITE_TIMEOUT, MYSQL_OPT_USE_RESULT,
  MYSQL_OPT_USE_REMOTE_CONNECTION, MYSQL_OPT_USE_EMBEDDED_CONNECTION,
  MYSQL_OPT_GUESS_CONNECTION, MYSQL_SET_CLIENT_IP, MYSQL_SECURE_AUTH,
  MYSQL_REPORT_DATA_TRUNCATION, MYSQL_OPT_RECONNECT,
  MYSQL_OPT_SSL_VERIFY_SERVER_CERT
};

struct st_mysql_options {
  unsigned int connect_timeout, read_timeout, write_timeout;
  unsigned int port, protocol;
  unsigned long client_flag;
  char *host,*user,*password,*unix_socket,*db;
  struct st_dynamic_array *init_commands;
  char *my_cnf_file,*my_cnf_group, *charset_dir, *charset_name;
  char *ssl_key; /* PEM key file */
  char *ssl_cert; /* PEM cert file */
  char *ssl_ca; /* PEM CA file */
  char *ssl_capath; /* PEM directory of CA-s? */
  char *ssl_cipher; /* cipher to use */
  char *shared_memory_base_name;
  unsigned long max_allowed_packet;
  my_bool use_ssl; /* if to use SSL or not */
  my_bool compress,named_pipe;
/*
On connect, find out the replication role of the server, and
establish connections to all the peers
*/
  my_bool rpl_probe;
/*
Each call to mysql_real_query() will parse it to tell if it is a read
or a write, and direct it to the slave or the master
*/
  my_bool rpl_parse;
/*
If set, never read from a master, only from slave, when doing
a read that is replication-aware
*/
  my_bool no_master_reads;
#if !defined(CHECK_EMBEDDED_DIFFERENCES) || defined(EMBEDDED_LIBRARY)
  my_bool separate_thread;
#endif
  enum mysql_option methods_to_use;
  char *client_ip;
  /* Refuse client connecting to server if it uses old (pre-4.1.1) protocol */
  my_bool secure_auth;
  /* 0 - never report, 1 - always report (default) */
  my_bool report_data_truncation;

  /* function pointers for local infile support */
  int (*local_infile_init)(void **, const char *, void *);
  int (*local_infile_read)(void *, char *, unsigned int);
  void (*local_infile_end)(void *);
  int (*local_infile_error)(void *, char *, unsigned int);
  void *local_infile_userdata;
};

enum mysql_status
{
  MYSQL_STATUS_READY,MYSQL_STATUS_GET_RESULT,MYSQL_STATUS_USE_RESULT
};

enum mysql_protocol_type
{
  MYSQL_PROTOCOL_DEFAULT, MYSQL_PROTOCOL_TCP, MYSQL_PROTOCOL_SOCKET,
  MYSQL_PROTOCOL_PIPE, MYSQL_PROTOCOL_MEMORY
};
/*
  There are three types of queries - the ones that have to go to
  the master, the ones that go to a slave, and the adminstrative
  type which must happen on the pivot connectioin
*/
enum mysql_rpl_type
{
  MYSQL_RPL_MASTER, MYSQL_RPL_SLAVE, MYSQL_RPL_ADMIN
};

typedef struct character_set
{
  unsigned int    number;    /* character set number             */
  unsigned int    state;    /* character set state             */
  const char       *csname; /* collation name                   */
  const char       *name;    /* character set name             */
  const char       *comment; /* comment                         */
  const char       *dir;    /* character set directory          */
  unsigned int    mbminlen; /* min. length for multibyte strings */
  unsigned int    mbmaxlen; /* max. length for multibyte strings */
} MY_CHARSET_INFO;

struct st_mysql_methods;
struct st_mysql_stmt;

typedef struct st_mysql
{
  NET net; /* Communication parameters */
  gptr connector_fd; /* ConnectorFd for SSL */
  char *host,*user,*passwd,*unix_socket,*server_version,*host_info,*info;
  char       *db;
  struct charset_info_st *charset;
  MYSQL_FIELD *fields;
  MEM_ROOT field_alloc;
  my_ulonglong affected_rows;
  my_ulonglong insert_id; /* id if insert on table with NEXTNR */
  my_ulonglong extra_info; /* Not used */
  unsigned long thread_id; /* Id for connection in server */
  unsigned long packet_length;
  unsigned int port;
  unsigned long client_flag,server_capabilities;
  unsigned int protocol_version;
  unsigned int field_count;
  unsigned int server_status;
  unsigned int  server_language;
  unsigned int warning_count;
  struct st_mysql_options options;
  enum mysql_status status;
  my_bool free_me; /* If free in mysql_close */
  my_bool reconnect; /* set to 1 if automatic reconnect */

  /* session-wide random string */
  char          scramble[SCRAMBLE_LENGTH+1];

/*
Set if this is the original connection, not a master or a slave we have
added though mysql_rpl_probe() or mysql_set_master()/ mysql_add_slave()
*/
  my_bool rpl_pivot;
  /*
Pointers to the master, and the next slave connections, points to
itself if lone connection.
  */
  struct st_mysql* master, *next_slave;

  struct st_mysql* last_used_slave; /* needed for round-robin slave pick */
/* needed for send/read/store/use result to work correctly with replication */
  struct st_mysql* last_used_con;

  LIST  *stmts;                   /* list of all statements */
  const struct st_mysql_methods *methods;
  void *thd;
  /*
Points to boolean flag in MYSQL_RES  or MYSQL_STMT. We set this flag
from mysql_stmt_close if close had to cancel result set of this object.
  */
  my_bool *unbuffered_fetch_owner;
#if defined(EMBEDDED_LIBRARY) || defined(EMBEDDED_LIBRARY_COMPATIBLE) || MYSQL_VERSION_ID >= 50100
  /* needed for embedded server - no net buffer to store the 'info' */
  char *info_buffer;
#endif

} MYSQL;

typedef struct st_mysql_res {
  my_ulonglong row_count;
  MYSQL_FIELD *fields;
  MYSQL_DATA *data;
  MYSQL_ROWS *data_cursor;
  unsigned long *lengths; /* column lengths of current row */
  MYSQL *handle; /* for unbuffered reads */
  MEM_ROOT field_alloc;
  unsigned int field_count, current_field;
  MYSQL_ROW row; /* If unbuffered read */
  MYSQL_ROW current_row; /* buffer to current row */
  my_bool eof; /* Used by mysql_fetch_row */
  /* mysql_stmt_close() had to cancel this result */
  my_bool    unbuffered_fetch_cancelled;
  const struct st_mysql_methods *methods;
} MYSQL_RES;

#define MAX_MYSQL_MANAGER_ERR 256
#define MAX_MYSQL_MANAGER_MSG 256

#define MANAGER_OK          200
#define MANAGER_INFO       250
#define MANAGER_ACCESS    401
#define MANAGER_CLIENT_ERR 450
#define MANAGER_INTERNAL_ERR 500

#if !defined(MYSQL_SERVER) && !defined(MYSQL_CLIENT)
#define MYSQL_CLIENT
#endif

typedef struct st_mysql_manager
{
  NET net;
  char *host,*user,*passwd;
  unsigned int port;
  my_bool free_me;
  my_bool eof;
  int cmd_status;
  int last_errno;
  char* net_buf,*net_buf_pos,*net_data_end;
  int net_buf_size;
  char last_error[MAX_MYSQL_MANAGER_ERR];
} MYSQL_MANAGER;

typedef struct st_mysql_parameters
{
  unsigned long *p_max_allowed_packet;
  unsigned long *p_net_buffer_length;
} MYSQL_PARAMETERS;

#if !defined(MYSQL_SERVER) && !defined(EMBEDDED_LIBRARY)
#define max_allowed_packet (*mysql_get_parameters()->p_max_allowed_packet)
#define net_buffer_length (*mysql_get_parameters()->p_net_buffer_length)
#endif

/*
  Set up and bring down the server; to ensure that applications will
  work when linked against either the standard client library or the
  embedded server library, these functions should be called.
*/
int STDCALL mysql_server_init(int argc, char **argv, char **groups);
void STDCALL mysql_server_end(void);
/*
  mysql_server_init/end need to be called when using libmysqld or
  libmysqlclient (exactly, mysql_server_init() is called by mysql_init() so
  you don't need to call it explicitely; but you need to call
  mysql_server_end() to free memory). The names are a bit misleading
  (mysql_SERVER* to be used when using libmysqlCLIENT). So we add more general
  names which suit well whether you're using libmysqld or libmysqlclient. We
  intend to promote these aliases over the mysql_server* ones.
*/
#define mysql_library_init mysql_server_init
#define mysql_library_end mysql_server_end

MYSQL_PARAMETERS *STDCALL mysql_get_parameters(void);

/*
  Set up and bring down a thread; these function should be called
  for each thread in an application which opens at least one MySQL
  connection.  All uses of the connection(s) should be between these
  function calls.
*/
my_bool STDCALL mysql_thread_init(void);
void STDCALL mysql_thread_end(void);

/*
  Functions to get information from the MYSQL and MYSQL_RES structures
  Should definitely be used if one uses shared libraries.
*/

作者: rsuhkoi 时间: 2008-08-29 21:56
标题: 回复 #2 freearth 的帖子
/*
  Functions to get information from the MYSQL and MYSQL_RES structures
  Should definitely be used if one uses shared libraries.
*/

my_ulonglong STDCALL mysql_num_rows(MYSQL_RES *res);
unsigned int STDCALL mysql_num_fields(MYSQL_RES *res);
my_bool STDCALL mysql_eof(MYSQL_RES *res);
MYSQL_FIELD *STDCALL mysql_fetch_field_direct(MYSQL_RES *res,
      unsigned int fieldnr);
MYSQL_FIELD * STDCALL mysql_fetch_fields(MYSQL_RES *res);
MYSQL_ROW_OFFSET STDCALL mysql_row_tell(MYSQL_RES *res);
MYSQL_FIELD_OFFSET STDCALL mysql_field_tell(MYSQL_RES *res);

unsigned int STDCALL mysql_field_count(MYSQL *mysql);
my_ulonglong STDCALL mysql_affected_rows(MYSQL *mysql);
my_ulonglong STDCALL mysql_insert_id(MYSQL *mysql);
unsigned int STDCALL mysql_errno(MYSQL *mysql);
const char * STDCALL mysql_error(MYSQL *mysql);
const char *STDCALL mysql_sqlstate(MYSQL *mysql);
unsigned int STDCALL mysql_warning_count(MYSQL *mysql);
const char * STDCALL mysql_info(MYSQL *mysql);
unsigned long STDCALL mysql_thread_id(MYSQL *mysql);
const char * STDCALL mysql_character_set_name(MYSQL *mysql);
int       STDCALL mysql_set_character_set(MYSQL *mysql, const char *csname);

MYSQL * STDCALL mysql_init(MYSQL *mysql);
my_bool STDCALL mysql_ssl_set(MYSQL *mysql, const char *key,
      const char *cert, const char *ca,
      const char *capath, const char *cipher);
const char * STDCALL mysql_get_ssl_cipher(MYSQL *mysql);
my_bool STDCALL mysql_change_user(MYSQL *mysql, const char *user,
   const char *passwd, const char *db);
MYSQL * STDCALL mysql_real_connect(MYSQL *mysql, const char *host,
   const char *user,
   const char *passwd,
   const char *db,
   unsigned int port,
   const char *unix_socket,
   unsigned long clientflag);
int STDCALL mysql_select_db(MYSQL *mysql, const char *db);
int STDCALL mysql_query(MYSQL *mysql, const char *q);
int STDCALL mysql_send_query(MYSQL *mysql, const char *q,
   unsigned long length);
int STDCALL mysql_real_query(MYSQL *mysql, const char *q,
unsigned long length);
MYSQL_RES *    STDCALL mysql_store_result(MYSQL *mysql);
MYSQL_RES *    STDCALL mysql_use_result(MYSQL *mysql);

/* perform query on master */
my_bool STDCALL mysql_master_query(MYSQL *mysql, const char *q,
   unsigned long length);
my_bool STDCALL mysql_master_send_query(MYSQL *mysql, const char *q,
unsigned long length);
/* perform query on slave */
my_bool STDCALL mysql_slave_query(MYSQL *mysql, const char *q,
   unsigned long length);
my_bool STDCALL mysql_slave_send_query(MYSQL *mysql, const char *q,
         unsigned long length);
void       STDCALL mysql_get_character_set_info(MYSQL *mysql,
                        MY_CHARSET_INFO *charset);

/* local infile support */

#define LOCAL_INFILE_ERROR_LEN 512

void
mysql_set_local_infile_handler(MYSQL *mysql,
                           int (*local_infile_init)(void **, const char *,
                        void *),
                           int (*local_infile_read)(void *, char *,
unsigned int),
                           void (*local_infile_end)(void *),
                           int (*local_infile_error)(void *, char*,
   unsigned int),
                           void *);

void
mysql_set_local_infile_default(MYSQL *mysql);

/*
  enable/disable parsing of all queries to decide if they go on master or
  slave
*/
void          STDCALL mysql_enable_rpl_parse(MYSQL* mysql);
void          STDCALL mysql_disable_rpl_parse(MYSQL* mysql);
/* get the value of the parse flag */
int          STDCALL mysql_rpl_parse_enabled(MYSQL* mysql);

/*  enable/disable reads from master */
void          STDCALL mysql_enable_reads_from_master(MYSQL* mysql);
void          STDCALL mysql_disable_reads_from_master(MYSQL* mysql);
/* get the value of the master read flag */
my_bool STDCALL mysql_reads_from_master_enabled(MYSQL* mysql);

enum mysql_rpl_type    STDCALL mysql_rpl_query_type(const char* q, int len);

/* discover the master and its slaves */
my_bool STDCALL mysql_rpl_probe(MYSQL* mysql);

/* set the master, close/free the old one, if it is not a pivot */
int          STDCALL mysql_set_master(MYSQL* mysql, const char* host,
   unsigned int port,
   const char* user,
   const char* passwd);
int          STDCALL mysql_add_slave(MYSQL* mysql, const char* host,
unsigned int port,
const char* user,
const char* passwd);

int STDCALL mysql_shutdown(MYSQL *mysql,
                                    enum mysql_enum_shutdown_level
                                    shutdown_level);
int STDCALL mysql_dump_debug_info(MYSQL *mysql);
int STDCALL mysql_refresh(MYSQL *mysql,
      unsigned int refresh_options);
int STDCALL mysql_kill(MYSQL *mysql,unsigned long pid);
int STDCALL mysql_set_server_option(MYSQL *mysql,
enum enum_mysql_set_option
option);
int STDCALL mysql_ping(MYSQL *mysql);
const char * STDCALL mysql_stat(MYSQL *mysql);
const char * STDCALL mysql_get_server_info(MYSQL *mysql);
const char * STDCALL mysql_get_client_info(void);
unsigned long STDCALL mysql_get_client_version(void);
const char * STDCALL mysql_get_host_info(MYSQL *mysql);
unsigned long STDCALL mysql_get_server_version(MYSQL *mysql);
unsigned int STDCALL mysql_get_proto_info(MYSQL *mysql);
MYSQL_RES * STDCALL mysql_list_dbs(MYSQL *mysql,const char *wild);
MYSQL_RES * STDCALL mysql_list_tables(MYSQL *mysql,const char *wild);
MYSQL_RES * STDCALL mysql_list_processes(MYSQL *mysql);
int STDCALL mysql_options(MYSQL *mysql,enum mysql_option option,
      const char *arg);
void STDCALL mysql_free_result(MYSQL_RES *result);
void STDCALL mysql_data_seek(MYSQL_RES *result,
my_ulonglong offset);
MYSQL_ROW_OFFSET STDCALL mysql_row_seek(MYSQL_RES *result,
MYSQL_ROW_OFFSET offset);
MYSQL_FIELD_OFFSET STDCALL mysql_field_seek(MYSQL_RES *result,
   MYSQL_FIELD_OFFSET offset);
MYSQL_ROW STDCALL mysql_fetch_row(MYSQL_RES *result);
unsigned long * STDCALL mysql_fetch_lengths(MYSQL_RES *result);
MYSQL_FIELD * STDCALL mysql_fetch_field(MYSQL_RES *result);
MYSQL_RES *    STDCALL mysql_list_fields(MYSQL *mysql, const char *table,
   const char *wild);
unsigned long STDCALL mysql_escape_string(char *to,const char *from,
      unsigned long from_length);
unsigned long STDCALL mysql_hex_string(char *to,const char *from,
                                       unsigned long from_length);
unsigned long STDCALL mysql_real_escape_string(MYSQL *mysql,
         char *to,const char *from,
         unsigned long length);
void STDCALL mysql_debug(const char *debug);
void STDCALL myodbc_remove_escape(MYSQL *mysql,char *name);
unsigned int STDCALL mysql_thread_safe(void);
my_bool STDCALL mysql_embedded(void);
MYSQL_MANAGER*  STDCALL mysql_manager_init(MYSQL_MANAGER* con);
MYSQL_MANAGER*  STDCALL mysql_manager_connect(MYSQL_MANAGER* con,
      const char* host,
      const char* user,
      const char* passwd,
      unsigned int port);
void          STDCALL mysql_manager_close(MYSQL_MANAGER* con);
int          STDCALL mysql_manager_command(MYSQL_MANAGER* con,
const char* cmd, int cmd_len);
int          STDCALL mysql_manager_fetch_line(MYSQL_MANAGER* con,
   char* res_buf,
   int res_buf_size);
my_bool       STDCALL mysql_read_query_result(MYSQL *mysql);

/*
  The following definitions are added for the enhanced
  client-server protocol
*/

/* statement state */
enum enum_mysql_stmt_state
{
  MYSQL_STMT_INIT_DONE= 1, MYSQL_STMT_PREPARE_DONE, MYSQL_STMT_EXECUTE_DONE,
  MYSQL_STMT_FETCH_DONE
};

/*
  This structure is used to define bind information, and
  internally by the client library.
  Public members with their descriptions are listed below
  (conventionally `On input' refers to the binds given to
  mysql_stmt_bind_param, `On output' refers to the binds given
  to mysql_stmt_bind_result):

  buffer_type - One of the MYSQL_* types, used to describe
               the host language type of buffer.
               On output: if column type is different from
               buffer_type, column value is automatically converted
               to buffer_type before it is stored in the buffer.
  buffer       - On input: points to the buffer with input data.
               On output: points to the buffer capable to store
               output data.
               The type of memory pointed by buffer must correspond
               to buffer_type. See the correspondence table in
               the comment to mysql_stmt_bind_param.

  The two above members are mandatory for any kind of bind.

  buffer_length  - the length of the buffer. You don't have to set
               it for any fixed length buffer: float, double,
               int, etc. It must be set however for variable-length
               types, such as BLOBs or STRINGs.

  length       - On input: in case when lengths of input values
               are different for each execute, you can set this to
               point at a variable containining value length. This
               way the value length can be different in each execute.
               If length is not NULL, buffer_length is not used.
               Note, length can even point at buffer_length if
               you keep bind structures around while fetching:
               this way you can change buffer_length before
               each execution, everything will work ok.
               On output: if length is set, mysql_stmt_fetch will
               write column length into it.

  is_null       - On input: points to a boolean variable that should
               be set to TRUE for NULL values.
               This member is useful only if your data may be
               NULL in some but not all cases.
               If your data is never NULL, is_null should be set to 0.
               If your data is always NULL, set buffer_type
               to MYSQL_TYPE_NULL, and is_null will not be used.

  is_unsigned - On input: used to signify that values provided for one
               of numeric types are unsigned.
               On output describes signedness of the output buffer.
               If, taking into account is_unsigned flag, column data
               is out of range of the output buffer, data for this column
               is regarded truncated. Note that this has no correspondence
               to the sign of result set column, if you need to find it out
               use mysql_stmt_result_metadata.
  error       - where to write a truncation error if it is present.
               possible error value is:
               0  no truncation
               1  value is out of range or buffer is too small

  Please note that MYSQL_BIND also has internals members.
*/

作者: rsuhkoi 时间: 2008-08-29 21:59
标题: 回复 #2 freearth 的帖子
typedef struct st_mysql_bind
{
  unsigned long *length;       /* output length pointer */
  my_bool    *is_null;    /* Pointer to null indicator */
  void *buffer;    /* buffer to get/put data */
  /* set this if you want to track data truncations happened during fetch */
  my_bool    *error;
  enum enum_field_types buffer_type; /* buffer type */
  /* output buffer length, must be set when fetching str/binary */
  unsigned long buffer_length;
  unsigned char *row_ptr;       /* for the current data position */
  unsigned long offset;          /* offset position for char/binary fetch */
  unsigned long length_value;    /* Used if length is 0 */
  unsigned int param_number;    /* For null count and error messages */
  unsigned int  pack_length;    /* Internal length for packed data */
  my_bool    error_value;    /* used if error is 0 */
  my_bool    is_unsigned;    /* set if integer type is unsigned */
  my_bool long_data_used;    /* If used with mysql_send_long_data */
  my_bool is_null_value; /* Used if is_null is 0 */
  void (*store_param_func)(NET *net, struct st_mysql_bind *param);
  void (*fetch_result)(struct st_mysql_bind *, MYSQL_FIELD *,
                     unsigned char **row);
  void (*skip_result)(struct st_mysql_bind *, MYSQL_FIELD *,
      unsigned char **row);
} MYSQL_BIND;

/* statement handler */
typedef struct st_mysql_stmt
{
  MEM_ROOT    mem_root;          /* root allocations */
  LIST          list;                /* list to keep track of all stmts */
  MYSQL       *mysql;             /* connection handle */
  MYSQL_BIND    *params;             /* input parameters */
  MYSQL_BIND    *bind;             /* output parameters */
  MYSQL_FIELD *fields;             /* result set metadata */
  MYSQL_DATA    result;             /* cached result set */
  MYSQL_ROWS    *data_cursor;       /* current row in cached result */
  /* copy of mysql->affected_rows after statement execution */
  my_ulonglong affected_rows;
  my_ulonglong insert_id;          /* copy of mysql->insert_id */
  /*
mysql_stmt_fetch() calls this function to fetch one row (it's different
for buffered, unbuffered and cursor fetch).
  */
  int          (*read_row_func)(struct st_mysql_stmt *stmt,
                              unsigned char **row);
  unsigned long    stmt_id;          /* Id for prepared statement */
  unsigned long  flags;             /* i.e. type of cursor to open */
  unsigned long  prefetch_rows;       /* number of rows per one COM_FETCH */
  /*
Copied from mysql->server_status after execute/fetch to know
server-side cursor status for this statement.
  */
  unsigned int server_status;
  unsigned int    last_errno;          /* error code */
  unsigned int param_count;       /* input parameter count */
  unsigned int field_count;       /* number of columns in result set */
  enum enum_mysql_stmt_state state; /* statement state */
  char    last_error[MYSQL_ERRMSG_SIZE]; /* error message */
  char    sqlstate[SQLSTATE_LENGTH+1];
  /* Types of input parameters should be sent to server */
  my_bool       send_types_to_server;
  my_bool       bind_param_done;    /* input buffers were supplied */
  unsigned char  bind_result_done;    /* output buffers were supplied */
  /* mysql_stmt_close() had to cancel this result */
  my_bool    unbuffered_fetch_cancelled;
  /*
Is set to true if we need to calculate field->max_length for
metadata fields when doing mysql_stmt_store_result.
  */
  my_bool    update_max_length;
} MYSQL_STMT;

enum enum_stmt_attr_type
{
  /*
When doing mysql_stmt_store_result calculate max_length attribute
of statement metadata. This is to be consistent with the old API,
where this was done automatically.
In the new API we do that only by request because it slows down
mysql_stmt_store_result sufficiently.
  */
  STMT_ATTR_UPDATE_MAX_LENGTH,
  /*
unsigned long with combination of cursor flags (read only, for update,
etc)
  */
  STMT_ATTR_CURSOR_TYPE,
  /*
Amount of rows to retrieve from server per one fetch if using cursors.
Accepts unsigned long attribute in the range 1 - ulong_max
  */
  STMT_ATTR_PREFETCH_ROWS
};

typedef struct st_mysql_methods
{
  my_bool (*read_query_result)(MYSQL *mysql);
  my_bool (*advanced_command)(MYSQL *mysql,
      enum enum_server_command command,
      const char *header,
      unsigned long header_length,
      const char *arg,
      unsigned long arg_length,
      my_bool skip_check,
                           MYSQL_STMT *stmt);
  MYSQL_DATA *(*read_rows)(MYSQL *mysql,MYSQL_FIELD *mysql_fields,
   unsigned int fields);
  MYSQL_RES * (*use_result)(MYSQL *mysql);
  void (*fetch_lengths)(unsigned long *to,
MYSQL_ROW column, unsigned int field_count);
  void (*flush_use_result)(MYSQL *mysql);
#if !defined(MYSQL_SERVER) || defined(EMBEDDED_LIBRARY)
  MYSQL_FIELD * (*list_fields)(MYSQL *mysql);
  my_bool (*read_prepare_result)(MYSQL *mysql, MYSQL_STMT *stmt);
  int (*stmt_execute)(MYSQL_STMT *stmt);
  int (*read_binary_rows)(MYSQL_STMT *stmt);
  int (*unbuffered_fetch)(MYSQL *mysql, char **row);
  void (*free_embedded_thd)(MYSQL *mysql);
  const char *(*read_statistics)(MYSQL *mysql);
  my_bool (*next_result)(MYSQL *mysql);
  int (*read_change_user_result)(MYSQL *mysql, char *buff, const char *passwd);
  int (*read_rows_from_cursor)(MYSQL_STMT *stmt);
#endif
} MYSQL_METHODS;

MYSQL_STMT * STDCALL mysql_stmt_init(MYSQL *mysql);
int STDCALL mysql_stmt_prepare(MYSQL_STMT *stmt, const char *query,
                           unsigned long length);
int STDCALL mysql_stmt_execute(MYSQL_STMT *stmt);
int STDCALL mysql_stmt_fetch(MYSQL_STMT *stmt);
int STDCALL mysql_stmt_fetch_column(MYSQL_STMT *stmt, MYSQL_BIND *bind_arg,
                                 unsigned int column,
                                 unsigned long offset);
int STDCALL mysql_stmt_store_result(MYSQL_STMT *stmt);
unsigned long STDCALL mysql_stmt_param_count(MYSQL_STMT * stmt);
my_bool STDCALL mysql_stmt_attr_set(MYSQL_STMT *stmt,
                                 enum enum_stmt_attr_type attr_type,
                                 const void *attr);
my_bool STDCALL mysql_stmt_attr_get(MYSQL_STMT *stmt,
                                 enum enum_stmt_attr_type attr_type,
                                 void *attr);
my_bool STDCALL mysql_stmt_bind_param(MYSQL_STMT * stmt, MYSQL_BIND * bnd);
my_bool STDCALL mysql_stmt_bind_result(MYSQL_STMT * stmt, MYSQL_BIND * bnd);
my_bool STDCALL mysql_stmt_close(MYSQL_STMT * stmt);
my_bool STDCALL mysql_stmt_reset(MYSQL_STMT * stmt);
my_bool STDCALL mysql_stmt_free_result(MYSQL_STMT *stmt);
my_bool STDCALL mysql_stmt_send_long_data(MYSQL_STMT *stmt,
                                       unsigned int param_number,
                                       const char *data,
                                       unsigned long length);
MYSQL_RES *STDCALL mysql_stmt_result_metadata(MYSQL_STMT *stmt);
MYSQL_RES *STDCALL mysql_stmt_param_metadata(MYSQL_STMT *stmt);
unsigned int STDCALL mysql_stmt_errno(MYSQL_STMT * stmt);
const char *STDCALL mysql_stmt_error(MYSQL_STMT * stmt);
const char *STDCALL mysql_stmt_sqlstate(MYSQL_STMT * stmt);
MYSQL_ROW_OFFSET STDCALL mysql_stmt_row_seek(MYSQL_STMT *stmt,
                                          MYSQL_ROW_OFFSET offset);
MYSQL_ROW_OFFSET STDCALL mysql_stmt_row_tell(MYSQL_STMT *stmt);
void STDCALL mysql_stmt_data_seek(MYSQL_STMT *stmt, my_ulonglong offset);
my_ulonglong STDCALL mysql_stmt_num_rows(MYSQL_STMT *stmt);
my_ulonglong STDCALL mysql_stmt_affected_rows(MYSQL_STMT *stmt);
my_ulonglong STDCALL mysql_stmt_insert_id(MYSQL_STMT *stmt);
unsigned int STDCALL mysql_stmt_field_count(MYSQL_STMT *stmt);

my_bool STDCALL mysql_commit(MYSQL * mysql);
my_bool STDCALL mysql_rollback(MYSQL * mysql);
my_bool STDCALL mysql_autocommit(MYSQL * mysql, my_bool auto_mode);
my_bool STDCALL mysql_more_results(MYSQL *mysql);
int STDCALL mysql_next_result(MYSQL *mysql);
void STDCALL mysql_close(MYSQL *sock);

/* status return codes */
#define MYSQL_NO_DATA       100
#define MYSQL_DATA_TRUNCATED 101

#define mysql_reload(mysql) mysql_refresh((mysql),REFRESH_GRANT)

#ifdef USE_OLD_FUNCTIONS
MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host,
      const char *user, const char *passwd);
int STDCALL mysql_create_db(MYSQL *mysql, const char *DB);
int STDCALL mysql_drop_db(MYSQL *mysql, const char *DB);
#define    mysql_reload(mysql) mysql_refresh((mysql),REFRESH_GRANT)
#endif
#define HAVE_MYSQL_REAL_CONNECT

/*
  The following functions are mainly exported because of mysqlbinlog;
  They are not for general usage
*/

#define simple_command(mysql, command, arg, length, skip_check) \
  (*(mysql)->methods->advanced_command)(mysql, command, NullS,  \
                                    0, arg, length, skip_check, NULL)
#define stmt_command(mysql, command, arg, length, stmt) \
  (*(mysql)->methods->advanced_command)(mysql, command, NullS,  \
                                    0, arg, length, 1, stmt)

#ifdef __NETWARE__
#pragma pack(pop) /* restore alignment */
#endif

#ifdef __cplusplus
}
#endif

#endif /* _mysql_h */

作者: rsuhkoi 时间: 2008-08-29 22:02
标题: 回复 #2 freearth 的帖子
是你要我贴的，我也没有办法。其实gcc出错的地方是下面的三行：
my_bool *unbuffered_fetch_owner;
#if defined(EMBEDDED_LIBRARY) || defined(EMBEDDED_LIBRARY_COMPATIBLE) || MYSQL_VERSION_ID >= 50100
/* needed for embedded server - no net buffer to store the 'info' */
我觉得好像是哪个字符被当作了@，但是就是不能确定

作者: freearth 时间: 2008-08-29 22:09
用gcc -E 处理这个.h文件，看一下错误信息和处理结果

原帖由 rsuhkoi 于 2008-8-29 22:02 发表
是你要我贴的，我也没有办法。其实gcc出错的地方是下面的三行：
my_bool *unbuffered_fetch_owner;
#if defined(EMBEDDED_LIBRARY) || defined(EMBEDDED_LIBRARY_COMPATIBLE) || MYSQL_VERSION_ID >= 50100 ...

作者: rsuhkoi 时间: 2008-08-30 10:15
标题: 回复 #7 freearth 的帖子
我用gcc -E 处理了头文件，发现gcc把 MYSQL_VERSION_ID >= 50100 中的M这个字符当作了@，真是莫名其妙。这个文件中估计有好几十个M，但是唯独这个M被当作了@，真是很奇怪

作者: freearth 时间: 2008-08-30 11:47
你这个头文件还包含了好几个别的头文件。
每次注释掉一个该文件中的include，看看注释掉哪个之后会出问题。至少，全部注释掉之后是可以正确处理的。应该是那个出问题的头文件中的问题。

原帖由 rsuhkoi 于 2008-8-30 10:15 发表
我用gcc -E 处理了头文件，发现gcc把 MYSQL_VERSION_ID >= 50100 中的M这个字符当作了@，真是莫名其妙。这个文件中估计有好几十个M，但是唯独这个M被当作了@，真是很奇怪

作者: rsuhkoi 时间: 2008-08-30 13:05
标题: 回复 #9 freearth 的帖子
我用你说的办法最终追查到是在一个这样的文件：
/* Copyright Abandoned 1996, 1999, 2001 MySQL AB
This file is public domain and comes with NO WARRANTY of any kind */

/* Version numbers for protocol & mysqld */

#ifndef _mysql_version_h
#define _mysql_version_h
#ifdef _CUSTOMCONFIG_
#include <custom_conf.h>
#else
#define PROTOCOL_VERSION @PROTOCOL_VERSION@
#define MYSQL_SERVER_VERSION "@VERSION@"
#define MYSQL_BASE_VERSION "mysqld-@MYSQL_BASE_VERSION@"
#define MYSQL_SERVER_SUFFIX_DEF "@MYSQL_SERVER_SUFFIX@"
#define FRM_VER @DOT_FRM_VERSION@
#define MYSQL_VERSION_ID @MYSQL_VERSION_ID@
#define MYSQL_PORT @MYSQL_TCP_PORT@
#define MYSQL_PORT_DEFAULT @MYSQL_TCP_PORT_DEFAULT@
#define MYSQL_UNIX_ADDR "@MYSQL_UNIX_ADDR@"
#define MYSQL_CONFIG_NAME "my"
#define MYSQL_COMPILATION_COMMENT "@COMPILATION_COMMENT@"

/* mysqld compile time options */
#endif /* _CUSTOMCONFIG_ */

#ifndef LICENSE
#define LICENSE GPL
#endif /* LICENSE */

#endif /* _mysql_version_h */
将之前的mysql.h文件中的宏MYSQL_VERSION_ID替换成了@MYSQL_VERSION_ID@，所以在预编译的时候就报了错，我不知道怎么使用gcc的哪个编译选项解决这个问题

作者: freearth 时间: 2008-08-30 13:28
这个文件应该是经过某个脚本处理，将那些＠XXX@都替换成具体的值。

你不是可以在linux下正常编译吗？看一下linux下被处理后的这个文件的内容，以及哪个脚本处理的它。在Windows下也要进行类似的处理。

原帖由 rsuhkoi 于 2008-8-30 13:05 发表
我用你说的办法最终追查到是在一个这样的文件：
/* Copyright Abandoned 1996, 1999, 2001 MySQL AB
This file is public domain and comes with NO WARRANTY of any kind */

/* Version numbers for p ...

作者: rsuhkoi 时间: 2008-08-30 13:36
标题: 回复 #11 freearth 的帖子
在linux以及freebsd下都是没有问题的。这些头文件都是mysql提供的源码中的一部分。不过我的程序只是引用了他的这几个头文件。我怀疑和gcc的编译选项有关系。我去看看mysql源码中的编译选项，看能不能搞定这个问题。

作者: freearth 时间: 2008-08-30 13:47
#ifdef _CUSTOMCONFIG_
#include <custom_conf.h>

注意这两行。看一下你有没有custom_conf.h文件，以及里面的内容对不对，如果这个文件存在且内容是对的，那么编译的时候加一个选项 -D_CUSTOMCONFIG_就行了。

原帖由 rsuhkoi 于 2008-8-30 13:36 发表
在linux以及freebsd下都是没有问题的。这些头文件都是mysql提供的源码中的一部分。不过我的程序只是引用了他的这几个头文件。我怀疑和gcc的编译选项有关系。我去看看mysql源码中的编译选项，看能不能搞定这个问题。

[ 本帖最后由 freearth 于 2008-8-30 13:49 编辑 ]

作者: rsuhkoi 时间: 2008-08-30 16:39
标题: 回复 #13 freearth 的帖子
里面没有这个文件，我在源代码中的makefile.in文件中有这样的一条语句：
MYSQL_VERSION_ID = @MYSQL_VERSION_ID@
configure之后生成的makefile文件中发现有这样相应的一条语句：
MYSQL_VERSION_ID = 50056
我想我大致明白错在哪里了，呵呵

作者: cjaizss 时间: 2008-08-30 18:12
-D_CUSTOMCONFIG_试试呢?

作者: rsuhkoi 时间: 2008-08-30 18:40
标题: 回复 #15 cjaizss 的帖子
我直接修改了一个头文件，就搞定了

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)