NO: The default until Connect 1.06.005, no conversion takes place, and a TYPE_ERROR is returned, resulting in a “not supported” message.
YES: The default from Connect 1.06.006. The column is internally converted to a column declared as VARCHAR(n),
nbeing the value of connect_conv_size.
FORCE(>= Connect 1.06.006): Also convert ODBC blob columns to TYPE_STRING.
SKIP: No conversion. When the column declaration is provided via Discovery (meaning the CONNECT table is created without a column description), this column is not generated. Also applies to ODBC tables.
YES(>= Connect 1.06.006),
NO(<= Connect 1.06.005)
NO: The first algorithm is always used. Because it can cause errors when updating variable record length tables, this value should be set only for testing.
AUTO: This is the default value. It leaves CONNECT to choose the algorithm to use. Currently it is equivalent to
NO, except when updating variable record length tables (DOS, CSV or FMT) with file mapping forced to OFF.
YES: Using a temporary file is chosen with some exceptions. These are when file mapping is ON, for VEC tables and when deleting from DBF tables (soft delete). For variable record length tables, file mapping is forced to OFF.
FORCE: Like YES but forces file mapping to be OFF for all table types.
TEST: Reserved for CONNECT development.
4194304upwards, depending on the physical memory size
0(no trace), or to other values if a console tracing is desired. Note that to test this handler, MariaDB should be executed with the --console parameter because CONNECT prints some error and trace messages on the console. In some Linux versions, this is re-routed into the error log file. Console tracing can be set on the command line or later by names or values. Valid values (from Connect 1.06.006) include:
0: No trace
1: Basic trace
2: More tracing
4: Index construction
8: Allocating and freeing memory
16: Sub-allocating in work area
32: Constructed query sent to external server
64: Currently executing statement
128: Creating and dropping CONNECT handlers
256: Creating and dropping CONNECT objects
512: Mongo and REST (from Connect 1.06.0010) tracing
set global connect_xtrace=0; No trace
set global connect_xtrace='YES'; By name
set global connect_xtrace=1; By value
set global connect_xtrace='QUERY,STMT'; By name
set global connect_xtrace=96; By value
set global connect_xtrace=1023; Trace all
set(>= Connect 1.06.006),
integer(<= Connect 1.06.005)
2147483647(<= Connect 1.06.005)
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.