1
###############################################
3
# Prepared Statements test on HEAP tables #
5
###############################################
8
# NOTE: PLEASE SEE ps_1general.test (bottom)
9
# BEFORE ADDING NEW TEST CASES HERE !!!
15
drop table if exists t1, t9 ;
24
drop table if exists t9;
26
# The used table type doesn't support BLOB/TEXT columns.
27
# (The server would send error 1163 .)
28
# So we use char(100) instead.
31
c1 tinyint, c2 smallint, c3 mediumint, c4 int,
32
c5 integer, c6 bigint, c7 float, c8 double,
33
c9 double precision, c10 real, c11 decimal(7, 4), c12 numeric(8, 4),
34
c13 date, c14 datetime, c15 timestamp, c16 time,
35
c17 year, c18 tinyint, c19 bool, c20 char,
36
c21 char(10), c22 varchar(30), c23 varchar(100), c24 varchar(100),
37
c25 varchar(100), c26 varchar(100), c27 varchar(100), c28 varchar(100),
38
c29 varchar(100), c30 varchar(100), c31 enum('one', 'two', 'three'),
39
c32 set('monday', 'tuesday', 'wednesday'),
42
-- source include/ps_renew.inc
44
-- source include/ps_query.inc
45
-- source include/ps_modify.inc
46
-- source include/ps_modify1.inc
47
-- source include/ps_conv.inc