Package org.h2.util
Interface HasSQL
-
- All Known Implementing Classes:
AbstractAggregate
,Aggregate
,Alias
,ArrayConstructorByQuery
,ArrayElementReference
,ArrayFunction
,ArrayTableFunction
,BetweenPredicate
,BinaryOperation
,BitFunction
,BooleanTest
,CardinalityExpression
,CastSpecification
,CoalesceFunction
,Column
,Comment
,CompareLike
,Comparison
,CompatibilityDatePlusTimeOperation
,CompatibilitySequenceValueFunction
,CompressFunction
,ConcatenationOperation
,ConcatFunction
,Condition
,ConditionAndOr
,ConditionAndOrN
,ConditionIn
,ConditionInConstantSet
,ConditionInParameter
,ConditionInQuery
,ConditionLocalAndGlobal
,ConditionNot
,Constant
,Constraint
,ConstraintCheck
,ConstraintDomain
,ConstraintReferential
,ConstraintUnique
,CryptFunction
,CSVReadFunction
,CSVWriteFunction
,CurrentDateTimeValueFunction
,CurrentGeneralValueSpecification
,DataAnalysisOperation
,DataChangeDeltaTable
,DataTypeSQLFunction
,DateTimeFormatFunction
,DateTimeFunction
,DayMonthNameFunction
,DbObject
,DBObjectFunction
,DefaultRow
,Domain
,DomainValueExpression
,DualIndex
,DualTable
,ExistsPredicate
,Expression
,ExpressionColumn
,ExpressionList
,ExtTypeInfo
,ExtTypeInfoEnum
,ExtTypeInfoGeometry
,ExtTypeInfoNumeric
,ExtTypeInfoRow
,FieldReference
,FileFunction
,Format
,Function0_1
,Function1
,Function1_2
,Function2
,FunctionAlias
,FunctionN
,FunctionsDB2Derby
,FunctionsLegacy
,FunctionsMSSQLServer
,FunctionsMySQL
,FunctionsOracle
,FunctionsPostgreSQL
,FunctionTable
,HashFunction
,Index
,InformationSchema
,InformationSchemaTable
,InformationSchemaTableLegacy
,IntervalOperation
,IsJsonPredicate
,JavaAggregate
,JavaFunction
,JavaTableFunction
,JsonConstructorFunction
,LengthFunction
,LinkedIndex
,LinkSchemaFunction
,MathFunction
,MathFunction1
,MathFunction2
,MergeUsing.When
,MergeUsing.WhenMatchedThenDelete
,MergeUsing.WhenMatchedThenUpdate
,MergeUsing.WhenNotMatched
,MetaIndex
,MetaSchema
,MetaTable
,ModeFunction
,MVDelegateIndex
,MVIndex
,MVPrimaryIndex
,MVSecondaryIndex
,MVSpatialIndex
,MVTable
,NullIfFunction
,NullPredicate
,OnDuplicateKeyValues
,Operation0
,Operation1
,Operation1_2
,Operation2
,OperationN
,Parameter
,PgCatalogSchema
,PgCatalogTable
,PredicateWithSubquery
,RandFunction
,RangeIndex
,RangeTable
,Regclass
,RegexpFunction
,Right
,RightOwner
,Role
,Row
,Rownum
,Schema
,SchemaObject
,SearchedCase
,SearchRow
,Sequence
,SequenceValue
,SessionControlFunction
,SetClauseList
,SetFunction
,Setting
,SignalFunction
,SimpleCase
,SimplePredicate
,SimpleRowValue
,SoundexFunction
,Sparse
,SpatialKey
,StringFunction
,StringFunction1
,StringFunction2
,Subquery
,SubstringFunction
,SysInfoFunction
,Table
,TableBase
,TableFunction
,TableInfoFunction
,TableLink
,TableSynonym
,TableValueConstructorTable
,TableView
,TimeZoneOperation
,ToCharFunction
,TriggerObject
,TrimFunction
,TruncateValueFunction
,TypedValueExpression
,TypeInfo
,TypePredicate
,UnaryOperation
,UniquePredicate
,User
,UserAggregate
,UserDefinedFunction
,Value
,ValueArray
,ValueBigDecimalBase
,ValueBigint
,ValueBinary
,ValueBlob
,ValueBoolean
,ValueBytesBase
,ValueChar
,ValueClob
,ValueCollectionBase
,ValueDate
,ValueDecfloat
,ValueDouble
,ValueEnum
,ValueEnumBase
,ValueExpression
,ValueGeometry
,ValueInteger
,ValueInterval
,ValueJavaObject
,ValueJson
,ValueLob
,ValueNull
,ValueNumeric
,ValueReal
,ValueRow
,ValueSmallint
,ValueStringBase
,ValueTime
,ValueTimestamp
,ValueTimestampTimeZone
,ValueTimeTimeZone
,ValueTinyint
,ValueUuid
,ValueVarbinary
,ValueVarchar
,ValueVarcharIgnoreCase
,Variable
,ViewIndex
,VirtualConstructedTable
,VirtualConstructedTableIndex
,VirtualTable
,VirtualTableIndex
,Wildcard
,WindowFunction
,XMLFunction
public interface HasSQL
An object that has an SQL representation.
-
-
Field Summary
Fields Modifier and Type Field Description static int
ADD_PLAN_INFORMATION
Add execution plan information.static int
DEFAULT_SQL_FLAGS
Default flags.static int
NO_CASTS
Don't add casts around literals.static int
QUOTE_ONLY_WHEN_REQUIRED
Quote identifiers only when it is strictly required (different case or identifier is also a keyword).static int
REPLACE_LOBS_FOR_TRACE
Replace long LOB values with some generated values.static int
TRACE_SQL_FLAGS
Combined flags for trace.
-
Method Summary
All Methods Instance Methods Abstract Methods Default Methods Modifier and Type Method Description default java.lang.String
getSQL(int sqlFlags)
Get the SQL statement of this expression.java.lang.StringBuilder
getSQL(java.lang.StringBuilder builder, int sqlFlags)
Appends the SQL statement of this object to the specified builder.default java.lang.String
getTraceSQL()
Get a medium size SQL expression for debugging or tracing.
-
-
-
Field Detail
-
QUOTE_ONLY_WHEN_REQUIRED
static final int QUOTE_ONLY_WHEN_REQUIRED
Quote identifiers only when it is strictly required (different case or identifier is also a keyword).- See Also:
- Constant Field Values
-
REPLACE_LOBS_FOR_TRACE
static final int REPLACE_LOBS_FOR_TRACE
Replace long LOB values with some generated values.- See Also:
- Constant Field Values
-
NO_CASTS
static final int NO_CASTS
Don't add casts around literals.- See Also:
- Constant Field Values
-
ADD_PLAN_INFORMATION
static final int ADD_PLAN_INFORMATION
Add execution plan information.- See Also:
- Constant Field Values
-
DEFAULT_SQL_FLAGS
static final int DEFAULT_SQL_FLAGS
Default flags.- See Also:
- Constant Field Values
-
TRACE_SQL_FLAGS
static final int TRACE_SQL_FLAGS
Combined flags for trace.- See Also:
- Constant Field Values
-
-
Method Detail
-
getTraceSQL
default java.lang.String getTraceSQL()
Get a medium size SQL expression for debugging or tracing.- Returns:
- the SQL expression
-
getSQL
default java.lang.String getSQL(int sqlFlags)
Get the SQL statement of this expression. This may not always be the original SQL statement, specially after optimization.- Parameters:
sqlFlags
- formatting flags- Returns:
- the SQL statement
-
getSQL
java.lang.StringBuilder getSQL(java.lang.StringBuilder builder, int sqlFlags)
Appends the SQL statement of this object to the specified builder.- Parameters:
builder
- string buildersqlFlags
- formatting flags- Returns:
- the specified string builder
-
-