in unittest/scripts/auto/js_shell/validation/sql_show_column_type_info_norecord.js [105:507]
Collation: binary (63)
Length: 11
Decimals: 0
Flags: NUM
Field 8
Name: `intu`
Org_name: `intu`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: UInteger
DbType: LONG
Collation: binary (63)
Length: 10
Decimals: 0
Flags: UNSIGNED NUM
Field 9
Name: `bigint`
Org_name: `bigint`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Integer
DbType: LONGLONG
Collation: binary (63)
Length: 20
Decimals: 0
Flags: NOT_NULL PRI_KEY AUTO_INCREMENT NUM
Field 10
Name: `bigintu`
Org_name: `bigintu`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: UInteger
DbType: LONGLONG
Collation: binary (63)
Length: 20
Decimals: 0
Flags: UNSIGNED NUM
Field 11
Name: `float`
Org_name: `float`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Float
DbType: FLOAT
Collation: binary (63)
Length: 10
Decimals: 2
Flags: NUM
Field 12
Name: `double`
Org_name: `double`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Double
DbType: DOUBLE
Collation: binary (63)
Length: 22
Decimals: 31
Flags: NUM
Field 13
Name: `decimal`
Org_name: `decimal`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Decimal
DbType: NEWDECIMAL
Collation: binary (63)
Length: 12
Decimals: 2
Flags: NUM
Field 14
Name: `date`
Org_name: `date`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Date
DbType: DATE
Collation: binary (63)
Length: 10
Decimals: 0
Flags: BINARY
Field 15
Name: `datetime`
Org_name: `datetime`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: DateTime
DbType: DATETIME
Collation: binary (63)
Length: 19
Decimals: 0
Flags: BINARY
Field 16
Name: `timestamp`
Org_name: `timestamp`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: DateTime
DbType: TIMESTAMP
Collation: binary (63)
Length: 19
Decimals: 0
Flags: BINARY TIMESTAMP
Field 17
Name: `time`
Org_name: `time`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Time
DbType: TIME
Collation: binary (63)
Length: 10
Decimals: 0
Flags: BINARY
Field 18
Name: `year`
Org_name: `year`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: UInteger
DbType: TINY
Collation: binary (63)
Length: 4
Decimals: 0
Flags: NOT_NULL UNSIGNED NUM
Field 19
Name: `tinyblob`
Org_name: `tinyblob`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Bytes
DbType: BLOB
Collation: binary (63)
Length: 255
Decimals: 0
Flags: BLOB BINARY
Field 20
Name: `tinytext`
Org_name: `tinytext`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: String
DbType: BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length: 255
Decimals: 0
Flags: BLOB
Field 21
Name: `blob`
Org_name: `blob`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Bytes
DbType: BLOB
Collation: binary (63)
Length: 65535
Decimals: 0
Flags: BLOB BINARY
Field 22
Name: `text`
Org_name: `text`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: String
DbType: BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length: 65535
Decimals: 0
Flags: BLOB
Field 23
Name: `mediumblob`
Org_name: `mediumblob`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Bytes
DbType: BLOB
Collation: binary (63)
Length: 16777215
Decimals: 0
Flags: BLOB BINARY
Field 24
Name: `mediumtext`
Org_name: `mediumtext`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: String
DbType: BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length: 16777215
Decimals: 0
Flags: BLOB
Field 25
Name: `longblob`
Org_name: `longblob`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Bytes
DbType: BLOB
Collation: binary (63)
Length: 4294967295
Decimals: 0
Flags: BLOB BINARY
Field 26
Name: `longtext`
Org_name: `longtext`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: String
DbType: BLOB
Collation: utf8mb4_0900_ai_ci (255)
Length: 4294967295
Decimals: 0
Flags: BLOB
Field 27
Name: `enum`
Org_name: `enum`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Enum
DbType: STRING
Collation: utf8mb4_0900_ai_ci (255)
Length: 0
Decimals: 0
Flags: ENUM
Field 28
Name: `set`
Org_name: `set`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Set
DbType: STRING
Collation: utf8mb4_0900_ai_ci (255)
Length: 0
Decimals: 0
Flags: SET
Field 29
Name: `json`
Org_name: `json`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Json
DbType: JSON
Collation: binary (63)
Length: 4294967295
Decimals: 0
Flags: BLOB BINARY
Field 30
Name: `geometry`
Org_name: `geometry`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Geometry
DbType: GEOMETRY
Collation: binary (63)
Length: 0
Decimals: 0
Flags: BLOB BINARY
Field 31
Name: `bool`
Org_name: `bool`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Integer
DbType: TINY
Collation: binary (63)
Length: 1
Decimals: 0
Flags: NUM
Field 32
Name: `char`
Org_name: `char`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: String
DbType: VAR_STRING
Collation: utf8mb4_0900_ai_ci (255)
Length: 40
Decimals: 0
Flags:
Field 33
Name: `varchar`
Org_name: `varchar`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: String
DbType: VAR_STRING
Collation: utf8mb4_0900_ai_ci (255)
Length: 80
Decimals: 0
Flags:
Field 34
Name: `binary`
Org_name: `binary`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Bytes
DbType: VAR_STRING
Collation: binary (63)
Length: 20
Decimals: 0
Flags: BINARY
Field 35
Name: `varbinary`
Org_name: `varbinary`
Catalog: `def`
Database: `scti_test`
Table: `t`
Org_table: `t`
Type: Bytes
DbType: VAR_STRING
Collation: binary (63)
Length: 20
Decimals: 0
Flags: BINARY
0
//@<OUT> Column type info enabled X JSON
{
"warning": "Using a password on the command line interface can be insecure.\n"
}