Skip to content

Instantly share code, notes, and snippets.

@twobraids
Created September 2, 2015 21:34
Show Gist options
  • Save twobraids/13169bf340ef3152ff97 to your computer and use it in GitHub Desktop.
Save twobraids/13169bf340ef3152ff97 to your computer and use it in GitHub Desktop.
how could this possibly be true?
breakpad=> select uuid, position('\u0000' in raw_crash::text) from raw_crashes_20150831 where raw_crash::text like '\u0000%';
uuid | position
------+----------
(0 rows)
breakpad=> select uuid, position('\u0000' in raw_crash::text) from raw_crashes_20150831 where raw_crash::text like '%\u0000%';
uuid | position
--------------------------------------+----------
808ed71a-499b-45d9-ae86-7d9642150831 | 0
(1 row)
@selenamarie
Copy link

ugh! i don't know off the top of my head. some problem with the text parsing in postgres/that crash is my bet.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment