Error reading odb file

[DJDavies2]

What happened?

I am getting an error when reading an odb if I ask for a particular column in the sql statement. Doing odc sql 'select lat,lon' is fine, but doing odc sql 'select lat,lon,predictor_thickness_200_50hPa_225' fails like this:

000 2026-01-12 10:34:29 (E) Exception: UserError: Can't find a table for : predictor_thickness_200_50hpa_225
000 2026-01-12 10:34:29 (E) ** UserError: Can't find a table for : predictor_thickness_200_50hpa_225 Caught in (/home/users/david.davies/cylc-run/mo-bundle-866/share/mo-bundle/eckit/src/eckit/runtime/Tool.cc:31 start)
000 2026-01-12 10:34:29 (E) ** Exception terminates odc

What are the steps to reproduce the bug?

See above

Version

develop

Platform (OS and architecture)

Linux

Relevant log output

Accompanying data

No response

Organisation

Met Office

[DJDavies2]

I would like to upload the odb file I am using to generate this failure, but when I try it says it doesn't recognise the file type. How do I upload the odb file? It isn't very big.

[yaswant]

@DJDavies2 you should be able to upload a .zip file.

[adammaycock]

Note that odc header and odc ls confirm presence of the predictor_thickness_200_50hPa_225 column (with expected value ranges).

Also, odc set and odc split behave as expected when operating on that column. The issue appears to be specific to odc sql.

[DJDavies2]

out.odb.tar.gz

[DJDavies2]

Thanks, I have uploaded the file now.

[DJDavies2]

It seems that the problem is related to the predictor_thickness_200_50hPa_225 having a capital letter in the name; creating the ODB with predictor_thickness_200_50hpa_225 results in a readable ODB. However this doesn't seem to be documented documented behaviour, unless I have missed it?

I feel this behaviour could be improved. If the ODB code allows an ODB to be created with columns that have capital letters it ought to be possible to read those ODBs.