Re: ECPG bug: "unterminated quoted identifier" - Mailing list pgsql-bugs

From 1250kv
Subject Re: ECPG bug: "unterminated quoted identifier"
Date
Msg-id CA+4qtLd4K09yFA3S5ktaDDr0VQAVuXQpzvhbFufhGOisny+d7w@mail.gmail.com
Whole thread Raw
In response to Re: ECPG bug: "unterminated quoted identifier"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ECPG bug: "unterminated quoted identifier"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
When I assign the value "aaa\"bbb" to the non-host variable foo and then assign the value of foo to the host-variable bar there no error:

int main()
{
  char *foo = "aaa\"bbb";
  printf("%s\n", foo);
 
  EXEC SQL char *bar = foo;
  printf("%s\n", bar);

  return 0;
}

Result:
aaa"bbb
aaa"bbb

On Tue, Oct 20, 2020 at 8:23 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
1250kv <1250kv@gmail.com> writes:
> void main()
> {
>   char *foo = "aaa\"bbb";
>   EXEC SQL char *bar = "aaa\"bbb";
> }

> ecpg sample.pgc -o 1.c
> sample .pgc:10: ERROR: unterminated quoted identifier

I don't really see a bug there.  While I'm not an ecpg expert by
any means, I'd expect the EXEC SQL section to parse quoted strings
according to SQL rules not C rules.  And under SQL, that's not
what you do to write a valid quoted identifier.

                        regards, tom lane

pgsql-bugs by date:

Previous
From: 1250kv
Date:
Subject: Re: ECPG bug: "unterminated quoted identifier"
Next
From: Tom Lane
Date:
Subject: Re: ECPG bug: "unterminated quoted identifier"