Description

There is a ton of small methods that used to determine Database capabilities like unions support etc.
This methods are crucial for tools that heavily rely on metadata.

This issue is about:

• fixating returning value by checking in a test
• reviewing and returning correct value.

Here is the list:

• insertsAreDetected()

• isCatalogAtStart()

• isReadOnly()

• locatorsUpdateCopy()

• nullPlusNonNullIsNull()

• nullsAreSortedAtEnd()

• nullsAreSortedAtStart()

• nullsAreSortedHigh()

• nullsAreSortedLow()

• othersDeletesAreVisible()

• othersInsertsAreVisible()

• othersUpdatesAreVisible()

• ownDeletesAreVisible()

• ownInsertsAreVisible()

• ownUpdatesAreVisible()

• storesLowerCaseIdentifiers()

• storesLowerCaseQuotedIdentifiers()

• storesMixedCaseIdentifiers()

• storesMixedCaseQuotedIdentifiers()

• storesUpperCaseIdentifiers()

• storesUpperCaseQuotedIdentifiers()

• supportsANSI92EntryLevelSQL()

• supportsANSI92FullSQL()

• supportsANSI92IntermediateSQL()

• supportsAlterTableWithAddColumn()

• supportsAlterTableWithDropColumn()

• supportsBatchUpdates()

• supportsCatalogsInDataManipulation()

• supportsCatalogsInIndexDefinitions()

• supportsCatalogsInPrivilegeDefinitions()

• supportsCatalogsInProcedureCalls()

• supportsCatalogsInTableDefinitions()

• supportsColumnAliasing()

• supportsConvert()

• supportsConvert()

• supportsCoreSQLGrammar()

• supportsCorrelatedSubqueries()

• supportsDataDefinitionAndDataManipulationTransactions()

• supportsDataManipulationTransactionsOnly()

• supportsDifferentTableCorrelationNames()

• supportsExpressionsInOrderBy()

• supportsExtendedSQLGrammar()

• supportsFullOuterJoins()

• supportsGetGeneratedKeys()

• supportsGroupBy()

• supportsGroupByBeyondSelect()

• supportsGroupByUnrelated()

• supportsIntegrityEnhancementFacility()

• supportsLikeEscapeClause()

• supportsLimitedOuterJoins()

• supportsMinimumSQLGrammar()

• supportsMixedCaseIdentifiers()

• supportsMixedCaseQuotedIdentifiers()

• supportsMultipleOpenResults()

• supportsMultipleResultSets()

• supportsMultipleTransactions()

• supportsNamedParameters()

• supportsNonNullableColumns()

• supportsOpenCursorsAcrossCommit()

• supportsOpenCursorsAcrossRollback()

• supportsOpenStatementsAcrossCommit()

• supportsOpenStatementsAcrossRollback()

• supportsOrderByUnrelated()

• supportsOuterJoins()

• supportsPositionedDelete()

• supportsPositionedUpdate()

• supportsRefCursors()

• supportsResultSetConcurrency()

• supportsResultSetHoldability()

• supportsResultSetType()

• supportsSavepoints()

• supportsSchemasInDataManipulation()

• supportsSchemasInIndexDefinitions()

• supportsSchemasInPrivilegeDefinitions()

• supportsSchemasInProcedureCalls()

• supportsSchemasInTableDefinitions()

• supportsSelectForUpdate()

• supportsSharding()

• supportsStatementPooling()

• supportsStoredFunctionsUsingCallSyntax()

• supportsStoredProcedures()

• supportsSubqueriesInComparisons()

• supportsSubqueriesInExists()

• supportsSubqueriesInIns()

• supportsSubqueriesInQuantifieds()

• supportsTableCorrelationNames()

• supportsTransactionIsolationLevel()

• supportsTransactions()

• supportsUnion()

• supportsUnionAll()

• updatesAreDetected()

• usesLocalFilePerTable()

• usesLocalFiles()

• allProceduresAreCallable()

• allTablesAreSelectable()

• autoCommitFailureClosesAllResultSets()

• dataDefinitionCausesTransactionCommit()

• dataDefinitionIgnoredInTransactions()

• deletesAreDetected()

• doesMaxRowSizeIncludeBlobs()

• generatedKeyAlwaysReturned()

• getResultSetHoldability()

• getRowIdLifetime()

• getSQLStateType()

• getSearchStringEscape()