Re: possible bug

[Les <nagylzs@xxxxxxxxx>]

So what happens if query the table directly?:

select * from wf.workflow  where head_table_id::float8::int8 = 25408438504;

vs

select * from wf.workflow  where head_table_id = 25408438504;

Both return lots of rows. The same number of rows.

select count(*) from wf.workflow  where head_table_id::float8::int8 = 25408438504;
count|
-----+

62260|

select count(*) from wf.workflow  where head_table_id = 25408438504;

count|
-----+

62260|

Both of them use seq scan.

QUERY PLAN                                                         |
-------------------------------------------------------------------+
Aggregate  (cost=2985.00..2985.01 rows=1 width=8)                  |
  ->  Seq Scan on workflow  (cost=0.00..2829.07 rows=62369 width=0)|
        Filter: (head_table_id = '25408438504'::bigint)            |

QUERY PLAN                                                                           |
-------------------------------------------------------------------------------------+
Aggregate  (cost=3289.86..3289.87 rows=1 width=8)                                    |
  ->  Seq Scan on workflow  (cost=0.00..3288.70 rows=460 width=0)                    |
        Filter: (((head_table_id)::double precision)::bigint = '25408438504'::bigint)|