MySQL 9.0.0
Source Code Documentation
Field_timestamp Class Reference

#include <field.h>

Inheritance diagram for Field_timestamp:
[legend]

Public Member Functions

 Field_timestamp (uchar *ptr_arg, uint32 len_arg, uchar *null_ptr_arg, uchar null_bit_arg, uchar auto_flags_arg, const char *field_name_arg)
 TIMESTAMP type columns hold date and time values in the range 1970-01-01 00:00:01 UTC to 2038-01-01 00:00:00 UTC, stored as number of seconds since the start of the Unix Epoch (1970-01-01 00:00:01 UTC.) More...
 
 Field_timestamp (bool is_nullable_arg, const char *field_name_arg)
 
enum_field_types type () const final
 
enum ha_base_keytype key_type () const final
 
type_conversion_status store_packed (longlong nr) final
 Store a temporal value in packed longlong format into a field. More...
 
longlong val_int () const final
 
int cmp (const uchar *, const uchar *) const final
 
size_t make_sort_key (uchar *buff, size_t length) const final
 Writes a copy of the current value in the record buffer, suitable for sorting using byte-by-byte comparison. More...
 
uint32 pack_length () const final
 
void sql_type (String &str) const final
 
bool zero_pack () const final
 
bool get_timestamp (my_timeval *tm, int *warnings) const final
 Get TIMESTAMP field value as seconds since begging of Unix Epoch. More...
 
bool get_date (MYSQL_TIME *ltime, my_time_flags_t fuzzydate) const final
 
Field_timestampclone (MEM_ROOT *mem_root) const final
 Makes a shallow copy of the Field object. More...
 
ucharpack (uchar *to, const uchar *from, size_t max_length) const final
 Pack the field into a format suitable for storage and transfer. More...
 
const ucharunpack (uchar *to, const uchar *from, uint param_data) final
 Unpack a field from row data. More...
 
type_conversion_status validate_stored_val (THD *thd) final
 Validate date value stored in the field. More...
 
- Public Member Functions inherited from Field_temporal_with_date_and_time
 Field_temporal_with_date_and_time (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg, uchar auto_flags_arg, const char *field_name_arg, uint8 dec_arg)
 Constructor for Field_temporal_with_date_and_time. More...
 
void store_timestamp (const my_timeval *tm) override
 Stores a timestamp value in timeval format in a field. More...
 
- Public Member Functions inherited from Field_temporal_with_date
 Field_temporal_with_date (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg, uchar auto_flags_arg, const char *field_name_arg, uint8 int_length_arg, uint8 dec_arg)
 Constructor for Field_temporal. More...
 
bool send_to_protocol (Protocol *protocol) const override
 Send the value of this field over the protocol using the correct Protocol::store*() function which matches the type of the field. More...
 
type_conversion_status store_time (MYSQL_TIME *ltime, uint8 dec) final
 Store MYSQL_TIME value with the given amount of decimal digits into a field. More...
 
Stringval_str (String *, String *) const override
 
longlong val_time_temporal () const override
 Returns TIME value in packed longlong format. More...
 
longlong val_date_temporal () const override
 Returns DATE/DATETIME value in packed longlong format. More...
 
longlong val_time_temporal_at_utc () const override
 
longlong val_date_temporal_at_utc () const override
 
bool get_time (MYSQL_TIME *ltime) const final
 
- Public Member Functions inherited from Field_temporal
 Field_temporal (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg, uchar auto_flags_arg, const char *field_name_arg, uint32 len_arg, uint8 dec_arg)
 Constructor for Field_temporal. More...
 
Item_result result_type () const final
 
uint32 max_display_length () const final
 
bool str_needs_quotes () const final
 
uint is_equal (const Create_field *new_field) const final
 Whether a field being created is type-compatible with an existing one. More...
 
Item_result numeric_context_result_type () const final
 Returns Item_result type of a field when it appears in numeric context such as: SELECT time_column + 1; SELECT SUM(time_column); Examples: More...
 
enum Item_result cmp_type () const final
 
