← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to drizzled/sql_state.cc

  • Committer: Brian Aker
  • Date: 2009-11-18 22:58:22 UTC
  • mto: (1223.1.1 push) (1226.1.2 push)
  • mto: This revision was merged to the branch mainline in revision 1224.
  • Revision ID: brian@gaz-20091118225822-4ryr9rviir23o0kr
Second pass through bugs related to CREATE TABLE LIKE

Show diffs side-by-side

added added

removed removed

Lines of Context:
drizzled/sql_state.cc
1
1
/* - mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
3
 *
4
 
 *  Copyright (C) 2008 Sun Microsystems, Inc.
 
4
 *  Copyright (C) 2008 Sun Microsystems
5
5
 *
6
6
 *  This program is free software; you can redistribute it and/or modify
7
7
 *  it under the terms of the GNU General Public License as published by
19
19
 */
20
20
 
21
21
/* Functions to map drizzle errno to sql_state */
22
 
#include "config.h"
 
22
#include <drizzled/global.h>
23
23
 
 
24
#include CSTDINT_H
24
25
#include <algorithm>
25
26
 
 
27
#include <drizzled/sql_state.h>
26
28
#include <drizzled/error.h>
27
 
#include <drizzled/error/sql_state.h>
28
29
 
29
30
using namespace std;
30
31
 
31
 
namespace drizzled
32
 
