Debian Codegraph @

mysql-test/suite/x/t/result_types.test

raw
1 ## generated
2 ## Test resultset types
3
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 ## Test starts here
8
9 --write_file $MYSQL_TMP_DIR/result_types_float.xpl
10 # test float and double
11 USE xtest;
12 CREATE TABLE test_float (f FLOAT, d DOUBLE);
13
14 INSERT INTO test_float VALUES (1.0/81, 1.0/81);
15 INSERT INTO test_float VALUES (1234567890.1234567890,1234567890.1234567890);
16
17 SELECT * FROM test_float;
18 EOF
19
20 --write_file $MYSQL_TMP_DIR/result_types_unsigned.xpl
21 USE xtest;
22 CREATE TABLE test_unsigned (i INT UNSIGNED, b BIGINT UNSIGNED, t TINYINT UNSIGNED, s SMALLINT UNSIGNED, f FLOAT UNSIGNED, d DOUBLE UNSIGNED, de DECIMAL(10,2) UNSIGNED, dt DATETIME, ts TIMESTAMP);
23
24 Mysqlx.Sql.StmtExecute {
25 stmt: "SELECT * FROM test_unsigned"
26 }
27 -->recvuntil Mysqlx.Sql.StmtExecuteOk
28 EOF
29
30 --write_file $MYSQL_TMP_DIR/result_types_set.xpl
31 USE xtest;
32 CREATE TABLE test_set (s SET('one','two','three','four','five','six','seven','eight','nine','ten','eleven','twelve','thirteen','fourteen','fifteen','sixteen','seventeen','eightteen','nineteen','twenty','thirty','forty','fifty','sixty','seventy','eightty','ninety'));
33
34 INSERT INTO test_set VALUES ('one,two');
35 INSERT INTO test_set VALUES ('one,two,three,four,five,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fifteen,sixteen,seventeen,eightteen,nineteen');
36 INSERT INTO test_set VALUES ('one,two,three,four,five,six,seven,eight,nine,ten,eleven,twelve,thirteen,fourteen,fifteen,sixteen,seventeen,eightteen,nineteen,twenty,thirty,forty,fifty,sixty,seventy,eightty,ninety');
37
38 SELECT * FROM test_set;
39 EOF
40
41 CREATE SCHEMA xtest;
42
43 exec $MYSQLXTEST
44 -ux_root --password=''
45 --file=$MYSQL_TMP_DIR/result_types_float.xpl 2>&1;
46
47 exec $MYSQLXTEST
48 -ux_root --password=''
49 --file=$MYSQL_TMP_DIR/result_types_unsigned.xpl 2>&1;
50
51 exec $MYSQLXTEST
52 -ux_root --password=''
53 --file=$MYSQL_TMP_DIR/result_types_set.xpl 2>&1;
54
55 ## Cleanup
56 --source ../include/xplugin_cleanup.inc