enum Derivation derivation () const final
 
uint repertoire () const final
 
const CHARSET_INFOcharset () const final
 
bool can_be_compared_as_longlong () const final
 
bool binary () const final
 
type_conversion_status store (const char *str, size_t len, const CHARSET_INFO *cs) final
 Store string into a date/time/datetime field. More...
 
type_conversion_status store_decimal (const my_decimal *decimal) final
 
type_conversion_status store (longlong nr, bool unsigned_val) override
 
type_conversion_status store (double nr) final
 
double val_real () const override
 
uint8 get_dec () const
 
my_decimalval_decimal (my_decimal *decimal_value) const override
 
my_time_flags_t get_date_flags (const THD *thd) const
 
uint8 get_fractional_digits () const
 
- Public Member Functions inherited from Field
 Field (const Field &)=default
 
void operator= (Field &)=delete
 
bool has_insert_default_general_value_expression () const
 Checks if the field is marked as having a general expression to generate default values. More...
 
bool has_insert_default_datetime_value_expression () const
 Checks if the field is marked as having a datetime value expression to generate default values on inserts. More...
 
bool has_update_default_datetime_value_expression () const
 Checks if the field is marked as having a datetime value expression to generate default values on updates. More...
 
bool has_insert_default_constant_expression () const
 Checks if the field is marked as having a constant expression to generate default values. More...
 
ucharget_null_ptr ()
 
virtual void set_field_length (uint32 length)
 
virtual void add_to_cost (CostOfItem *cost) const
 Update '*cost' with the fact that this Field is accessed. More...
 
bool is_flag_set (unsigned flag) const
 
void set_flag (unsigned flag)
 
void clear_flag (unsigned flag)
 
uint32 all_flags () const
 
virtual bool is_wrapper_field () const
 If true, it's a Create_field_wrapper (a sub-class of Field used during CREATE/ALTER that we mustn't cast to other sub-classes of Field that aren't on a direct path of inheritance, e.g. More...
 
virtual bool is_unsigned () const
 Whether the field is signed or not. More...
 
bool is_gcol () const
 
bool is_virtual_gcol () const
 
void set_hidden (dd::Column::enum_hidden_type hidden)
 Sets the hidden type for this field. More...
 
dd::Column::enum_hidden_type hidden () const
 
bool is_hidden () const
 
bool is_hidden_by_system () const
 
bool is_hidden_by_user () const
 
bool is_field_for_functional_index () const
 
 Field (uchar *ptr_arg, uint32 length_arg, uchar *null_ptr_arg, uchar null_bit_arg, uchar auto_flags_arg, const char *field_name_arg)
 This is used as a table name when the table structure is not set up. More...
 
virtual ~Field ()=default
 
void reset_warnings ()
 
void set_tmp_nullable ()
 Turn on temporary nullability for the field. More...
 
void reset_tmp_nullable ()
 Turn off temporary nullability for the field. More...
 
void reset_tmp_null ()
 Reset temporary NULL value for field. More...
 
void set_tmp_null ()
 Set field to temporary value NULL. More...
 
bool is_tmp_nullable () const
 
bool is_tmp_null () const
 
type_conversion_status store_time (MYSQL_TIME *ltime)
 Store MYSQL_TYPE value into a field when the number of fractional digits is not important or is not know. More...
 
type_conversion_status store (const char *to, size_t length, const CHARSET_INFO *cs, enum_check_fields check_level)
 
longlong val_temporal_by_field_type () const
 Returns "native" packed longlong representation of a TIME or DATE/DATETIME field depending on field type. More...
 
Stringval_str (String *str) const
 
Stringval_int_as_str (String *val_buffer, bool unsigned_flag) const
 Interpret field value as an integer but return the result as a string. More...
 
virtual Item_result cast_to_int_type () const
 
bool gcol_expr_is_equal (const Create_field *field) const
 Check whether generated columns' expressions are the same. More...
 
virtual bool eq (const Field *field) const
 
virtual bool eq_def (const Field *field) const
 