{
33
 
 
34
 
namespace error
35
 
{
36
 
 
37
 
struct sql_state_t
38
 
{
39
 
  drizzled::error_t drizzle_errno;
 
32
typedef struct st_map_errno_to_sqlstate
 
33
{
 
34
  uint32_t drizzle_errno;
40
35
  const char *odbc_state;
41
36
  const char *jdbc_state;
42
 
};
 
37
} errno_sqlstate_map;
43
38
 
44
 
sql_state_t sqlstate_map[]=
 
39
errno_sqlstate_map sqlstate_map[]=
45
40
{
46
41
  { ER_DUP_KEY                              ,"23000", "" },
47
42
  { ER_OUTOFMEMORY                          ,"HY001", "S1001" },
98
93
  { ER_FIELD_SPECIFIED_TWICE                ,"42000", "" },
99
94
  { ER_UNSUPPORTED_EXTENSION                ,"42000", "" },
100
95
  { ER_TABLE_MUST_HAVE_COLUMNS              ,"42000", "" },
 
96
  { ER_UNKNOWN_CHARACTER_SET                ,"42000", "" },
101
97
  { ER_TOO_BIG_ROWSIZE                      ,"42000", "" },
102
98
  { ER_WRONG_OUTER_JOIN                     ,"42000", "" },
103
99
  { ER_NULL_COLUMN_IN_INDEX                 ,"42000", "" },
 
100
  { ER_PASSWORD_ANONYMOUS_USER              ,"42000", "" },
 
101
  { ER_PASSWORD_NOT_ALLOWED                 ,"42000", "" },
 
102
  { ER_PASSWORD_NO_MATCH                    ,"42000", "" },
104
103
  { ER_WRONG_VALUE_COUNT_ON_ROW             ,"21S01", "" },
 
104
  { ER_INVALID_USE_OF_NULL                  ,"22004", "" },
 
105
  { ER_REGEXP_ERROR                         ,"42000", "" },
105
106
  { ER_MIX_OF_GROUP_FUNC_AND_FIELDS         ,"42000", "" },
106
 
  { ER_TABLE_UNKNOWN                        ,"42S02", "" },
 
107
  { ER_NONEXISTING_GRANT                    ,"42000", "" },
 
108
  { ER_TABLEACCESS_DENIED_ERROR             ,"42000", "" },
 
109
  { ER_COLUMNACCESS_DENIED_ERROR            ,"42000", "" },
 
110
  { ER_ILLEGAL_GRANT_FOR_TABLE              ,"42000", "" },
 
111
  { ER_GRANT_WRONG_HOST_OR_USER             ,"42000", "" },
 
112
  { ER_NO_SUCH_TABLE                        ,"42S02", "" },
 
113
  { ER_NONEXISTING_TABLE_GRANT              ,"42000", "" },
 
114
  { ER_NOT_ALLOWED_COMMAND                  ,"42000", "" },
107
115
  { ER_SYNTAX_ERROR                         ,"42000", "" },
 
116
  { ER_ABORTING_CONNECTION                  ,"08S01", "" },
108
117
  { ER_NET_PACKET_TOO_LARGE                 ,"08S01", "" },
 
118
  { ER_NET_READ_ERROR_FROM_PIPE             ,"08S01", "" },
 
119
  { ER_NET_FCNTL_ERROR                      ,"08S01", "" },
109
120
  { ER_NET_PACKETS_OUT_OF_ORDER             ,"08S01", "" },
 
121
  { ER_NET_UNCOMPRESS_ERROR                 ,"08S01", "" },
 
122
  { ER_NET_READ_ERROR                       ,"08S01", "" },
 
123
  { ER_NET_READ_INTERRUPTED                 ,"08S01", "" },
 
124
  { ER_NET_ERROR_ON_WRITE                   ,"08S01", "" },
 
125
  { ER_NET_WRITE_INTERRUPTED                ,"08S01", "" },
 
126
  { ER_TOO_LONG_STRING                      ,"42000", "" },
110
127
  { ER_TABLE_CANT_HANDLE_BLOB               ,"42000", "" },
111
128
  { ER_TABLE_CANT_HANDLE_AUTO_INCREMENT     ,"42000", "" },
112
129
  { ER_WRONG_COLUMN_NAME                    ,"42000", "" },
119
136
  { ER_KEY_DOES_NOT_EXITS                   ,"42000", "S1009" },
120
137
  { ER_CHECK_NO_SUCH_TABLE                  ,"42000", "" },
121
138
  { ER_CHECK_NOT_IMPLEMENTED                ,"42000", "" },
 
139
  { ER_CANT_DO_THIS_DURING_AN_TRANSACTION   ,"25000", "" },
122
140
  { ER_NEW_ABORTING_CONNECTION              ,"08S01", "" },
 
141
  { ER_MASTER_NET_READ                      ,"08S01", "" },
 
142
  { ER_MASTER_NET_WRITE                     ,"08S01", "" },
 
143
  { ER_TOO_MANY_USER_CONNECTIONS            ,"42000", "" },
123
144
  { ER_READ_ONLY_TRANSACTION                ,"25000", "" },
 
145
  { ER_NO_PERMISSION_TO_CREATE_USER         ,"42000", "" },
124
146
  { ER_LOCK_DEADLOCK                        ,"40001", "" },
125
147
  { ER_NO_REFERENCED_ROW                    ,"23000", "" },
126
148
  { ER_ROW_IS_REFERENCED                    ,"23000", "" },
 
149
  { ER_CONNECT_TO_MASTER                    ,"08S01", "" },
127
150
  { ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT    ,"21000", "" },
 
151
  { ER_USER_LIMIT_REACHED                   ,"42000", "" },
 
152
  { ER_SPECIFIC_ACCESS_DENIED_ERROR         ,"42000", "" },
128
153
  { ER_NO_DEFAULT                           ,"42000", "" },
129
154
  { ER_WRONG_VALUE_FOR_VAR                  ,"42000", "" },
130
155
  { ER_WRONG_TYPE_FOR_VAR                   ,"42000", "" },
137
162
  { ER_DERIVED_MUST_HAVE_ALIAS              ,"42000", "" },
138
163
  { ER_SELECT_REDUCED                       ,"01000", "" },
139
164
  { ER_TABLENAME_NOT_ALLOWED_HERE           ,"42000", "" },
 
165
  { ER_NOT_SUPPORTED_AUTH_MODE              ,"08004", "" },
140
166
  { ER_SPATIAL_CANT_HAVE_NULL               ,"42000", "" },
141
167
  { ER_COLLATION_CHARSET_MISMATCH           ,"42000", "" },
142
168
  { ER_WARN_TOO_FEW_RECORDS                 ,"01000", "" },
148
174
  { ER_WRONG_NAME_FOR_CATALOG               ,"42000", "" },
149
175
  { ER_UNKNOWN_STORAGE_ENGINE               ,"42000", "" },
150
176
  { ER_TRUNCATED_WRONG_VALUE                ,"22007", "" },
 
177
  { ER_SP_NO_RECURSIVE_CREATE               ,"2F003", "" },
 
178
  { ER_SP_ALREADY_EXISTS                    ,"42000", "" },
151
179
  { ER_SP_DOES_NOT_EXIST                    ,"42000", "" },
 
180
  { ER_SP_LILABEL_MISMATCH                  ,"42000", "" },
 
181
  { ER_SP_LABEL_REDEFINE                    ,"42000", "" },
 
182
  { ER_SP_LABEL_MISMATCH                    ,"42000", "" },
 
183
  { ER_SP_UNINIT_VAR                        ,"01000", "" },
 
184
  { ER_SP_BADSELECT                         ,"0A000", "" },
 
185
  { ER_SP_BADRETURN                         ,"42000", "" },
 
186
  { ER_SP_BADSTATEMENT                      ,"0A000", "" },
 
187
  { ER_UPDATE_LOG_DEPRECATED_IGNORED        ,"42000", "" },
 
188
  { ER_UPDATE_LOG_DEPRECATED_TRANSLATED     ,"42000", "" },
152
189
  { ER_QUERY_INTERRUPTED                    ,"70100", "" },
 
190
  { ER_SP_WRONG_NO_OF_ARGS                  ,"42000", "" },
 
191
  { ER_SP_COND_MISMATCH                     ,"42000", "" },
 
192
  { ER_SP_NORETURN                          ,"42000", "" },
 
193
  { ER_SP_NORETURNEND                       ,"2F005", "" },
 
194
  { ER_SP_BAD_CURSOR_QUERY                  ,"42000", "" },
 
195
  { ER_SP_BAD_CURSOR_SELECT                 ,"42000", "" },
 
196
  { ER_SP_CURSOR_MISMATCH                   ,"42000", "" },
 
197
  { ER_SP_CURSOR_ALREADY_OPEN               ,"24000", "" },
 
198
  { ER_SP_CURSOR_NOT_OPEN                   ,"24000", "" },
 
199
  { ER_SP_UNDECLARED_VAR                    ,"42000", "" },
 
200
  { ER_SP_FETCH_NO_DATA                     ,"02000", "" },
 
201
  { ER_SP_DUP_PARAM                         ,"42000", "" },
 
202
  { ER_SP_DUP_VAR                           ,"42000", "" },
 
203
  { ER_SP_DUP_COND                          ,"42000", "" },
 
204
  { ER_SP_DUP_CURS                          ,"42000", "" },
 
205
  { ER_SP_SUBSELECT_NYI                     ,"0A000", "" },
 
206
  { ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG        ,"0A000", "" },
 
207
  { ER_SP_VARCOND_AFTER_CURSHNDLR           ,"42000", "" },
 
208
  { ER_SP_CURSOR_AFTER_HANDLER              ,"42000", "" },
 
209
  { ER_SP_CASE_NOT_FOUND                    ,"20000", "" },
153
210
  { ER_DIVISION_BY_ZERO                     ,"22012", "" },
154
211
  { ER_ILLEGAL_VALUE_FOR_TYPE               ,"22007", "" },
 
212
  { ER_PROCACCESS_DENIED_ERROR              ,"42000", "" },
 
213
  { ER_XAER_NOTA                            ,"XAE04", "" },
 
214
  { ER_XAER_INVAL                           ,"XAE05", "" },
155
215
  { ER_XAER_RMFAIL                          ,"XAE07", "" },
 
216
  { ER_XAER_OUTSIDE                         ,"XAE09", "" },
 
217
  { ER_XAER_RMERR                           ,"XAE03", "" },
 
218
  { ER_XA_RBROLLBACK                        ,"XA100", "" },
 
219
  { ER_NONEXISTING_PROC_GRANT               ,"42000", "" },
156
220
  { ER_DATA_TOO_LONG                        ,"22001", "" },
 
221
  { ER_SP_BAD_SQLSTATE                      ,"42000", "" },
 
222
  { ER_CANT_CREATE_USER_WITH_GRANT          ,"42000", "" },
 
223
  { ER_SP_DUP_HANDLER                       ,"42000", "" },
 
224
  { ER_SP_NOT_VAR_ARG                       ,"42000", "" },
157
225
  { ER_SP_NO_RETSET                         ,"0A000", "" },
158
226
  { ER_CANT_CREATE_GEOMETRY_OBJECT          ,"22003", "" },
159
227
  { ER_TOO_BIG_SCALE                        ,"42000", "S1009" },
160
228
  { ER_TOO_BIG_PRECISION                    ,"42000", "S1009" },
161
229
  { ER_M_BIGGER_THAN_D                      ,"42000", "S1009" },
 
230
  { ER_TOO_LONG_BODY                        ,"42000", "S1009" },
162
231
  { ER_TOO_BIG_DISPLAYWIDTH                 ,"42000", "S1009" },
 
232
  { ER_XAER_DUPID                           ,"XAE08", "" },
163
233
  { ER_DATETIME_FUNCTION_OVERFLOW           ,"22008", "" },
164
234
  { ER_ROW_IS_REFERENCED_2                  ,"23000", "" },
165
235
  { ER_NO_REFERENCED_ROW_2                  ,"23000", "" },
 
236
  { ER_SP_BAD_VAR_SHADOW                    ,"42000", "" },
 
237
  { ER_SP_WRONG_NAME                        ,"42000", "" },
 
238
  { ER_SP_NO_AGGREGATE                      ,"42000", "" },
 
239
  { ER_MAX_PREPARED_STMT_COUNT_REACHED      ,"42000", "" },
166
240
  { ER_NON_GROUPING_FIELD_USED              ,"42000", "" },
167
241
  { ER_FOREIGN_DUPLICATE_KEY                ,"23000", "S1009" },
168
242
  { ER_CANT_CHANGE_TX_ISOLATION             ,"25001", "" },
169
243
  { ER_WRONG_PARAMCOUNT_TO_FUNCTION         ,"42000", "" },
170
244
  { ER_WRONG_PARAMETERS_TO_NATIVE_FCT       ,"42000", "" },
 
245
  { ER_WRONG_PARAMETERS_TO_STORED_FCT       ,"42000", "" },
171
246
  { ER_DUP_ENTRY_WITH_KEY_NAME              ,"23000", "S1009" },
172
247
};
173
248
 
174
 
static bool compare_errno_map(sql_state_t a,
175
 
                              sql_state_t b)
 
249
static bool compare_errno_map(errno_sqlstate_map a,
 
250
                              errno_sqlstate_map b)
176
251
{
177
252
  return (a.drizzle_errno < b.drizzle_errno);
178
253
}
179
254
 
180
 
const char *convert_to_sqlstate(drizzled::error_t drizzle_errno)
 
255
const char *drizzle_errno_to_sqlstate(uint32_t drizzle_errno)
181
256
{
182
257
 
183
 
  sql_state_t drizzle_err_state= {drizzle_errno, NULL, NULL};
184
 
  sql_state_t* result=
 
258
  errno_sqlstate_map drizzle_err_state= {drizzle_errno, NULL, NULL};
 
259
  errno_sqlstate_map* result=
185
260
    lower_bound(&sqlstate_map[0],
186
261
                &sqlstate_map[sizeof(sqlstate_map)/sizeof(*sqlstate_map)],
187
262
                drizzle_err_state, compare_errno_map);
188
263
 
189
264
  if ((*result).drizzle_errno == drizzle_errno)
190
265
    return (*result).odbc_state;
191
 
 
192
266
  /* General error */
193
267
  return "HY000";
 
268
 
194
269
}
195
 
 
196
 
} /* namespace error */
197
 
} /* namespace drizzled */