Flex tables and strange json parsing

petry

Hello!

 

I have the following column in a materialized view: 

 

 

public | flextable_view | my_column  | int   |    8 | (MapLookup(flextable.__raw__, 'field'))::int

 

But sometimes it is materialized as Null:

 

select (MapLookup(flextable_view.__raw__, 'field'))::!int, field from flextable_view where field is null;

 MapLookup | field
-----------+----------
      1988 |
       399 |
       163 |
      2052 |
       591 |
       105 |
       417 |
       105 |
      1260 |
       417 |
      1934 |
       605 |
      1758 |
      1721 |
      1449 |
      1656 |
       105 |
      2052 |
      1934 |
       726 |
       591 |
       591 |
      1934 |
       591 |
       622 |
      2052 |

Why is it happening?

 

Thank you,

Petr