From 69b7d59a744134e33bbe51dab44dd4113c83b7fb Mon Sep 17 00:00:00 2001 From: Greg Stark Date: Mon, 29 Jul 2013 23:43:44 +0100 Subject: Sync ECPG with WITH ORDINALITY changes --- src/interfaces/ecpg/test/expected/sql-parser.c | 20 +------------------- 1 file changed, 1 insertion(+), 19 deletions(-) (limited to 'src/interfaces/ecpg/test/expected/sql-parser.c') diff --git a/src/interfaces/ecpg/test/expected/sql-parser.c b/src/interfaces/ecpg/test/expected/sql-parser.c index 876bbf34a15..a4a6d864bfb 100644 --- a/src/interfaces/ecpg/test/expected/sql-parser.c +++ b/src/interfaces/ecpg/test/expected/sql-parser.c @@ -58,25 +58,7 @@ if (sqlca.sqlcode < 0) sqlprint();} #line 20 "parser.pgc" - { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into T values ( 1 , null )", ECPGt_EOIT, ECPGt_EORT); -#line 22 "parser.pgc" - -if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 22 "parser.pgc" - -if (sqlca.sqlcode < 0) sqlprint();} -#line 22 "parser.pgc" - - { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into T values ( 1 , 1 )", ECPGt_EOIT, ECPGt_EORT); -#line 23 "parser.pgc" - -if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 23 "parser.pgc" - -if (sqlca.sqlcode < 0) sqlprint();} -#line 23 "parser.pgc" - - { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into T values ( 1 , 2 )", ECPGt_EOIT, ECPGt_EORT); + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into t select 1 , nullif ( y - 1 , 0 ) from generate_series ( 1 , 3 ) with ordinality as series ( x , y )", ECPGt_EOIT, ECPGt_EORT); #line 24 "parser.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -- cgit v1.2.3