diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2008-10-21 08:38:16 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2008-10-21 08:38:16 +0000 |
| commit | 1471e3843d04797ff117f84f6331b8b2e8fdd787 (patch) | |
| tree | e272add9a453af220026882c99586e0a722b584a /src/interfaces/ecpg/test/expected/sql-parser.c | |
| parent | 089ae3bc9aa21c9a7eb38d9baa8ebdc6063c37db (diff) | |
| download | postgresql-1471e3843d04797ff117f84f6331b8b2e8fdd787.tar.gz postgresql-1471e3843d04797ff117f84f6331b8b2e8fdd787.zip | |
Allow SQL:2008 syntax ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE
alongside our traditional syntax.
Diffstat (limited to 'src/interfaces/ecpg/test/expected/sql-parser.c')
| -rw-r--r-- | src/interfaces/ecpg/test/expected/sql-parser.c | 27 |
1 files changed, 23 insertions, 4 deletions
diff --git a/src/interfaces/ecpg/test/expected/sql-parser.c b/src/interfaces/ecpg/test/expected/sql-parser.c index 41193a4d2f0..bdc9908d16c 100644 --- a/src/interfaces/ecpg/test/expected/sql-parser.c +++ b/src/interfaces/ecpg/test/expected/sql-parser.c @@ -101,7 +101,7 @@ if (sqlca.sqlcode < 0) sqlprint();} for (i=0; i<3; i++) printf("item[%d] = %d\n", i, ind[i] ? -1 : item[i]); - { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "drop table T ", ECPGt_EOIT, ECPGt_EORT); + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "alter table T alter Item1 type bigint ", ECPGt_EOIT, ECPGt_EORT); #line 31 "parser.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); @@ -110,15 +110,34 @@ if (sqlca.sqlwarn[0] == 'W') sqlprint(); if (sqlca.sqlcode < 0) sqlprint();} #line 31 "parser.pgc" + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "alter table T alter column Item2 set data type smallint ", ECPGt_EOIT, ECPGt_EORT); +#line 32 "parser.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 32 "parser.pgc" + +if (sqlca.sqlcode < 0) sqlprint();} +#line 32 "parser.pgc" + + + { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "drop table T ", ECPGt_EOIT, ECPGt_EORT); +#line 34 "parser.pgc" + +if (sqlca.sqlwarn[0] == 'W') sqlprint(); +#line 34 "parser.pgc" + +if (sqlca.sqlcode < 0) sqlprint();} +#line 34 "parser.pgc" + { ECPGdisconnect(__LINE__, "ALL"); -#line 33 "parser.pgc" +#line 36 "parser.pgc" if (sqlca.sqlwarn[0] == 'W') sqlprint(); -#line 33 "parser.pgc" +#line 36 "parser.pgc" if (sqlca.sqlcode < 0) sqlprint();} -#line 33 "parser.pgc" +#line 36 "parser.pgc" return 0; |