Opened 6 years ago

Closed 6 years ago

Last modified 4 years ago

#4321 closed defect (fixed)

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 (4)

comment:1 Changed 6 years ago by peifer

The mentioned code is from line 233 of ogr_join_test.py

comment:2 Changed 6 years ago by Even Rouault

Component: AutotestOGR_SF
Keywords: ogr sql added; autotest.ogr removed
Version: svn-trunk1.8.0

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

comment:3 Changed 6 years ago by Even Rouault

Milestone: 1.8.2
Resolution: fixed
Status: newclosed

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

comment:4 Changed 4 years ago by Even Rouault

Milestone: 1.8.2

Milestone 1.8.2 deleted

Note: See TracTickets for help on using tickets.