When I call
arcpy.FeatureClassToFeatureClass_conversion from the PyCharm python console, the
where_clause argument is ignored. When a value is supplied, it does not return an error message, nor does it apply the
where_clause to the operation. For example:
In: arcpy.FeatureClassToFeatureClass_conversion(r'C:\Workspace\test.gdb\wells', r'C:\Workspace\test.gdb', 'test1', where_clause='This is not sql')
Out: <Result 'C:\\Workspace\\test.gdb\\test1'>
Stranger still, this command works correctly (in the above case, it returns an error) when executed from the Windows command interface (but using the same python environment). The where clause is only ignored in the PyCharm console. I am using arcpy from ArcGIS Pro 2.5.0, and PyCharm 2020.2.
I don't understand why this is happening, and it is compromising some of my workflows.
Can anyone replicate this error, or suggest a solution?