package Mysqlx.Expr

Get desktop application:
View/edit binary Protocol Buffers messages

a Array of expressions

Used in: Expr

• repeated Expr value = 1

col_identifier (table): col@doc_path, tbl.col@doc_path col, tbl.col, schema.tbl.col col_identifier (document): doc_path .. productionlist:: col_identifier: string "." string "." string | : string "." string | : string | : string "." string "." string "@" document_path | : string "." string "@" document_path | : string "@" document_path | : document_path document_path: member | arrayLocation | doubleAsterisk member = "." string | "." "*" arrayLocation = "[" index "]" | "[" "*" "]" doubleAsterisk = "**"

Used in: Crud.UpdateOperation, Expr

• repeated DocumentPathItem document_path = 1

• optional string name = 2

• optional string table_name = 3

• optional string schema_name = 4

DocumentPathItem .. productionlist:: document_path: path_item | path_item document_path path_item : member | array_index | "**" member : "." string | "." "*" array_index : "[" number "]" | "[" "*" "]"

Used in: Crud.Column, ColumnIdentifier

• required DocumentPathItem.Type type = 1

• optional string value = 2

• optional uint32 index = 3

Used in: DocumentPathItem

• MEMBER = 1

  .member

• MEMBER_ASTERISK = 2

  .*

• ARRAY_INDEX = 3

  [index]

• ARRAY_INDEX_ASTERISK = 4

  [*]

• DOUBLE_ASTERISK = 5

  **

Expressions the "root" of the expression tree .. productionlist:: expr: `operator` | : `identifier` | : `function_call` | : variable | : `literal` | : placeholder If expression type is PLACEHOLDER then it refers to the value of a parameter specified when executing a statement (see `args` field of `StmtExecute` command). Field `position` (which must be present for such an expression) gives 0-based position of the parameter in the parameter list.

Used in: Crud.Delete, Crud.Find, Crud.Insert.TypedRow, Crud.LimitExpr, Crud.Order, Crud.Projection, Crud.Update, Crud.UpdateOperation, Array, FunctionCall, Object.ObjectField, Operator

• required Expr.Type type = 1

• optional ColumnIdentifier identifier = 2

• optional string variable = 3

• optional Datatypes.Scalar literal = 4

• optional FunctionCall function_call = 5

• optional Operator operator = 6

• optional uint32 position = 7

• optional Object object = 8

• optional Array array = 9

Used in: Expr

• IDENT = 1

• LITERAL = 2

• VARIABLE = 3

• FUNC_CALL = 4

• OPERATOR = 5

• PLACEHOLDER = 6

• OBJECT = 7

• ARRAY = 8

function call: ``func(a, b, "1", 3)`` .. productionlist:: function_call: `identifier` "(" [ `expr` ["," `expr` ]* ] ")"

Used in: Expr

• required Identifier name = 1

• repeated Expr param = 2

identifier: name, schame.name .. productionlist:: identifier: string "." string | : string

Used in: FunctionCall

• required string name = 1

• optional string schema_name = 2

an object (with expression values)

Used in: Expr

• repeated Object.ObjectField fld = 1

Used in: Object

• required string key = 1

• required Expr value = 2

operator: ``<<(a, b)`` .. note:: Non-authoritative list of operators implemented (case sensitive): Nullary * ``*`` * ``default`` Unary * ``!`` * ``sign_plus`` * ``sign_minus`` * ``~`` Binary * ``&&`` * ``||`` * ``xor`` * ``==`` * ``!=`` * ``>`` * ``>=`` * ``<`` * ``<=`` * ``&`` * ``|`` * ``^`` * ``<<`` * ``>>`` * ``+`` * ``-`` * ``*`` * ``/`` * ``div`` * ``%`` * ``is`` * ``is_not`` * ``regexp`` * ``not_regexp`` * ``like`` * ``not_like`` * ``cast`` * ``cont_in`` * ``not_cont_in`` * ``overlaps`` * ``not_overlaps`` Using special representation, with more than 2 params * ``in`` (param[0] IN (param[1], param[2], ...)) * ``not_in`` (param[0] NOT IN (param[1], param[2], ...)) Ternary * ``between`` * ``between_not`` * ``date_add`` * ``date_sub`` Units for date_add/date_sub * ``MICROSECOND`` * ``SECOND`` * ``MINUTE`` * ``HOUR`` * ``DAY`` * ``WEEK`` * ``MONTH`` * ``QUARTER`` * ``YEAR`` * ``SECOND_MICROSECOND`` * ``MINUTE_MICROSECOND`` * ``MINUTE_SECOND`` * ``HOUR_MICROSECOND`` * ``HOUR_SECOND`` * ``HOUR_MINUTE`` * ``DAY_MICROSECOND`` * ``DAY_SECOND`` * ``DAY_MINUTE`` * ``DAY_HOUR`` Types for cast * ``BINARY[(N)]`` * ``CHAR[(N)]`` * ``DATE`` * ``DATETIME`` * ``DECIMAL[(M[,D])]`` * ``JSON`` * ``SIGNED [INTEGER]`` * ``TIME`` * ``UNSIGNED [INTEGER]`` .. productionlist:: operator: `name` "(" [ `expr` ["," `expr` ]* ] ")"

Used in: Expr

• required string name = 1

• repeated Expr param = 2