Skip to main content

vsql returns error on using with statement

  • March 27, 2019
  • 0 replies
  • 1 view

hanans

query starts like :

with campaigns as (QUERY1),
campaign_sample as (QUERY2)
QUERY3

running vsql on the query gets:

vsql:generate_data.sql:54: ERROR 4566:  Relation "campaign_sample" does not exist

running the same sql file from intellij datagrip works (not from the vsql command line)