sysbench/tests/t/api_sql_pgsql.t at 9427a3daf4bfef2c7c9b0b5dcedc716116f62d91 · akopytov/sysbench · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
########################################################################
SQL Lua API + PostgreSQL tests
########################################################################

  $ . ${SBTEST_INCDIR}/pgsql_common.sh
  $ . ${SBTEST_INCDIR}/api_sql_common.sh
  drv:name() = pgsql
  SQL types:
  {
    BIGINT = 4,
    CHAR = 11,
    DATE = 8,
    DATETIME = 9,
    DOUBLE = 6,
    FLOAT = 5,
    INT = 3,
    NONE = 0,
    SMALLINT = 2,
    TIME = 7,
    TIMESTAMP = 10,
    TINYINT = 1,
    VARCHAR = 12
  }
  --
  SQL error codes:
  {
    FATAL = 2,
    IGNORABLE = 1,
    NONE = 0
  }
  --
  FATAL: invalid database driver name: 'non-existing'
  failed to initialize the DB driver
  100
  --
  --
  1 foo 0.4
  2 nil 0.3
  nil bar 0.2
  nil nil 0.1
  --
  bar nil
  --
  FATAL: PQprepare() failed: ERROR:  relation "nonexisting" does not exist
  LINE 1: SELECT * FROM nonexisting
                        ^

  SQL API error
  --
  <sql_param>
  <sql_param>
  <sql_param>
  Unsupported argument type: 8
  nil
  <sql_result>
  <sql_result>
  <sql_result>
  ALERT: attempt to free an invalid result set
  db_free_results() failed
  db_free_results() failed
  db_free_results() failed
  601\t0987654321\t0.9 (esc)
  --
  (last message repeated 2 times)
  ALERT: attempt to use an already closed connection
  */api_sql.lua:*: SQL API error (glob)
  ALERT: attempt to close an already closed connection
  --
  4
  601 700 0987654321 0987654321
  --
  1
  2
  --
  reconnects = 1
  FATAL: Connection to database failed: could not translate host name "non-existing" to address: * (glob)

  connection creation failed
  --
  FATAL: PQexec() failed: 7 null value in column "a" *violates not-null constraint (glob)
  FATAL: failed query was: INSERT INTO t VALUES (NULL)
  Got an error descriptor:
  {
    connection = <sql_connection>,
    query = "INSERT INTO t VALUES (NULL)",
    sql_errmsg = 'null value in column "a" *violates not-null constraint', (glob)
    sql_errno = 0,
    sql_state = "23502"
  }
  */api_sql.lua:*: SQL error, errno = 0, state = '23502': null value in column "a" *violates not-null constraint (glob)
  FATAL: PQexec() failed: 7 value too long for type character(1)
  FATAL: failed query was: INSERT INTO t VALUES ('test')
  Got an error descriptor:
  {
    connection = <sql_connection>,
    query = "INSERT INTO t VALUES ('test')",
    sql_errmsg = "value too long for type character(1)",
    sql_errno = 0,
    sql_state = "22001"
  }
  */api_sql.lua:*: SQL error, errno = 0, state = '22001': value too long for type character(1) (glob)
  FATAL: PQexec() failed: 7 table "t" does not exist
  FATAL: failed query was: DROP TABLE t
  Got an error descriptor:
  {
    connection = <sql_connection>,
    query = "DROP TABLE t",
    sql_errmsg = 'table "t" does not exist',
    sql_errno = 0,
    sql_state = "42P01"
  }
  */api_sql.lua:*: SQL error, errno = 0, state = '42P01': table "t" does not exist (glob)
  --
  ########################################################################
  # Multiple connections test
  ########################################################################
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
  ########################################################################
  # Incorrect bulk API usage
  ########################################################################
  ALERT: attempt to call bulk_insert_next() before bulk_insert_init()
  */api_sql.lua:*: db_bulk_insert_next() failed (glob)
  ########################################################################
  # query_row() with an empty result set
  ########################################################################
  nil
  ########################################################################
  # GH-282: Mysql's fetch_row() is broken
  ########################################################################
  1
  2
  ########################################################################
  # Client prepare with string parameter is broken
  ########################################################################
  --
  12345678
  --
  12345678
  12345678