Re: SQL is fetching results BLANK checks but the data has no BLANKS

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Yes, I am getting the same results for the following SQLs.

        SELECT test_number
        FROM bronx.test_test_details_all_mcm
        WHERE test_description LIKE ' %'
;

• Count is 878

 SELECT TEST_NUMBER

 FROM BRONX.TEST_TEST_DETAILS_ALL_MCM

 WHERE LEFT(TEST_DESCRIPTION, 1) = ' '

 ;

Count is 878

Thanks,

Sarwar

---

From: Erik Wienhold <ewie@xxxxxxxxx>
Sent: Wednesday, July 5, 2023 5:46 PM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS

 

> On 05/07/2023 23:34 CEST M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:
>
> Table has no indexes so far.

Do you get the same results when using LIKE instead?

        SELECT test_number
        FROM bronx.test_test_details_all_mcm
        WHERE test_description LIKE ' %'

--
Erik