virtual uint32 pack_length_in_rec () const
 
virtual bool compatible_field_size (uint metadata, Relay_log_info *, uint16, int *order) const
 Check to see if field size is compatible with destination. More...
 
virtual uint pack_length_from_metadata (uint field_metadata) const
 
virtual uint row_pack_length () const
 
int save_field_metadata (uchar *first_byte)
 
virtual uint32 data_length (ptrdiff_t row_offset=0) const
 
virtual uint32 max_data_length () const
 Get the maximum size of the data in packed format. More...
 
virtual type_conversion_status reset ()
 
virtual void set_default ()
 
void evaluate_insert_default_function ()
 Evaluates the INSERT default function and stores the result in the field. More...
 
void evaluate_update_default_function ()
 Evaluates the UPDATE default function, if one exists, and stores the result in the record buffer. More...
 
virtual uint32 key_length () const
 
virtual enum_field_types real_type () const
 
virtual enum_field_types binlog_type () const
 
int cmp (const uchar *str) const
 
virtual int cmp_max (const uchar *a, const uchar *b, uint max_len) const
 
virtual int cmp_binary (const uchar *a, const uchar *b, uint32 max_length=~0L) const
 
virtual int cmp_offset (ptrdiff_t row_offset) const
 
virtual int cmp_binary_offset (ptrdiff_t row_offset) const
 
virtual int key_cmp (const uchar *a, const uchar *b) const
 
virtual int key_cmp (const uchar *str, uint length) const
 
virtual uint decimals () const
 
virtual bool is_text_key_type () const
 
bool is_null (ptrdiff_t row_offset=0) const
 Check whether the full table's row is NULL or the Field has value NULL. More...
 
bool is_real_null (ptrdiff_t row_offset=0) const
 Check whether the Field has value NULL (temporary or actual). More...
 
bool is_null_in_record (const uchar *record) const
 Check if the Field has value NULL or the record specified by argument has value NULL for this Field. More...
 
void set_null (ptrdiff_t row_offset=0)
 Set field to value NULL. More...
 
void set_notnull (ptrdiff_t row_offset=0)
 Set field to value NOT NULL. More...
 
type_conversion_status check_constraints (int mysql_errno)
 Check NOT NULL constraint on the field after temporary nullability is disabled. More...
 
void set_check_for_truncated_fields (enum_check_fields check_for_truncated_fields)
 Remember the value of THD::check_for_truncated_fields to handle possible NOT-NULL constraint errors after BEFORE-trigger execution is finished. More...
 
bool is_nullable () const
 
uint null_offset (const uchar *record) const
 
uint null_offset () const
 
void set_null_ptr (uchar *p_null_ptr, uint p_null_bit)
 
virtual void make_send_field (Send_field *send_field) const
 Populates a Send_field object with metadata about the column represented by this Field object. More...
 
virtual size_t make_sort_key (uchar *buff, size_t length, size_t trunc_pos) const
 Writes a copy of the current value in the record buffer, suitable for sorting using byte-by-byte comparison. More...
 
virtual bool optimize_range (uint idx, uint part) const
 Whether this field can be used for index range scans when in the given keypart of the given index. More...
 
virtual void mem_free ()
 
virtual Fieldnew_field (MEM_ROOT *root, TABLE *new_table) const
 
Fieldnew_field (MEM_ROOT *root, TABLE *new_table, uchar *new_ptr, uchar *new_null_ptr, uint new_null_bit) const
 
virtual Fieldnew_key_field (MEM_ROOT *root, TABLE *new_table, uchar *new_ptr, uchar *new_null_ptr, uint new_null_bit) const
 
Fieldnew_key_field (MEM_ROOT *root, TABLE *new_table, uchar *new_ptr) const
 
void move_field (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg)
 
virtual void move_field_offset (ptrdiff_t ptr_diff)
 
virtual void get_image (uchar *buff, size_t length, const CHARSET_INFO *) const
 
virtual void set_image (const uchar *buff, size_t length, const CHARSET_INFO *)
 
