unittest/scripts/js_devapi/validation/mysqlx_column_metadata.js

//@ Metadata on Bit Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: one|
|Column Label: one|
|Type: <Type.BIT>|
|Length: 1|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on TinyInt Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: two|
|Column Label: two|
|Type: <Type.TINYINT>|
|Length: 4|
|Fractional Digits: 0|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned TinyInt Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: utwo|
|Column Label: utwo|
|Type: <Type.TINYINT>|
|Length: 3|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on SmallInt Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: three|
|Column Label: three|
|Type: <Type.SMALLINT>|
|Length: 6|
|Fractional Digits: 0|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned SmallInt Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: uthree|
|Column Label: uthree|
|Type: <Type.SMALLINT>|
|Length: 5|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on MediumInt Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: four|
|Column Label: four|
|Type: <Type.MEDIUMINT>|
|Length: 9|
|Fractional Digits: 0|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned MediumInt Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: ufour|
|Column Label: ufour|
|Type: <Type.MEDIUMINT>|
|Length: 8|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Int Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: five|
|Column Label: five|
|Type: <Type.INT>|
|Length: 11|
|Fractional Digits: 0|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned Int Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: ufive|
|Column Label: ufive|
|Type: <Type.INT>|
|Length: 10|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Float Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: six|
|Column Label: six|
|Type: <Type.FLOAT>|
|Length: 12|
|Fractional Digits: 31|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned Float Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: usix|
|Column Label: usix|
|Type: <Type.FLOAT>|
|Length: 12|
|Fractional Digits: 31|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Float Column with length and fractional digits
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: csix|
|Column Label: csix|
|Type: <Type.FLOAT>|
|Length: 5|
|Fractional Digits: 3|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Decimal Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: seven|
|Column Label: seven|
|Type: <Type.DECIMAL>|
|Length: 11|
|Fractional Digits: 0|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned Decimal Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: useven|
|Column Label: useven|
|Type: <Type.DECIMAL>|
|Length: 10|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Decimal Column with length and fractional digits
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: cseven|
|Column Label: cseven|
|Type: <Type.DECIMAL>|
|Length: 6|
|Fractional Digits: 2|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Double Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: eight|
|Column Label: eight|
|Type: <Type.DOUBLE>|
|Length: 22|
|Fractional Digits: 31|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Unsigned Double Column
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: ueight|
|Column Label: ueight|
|Type: <Type.DOUBLE>|
|Length: 22|
|Fractional Digits: 31|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Double Column with length and fractional digits
|Schema Name: py_shell_test|
|Table Name: table1|
|Table Label: table1|
|Column Name: ceight|
|Column Label: ceight|
|Type: <Type.DOUBLE>|
|Length: 8|
|Fractional Digits: 3|
|Is Number Signed: true|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Json Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: one|
|Column Label: one|
|Type: <Type.JSON>|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: binary|
|Charset Name: binary|
|Is ZeroFill: false|

//@ Metadata on Char Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: two|
|Column Label: two|
|Type: <Type.STRING>|
|Length: 20|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: utf8mb4_general_ci//utf8mb4_0900_ai_ci|
|Charset Name: utf8mb4|
|Is ZeroFill: false|

//@ Metadata on Varchar Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: three|
|Column Label: three|
|Type: <Type.STRING>|
|Length: 80|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: utf8mb4_general_ci//utf8mb4_0900_ai_ci|
|Charset Name: utf8mb4|
|Is ZeroFill: false|

//@ Metadata on Text Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: four|
|Column Label: four|
|Type: <Type.STRING>|
|Length: 65535|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: utf8mb4_general_ci//utf8mb4_0900_ai_ci|
|Charset Name: utf8mb4|
|Is ZeroFill: false|

//@ Metadata on Time Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: five|
|Column Label: five|
|Type: <Type.TIME>|
|Length: 10|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Date Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: six|
|Column Label: six|
|Type: <Type.DATE>|
|Length: 10|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on DateTime Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: seven|
|Column Label: seven|
|Type: <Type.DATETIME>|
|Length: 19|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: |
|Charset Name: |
|Is ZeroFill: false|

//@ Metadata on Set Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: eight|
|Column Label: eight|
|Type: <Type.SET>|
|Length: |
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: utf8mb4_general_ci//utf8mb4_0900_ai_ci|
|Charset Name: utf8mb4|
|Is ZeroFill: false|

//@ Metadata on Enum Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: nine|
|Column Label: nine|
|Type: <Type.ENUM>|
|Length: |
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: utf8mb4_general_ci//utf8mb4_0900_ai_ci|
|Charset Name: utf8mb4|
|Is ZeroFill: false|

//@ Metadata on VarBinary Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: ten|
|Column Label: ten|
|Type: <Type.BYTES>|
|Length: 15|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: binary|
|Charset Name: binary|
|Is ZeroFill: false|

//@ Metadata on Blob Column
|Schema Name: py_shell_test|
|Table Name: table2|
|Table Label: table2|
|Column Name: eleven|
|Column Label: eleven|
|Type: <Type.BYTES>|
|Length: 65535|
|Fractional Digits: 0|
|Is Number Signed: false|
|Collation Name: binary|
|Charset Name: binary|
|Is ZeroFill: false|