summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/expected/sql-binary.c
AgeCommit message (Collapse)Author
2019-09-20Revert "Add DECLARE STATEMENT support to ECPG."Tom Lane
This reverts commit bd7c95f0c1a38becffceb3ea7234d57167f6d4bf, along with assorted follow-on fixes. There are some questions about the definition and implementation of that statement, and we don't have time to resolve them before v13 release. Rather than ship the feature and then have backwards-compatibility concerns constraining any redesign, let's remove it for now and try again later. Discussion: https://postgr.es/m/TY2PR01MB2443EC8286995378AEB7D9F8F5B10@TY2PR01MB2443.jpnprd01.prod.outlook.com
2019-02-16Add DECLARE STATEMENT support to ECPG.Michael Meskes
DECLARE STATEMENT is a statement that lets users declare an identifier pointing at a connection. This identifier will be used in other embedded dynamic SQL statement such as PREPARE, EXECUTE, DECLARE CURSOR and so on. When connecting to a non-default connection, the AT clause can be used in a DECLARE STATEMENT once and is no longer needed in every dynamic SQL statement. This makes ECPG applications easier and more efficient. Moreover, writing code without designating connection explicitly improves portability. Authors: Ideriha-san ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>) Kuroda-san ("Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>) Discussion: https://postgr.es/m4E72940DA2BF16479384A86D54D0988A565669DF@G01JPEXMBKW04
2019-01-30Change error handling of out of scope variables in ecpg.Michael Meskes
The function called can result in an out of memory error that subsequently was disregarded. Instead it should set the appropriate SQL error variables and be checked by whatever whenever statement is defined.
2019-01-30Make some ecpg test cases more robust against unexpected errors that happenMichael Meskes
during development. Test cases themselves should not hang or segfault.
2016-07-17Establish conventions about global object names used in regression tests.Tom Lane
To ensure that "make installcheck" can be used safely against an existing installation, we need to be careful about what global object names (database, role, and tablespace names) we use; otherwise we might accidentally clobber important objects. There's been a weak consensus that test databases should have names including "regression", and that test role names should start with "regress_", but we didn't have any particular rule about tablespace names; and neither of the other rules was followed with any consistency either. This commit moves us a long way towards having a hard-and-fast rule that regression test databases must have names including "regression", and that test role and tablespace names must start with "regress_". It's not completely there because I did not touch some test cases in rolenames.sql that test creation of special role names like "session_user". That will require some rethinking of exactly what we want to test, whereas the intent of this patch is just to hit all the cases in which the needed renamings are cosmetic. There is no enforcement mechanism in this patch either, but if we don't add one we can expect that the tests will soon be violating the convention again. Again, that's not such a cosmetic change and it will require discussion. (But I did use a quick-hack enforcement patch to find these cases.) Discussion: <16638.1468620817@sss.pgh.pa.us>
2013-11-26ECPG: Add EXEC SQL CLOSE C to the tests.Michael Meskes
Patch by Boszormenyi Zoltan <zb@cybertec.at>
2010-01-26Applied patch by Boszormenyi Zoltan <zb@cybertec.at> to add out-of-scope ↵Michael Meskes
cursor support to native mode.
2009-08-04Fix an ecpg test, too. Are we there yet?Tom Lane
2009-02-02When changing a regression test file one should also change the expected ↵Michael Meskes
output file.
2009-02-02Fixed auto allocation for binary data types.Michael Meskes
2008-12-29First rounf of whitespace changes. Everything but connect-test1 should be fine.Michael Meskes
2008-11-11Replaced manually synced preproc.y by the one created by the new script.Michael Meskes
Adapted regression test files accordingly.
2008-02-17- Removed duplicate include of ecpgtype.h which meant I had to adapt all ↵Michael Meskes
expected results. - Changed INFORMIX mode symbol definition yet again because the old way didn't work on NetBSD. Hopefully this one does.
2007-08-14Fixed compiler warning for enum handlingMichael Meskes
2007-08-14- Finished major rewrite to use new protocol versionMichael Meskes
- Really prepare statements - Added more regression tests - Added auto-prepare mode - Use '$n' for positional variables, '?' is still possible via ecpg option - Cleaned up the sources a little bit
2007-03-17- Changed some whitespacing in connect statement.Michael Meskes
- Made some chars const as proposed by Stefan Huehner <stefan@huehner.org>. - Synced parser and keyword lists. - Copied two token parsing from backend parser to ecpg parser. - Also added a test case for this.
2007-01-12Simplified regression handlingMichael Meskes
Added patch by Joachim to work around OpenBSD bug in regression suite.
2007-01-11Applied Joachim's patch for a --regression option.Michael Meskes
Made this option mark the .c files, so the environment variable is no longer needed. Created a special MinGW file with the special error message. Do not print port into log file when running regression tests.
2007-01-05Update ecpg regresison output for new library version number.Bruce Momjian
2006-10-04Reverted changes made by pgindentMichael Meskes
Made show.pgc set all variables before displaying them.
2006-10-04pgindent run for 8.2.Bruce Momjian
2006-09-05Started to cleanup complex tests.Michael Meskes
Added some interval checks to regression suite.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-09 03:58:00 +0000