Re: garbage data back

[Brad White <b55white@xxxxxxxxx>]

David,

Thanks!

'EXPLAIN ANALYZE' is very slick.

Promises to be very helpful.

As soon as I saw the output, it was obvious where my problem was.

Brad.

On Mon, Mar 6, 2023 at 2:30 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Mon, Mar 6, 2023 at 1:18 PM Brad White <b55white@xxxxxxxxx> wrote:

As you can see here, when attempting to filter on the FileKey, it is actually filtering on the Order Item ID field.

select "FileKey", "OrderItemID" from "vw_rptInvc_Permits"
where "FileKey" LIKE '%1317'

I'm stumped. Any guesses?

Agreed, what you've shown doesn't make sense.

Try:

EXPLAIN ANALYZE

REINDEX (on any underlying table indexes)

Show the version you are running.

David J.