virtual size_t get_key_image (uchar *buff, size_t length, imagetype type) const
 
virtual void set_key_image (const uchar *buff, size_t length)
 
longlong val_int_offset (ptrdiff_t row_offset)
 
longlong val_int (uchar *new_ptr)
 
Stringval_str (String *str, uchar *new_ptr)
 
ucharpack (uchar *to) const
 
const ucharunpack (const uchar *from)
 
virtual ucharpack_with_metadata_bytes (uchar *to, const uchar *from, uint max_length) const
 This function does the same thing as pack(), except for the difference that max_length does not mean the number of bytes in the output, but the maximum field length from the input (which must be exactly field->max_field_length()). More...
 
virtual bool pack_diff (uchar **to, ulonglong value_options) const
 Write the field for the binary log in diff format. More...
 
virtual uint max_packed_col_length () const
 This is a wrapper around pack_length() used by filesort() to determine how many bytes we need for packing "addon fields". More...
 
uint offset (uchar *record) const
 
void copy_data (ptrdiff_t src_record_offset)
 
const CHARSET_INFOcharset_for_protocol () const
 
virtual const CHARSET_INFOsort_charset () const
 
virtual bool has_charset () const
 
virtual bool match_collation_to_optimize_range () const
 
virtual void set_derivation (enum Derivation)
 
bool set_warning (Sql_condition::enum_severity_level level, unsigned int code, int cut_increment)
 Produce warning or note about data saved into field. More...
 
bool set_warning (Sql_condition::enum_severity_level level, uint code, int cut_increment, const char *view_db, const char *view_name)
 Produce warning or note about data saved into field. More...
 
bool warn_if_overflow (int op_result)
 Process decimal library return codes and issue warnings for overflow and truncation. More...
 
virtual void init (TABLE *table_arg)
 
longlong convert_decimal2longlong (const my_decimal *val, bool unsigned_flag, bool *has_overflow)
 Conversion from decimal to longlong. More...
 
virtual uint32 char_length () const
 
virtual geometry_type get_geometry_type () const
 
void dbug_print () const
 
ha_storage_media field_storage_type () const
 
void set_storage_type (ha_storage_media storage_type_arg)
 
column_format_type column_format () const
 
void set_column_format (column_format_type column_format_arg)
 
virtual void hash (ulong *nr, ulong *nr2) const
 
virtual ulonglong get_max_int_value () const
 Get the upper limit of the MySQL integral and floating-point type. More...
 
virtual const uchardata_ptr () const
 Return a const pointer to the actual data in the record buffer. More...
 
const ucharfield_ptr () const
 Return a const pointer to where the field is stored in the record buffer. More...
 
ucharfield_ptr ()
 Return a pointer to where the field is stored in the record buffer. More...
 
void set_field_ptr (uchar *ptr_arg)
 
virtual bool is_updatable () const
 Checks whether a string field is part of write_set. More...
 
bool is_part_of_actual_key (THD *thd, uint cur_index, KEY *cur_index_info) const
 Check whether field is part of the index taking the index extensions flag into account. More...
 
Key_map get_covering_prefix_keys () const
 Get covering prefix keys. More...
 
virtual bool is_array () const
 Whether the field is a typed array. More...
 
virtual uint32 get_length_bytes () const
 Return number of bytes the field's length takes. More...
 
bool handle_old_value () const
 Whether field's old valued have to be handled. More...
 
virtual void set_field_index (uint16 field_index)
 Sets field index. More...
 
uint16 field_index () const
 Returns field index. More...
 

Static Public Attributes

static const int PACK_LENGTH = 4
 
- Static Public Attributes inherited from Field
static constexpr size_t MAX_VARCHAR_WIDTH {65535}
 
static constexpr size_t MAX_TINY_BLOB_WIDTH {255}
 
static constexpr size_t MAX_SHORT_BLOB_WIDTH {65535}
 
static constexpr size_t MAX_MEDIUM_BLOB_WIDTH {16777215}
 
static constexpr size_t MAX_LONG_BLOB_WIDTH {4294967295}
 

