columnFromVar sometimes called with a variable with negative varattno

[kaidaguerre]

Investigate why this is and fix

This has been seen when running the queries

insert into
  seen_hn_top (id, title, text, url, time)

  -- Alert for top items on a range of subjects
  select
    id,
    title,
    text,
    url,
    time
  from
    hackernews_top
  where
    (
      title ilike '%sql%'
      or title ilike '%osquery%'
      or title ilike '%postgres%'
      or title ilike '%steampipe%'
    )
    and id not in
    (
      select
        id
      from
        seen_hn_top
    )

  union

  -- Alert immediately for anything Steampipe related
  select
    id,
    title,
    text,
    url,
    time
  from
    hackernews_new
  where
    (
      title ilike '%steampipe%'
      or url ilike '%steampipe%'
    )
    and id not in
    (
      select
        id
      from
        seen_hn_top
    )

  returning *;

select
  '#ff6600' as color,
  title || ' - ' || url as fallback,
  title,
  text,
  url as title_link,
  'Hacker News' as footer
from
  seen_hn_top
where
  seen > current_timestamp - interval '2 mins'

insert into
  seen_twitter_mention (id, text, url, username, created_at)
  select
    id,
    text,
    'https://twitter.com/' || (author->>'username') || '/statuses/' || id as url,
    author->>'username' as username,
    created_at
  from
    twitter_search_recent
  where
    query = '(steampipe OR steampipe.io OR github.com/turbot) -tomathy -GutturalSteve -"steampipe alley"'
    and id not in
    (
      select
        id
      from
        seen_twitter_mention
    )
    returning *;

select
  '#1da1f2' as color,
  url as fallback,
  text,
  id || ' by @' || username as title,
  url as title_link,
  'Twitter' as footer
from
  seen_twitter_mention
where
  seen > current_timestamp - interval '2 mins'

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.