Ticket #4321 (closed defect: fixed)

Opened 20 months ago

Last modified 7 weeks ago

autotest/ogr/ogr_join_test.py: Type mismatch errors

Reported by: peifer Owned by: warmerdam
Priority: normal Milestone:
Component: OGR_SF Version: 1.8.0
Severity: normal Keywords: ogr sql
Cc:

Description

I noted the below errors while running ogr_join_test.py. I guess the errors are related to this JOIN on line 173:

+ 'LEFT JOIN idlink2 ON poly.eas_id = idlink2.name ' )

...where poly.eas_id is a numeric field and idlink2.name is a string field.

TEST: ogr_join_10 ... 
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.
ERROR 1: Type mismatch or improper type of arguments to = operator.

Change History

Changed 20 months ago by peifer

The mentioned code is from line 233 of ogr_join_test.py

Changed 20 months ago by rouault

  • keywords ogr sql added; autotest.ogr removed
  • version changed from svn-trunk to 1.8.0
  • component changed from Autotest to OGR_SF

r23299 /trunk/gdal/ogr/ogrsf_frmts/generic/ogr_gensql.cpp: OGR SQL: fix joining a float column with a string column (#4321)

r23300 /trunk/autotest/ogr/ogr_join_test.py: OGR SQL: Test joining a float column with a string column (#4321)

Should likely be backported in 1.8 branch as it is a regression w.r.t pre 1.8 behaviour, but likely not a very common use case though

Changed 20 months ago by rouault

  • status changed from new to closed
  • resolution set to fixed
  • milestone set to 1.8.2

r23306 /branches/1.8/gdal/ogr/ogrsf_frmts/generic/ogr_gensql.cpp: OGR SQL: fix joining a float column with a string column (#4321)

Changed 7 weeks ago by rouault

  • milestone 1.8.2 deleted

Milestone 1.8.2 deleted

Note: See TracTickets for help on using tickets.