Protected Member Functions

my_time_flags_t date_flags (const THD *thd) const final
 Flags that are passed as "flag" argument to check_date(), number_to_datetime(), str_to_datetime(). More...
 
type_conversion_status store_internal (const MYSQL_TIME *ltime, int *error) final
 Low level routine to store a MYSQL_TIME value into a field. More...
 
bool get_date_internal (MYSQL_TIME *ltime) const final
 Low level function to get value into MYSQL_TIME, without checking for being valid. More...
 
bool get_date_internal_at_utc (MYSQL_TIME *ltime) const final
 
void store_timestamp_internal (const my_timeval *tm) final
 Store "struct timeval" value into field. More...
 
- Protected Member Functions inherited from Field_temporal_with_date_and_time
void init_timestamp_flags ()
 Initialize flags for TIMESTAMP DEFAULT CURRENT_TIMESTAMP / ON UPDATE CURRENT_TIMESTAMP columns. More...
 
bool convert_TIME_to_timestamp (const MYSQL_TIME *ltime, const Time_zone &tz, my_timeval *tm, int *error)
 
- Protected Member Functions inherited from Field_temporal_with_date
bool get_internal_check_zero (MYSQL_TIME *ltime, my_time_flags_t fuzzydate) const
 Get value into MYSQL_TIME and check TIME_NO_ZERO_DATE flag. More...
 
type_conversion_status convert_number_to_TIME (longlong nr, bool unsigned_val, int nanoseconds, MYSQL_TIME *ltime, int *warning) final
 Convert a number with fractional part with nanosecond precision into MYSQL_TIME, according to the field type. More...
 
bool convert_str_to_TIME (const char *str, size_t len, const CHARSET_INFO *cs, MYSQL_TIME *ltime, MYSQL_TIME_STATUS *status) final
 Convert a string to MYSQL_TIME, according to the field type. More...
 
type_conversion_status store_internal_adjust_frac (MYSQL_TIME *ltime, int *warnings) final
 Low level routine to store a MYSQL_TIME value into a field with rounding/truncation according to the field decimals() value and sql_mode. More...
 
virtual my_time_flags_t date_flags (const THD *thd) const
 Flags that are passed as "flag" argument to check_date(), number_to_datetime(), str_to_datetime(). More...
 
my_time_flags_t date_flags () const
 Flags that are passed as "flag" argument to check_date(), number_to_datetime(), str_to_datetime(). More...
 
- Protected Member Functions inherited from Field_temporal
type_conversion_status store_lldiv_t (const lldiv_t *lld, int *warning)
 Store a temporal value in lldiv_t into a field, with rounding according to the field decimals() value. More...
 
longlong convert_number_to_datetime (longlong nr, bool unsigned_val, MYSQL_TIME *ltime, int *warnings)
 Convert an integer number into MYSQL_TIME, according to the field type. More...
 
bool set_warnings (const ErrConvString &str, int warnings)
 Set warnings from a warning vector. More...
 
my_time_flags_t date_flags () const
 Flags that are passed as "flag" argument to check_date(), number_to_datetime(), str_to_datetime(). More...
 
bool set_datetime_warning (Sql_condition::enum_severity_level level, uint code, const ErrConvString &val, enum_mysql_timestamp_type ts_type, int truncate_increment)
 Produce warning or note about double datetime data saved into field. More...
 
- Protected Member Functions inherited from Field
ucharpack_int16 (uchar *to, const uchar *from, size_t max_length) const
 
const ucharunpack_int16 (uchar *to, const uchar *from) const
 
ucharpack_int24 (uchar *to, const uchar *from, size_t max_length) const
 
const ucharunpack_int24 (uchar *to, const uchar *from) const
 
ucharpack_int32 (uchar *to, const uchar *from, size_t max_length) const
 
const ucharunpack_int32 (uchar *to, const uchar *from) const
 
ucharpack_int64 (uchar *to, const uchar *from, size_t max_length) const
 
const ucharunpack_int64 (uchar *to, const uchar *from) const
 

Private Member Functions

