07-Geometry

Geometry basic

1. Create super/child/normal tables and insert geometry data

2. Query with ST_GeomFromText() and check results

3. Query with ST_AsText() and check results

4. Verify TD-28365 Bug

path: cases/11-Functions/07-Geometry/test_fun_geo_basic.py

Fun: st_geomfromtext()

1. Create 1 super table 2 child tables and 1 normal table

2. Insert geometry data and null into above tables

3. Insert invalid geometry data into child/normal table and expect error

4. Use st_geomfromtext() to query geometry data from above tables and check the results

5. Query with invalid parameter "POIN(1.0 1.5)"

6. Query with invalid parameter "LINESTRING(1.0 1.0, 2.0 2.0, 5.0 5.0,)"

7. Query with invalid parameter "POLYGON((3.0 6.0, 5.0 6.0, 5.0 8.0, 3.0 8.0))"

8. Query with invalid parameter "XXX"

path: cases/11-Functions/07-Geometry/test_fun_geo_basic.py

Fun: st_astext()

1. Create 1 super table 2 child tables and 1 normal table

2. Insert geometry data and null into above tables

3. Insert invalid geometry data into child/normal table and expect error

4. Query with st_astext() on super/child/normal tables and check the results

5. Query with parameter "NULL"

6. Query with invalid parameter "XXX"

7. Query with no parameter

8. Query on not geometry datatype column

path: cases/11-Functions/07-Geometry/test_fun_geo_basic.py