[fdo][FDO346][New] MySQL - Cannot query features from MySQL with a column type ...

[Barbara Zoladek]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO346

Type
 Defect

Artifact ID
 FDO346 (MySQL - Cannot query features from MySQL with a column type "LONGTEXT")

Reported by
 Barbara Zoladek
 barbarazoladek (barbara.zoladek at autodesk.com)

New artifact details:
---------------------------------------------------------

- Defect Severity set to new value
  Medium
- Summary set to new value
  MySQL - Cannot query features from MySQL with a column type "LONGTEXT"
- Artifact created
- Description set to new value
  MySQL - RevEng: Cannot query features from MySQL with a column type "LONGTEXT"

Create a MySQL database with the following definition:

CREATE DATABASE MySQL_ModForeign;

CREATE TABLE MySQL_ModForeign.Point 
	(GEOMETRY POINT, 
	ENTITYID INT AUTO_INCREMENT PRIMARY KEY, 
	FSTEXTCONTENT LONGTEXT) 
	ENGINE = MYISAM;
	
ALTER TABLE MySQL_ModForeign.Point AUTO_INCREMENT = 201;

populate the table with at least one feature.  The attached file can be used to load data with the following command at the MySQL prompt:

LOAD DATA INFILE '<<path>>/POINT.out' 
	INTO TABLE MySQL_ModForeign.Point
	FIELDS TERMINATED BY ','
	LINES TERMINATED BY '\n';

The describe schema returns the FSTEXTCONTENT type as a FdoDataType_String but the length seems excessively long:

INFO: SchemaDefinition.point Properties: (): 
 Name: FSTEXTCONTENT
 Qualified Name: Fdomysql_modforeign:point.FSTEXTCONTENT
 Description: 
 DataProperty Type: FdoDataType_String
 Read Only: False
 Nullable: True
 Default Value: 
 Precision: 0
 Scale: 0
 Length: 2147483647

When we query the feature we get the following exception:

FdoCommandException(): RDBMS:  


- Artifact Status set to new value
  New

---------------------------------------------------------
This message was automatically generated by Project Tracker.