1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
|
/* Copyright (c) 2014, 2025, Oracle and/or its affiliates.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License, version 2.0,
as published by the Free Software Foundation.
This program is designed to work with certain software (including
but not limited to OpenSSL) that is licensed under separate terms,
as designated in a particular file or component or in included license
documentation. The authors of MySQL hereby grant you an additional
permission to link the program and your derivative works with the
separately licensed software that they have either included with
the program or referenced in the documentation.
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, version 2.0, 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., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
#ifndef DD__COLUMN_INCLUDED
#define DD__COLUMN_INCLUDED
#include <optional>
#include "lex_string.h" // LEX_CSTRING
#include "my_inttypes.h"
#include "sql/dd/collection.h" // dd::Collection
#include "sql/dd/sdi_fwd.h" // RJ_Document
#include "sql/dd/types/entity_object.h" // dd::Entity_object
#include "sql/gis/srid.h"
namespace dd {
///////////////////////////////////////////////////////////////////////////
class Abstract_table;
class Column_impl;
class Column_type_element;
class Properties;
namespace tables {
class Columns;
}
///////////////////////////////////////////////////////////////////////////
// Redefined enum_field_types here. We can remove some old types ?
enum class enum_column_types {
DECIMAL = 1, // This is 1 > than MYSQL_TYPE_DECIMAL
TINY,
SHORT,
LONG,
FLOAT,
DOUBLE,
TYPE_NULL,
TIMESTAMP,
LONGLONG,
INT24,
DATE,
TIME,
DATETIME,
YEAR,
NEWDATE,
VARCHAR,
BIT,
TIMESTAMP2,
DATETIME2,
TIME2,
NEWDECIMAL,
ENUM,
SET,
TINY_BLOB,
MEDIUM_BLOB,
LONG_BLOB,
BLOB,
VAR_STRING,
STRING,
GEOMETRY,
JSON
};
class Column : virtual public Entity_object {
public:
typedef Collection<Column_type_element *> Column_type_element_collection;
typedef Column_impl Impl;
typedef tables::Columns DD_table;
enum enum_column_key { CK_NONE = 1, CK_PRIMARY, CK_UNIQUE, CK_MULTIPLE };
enum class enum_hidden_type {
/// The column is visible (a normal column)
HT_VISIBLE = 1,
/// The column is completely invisible to the server
HT_HIDDEN_SE = 2,
/// The column is visible to the server, but hidden from the user.
/// This is used for i.e. implementing functional indexes.
HT_HIDDEN_SQL = 3,
/// User table column marked as INVISIBLE by using the column visibility
/// attribute. Column is hidden from the user unless it is explicitly
/// referenced in the statement. Column is visible to the server.
HT_HIDDEN_USER = 4
};
~Column() override = default;
/////////////////////////////////////////////////////////////////////////
// Table.
/////////////////////////////////////////////////////////////////////////
virtual const Abstract_table &table() const = 0;
virtual Abstract_table &table() = 0;
/////////////////////////////////////////////////////////////////////////
// collation.
/////////////////////////////////////////////////////////////////////////
virtual Object_id collation_id() const = 0;
virtual void set_collation_id(Object_id collation_id) = 0;
virtual void set_is_explicit_collation(bool is_explicit_collation) = 0;
virtual bool is_explicit_collation() const = 0;
/////////////////////////////////////////////////////////////////////////
// type.
/////////////////////////////////////////////////////////////////////////
virtual enum_column_types type() const = 0;
virtual void set_type(enum_column_types type) = 0;
/////////////////////////////////////////////////////////////////////////
// nullable.
/////////////////////////////////////////////////////////////////////////
virtual bool is_nullable() const = 0;
virtual void set_nullable(bool nullable) = 0;
/////////////////////////////////////////////////////////////////////////
// is_zerofill.
/////////////////////////////////////////////////////////////////////////
virtual bool is_zerofill() const = 0;
virtual void set_zerofill(bool zerofill) = 0;
/////////////////////////////////////////////////////////////////////////
// is_unsigned.
/////////////////////////////////////////////////////////////////////////
virtual bool is_unsigned() const = 0;
virtual void set_unsigned(bool unsigned_flag) = 0;
/////////////////////////////////////////////////////////////////////////
// auto increment.
/////////////////////////////////////////////////////////////////////////
virtual bool is_auto_increment() const = 0;
virtual void set_auto_increment(bool auto_increment) = 0;
/////////////////////////////////////////////////////////////////////////
// ordinal_position
/////////////////////////////////////////////////////////////////////////
virtual uint ordinal_position() const = 0;
/////////////////////////////////////////////////////////////////////////
// char_length.
/////////////////////////////////////////////////////////////////////////
virtual size_t char_length() const = 0;
virtual void set_char_length(size_t char_length) = 0;
/////////////////////////////////////////////////////////////////////////
// numeric_precision.
/////////////////////////////////////////////////////////////////////////
virtual uint numeric_precision() const = 0;
virtual void set_numeric_precision(uint numeric_precision) = 0;
/////////////////////////////////////////////////////////////////////////
// srid
/////////////////////////////////////////////////////////////////////////
virtual void set_srs_id(std::optional<gis::srid_t> srs_id) = 0;
virtual std::optional<gis::srid_t> srs_id() const = 0;
/////////////////////////////////////////////////////////////////////////
// numeric_scale.
/////////////////////////////////////////////////////////////////////////
virtual uint numeric_scale() const = 0;
virtual void set_numeric_scale(uint numeric_scale) = 0;
virtual void set_numeric_scale_null(bool is_null) = 0;
virtual bool is_numeric_scale_null() const = 0;
/////////////////////////////////////////////////////////////////////////
// datetime_precision.
/////////////////////////////////////////////////////////////////////////
virtual uint datetime_precision() const = 0;
virtual void set_datetime_precision(uint datetime_precision) = 0;
virtual void set_datetime_precision_null(bool is_null) = 0;
virtual bool is_datetime_precision_null() const = 0;
/////////////////////////////////////////////////////////////////////////
// has_no_default.
/////////////////////////////////////////////////////////////////////////
virtual bool has_no_default() const = 0;
virtual void set_has_no_default(bool has_explicit_default) = 0;
/////////////////////////////////////////////////////////////////////////
// default_value (binary).
/////////////////////////////////////////////////////////////////////////
virtual const String_type &default_value() const = 0;
virtual void set_default_value(const String_type &default_value) = 0;
virtual void set_default_value_null(bool is_null) = 0;
virtual bool is_default_value_null() const = 0;
/////////////////////////////////////////////////////////////////////////
// default_value_utf8
/////////////////////////////////////////////////////////////////////////
virtual const String_type &default_value_utf8() const = 0;
virtual void set_default_value_utf8(
const String_type &default_value_utf8) = 0;
virtual void set_default_value_utf8_null(bool is_null) = 0;
virtual bool is_default_value_utf8_null() const = 0;
/////////////////////////////////////////////////////////////////////////
// is virtual ?
/////////////////////////////////////////////////////////////////////////
virtual bool is_virtual() const = 0;
virtual void set_virtual(bool is_virtual) = 0;
/////////////////////////////////////////////////////////////////////////
// generation_expression (binary).
/////////////////////////////////////////////////////////////////////////
virtual const String_type &generation_expression() const = 0;
virtual void set_generation_expression(
const String_type &generation_expression) = 0;
virtual bool is_generation_expression_null() const = 0;
/////////////////////////////////////////////////////////////////////////
// generation_expression_utf8
/////////////////////////////////////////////////////////////////////////
virtual const String_type &generation_expression_utf8() const = 0;
virtual void set_generation_expression_utf8(
const String_type &generation_expression_utf8) = 0;
virtual bool is_generation_expression_utf8_null() const = 0;
/////////////////////////////////////////////////////////////////////////
// default_option.
/////////////////////////////////////////////////////////////////////////
virtual const String_type &default_option() const = 0;
virtual void set_default_option(const String_type &default_option) = 0;
/////////////////////////////////////////////////////////////////////////
// update_option.
/////////////////////////////////////////////////////////////////////////
virtual const String_type &update_option() const = 0;
virtual void set_update_option(const String_type &update_option) = 0;
/////////////////////////////////////////////////////////////////////////
// Comment.
/////////////////////////////////////////////////////////////////////////
virtual const String_type &comment() const = 0;
virtual void set_comment(const String_type &comment) = 0;
/////////////////////////////////////////////////////////////////////////
// hidden.
/////////////////////////////////////////////////////////////////////////
virtual enum_hidden_type hidden() const = 0;
virtual void set_hidden(enum_hidden_type hidden) = 0;
bool is_se_hidden() const {
return hidden() == enum_hidden_type::HT_HIDDEN_SE;
}
/////////////////////////////////////////////////////////////////////////
// Options.
/////////////////////////////////////////////////////////////////////////
virtual const Properties &options() const = 0;
virtual Properties &options() = 0;
virtual bool set_options(const String_type &options_raw) = 0;
/////////////////////////////////////////////////////////////////////////
// se_private_data.
/////////////////////////////////////////////////////////////////////////
virtual const Properties &se_private_data() const = 0;
virtual Properties &se_private_data() = 0;
virtual bool set_se_private_data(const Properties &se_private_data) = 0;
virtual bool set_se_private_data(const String_type &se_private_data_raw) = 0;
/////////////////////////////////////////////////////////////////////////
// SE-specific json attributes
/////////////////////////////////////////////////////////////////////////
virtual LEX_CSTRING engine_attribute() const = 0;
virtual void set_engine_attribute(LEX_CSTRING attrs) = 0;
virtual LEX_CSTRING secondary_engine_attribute() const = 0;
virtual void set_secondary_engine_attribute(LEX_CSTRING attrs) = 0;
/////////////////////////////////////////////////////////////////////////
// Column key type.
/////////////////////////////////////////////////////////////////////////
virtual void set_column_key(enum_column_key column_key) = 0;
virtual enum_column_key column_key() const = 0;
/////////////////////////////////////////////////////////////////////////
// Column display type.
/////////////////////////////////////////////////////////////////////////
virtual const String_type &column_type_utf8() const = 0;
virtual void set_column_type_utf8(const String_type &column_type_utf8) = 0;
/////////////////////////////////////////////////////////////////////////
// Elements.
/////////////////////////////////////////////////////////////////////////
virtual Column_type_element *add_element() = 0;
virtual const Column_type_element_collection &elements() const = 0;
virtual size_t elements_count() const = 0;
/**
Converts *this into json.
Converts all member variables that are to be included in the sdi
into json by transforming them appropriately and passing them to
the rapidjson writer provided.
@param wctx opaque context for data needed by serialization
@param w rapidjson writer which will perform conversion to json
*/
virtual void serialize(Sdi_wcontext *wctx, Sdi_writer *w) const = 0;
/**
Re-establishes the state of *this by reading sdi information from
the rapidjson DOM subobject provided.
Cross-references encountered within this object are tracked in
sdictx, so that they can be updated when the entire object graph
has been established.
@param rctx stores book-keeping information for the
deserialization process
@param val subobject of rapidjson DOM containing json
representation of this object
*/
virtual bool deserialize(Sdi_rcontext *rctx, const RJ_Value &val) = 0;
virtual bool is_array() const = 0;
};
///////////////////////////////////////////////////////////////////////////
} // namespace dd
#endif // DD__COLUMN_INCLUDED
|