bool get_date_internal_at (const Time_zone *tz, MYSQL_TIME *ltime) const
 Retrieves a value from a record, without checking fuzzy date flags. More...
 

Additional Inherited Members

- Public Types inherited from Field
enum  enum_auto_flags {
  NONE = 0 , NEXT_NUMBER = 1 , DEFAULT_NOW = 2 , ON_UPDATE_NOW = 4 ,
  GENERATED_FROM_EXPRESSION = 8
}
 Flags for Field::auto_flags / Create_field::auto_flags bitmaps. More...
 
enum  geometry_type {
  GEOM_GEOMETRY = 0 , GEOM_POINT = 1 , GEOM_LINESTRING = 2 , GEOM_POLYGON = 3 ,
  GEOM_MULTIPOINT = 4 , GEOM_MULTILINESTRING = 5 , GEOM_MULTIPOLYGON = 6 , GEOM_GEOMETRYCOLLECTION = 7
}
 
enum  imagetype { itRAW , itMBR }
 
- Static Public Member Functions inherited from Field
static bool type_can_have_key_part (enum_field_types)
 Check whether a field type can be partially indexed by a key. More...
 
static enum_field_types field_type_merge (enum_field_types, enum_field_types)
 Return type of which can carry value of both given types in UNION result. More...
 
static Item_result result_merge_type (enum_field_types)
 Detect Item_result by given field type of UNION merge result. More...
 
- Public Attributes inherited from Field
TABLEtable
 Pointer to TABLE object that owns this field. More...
 
const char * orig_db_name {nullptr}
 Pointer to original database name, only non-NULL for a temporary table. More...
 
const char * orig_table_name {nullptr}
 Pointer to original table name, only non-NULL for a temporary table. More...
 
const char ** table_name
 
const char * field_name
 
LEX_CSTRING comment
 
Key_map key_start
 
Key_map part_of_key
 Keys that includes this field except of prefix keys. More...
 
Key_map part_of_prefixkey
 Prefix keys. More...
 
Key_map part_of_sortkey
 
Key_map part_of_key_not_extended
 All keys that include this field, but not extended by the storage engine to include primary key columns. More...
 
uint32 field_length
 
uchar null_bit
 
uchar auto_flags
 Bitmap of flags indicating if field value is auto-generated by default and/or on update, and in which way. More...
 
bool is_created_from_null_item
 If true, this field was created in create_tmp_field_from_item from a NULL value. More...
 
bool m_indexed
 True if this field belongs to some index (unlike part_of_key, the index might have only a prefix). More...
 
LEX_CSTRING m_engine_attribute = EMPTY_CSTR
 
LEX_CSTRING m_secondary_engine_attribute = EMPTY_CSTR
 
Value_generatorgcol_info {nullptr}
 
bool stored_in_db
 Indication that the field is physically stored in tables rather than just generated on SQL queries. More...
 
Value_generatorm_default_val_expr {nullptr}
 Holds the expression to be used to generate default values. More...
 
- Static Protected Member Functions inherited from Field_temporal
static uint8 normalize_dec (uint8 dec_arg)
 Adjust number of decimal digits from DECIMAL_NOT_SPECIFIED to DATETIME_MAX_DECIMALS. More...
 
- Protected Attributes inherited from Field_temporal
uint8 dec
 
- Protected Attributes inherited from Field
ucharptr
 Holds the position to the field in record. More...
 
- Static Protected Attributes inherited from Field
static uchar dummy_null_buffer = ' '
 

Constructor & Destructor Documentation

◆ Field_timestamp() [1/2]

Field_timestamp::Field_timestamp ( uchar ptr_arg,
uint32  len_arg,
uchar null_ptr_arg,
uchar  null_bit_arg,
uchar  auto_flags_arg,
const char *  field_name_arg 
)

TIMESTAMP type columns hold date and time values in the range 1970-01-01 00:00:01 UTC to 2038-01-01 00:00:00 UTC, stored as number of seconds since the start of the Unix Epoch (1970-01-01 00:00:01 UTC.)

