For example, the xdmp:database-name function is expressed in SQL as
The MarkLogic SQL interface includes a MATCH operator that can be used to perform full-text queries against either a column or a field that is bound to a view, as described in Creating a View.
When the MATCH operator is applied to the whole content, column names are bound to their corresponding range index references and searchable fields are bound to their field names. When the MATCH operator is applied to individual columns, all names are unbound, as it doesn't make sense to constrain searches against one range index to the values of another. These queries are executed in unfiltered mode.
|Wildcards*||? % *|
|Boolean Operators||AND, OR, NOT, NOT_IN, NEAR/integer)|
|Comparison Operators||EQ, NE, LT, LE, GT, GE|
|Name Binding**||<field_name>:<value>, <column_name>:<value>|
SELECT * FROM employees WHERE employees MATCH "Manager" SELECT * FROM employees WHERE employees MATCH "position:Manager" SELECT firstname, lastname FROM employees WHERE employees MATCH "employeeid LE 3" SELECT * FROM messages WHERE messages MATCH "cause:numeric AND text:expression" SELECT * FROM messages WHERE text MATCH "invalid OR wrong OR incorrect" SELECT * FROM messages WHERE messages MATCH "(cause:operand NEAR/10 cause:incompatible) AND (correct AND expect)" SELECT * FROM resumes WHERE resumes MATCH 'firstname:M* and (BA or BS) NEAR/15 (Pomona NOT_IN "Cal Poly Pomona")' SELECT * FROM employees WHERE employees MATCH 'firstname:J*' SELECT * FROM employees WHERE firstname MATCH "J*"
All SET parameters are good for the duration of the SQL session in which they are set. Some parameters are read-only and can only be specified by the SHOW statement. These are described in Read-only SHOW Parameters.
|ALL||Return values for all the variables with descriptions (columns=name, setting, description).|
|lc_ctype||Return the locale for character classifications. For us this is fixed at |
|max_function_args||The limit on the number of function arguments. This will be the value of SQLITE_MAX_FUNCTION_ARG, by default |
|max_identifier_length||The limit on the length of a name. This will be fixed at |
|max_index_keys||The limit on the number of keys in an index. This will be the value of SQLITE_MAX_COLUMN, by default |
|integer_datetimes||Whether the server supports 64-bit date/time values. Fixed at |
|server_encoding||The encoding the server uses. Fixed at |
|server_version||The version of MarkLogic Server.|
|server_version_num||The version of the server expressed as a single integer.|