Set

Table of Contents



SET changes the value of a session variable. Session variables apply to the current connection only and do not affect other sessions. To define your own variables, use Declare.

round-pushpin Turns on warnings for missing fields.
SET WarnMissingFields true




Home
The home page
SQL :: Declare
Declares a variable for the rest of a script.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: QueryThreadWeight
Removed: QueryThreadWeight is no longer a session variable.
SQL :: ReadUncommitted
Reads without waiting for other transactions' locks.
SQL :: Session Variables
Settings that are scoped to the connected session.
SQL :: TraceWaitTimes
Reports the time spent in each internal operation of a query.
SQL :: WarnMissingFields
Warns when a query references a field that a document does not have.
SQL :: WarnNullPropagation
Warns when a null makes an expression null.