testsuite.x.devapi

Class MetadataTest

java.lang.Object

testsuite.x.internal.InternalXBaseTestCase

testsuite.x.devapi.DevApiBaseTestCase

testsuite.x.devapi.BaseTableTestCase

testsuite.x.devapi.MetadataTest

public class MetadataTest
extends BaseTableTestCase

Tests for "Column" table metadata API.

Field Summary

Fields inherited from class testsuite.x.devapi.DevApiBaseTestCase

dbCharset, dbCollation, schema, session

Fields inherited from class testsuite.x.internal.InternalXBaseTestCase

baseUrl, DEFAULT_METADATA_CHARSET, fact, isSetForXTests, testHostInfo, testProperties

Constructor Summary

Constructors

Constructor and Description
MetadataTest()

Method Summary

Modifier and Type	Method and Description
void	derivedCol()
void	docAsTableIsJSON()
void	example_metadata()
void	exhaustTypes() Some metadata fields have no sense with concrete SQL data type.
void	renameCol()
void	setupTableTest()
void	teardownTableTest()
void	testGetColumnInfoFromnSession()
void	testGetColumnLabel()
void	testGetColumnName()
void	testGetColumnNameAndgetColumnLabel()
void	testGetFractionalDigits()
void	testGetLength()
void	testGetSchemaName()
void	testGetTableLabel()
void	testGetTableName()
void	testGetType()
void	testIsNumberSigned()
void	testIsPaddedAndisNullableAndisAutoIncrement()
void	testIsPrimaryKeyAndisUniqueKeyAndisPartKey()
void	testMultiSelects()
void	testMultiSelectsAsync()
void	testWithUnsignedData()

Methods inherited from class testsuite.x.devapi.BaseTableTestCase

setupBaseTableTest, teardownBaseTableTest

Methods inherited from class testsuite.x.devapi.DevApiBaseTestCase

assertNonSecureSession, assertPreparedStatementsCount, assertPreparedStatementsCountsAndId, assertPreparedStatementsStatusCounts, assertSecureSession, assertSecureSession, buildString, count_data, destroyTestSession, dropCollection, getPreparedStatementExecutionsCount, getPreparedStatementId, getPreparedStatementsCount, getPreparedStatementsCount, getPreparedStatementsCount, getPrepDeallocateCount, getPrepExecuteCount, getPrepPrepareCount, getThreadId, isMysqlRunningLocally, isServerRunningOnWindows, makeParam, makeParam, makeParam, setupTestSession, sqlUpdate, supportsTestCertificates, supportsTLSv1_2

Methods inherited from class testsuite.x.internal.InternalXBaseTestCase

assertSessionStatusEquals, assertSessionStatusNotEquals, assertThrows, assertThrows, assertThrows, assertThrows, createAuthenticatedTestProtocol, createTempTestCollection, createTestProtocol, createTestSchema, createTestSession, dropTempTestCollection, getEncodedTestHost, getTestDatabase, getTestHost, getTestPassword, getTestPort, getTestUser, mysqlVersionMeetsMinimum, mysqlVersionMeetsMinimum

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MetadataTest

public MetadataTest()

Method Detail

setupTableTest

@BeforeEach
public void setupTableTest()

teardownTableTest

@AfterEach
public void teardownTableTest()

example_metadata

@Test
public void example_metadata()

renameCol

@Test
public void renameCol()

derivedCol

@Test
public void derivedCol()

docAsTableIsJSON

@Test
public void docAsTableIsJSON()

exhaustTypes

@Test
public void exhaustTypes()

Some metadata fields have no sense with concrete SQL data type. The following table from MysqlxResultset.ColumnMetaData describes which fields are relevant to each type:

     ================= ============ ======= ========== ====== ========
     SQL Type          .type        .length .frac_dig  .flags .charset
     ================= ============ ======= ========== ====== ========
     TINY              SINT         x
     TINY UNSIGNED     UINT         x                  x
     SHORT             SINT         x
     SHORT UNSIGNED    UINT         x                  x
     INT24             SINT         x
     INT24 UNSIGNED    UINT         x                  x
     INT               SINT         x
     INT UNSIGNED      UINT         x                  x
     LONGLONG          SINT         x
     LONGLONG UNSIGNED UINT         x                  x
     DOUBLE            DOUBLE       x       x          x
     FLOAT             FLOAT        x       x          x
     DECIMAL           DECIMAL      x       x          x
     VARCHAR,CHAR,...  BYTES        x                  x      x
     GEOMETRY          BYTES
     TIME              TIME         x
     DATE              DATETIME     x
     DATETIME          DATETIME     x
     YEAR              UINT         x                  x
     TIMESTAMP         DATETIME     x
     SET               SET                                    x
     ENUM              ENUM                                   x
     NULL              BYTES
     BIT               BIT          x
     ================= ============ ======= ========== ====== ========
 

testGetColumnInfoFromnSession

@Test
public void testGetColumnInfoFromnSession()
                                         throws java.lang.Exception

Throws:

java.lang.Exception

testGetSchemaName

@Test
public void testGetSchemaName()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testGetTableName

@Test
public void testGetTableName()
                            throws java.lang.Exception

Throws:

java.lang.Exception

testGetTableLabel

@Test
public void testGetTableLabel()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testGetColumnName

@Test
public void testGetColumnName()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testGetColumnLabel

@Test
public void testGetColumnLabel()
                              throws java.lang.Exception

Throws:

java.lang.Exception

testGetType

@Test
public void testGetType()
                       throws java.lang.Exception

Throws:

java.lang.Exception

testGetFractionalDigits

@Test
public void testGetFractionalDigits()
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testIsNumberSigned

@Test
public void testIsNumberSigned()
                              throws java.lang.Exception

Throws:

java.lang.Exception

testGetLength

@Test
public void testGetLength()
                         throws java.lang.Exception

Throws:

java.lang.Exception

testIsPrimaryKeyAndisUniqueKeyAndisPartKey

@Test
public void testIsPrimaryKeyAndisUniqueKeyAndisPartKey()
                                                      throws java.lang.Exception

Throws:

java.lang.Exception

testGetColumnNameAndgetColumnLabel

@Test
public void testGetColumnNameAndgetColumnLabel()
                                              throws java.lang.Exception

Throws:

java.lang.Exception

testMultiSelects

@Test
public void testMultiSelects()
                            throws java.lang.Exception

Throws:

java.lang.Exception

testMultiSelectsAsync

@Test
public void testMultiSelectsAsync()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testIsPaddedAndisNullableAndisAutoIncrement

@Test
public void testIsPaddedAndisNullableAndisAutoIncrement()
                                                       throws java.lang.Exception

Throws:

java.lang.Exception

testWithUnsignedData

@Test
public void testWithUnsignedData()
                                throws java.lang.Exception

Throws:

java.lang.Exception