SELECT of pseudo hex value gives unexpected result

From: "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: SELECT of pseudo hex value gives unexpected result
Date: 2019-01-29 16:18:07
Message-ID: 3edb0e31-8fea-3cf7-477c-7554ea25975e@pro-open.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I found this in an SQL-injection attempt today:
union select 0x5e73266725,0x5e73266725[,...],0x5e73266725;

Tried
SELECT 0x5e73266725;

and received:
-[ RECORD 1 ]--
x5e73266725 | 0

That was not what I expected... is this expected/documented behaviour?

Thx in advance!
--
Gunnar "Nick" Bluth
RHCE/SCLA

Mobil +49 172 8853339
Email: gunnar(dot)bluth(at)pro-open(dot)de
__________________________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX. Ten years later
they are choosing Windows over UNIX. What part of that message aren't you
getting? - Tom Payne

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-01-29 16:39:29 Re: SELECT of pseudo hex value gives unexpected result
Previous Message Adrian Klaver 2019-01-29 15:21:46 Re: How to set parameters in 'options'?