TIMESTAMP columns can be automatically set on row updates to and/or have CURRENT_TIMESTAMP as default value for inserts. We use flags Field::auto_flags member to control this behavior.

◆ Field_timestamp() [2/2]

Field_timestamp::Field_timestamp ( bool  is_nullable_arg,
const char *  field_name_arg 
)

Member Function Documentation

◆ clone()

Field_timestamp * Field_timestamp::clone ( MEM_ROOT mem_root) const
inlinefinalvirtual

Makes a shallow copy of the Field object.

Note
This member function must be overridden in all concrete subclasses. Several of the Field subclasses are concrete even though they are not leaf classes, so the compiler will not always catch this.
Parameters
mem_rootMEM_ROOT to use for memory allocation.
Return values
NULLIf memory allocation failed.

Implements Field.

◆ cmp()

int Field_timestamp::cmp ( const uchar a_ptr,
const uchar b_ptr 
) const
finalvirtual

Implements Field.

◆ date_flags()

my_time_flags_t Field_timestamp::date_flags ( const THD thd) const
finalprotectedvirtual

Flags that are passed as "flag" argument to check_date(), number_to_datetime(), str_to_datetime().

Flags depend on the session sql_mode settings, such as MODE_NO_ZERO_DATE, MODE_NO_ZERO_IN_DATE. Also, Field_newdate, Field_datetime, Field_datetimef add TIME_FUZZY_DATE to the session sql_mode settings, to allow relaxed date format, while Field_timestamp, Field_timestampf do not.

Parameters
thdTHD
Return values
sql_modeflags mixed with the field type flags.

Reimplemented from Field_temporal.

◆ get_date()

bool Field_timestamp::get_date ( MYSQL_TIME ltime,
my_time_flags_t  fuzzydate 
) const
finalvirtual

Reimplemented from Field.

◆ get_date_internal()

bool Field_timestamp::get_date_internal ( MYSQL_TIME ltime) const
finalprotectedvirtual

Low level function to get value into MYSQL_TIME, without checking for being valid.

Implements Field_temporal_with_date.

◆ get_date_internal_at()

bool Field_timestamp::get_date_internal_at ( const Time_zone tz,
MYSQL_TIME ltime 
) const
private

Retrieves a value from a record, without checking fuzzy date flags.

Parameters
tzThe time zone to convert to
[out]ltimeThe timestamp value in the time zone.
Return values
trueMeans that the timestamp value read is 0. ltime is not touched in this case.
falseIf timestamp is non-zero.

◆ get_date_internal_at_utc()

bool Field_timestamp::get_date_internal_at_utc ( MYSQL_TIME ltime) const
finalprotectedvirtual

Reimplemented from Field_temporal_with_date.

◆ get_timestamp()

bool Field_timestamp::get_timestamp ( my_timeval tm,
int *  warnings 
) const
finalvirtual

Get TIMESTAMP field value as seconds since begging of Unix Epoch.

Reimplemented from Field.

◆ key_type()

enum ha_base_keytype Field_timestamp::key_type ( ) const
inlinefinalvirtual

Reimplemented from Field.

◆ make_sort_key()

size_t Field_timestamp::make_sort_key ( uchar buff,
size_t  length 
) const
finalvirtual

Writes a copy of the current value in the record buffer, suitable for sorting using byte-by-byte comparison.

Integers are always in big-endian regardless of hardware architecture. At most length bytes are written into the buffer.

Parameters
buffThe buffer, assumed to be at least length bytes.
lengthNumber of bytes to write.
Return values
Thenumber of bytes actually written.
Note
This is now only used by replication; filesort makes its own sort keys based off of Items, not Fields.

Implements Field.

◆ pack()

uchar * Field_timestamp::pack ( uchar to,
const uchar from,
size_t  max_length 
) const
inlinefinalvirtual

Pack the field into a format suitable for storage and transfer.

To implement packing functionality, only the virtual function should be overridden. The other functions are just convenience functions and hence should not be overridden.

