BigQuery Error In where Clause with a String type column

Question

I have a column that contains strings like this '0 0PAA01 CF101 -S07'. I have some records in the database and when I tried to retrieve it using BigQuery the query is not returning records. I am doing select * from table where column='0 0PAA01 CF101 -S07'

Is a BigQuery Problem?

Felipe Hoffa Felipe Hoffa · Accepted Answer · 2019-12-20T17:00:29

I'm 99% sure this is not a BigQuery problem - but that the strings are in fact different.

Look at this:

SELECT MD5('my name is Felipe Hoffa') from_keyboard
  , MD5(str) from_db
  , str='my name is Felipe Hoffa' equal_are_they
FROM (
     SELECT 'my name is Felipe Hoffa' str 
)

Why are they different? One has a tab instead of a space.

BigQuery Error In where Clause with a String type column

1 Answers