Skip to content

Instantly share code, notes, and snippets.

@twobraids

twobraids/gist:13169bf340ef3152ff97

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.
Download ZIP
how could this possibly be true?
Raw
gistfile1.txt
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