The actual format is opaque and will vary between types of Field (it is meant to be unpacked by unpack(), but be aware that it is used among others in the replication log, so you cannot change it without incurring a format break.

Note
The default implementation just copies the raw bytes of the record into the destination, but never more than max_length characters.
Parameters
toPointer to memory area where representation of field should be put.
fromPointer to memory area where record representation of field is stored, typically field->field_ptr().
max_lengthAvailable space in “to”, in bytes. pack() will not write more bytes than this; if the field is too short, the contents are not unpackable by unpack(). (It is nominally supposed to be a prefix of what would have been written with a full buffer, ie., the same as packing and then truncating the output, but not all Field classes follow this.)
Returns
The byte after the last byte in “to” written to. If the return value is equal to (to + max_length), it could either be that the value fit exactly, or that the buffer was too small; you cannot distinguish between the two cases based on the return value alone.

Reimplemented from Field.

◆ pack_length()

uint32 Field_timestamp::pack_length ( ) const
inlinefinalvirtual

Reimplemented from Field.

◆ sql_type()

void Field_timestamp::sql_type ( String str) const
finalvirtual

Implements Field.

◆ store_internal()

type_conversion_status Field_timestamp::store_internal ( const MYSQL_TIME ltime,
int *  error 
)
finalprotectedvirtual

Low level routine to store a MYSQL_TIME value into a field.

The value must be already properly rounded or truncated and checked for being a valid TIME/DATE/DATETIME value.

Parameters
[in]ltimeMYSQL_TIME value.
[out]errorError flag vector, set in case of error.
Return values
falseIn case of success.
trueIn case of error.

Implements Field_temporal.

◆ store_packed()

type_conversion_status Field_timestamp::store_packed ( longlong  nr)
finalvirtual

Store a temporal value in packed longlong format into a field.

The packed value is compatible with TIME_to_longlong_time_packed(), TIME_to_longlong_date_packed() or TIME_to_longlong_datetime_packed(). Note, the value must be properly rounded or truncated according according to field->decimals().

Parameters
nrtemporal value in packed longlong format.
Return values
falseon success
trueon error

Reimplemented from Field.

◆ store_timestamp_internal()

void Field_timestamp::store_timestamp_internal ( const my_timeval tm)
finalprotectedvirtual

Store "struct timeval" value into field.

The value must be properly rounded or truncated according to the number of fractional second digits.

Implements Field_temporal_with_date_and_time.

◆ type()

enum_field_types Field_timestamp::type ( ) const
inlinefinalvirtual

Implements Field.

◆ unpack()

const uchar * Field_timestamp::unpack ( uchar to,
const uchar from,
uint  param_data 
)
inlinefinalvirtual

Unpack a field from row data.

This method is used to unpack a field from a master whose size of the field is less than that of the slave.

The param_data parameter is a two-byte integer (stored in the least significant 16 bits of the unsigned integer) usually consisting of two parts: the real type in the most significant byte and a original pack length in the least significant byte.

The exact layout of the param_data field is given by the Table_map_log_event::save_field_metadata().

This is the default method for unpacking a field. It just copies the memory block in byte order (of original pack length bytes or length of field, whichever is smaller).

Parameters
toDestination of the data
fromSource of the data
param_dataReal type and original pack length of the field data
Returns
New pointer into memory based on from + length of the data

Reimplemented from Field.

◆ val_int()

longlong Field_timestamp::val_int ( void  ) const
finalvirtual

Implements Field.

◆ validate_stored_val()

type_conversion_status Field_timestamp::validate_stored_val ( THD thd)
finalvirtual

Validate date value stored in the field.

Now we check whether date value is zero or has zero in date or not and sets warning/error message appropriately(depending on the sql_mode).

Reimplemented from Field_temporal_with_date.

◆ zero_pack()

bool Field_timestamp::zero_pack ( ) const
inlinefinalvirtual

Reimplemented from Field.

Member Data Documentation

◆ PACK_LENGTH

const int Field_timestamp::PACK_LENGTH = 4
static

The documentation for this class was generated from the following files: