Skip to content

01-Data Types

Column and tag boundary
1. Create stable with max column and tag length
2. Insert data with max column and tag length
3. Verify data correctness with query
4. Create column/tag with binary
5. Create column/tag with varchar
6. Create column/tag with nchar
7. Create column/tag with varbinary
8. Create tag with json
9. Insert data with chinese sring on nchar
path: cases/01-DataTypes/test_column_tag_boundary.py

DataTypes: bigint
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_bigint.py

DataTypes: blob
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
6. Check auto create table with blob cols
path: cases/01-DataTypes/test_datatype_blob.py

DataTypes: bool
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_bool.py

DataTypes: decimal
1. Check decimal ddl
2. No decimal table test
3. Insert decimal values
4. Query decimal values
5. Verify JIRA TS-6333
path: cases/01-DataTypes/test_datatype_decimal.py

DataTypes: decimal64
1. check decimal64 ddl
2. insert decimal64 values
3. query decimal64 values on where condition
path: cases/01-DataTypes/test_datatype_decimal64.py

DataTypes: decimal last
1. Check decimal ddl
2. Insert decimal values
3. Query decimal with last/last_row
4. Query decimal view with last/last_row
path: cases/01-DataTypes/test_datatype_decimal_last.py

DataTypes: double
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_double.py

DataTypes: float
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_float.py

DataTypes: geometry
1. Create stable with geometry datatype on column and tag
2. Insert and query data with geometry datatype
3. Automatically create child table with geometry datatype on tag
4. Alter tag value with geometry datatype
5. Test illegal input for geometry datatype
6. Create normal table with geometry datatype on column
7. Insert and query data with geometry datatype
8. Insert geometry column/tag with NULL value
9. Insert geometry format: POINT/LINESTRING/POLYGON,/MULTIPOINT/MULTILINESTRING/MULTIPOLYGON/GEOMETRYCOLLECTION
path: cases/01-DataTypes/test_datatype_geometry.py

DataTypes: int
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_int.py

DataTypes: json
1. Create table
2. Insert data
3. Alter tag value
4. Handle illegal input
path: cases/01-DataTypes/test_datatype_json.py

DataTypes: nchar
1. Create table
2. Insert data
3. Alter tag value
4. Handle illegal input
path: cases/01-DataTypes/test_datatype_nchar.py

DataTypes: nchar chinese
1. Create table
2. Insert data
3. Query data
path: cases/01-DataTypes/test_datatype_nchar_chinese.py

DataTypes: smallint
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_smallint.py

DataTypes: timestamp
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_timestamp.py

DataTypes: tinyint
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_tinyint.py

DataTypes: unsigned int
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_uint.py

DataTypes: unsigned numeric
1. Create table
2. Insert data
3. Alter tag value
4. Handle illegal input
path: cases/01-DataTypes/test_datatype_unsign.py

DataTypes: varbinary
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
path: cases/01-DataTypes/test_datatype_varbinary.py

DataTypes: varchar
1. Create table
2. Insert data
3. Auto-create table
4. Alter tag value
5. Handle illegal input
6. Query with varchar values
7. Cast on varchar
path: cases/01-DataTypes/test_datatype_varchar.py

NULL: column
1. Create table
2. Insert data with NULL
3. Query data
path: cases/01-DataTypes/test_null_column.py

NULL: varchar column with LIMIT triggers blockDataKeepFirstNRows all-NULL path
When the first N rows of a variable-length column are all NULL and a
LIMIT N query is executed, blockDataKeepFirstNRows must set
varmeta.length to 0 instead of keeping the stale value.
path: cases/01-DataTypes/test_null_column.py

NULL: tag
1. Create table with NULL tags
2. Select tags
3. Alter tags with NULL
4. Insert data with NULL tags
5. Query data with NULL tags
path: cases/01-DataTypes/test_null_tag.py