This is the behavior that I see for old sheets as well. I have this old sheet here: https://docs.google.com/spreadsheet/ccc?key=0Ap-GB-Crk0g3dHBsRkdNbFRkVUxKemhmN3Z2S1VFX2c&usp=drive_web#gid=0
The query SELECT A,B WHERE B='' returns 0 rows https://spreadsheets.google.com/tq?key=0Ap-GB-Crk0g3dHBsRkdNbFRkVUxKemhmN3Z2S1VFX2c&tq=SELECT+A,B+WHERE+B=%27%27 The query SELECT A,B WHERE B IS NULL returns 1 row https://spreadsheets.google.com/tq?key=0Ap-GB-Crk0g3dHBsRkdNbFRkVUxKemhmN3Z2S1VFX2c&tq=SELECT+A,B+WHERE+B+IS+NULL On 1404319609885, Scott Sherris <[email protected]> wrote: > Actually, let me clarify - I actually cannot get the "IS NULL" statement > to work on the Old Sheets, so to me this seems like a big change. I can't > "flip a switch" to go to the new sheets - I have to coordinate app query > changes as well as using new keys and keeping the data synchronized. > You're also going to see a lot of breakage if the promised conversion of > old sheets to new sheets ever happens. > > I don't have a test environment set up that will show this, but if you > think you might find that helpful I can create one. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
