Class AbstractMySQLDictionary
java.lang.Object
org.apache.openjpa.jdbc.sql.DBDictionary
org.apache.openjpa.jdbc.sql.AbstractMySQLDictionary
- All Implemented Interfaces:
JoinSyntaxes, Configurable, IdentifierConfiguration, ConnectionDecorator, LoggingConnectionDecorator.SQLWarningHandler
- Direct Known Subclasses:
MariaDBDictionary, MySQLDictionary
Base dictionary for the MySQL family of databases (MySQL and MariaDB),
which share the SQL dialect, the DDL types and the behaviour of their
JDBC drivers that this dictionary deals with. The differences, such as
the reserved words, the version dependent features and the error codes,
are left to the subclasses.
-
Nested Class Summary
Nested classes/interfaces inherited from class DBDictionary
DBDictionary.DateMillisecondBehaviors, DBDictionary.SerializedData -
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final StringbooleanWhether the driver automatically deserializes blobs.static final Stringstatic final Stringstatic final Stringstatic final StringbooleanWhether to inline multi-table bulk-delete operations into MySQL's combinedDELETE FROM foo, bar, bazsyntax.The table type to use when creating tables; defaults to innodb.static final Stringstatic final StringbooleanWhether to use clobs; defaults to true.Fields inherited from class DBDictionary
_procs, _proxyManager, allowQueryTimeoutOnFindUpdate, allowsAliasInBulkClause, allowsBulkTargetInSubselect, arrayTypeName, autoAssignClause, autoAssignTypeName, backslashEscapesInStringLiterals, batchLimit, bigintTypeName, binaryTypeName, bitLengthFunction, bitTypeName, blobBufferSize, blobTypeName, booleanRepresentation, booleanTypeName, castFunction, catalogSeparator, ceilingFunction, CENTI, characterColumnSize, charTypeName, clobBufferSize, clobTypeName, closePoolSQL, concatenateDelimiter, concatenateFunction, conf, connected, CONS_NAME_AFTER, CONS_NAME_BEFORE, CONS_NAME_MID, constraintNameMode, createPrimaryKeys, crossJoinClause, currentDateFunction, currentTimeFunction, currentTimestampFunction, databaseProductName, databaseProductVersion, dateFractionDigits, datePrecision, dateTypeName, DECI, decimalTypeName, defaultSchemaName, delimitedCase, disableAlterSeqenceIncrementBy, disableSchemaFactoryColumnTypeErrors, distinctCountColumnSeparator, distinctTypeName, doubleTypeName, driverVendor, dropTableSQL, exceptFunction, extractDateTimeFieldFunction, fixedSizeTypeNames, fixedSizeTypeNameSet, floatTypeName, forUpdateClause, fractionalTypeNameSet, fullResultCollectionInOrderByRelation, getStringVal, inClauseLimit, indexPhysicalForeignKeys, initializationSQL, innerJoinClause, integerCastTypeName, integerTypeName, invalidColumnWordSet, invalidTableWordSet, isJDBC3, isJDBC4, javaObjectTypeName, javaToDbColumnNameProcessing, joinSyntax, lastGeneratedKeyQuery, leadingDelimiter, leftFunctionName, log, longCastTypeName, longVarbinaryTypeName, longVarcharTypeName, maxAutoAssignNameLength, maxColumnNameLength, maxConstraintNameLength, maxEmbeddedBlobSize, maxEmbeddedClobSize, maxIndexesPerTable, maxIndexNameLength, maxTableNameLength, MICRO, MILLI, NAME_ANY, NAME_SEQUENCE, NAME_TABLE, nameConcatenator, NANO, nativeSequenceType, naturalLogarithmFunction, nextSequenceQuery, NO_BATCH, nullTypeName, numericTypeName, otherTypeName, outerJoinClause, platform, RANGE_POST_DISTINCT, RANGE_POST_LOCK, RANGE_POST_SELECT, RANGE_PRE_DISTINCT, rangePosition, realTypeName, refTypeName, replaceFunctionName, reportsSuccessNoInfoOnBatchUpdates, requiresAliasForSubselect, requiresAutoCommitForMetaData, requiresCastForCaseStringResult, requiresCastForComparisons, requiresCastForExtractOperand, requiresCastForMathFunctions, requiresConditionForCrossJoin, requiresSearchStringEscapeForLike, requiresTargetForDelete, reservedWords, reservedWordSet, rightFunctionName, roundTimeToMillisec, SCHEMA_CASE_LOWER, SCHEMA_CASE_PRESERVE, SCHEMA_CASE_UPPER, schemaCase, searchStringEscape, searchStringNoEscape, SEC, selectWords, selectWordSet, sequenceNameSQL, sequenceSchemaSQL, sequenceSQL, setStringRightTruncationOn, simulateLocking, smallintTypeName, sqlStateCodes, storageLimitationsFatal, storeCharsAsNumbers, storeLargeNumbersAsStrings, stringLengthFunction, structTypeName, substringFunctionName, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsAutoAssign, supportsCascadeDeleteAction, supportsCascadeUpdateAction, supportsCaseConversionForLob, supportsComments, supportsCorrelatedSubselect, supportsDefaultDeleteAction, supportsDefaultUpdateAction, supportsDeferredConstraints, supportsDelimitedIdentifiers, supportsForeignKeys, supportsForeignKeysComposite, supportsGeneralCaseExpression, supportsGetGeneratedKeys, supportsHaving, supportsLockingWithDistinctClause, supportsLockingWithInnerJoin, supportsLockingWithMultipleTables, supportsLockingWithOrderClause, supportsLockingWithOuterJoin, supportsLockingWithSelectRange, supportsModOperator, supportsMultipleNontransactionalResultSets, supportsNullDeleteAction, supportsNullTableForGetColumns, supportsNullTableForGetImportedKeys, supportsNullTableForGetIndexInfo, supportsNullTableForGetPrimaryKeys, supportsNullUniqueColumn, supportsNullUpdateAction, supportsParameterInSelect, supportsQueryTimeout, supportsRestrictDeleteAction, supportsRestrictUpdateAction, supportsSchemaForGetColumns, supportsSchemaForGetTables, supportsSelectEndIndex, supportsSelectForUpdate, supportsSelectFromFinalTable, supportsSelectStartIndex, supportsSimpleCaseExpression, supportsSubselect, supportsUniqueConstraints, supportsUnsizedCharOnCast, supportsUuidType, supportsXMLColumn, systemSchemas, systemSchemaSet, systemTables, systemTableSet, tableForUpdateClause, tableLengthIncludesSchema, tableTypes, timestampTypeName, timestampWithZoneTypeName, timeTypeName, timeWithZoneTypeName, tinyintTypeName, toLowerCaseFunction, toUpperCaseFunction, trailingDelimiter, trimBothFunction, trimLeadingFunction, trimSchemaName, trimStringColumns, trimTrailingFunction, typecastToStringTypeName, typeModifierSet, UNLIMITED, useGetBestRowIdentifierForPrimaryKeys, useGetBytesForBlobs, useGetObjectForBlobs, useGetStringForClobs, useJDBC4SetBinaryStream, useNativeSequenceCache, useSchemaName, useSetBytesForBlobs, useSetStringForClobs, useWildCardForCount, uuidTypeName, validationSQL, varbinaryTypeName, varcharTypeName, VENDOR_DATADIRECT, VENDOR_OTHER, xmlTypeEncoding, xmlTypeNameFields inherited from interface JoinSyntaxes
SYNTAX_DATABASE, SYNTAX_SQL92, SYNTAX_TRADITIONAL -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected voidAdds words that the database reserves in a table name, and that are eitherinvalid column wordsalready or valid column names, to thereserved wordsonly, as far as they are missing there (OPENJPA-3074).protected voidaddUpdatedReservedWords(Collection<String> words) Adds words that the database reserves to theinvalid column wordsand to thereserved words, as far as they are missing there (OPENJPA-3074).voidappendNullsPrecedence(SQLBuffer ordering, int nullPrecedence) MySQL / MariaDB do not support ANSI SQLNULLS FIRST/NULLS LAST.protected voidappendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) If this dictionary can select ranges, use this method to append the range SQL.voidappendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) Append XML comparison.protected voidMakes thenormalizing ruleof this dictionary delimit the reserved words ifdelimitsReservedWords(), so that an identifier named for this dictionary keeps a name that is such a word.protected abstract booleanWhether a table, column or other name that is areserved wordis delimited in the SQL, so that it keeps its name, rather than renamed, e.g. with a0appended.String[]Return a series of SQL statements to add the given primary key to its table.getBlobObject(ResultSet rs, int column, JDBCStore store) Convert the specified column of the SQL ResultSet to the proper java type.String[]getCreateTableSQL(Table table) Return a series of SQL statements to create the given table, complete with columns.String[]getDeleteTableContentsSQL(Table[] tables, Connection conn) Create SQL to delete the contents of the specified tables.String[]getDropForeignKeySQL(ForeignKey fk, Connection conn) ReturnALTER TABLE <table name> DROP FOREIGN KEY <fk name>.String[]getDropIndexSQL(Index index) Return a series of SQL statements to drop the given index.String[]ReturnALTER TABLE <table name> DROP PRIMARY KEY.EXTRACT(WEEK) counts weeks from Sunday; mode 3 of WEEK gives the ISO week that JPA defines.getLocalTime(ResultSet rs, int column) Retrieve the specified column of the SQL ResultSet to the properLocalTimejava type.protected abstract intThe largest scale of a decimal column the database allows.intgetPreferredType(int type) Return the preferredTypestype for the given one.protected abstract StringThe name of the fetch configuration hint whose value is appended after theSELECTkeyword of a query.Check to see if we have set theselect hintin the fetch configuration, and if so, append the hint after the "SELECT" part of the query.protected Collection<String> getTypeName(Column col) OPENJPA-740 Special case for MySql special column types, like LONGTEXT, LONGBLOG etc..voidindexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) Invoke this database's indexOf function.protected ColumnCreate a new column from the information in the schema metadata.voidRemoves theupdated reserved wordsif the compatibility options ask for the earlier names.voidsetLocalTime(PreparedStatement stmnt, int idx, LocalTime val, Column col) toJDBCEscapedDateTimeLiteral(String escape, int parseType) MySQL Connector/J and MariaDB Connector/J translate a JDBC escaped date-time literal into a string literal, so that COALESCE or CASE with a date-time column has a string result.protected voidUse the temporal types with a fraction of a second, which MySQL has from 5.7 and MariaDB from 10.2 on.protected booleanWhether theupdated reserved wordsandreserved table wordsare in use, which the compatibility optionUpdatedReservedWords=falseturns off.Methods inherited from class DBDictionary
addCastAsType, addErrorCode, allowsBulkUpdateOfJoinedTables, appendBulkPrimaryKeysIn, appendCast, appendLength, appendNumericCast, appendSelect, appendSize, appendUpdates, applyRange, assertSupport, calculateValue, canOuterJoin, closeDataSource, combineForeignKey, comment, comparison, connectedConfiguration, convertSchemaCase, convertSchemaCase, copy, copy, createIndexIfNecessary, createIndexIfNecessary, decorate, deleteStream, delimitAll, endConfiguration, executeQuery, fromDBName, getAddColumnSQL, getAddForeignKeySQL, getAlterSequenceSQL, getArray, getAsciiStream, getBatchFetchSize, getBatchLimit, getBatchUpdateCount, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBoolean, getBooleanRepresentation, getByte, getBytes, getCalendar, getCastFunction, getCastFunction, getCatalogNameForMetadata, getCatalogNameForMetadata, getChar, getCharacterStream, getClob, getClobString, getColumnDBName, getColumnIdentifier, getColumnNameForMetadata, getColumnNameForMetadata, getColumns, getColumns, getConversionKey, getCreateIndexSQL, getCreateSequenceSQL, getCreateTableSQL, getDate, getDate, getDateFractionDigits, getDeclareColumnSQL, getDefaultIdentifierRule, getDefaultSchemaName, getDeleteTargets, getDelimitedCase, getDelimitIdentifiers, getDouble, getDropColumnSQL, getDropSequenceSQL, getDropTableSQL, getExtractDateTimePartFunction, getExtractField, getExtractOperandCastType, getFloat, getForeignKeyConstraintSQL, getForUpdateClause, getFrom, getFromSelect, getFullIdentifier, getFullName, getFullName, getFullName, getGeneratedKey, getGeneratedKeySequenceName, getGenKeySeqName, getIdentifierConcatenator, getIdentifierDelimiter, getIdentifierRule, getIdentifierRules, getIdentityColumnName, getImportedKeys, getImportedKeys, getImportedKeys, getImportedKeys, getIndexInfo, getIndexInfo, getInstant, getInt, getIntegerCastTypeName, getInvalidColumnWordSet, getInvalidTableWordSet, getIsNotNullSQL, getIsNullSQL, getJDBCType, getJDBCType, getJDBCType, getKey, getLeadingDelimiter, getLOBStream, getLocalDate, getLocalDateTime, getLocale, getLog, getLong, getLongCastTypeName, getMajorVersion, getMarkerForInsertUpdate, getMillisecondBehavior, getMinorVersion, getNamingUtil, getNormalizingRule, getNumber, getNumberCastTypeName, getObject, getOffsetDateTime, getOffsetTime, getPlaceholderValueString, getPrimaryKeyConstraintSQL, getPrimaryKeys, getPrimaryKeys, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromGetPrimaryKeys, getPrimaryKeysFromGetPrimaryKeys, getRef, getSchemaCase, getSchemaNameForMetadata, getSchemaNameForMetadata, getSelects, getSequence, getSequenceIncrement, getSequences, getSequences, getSequencesSQL, getSequencesSQL, getShort, getStoreCharsAsNumbers, getStoredProcedure, getStoredProcedureCallSQL, getStoredProcedureNameCandidates, getString, getStringCastTypeName, getSupportsDelimitedIdentifiers, getSupportsXMLColumn, getTableNameForMetadata, getTableNameForMetadata, getTables, getTables, getTime, getTimestamp, getTimestampPrecision, getTrailingDelimiter, getTrimSchemaName, getTypeName, getUniqueConstraintSQL, getValidColumnName, getValidColumnName, getValidColumnName, getValidColumnName, getValidDefaultSequenceName, getValidDefaultTableName, getValidForeignKeyName, getValidForeignKeyName, getValidIndexName, getValidIndexName, getValidPrimaryKeyName, getValidSequenceName, getValidSequenceName, getValidTableName, getValidTableName, getValidUniqueName, getValidUniqueName, getVersionColumn, getVersionColumn, getWhere, getXMLTypeEncoding, getYear, handleWarning, insertBlobForStreamingLoad, insertClobForStreamingLoad, insertSize, isConnected, isDroppable, isFatalException, isImplicitJoin, isReplicationConnection, isSelect, isStoreCharsAsNumbersExplicit, isSystemIndex, isSystemIndex, isSystemSequence, isSystemSequence, isSystemSequence, isSystemTable, isSystemTable, isUnsizedDecimal, isUsingLimit, isUsingOffset, isUsingOrderBy, isUsingRange, left, makeNameValid, makeNameValid, makeNameValid, makeNameValid, matchErrorState, mathFunction, needsToCreateIndex, needsToCreateIndex, newForeignKey, newIndex, newPrimaryKey, newSequence, newStoreException, newTable, normalize, prepareStatement, processDBColumnName, putBytes, putChars, putString, refSchemaComponents, replace, right, serialize, setArray, setAsciiStream, setBatchLimit, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setBooleanRepresentation, setByte, setBytes, setCalendar, setChar, setCharacterStream, setClob, setClobString, setDate, setDate, setDateMillisecondBehavior, setDefaultSchemaName, setDelimitedCase, setDelimitIdentifiers, setDouble, setFloat, setInstant, setInt, setJoinSyntax, setLeadingDelimiter, setLocalDate, setLocalDateTime, setLocale, setLong, setMajorVersion, setMinorVersion, setNull, setNumber, setObject, setOffsetDateTime, setOffsetTime, setQueryTimeout, setRef, setShort, setStatementQueryTimeout, setStoreCharsAsNumbers, setString, setSupportsDelimitedIdentifiers, setSupportsXMLColumn, setTime, setTimeouts, setTimeouts, setTimestamp, setTrailingDelimiter, setTrimSchemaName, setTyped, setUnknown, setUnknown, setXMLTypeEncoding, setYear, shorten, startConfiguration, storageWarning, substring, supportsDeferredForeignKeyConstraints, supportsDeferredUniqueConstraints, supportsDeleteAction, supportsIsolationForUpdate, supportsLocking, supportsRandomAccessResultSet, supportsUpdateAction, toBulkOperation, toDBName, toDBName, toDelete, toNativeJoin, toOperation, toOperation, toSelect, toSelect, toSelect, toSelect, toSelect, toSelectCount, toSnakeCase, toSQL92Join, toStringLiteral, toTableUpdate, toTraditionalJoin, toTypedDateTimeLiteral, toUpdate, updateBlob, updateClob, validateBatchProcess, validateDBSpecificBatchProcess, versionEqualOrEarlierThan, versionEqualOrLaterThan, versionLaterThan
-
Field Details
-
DELIMITER_BACK_TICK
- See Also:
-
tableType
The table type to use when creating tables; defaults to innodb. -
useClobs
public boolean useClobsWhether to use clobs; defaults to true. Set this to false if you have an old version of MySQL which does not handle clobs properly. -
driverDeserializesBlobs
public boolean driverDeserializesBlobsWhether the driver automatically deserializes blobs. -
optimizeMultiTableDeletes
public boolean optimizeMultiTableDeletesWhether to inline multi-table bulk-delete operations into MySQL's combinedDELETE FROM foo, bar, bazsyntax. Defaults to false, since this may fail in the presence of InnoDB tables with foreign keys. -
tinyBlobTypeName
- See Also:
-
mediumBlobTypeName
- See Also:
-
longBlobTypeName
- See Also:
-
tinyTextTypeName
- See Also:
-
mediumTextTypeName
- See Also:
-
longTextTypeName
- See Also:
-
-
Constructor Details
-
AbstractMySQLDictionary
public AbstractMySQLDictionary()
-
-
Method Details
-
addUpdatedReservedWords
Adds words that the database reserves to theinvalid column wordsand to thereserved words, as far as they are missing there (OPENJPA-3074). The compatibility optionUpdatedReservedWords=falseremoves the words that were added here again, so that the names keep the form an earlier release generated.- See Also:
-
addUpdatedReservedTableWords
Adds words that the database reserves in a table name, and that are eitherinvalid column wordsalready or valid column names, to thereserved wordsonly, as far as they are missing there (OPENJPA-3074). The compatibility optionUpdatedReservedWords=falseremoves them again, as theupdated reserved words. -
usesUpdatedReservedWords
protected boolean usesUpdatedReservedWords()Whether theupdated reserved wordsandreserved table wordsare in use, which the compatibility optionUpdatedReservedWords=falseturns off. Known once the configuration is set. -
delimitsReservedWords
protected abstract boolean delimitsReservedWords()Whether a table, column or other name that is areserved wordis delimited in the SQL, so that it keeps its name, rather than renamed, e.g. with a0appended. -
setConfiguration
Removes theupdated reserved wordsif the compatibility options ask for the earlier names. This has to happen before the naming rules are configured, which take a copy of the words.- Specified by:
setConfigurationin interfaceConfigurable- Overrides:
setConfigurationin classDBDictionary
-
configureNamingRules
protected void configureNamingRules()Makes thenormalizing ruleof this dictionary delimit the reserved words ifdelimitsReservedWords(), so that an identifier named for this dictionary keeps a name that is such a word. The rule is this dictionary's own, the identifiers of other dictionaries of the JVM are not affected.- Overrides:
configureNamingRulesin classDBDictionary
-
getSelectHint
The name of the fetch configuration hint whose value is appended after theSELECTkeyword of a query.- See Also:
-
getMaxDecimalScale
protected abstract int getMaxDecimalScale()The largest scale of a decimal column the database allows. -
useFractionalSecondTemporalTypes
protected void useFractionalSecondTemporalTypes()Use the temporal types with a fraction of a second, which MySQL has from 5.7 and MariaDB from 10.2 on. -
getExtractDateTimeFieldFunction
EXTRACT(WEEK) counts weeks from Sunday; mode 3 of WEEK gives the ISO week that JPA defines. EXTRACT(SECOND) returns the whole seconds only; the fraction of the second that JPA includes is added from EXTRACT(MICROSECOND).- Overrides:
getExtractDateTimeFieldFunctionin classDBDictionary
-
setLocalTime
public void setLocalTime(PreparedStatement stmnt, int idx, LocalTime val, Column col) throws SQLException Timehas no fraction of a second, so aLocalTimeis passed to and read from the driver as it is, keeping the fraction that aTIME(6)column orEXTRACT(SECOND)holds.- Overrides:
setLocalTimein classDBDictionary- Throws:
SQLException
-
getLocalTime
Description copied from class:DBDictionaryRetrieve the specified column of the SQL ResultSet to the properLocalTimejava type.- Overrides:
getLocalTimein classDBDictionary- Throws:
SQLException
-
getCreateTableSQL
Description copied from class:DBDictionaryReturn a series of SQL statements to create the given table, complete with columns. Indexes and constraints will be created separately.- Overrides:
getCreateTableSQLin classDBDictionary
-
getDropIndexSQL
Description copied from class:DBDictionaryReturn a series of SQL statements to drop the given index. ReturnsDROP INDEX <index name>by default.- Overrides:
getDropIndexSQLin classDBDictionary
-
getDropPrimaryKeySQL
ReturnALTER TABLE <table name> DROP PRIMARY KEY.- Overrides:
getDropPrimaryKeySQLin classDBDictionary
-
getDropForeignKeySQL
ReturnALTER TABLE <table name> DROP FOREIGN KEY <fk name>.- Overrides:
getDropForeignKeySQLin classDBDictionary
-
getAddPrimaryKeySQL
Description copied from class:DBDictionaryReturn a series of SQL statements to add the given primary key to its table. Return an empty array if operation not supported. ReturnsALTER TABLE <table name> ADD <pk cons sql >by default.- Overrides:
getAddPrimaryKeySQLin classDBDictionary
-
getDeleteTableContentsSQL
Description copied from class:DBDictionaryCreate SQL to delete the contents of the specified tables. The default implementation drops all non-deferred RESTRICT foreign key constraints involving the specified tables, issues DELETE statements against the tables, and then adds the dropped constraints back in. Databases with more optimal ways of deleting the contents of several tables should override this method.- Overrides:
getDeleteTableContentsSQLin classDBDictionary
-
appendSelectRange
Description copied from class:DBDictionaryIf this dictionary can select ranges, use this method to append the range SQL.- Overrides:
appendSelectRangein classDBDictionary
-
newColumn
Description copied from class:DBDictionaryCreate a new column from the information in the schema metadata.- Overrides:
newColumnin classDBDictionary- Throws:
SQLException
-
getBlobObject
Description copied from class:DBDictionaryConvert the specified column of the SQL ResultSet to the proper java type.- Overrides:
getBlobObjectin classDBDictionary- Throws:
SQLException
-
getPreferredType
public int getPreferredType(int type) Description copied from class:DBDictionaryReturn the preferredTypestype for the given one. Returns the given type by default.- Overrides:
getPreferredTypein classDBDictionary
-
appendXmlComparison
public void appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) Append XML comparison.- Overrides:
appendXmlComparisonin classDBDictionary- Parameters:
buf- the SQL buffer to write the comparisonop- the comparison operation to performlhs- the left hand side of the comparisonrhs- the right hand side of the comparisonlhsxml- indicates whether the left operand maps to XMLrhsxml- indicates whether the right operand maps to XML
-
getSelectOperation
Check to see if we have set theselect hintin the fetch configuration, and if so, append the hint after the "SELECT" part of the query.- Overrides:
getSelectOperationin classDBDictionary
-
getSelectTableAliases
- Overrides:
getSelectTableAliasesin classDBDictionary
-
getTypeName
OPENJPA-740 Special case for MySql special column types, like LONGTEXT, LONGBLOG etc..- Overrides:
getTypeNamein classDBDictionary- See Also:
-
indexOf
Description copied from class:DBDictionaryInvoke this database's indexOf function.- Overrides:
indexOfin classDBDictionary- Parameters:
buf- the SQL buffer to write the indexOf invocation tostr- a query value representing the target stringfind- a query value representing the search stringstart- a query value representing the start index, or null to start at the beginning
-
appendNullsPrecedence
MySQL / MariaDB do not support ANSI SQLNULLS FIRST/NULLS LAST. Emulate via an auxiliary<expr> IS NULLsort key.The default NULL ordering places NULLs before non-NULLs when sorting ASC and after non-NULLs when sorting DESC. When the requested precedence already matches that default, nothing extra is emitted. Otherwise the last order term
<expr> ASC|DESCis rewritten to<expr> IS NULL <sort>, <expr> ASC|DESC.- Overrides:
appendNullsPrecedencein classDBDictionary- Parameters:
ordering- the in-progress ORDER BY buffernullPrecedence-QueryExpressions.NULLS_FIRSTorQueryExpressions.NULLS_LAST
-
toJDBCEscapedDateTimeLiteral
MySQL Connector/J and MariaDB Connector/J translate a JDBC escaped date-time literal into a string literal, so that COALESCE or CASE with a date-time column has a string result. A SQL standard typed literal keeps the date-time type.- Overrides:
toJDBCEscapedDateTimeLiteralin classDBDictionary
-