| 1 |
#include <stdlib.h> |
| 2 |
#include <string.h> |
| 3 |
#include <stdio.h> |
| 4 |
#include <time.h> |
| 5 |
|
| 6 |
exec sql include ../regression; |
| 7 |
exec sql whenever sqlerror sqlprint; |
| 8 |
|
| 9 |
static void |
| 10 |
dump_binary(char *buf, int len, int ind) |
| 11 |
{ |
| 12 |
int i; |
| 13 |
|
| 14 |
printf("len=%d, ind=%d, data=0x", len, ind); |
| 15 |
for (i = 0; i < len; ++i) |
| 16 |
printf("%02x", 0xff & buf[i]); |
| 17 |
printf("\n"); |
| 18 |
} |
| 19 |
|
| 20 |
#define DATA_SIZE 0x200 |
| 21 |
#define LACK_SIZE 13 |
| 22 |
# |
| 23 |
int |
| 24 |
main(void) |
| 25 |
{ |
| 26 |
exec sql begin declare section; |
| 27 |
bytea send_buf[2][512]; |
| 28 |
bytea recv_buf[2][DATA_SIZE]; |
| 29 |
bytea recv_vlen_buf[][DATA_SIZE]; |
| 30 |
bytea recv_short_buf[DATA_SIZE - LACK_SIZE]; |
| 31 |
int ind[2]; |
| 32 |
exec sql end declare section; |
| 33 |
int i, j, c; |
| 34 |
|
| 35 |
#define init() { \ |
| 36 |
for (i = 0; i < 2; ++i) \ |
| 37 |
{ \ |
| 38 |
memset(recv_buf[i].arr, 0x0, sizeof(recv_buf[i].arr)); \ |
| 39 |
recv_buf[i].len = 0; \ |
| 40 |
ind[i] = 0; \ |
| 41 |
} \ |
| 42 |
recv_vlen_buf = NULL, \ |
| 43 |
memset(recv_short_buf.arr, 0x0, sizeof(recv_short_buf.arr)); \ |
| 44 |
} \ |
| 45 |
while (0) |
| 46 |
|
| 47 |
ECPGdebug(1, stderr); |
| 48 |
|
| 49 |
for (i = 0; i < 2; ++i) |
| 50 |
{ |
| 51 |
for (j = 0, c = 0xff; (c == -1 ? c = 0xff : 1), j < DATA_SIZE; ++j, --c) |
| 52 |
send_buf[i].arr[j] = c; |
| 53 |
|
| 54 |
send_buf[i].len = DATA_SIZE; |
| 55 |
} |
| 56 |
|
| 57 |
exec sql connect to REGRESSDB1; |
| 58 |
|
| 59 |
exec sql create table if not exists test (data1 bytea, data2 bytea); |
| 60 |
|
| 61 |
exec sql prepare ins_stmt from "insert into test values(?,?)"; |
| 62 |
exec sql prepare sel_stmt from "select data1,data2 from test"; |
| 63 |
exec sql allocate descriptor idesc; |
| 64 |
exec sql allocate descriptor odesc; |
| 65 |
|
| 66 |
/* Test for static sql statement with normal host variable, indicator */ |
| 67 |
init(); |
| 68 |
exec sql truncate test; |
| 69 |
exec sql insert into test values(:send_buf[0], :send_buf[1]); |
| 70 |
exec sql select data1,data2 into :recv_buf[0]:ind[0], :recv_short_buf:ind[1] from test; |
| 71 |
dump_binary(recv_buf[0].arr, recv_buf[0].len, ind[0]); |
| 72 |
dump_binary(recv_short_buf.arr, recv_short_buf.len, ind[1]); |
| 73 |
|
| 74 |
/* Test for cursor */ |
| 75 |
init(); |
| 76 |
exec sql truncate test; |
| 77 |
exec sql insert into test values(:send_buf[0], :send_buf[1]); |
| 78 |
exec sql declare cursor1 cursor for select data1 from test where data1 = :send_buf[0]; |
| 79 |
exec sql open cursor1; |
| 80 |
exec sql fetch from cursor1 INTO :recv_buf[0]; |
| 81 |
exec sql close cursor1; |
| 82 |
exec sql free cursor1 ; |
| 83 |
dump_binary(recv_buf[0].arr, recv_buf[0].len, 0); |
| 84 |
|
| 85 |
/* Test for variable length array */ |
| 86 |
init(); |
| 87 |
exec sql truncate test; |
| 88 |
exec sql insert into test values(:send_buf[0], :send_buf[1]); |
| 89 |
exec sql insert into test values(:send_buf[0], :send_buf[1]); |
| 90 |
exec sql select data1 into :recv_vlen_buf from test; |
| 91 |
dump_binary(recv_vlen_buf[0].arr, recv_vlen_buf[0].len, 0); |
| 92 |
dump_binary(recv_vlen_buf[1].arr, recv_vlen_buf[1].len, 0); |
| 93 |
free(recv_vlen_buf); |
| 94 |
|
| 95 |
/* Test for dynamic sql statement with normal host variable, indicator */ |
| 96 |
init(); |
| 97 |
exec sql truncate test; |
| 98 |
exec sql execute ins_stmt using :send_buf[0], :send_buf[1]; |
| 99 |
exec sql execute sel_stmt into :recv_buf[0]:ind[0], :recv_short_buf:ind[1]; |
| 100 |
dump_binary(recv_buf[0].arr, recv_buf[0].len, ind[0]); |
| 101 |
dump_binary(recv_short_buf.arr, recv_short_buf.len, ind[1]); |
| 102 |
|
| 103 |
/* Test for dynamic sql statement with sql descriptor */ |
| 104 |
init(); |
| 105 |
exec sql truncate test; |
| 106 |
exec sql set descriptor idesc value 1 data = :send_buf[0]; |
| 107 |
exec sql set descriptor idesc value 2 data = :send_buf[1]; |
| 108 |
exec sql execute ins_stmt using sql descriptor idesc; |
| 109 |
exec sql execute sel_stmt into sql descriptor odesc; |
| 110 |
exec sql get descriptor odesc value 1 :recv_buf[0] = data, :ind[0] = indicator; |
| 111 |
exec sql get descriptor odesc value 2 :recv_short_buf = data, :ind[1] = indicator; |
| 112 |
dump_binary(recv_buf[0].arr, recv_buf[0].len, ind[0]); |
| 113 |
dump_binary(recv_short_buf.arr, recv_short_buf.len, ind[1]); |
| 114 |
|
| 115 |
exec sql drop table test; |
| 116 |
|
| 117 |
/* Test for invalid bytea format */ |
| 118 |
exec sql select ''::text into :recv_buf[0]; |
| 119 |
exec sql select '\\a1234'::text into :recv_buf[0]; |
| 120 |
|
| 121 |
exec sql commit; |
| 122 |
exec sql disconnect; |
| 123 |
|
| 124 |
return 0; |
| 125 |
} |