Debian Codegraph @

mysql-test/suite/test_services/r/test_mysql_command_services_component.result

raw
1 INSTALL COMPONENT "file://component_test_mysql_command_services";
2 # Test : sending no arguments.
3 SELECT test_mysql_command_services_udf();
4 test_mysql_command_services_udf()
5 NULL
6 # Test : should return '2' the output of SELECT 1+1;
7 SELECT test_mysql_command_services_udf("select 1+1");
8 test_mysql_command_services_udf("select 1+1")
9 2
10 # Test : should return '2.5' the output of SELECT 1.3+1.2;
11 SELECT test_mysql_command_services_udf("select 1.3+1.2");
12 test_mysql_command_services_udf("select 1.3+1.2")
13 2.5
14 # Test : should return TIMESTAMP
15 SELECT test_mysql_command_services_udf("SELECT TIMESTAMP('2003-12-31')");
16 test_mysql_command_services_udf("SELECT TIMESTAMP('2003-12-31')")
17 2003-12-31 00:00:00
18 # Test : should return DATE
19 SELECT test_mysql_command_services_udf("SELECT FROM_DAYS(730669)");
20 test_mysql_command_services_udf("SELECT FROM_DAYS(730669)")
21 2000-07-03
22 # Test : should return TIME
23 SELECT test_mysql_command_services_udf("SELECT CURTIME()");
24 CREATE TABLE test.t1 (c1 int, c2 char(13));
25 INSERT INTO test.t1 VALUES (1, "foo"), (2, "bar"), (3, "zap");
26 SELECT * FROM test.t1;
27 c1 c2
28 1 foo
29 2 bar
30 3 zap
31 SELECT test_mysql_command_services_udf("SELECT * FROM test.t1");
32 test_mysql_command_services_udf("SELECT * FROM test.t1")
33 1foo2bar3zap
34 CREATE TABLE test.t2 (c1 int, c2 float);
35 INSERT INTO test.t2 VALUES (1, 1.1), (2, 2.2), (3, 3.3);
36 SELECT * FROM test.t2;
37 c1 c2
38 1 1.1
39 2 2.2
40 3 3.3
41 SELECT test_mysql_command_services_udf("SELECT * FROM test.t2");
42 test_mysql_command_services_udf("SELECT * FROM test.t2")
43 11.122.233.3
44 CREATE TABLE test.t3 (c1 int, c2 double);
45 INSERT INTO test.t3 VALUES (1, 1.11), (2, 2.22), (3, 3.33);
46 SELECT * FROM test.t3;
47 c1 c2
48 1 1.11
49 2 2.22
50 3 3.33
51 SELECT test_mysql_command_services_udf("SELECT * FROM test.t3");
52 test_mysql_command_services_udf("SELECT * FROM test.t3")
53 11.1122.2233.33
54 CREATE TABLE test.t4 (c1 int, c2 decimal(5,3));
55 INSERT INTO test.t4 VALUES (1, 1.111), (2, 2.222), (3, 3.333);
56 SELECT * FROM test.t4;
57 c1 c2
58 1 1.111
59 2 2.222
60 3 3.333
61 SELECT test_mysql_command_services_udf("SELECT * FROM test.t4");
62 test_mysql_command_services_udf("SELECT * FROM test.t4")
63 11.11122.22233.333
64 The output is truncated to MAX_FIELD_WIDTH size, this is
65 because the udf buffer is of that size.
66 CREATE TABLE test.t5 (c1 int, c2 varchar(1000));
67 INSERT INTO test.t5 VALUES (1, repeat('a',1000));
68 SELECT * FROM test.t5;
69 c1 c2
70 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
71 SELECT test_mysql_command_services_udf("SELECT * FROM test.t5");
72 test_mysql_command_services_udf("SELECT * FROM test.t5")
73 1aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
74 # Test : should return error message
75 SELECT test_mysql_command_services_udf("SELECT * FROM mysql.plugin ORDER BY name");
76 ERROR HY000: Error in command service backend interface, because of : "SELECT command denied to user 'mysql.session'@'localhost' for table 'plugin'"
77 # Test : should return error message BUG#34035897
78 SELECT test_mysql_command_services_udf("SELECT * FROM information_schema.innodb_tables");
79 ERROR HY000: Error in command service backend interface, because of : "Access denied; you need (at least one of) the PROCESS privilege(s) for this operation"
80 SELECT test_mysql_command_services_udf("SELECT * FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY");
81 # Test : should return NULL field value if exits BUG#34026180
82 CREATE TABLE test.t6(c1 int, c2 text);
83 INSERT INTO test.t6 VALUES(1, 'FOO');
84 SELECT test_mysql_command_services_udf("INSERT INTO test.t6(c2) VALUES('BAR')");
85 test_mysql_command_services_udf("INSERT INTO test.t6(c2) VALUES('BAR')")
86
87 SELECT test_mysql_command_services_udf("SELECT c1,c2 FROM test.t6");
88 test_mysql_command_services_udf("SELECT c1,c2 FROM test.t6")
89 1FOONULLBAR
90 # Test: reusing the same connection to run several queries should not crash
91 SELECT test_mysql_command_services_udf("SELECT 1");
92 test_mysql_command_services_udf("SELECT 1")
93 1
94 SELECT test_mysql_command_services_udf("SELECT 1", 2);
95 test_mysql_command_services_udf("SELECT 1", 2)
96 1
97 SELECT test_mysql_command_services_apis_udf();
98 test_mysql_command_services_apis_udf()
99 10mysql-1
100 SELECT test_mysql_command_services_apis_udf("SELECT 1+1");
101 test_mysql_command_services_apis_udf("SELECT 1+1")
102 NULL
103 The test.my_demo_transaction table is created inside above udf function
104 DROP TABLE test.my_demo_transaction;
105 DROP TABLE t1;
106 DROP TABLE t2;
107 DROP TABLE t3;
108 DROP TABLE t4;
109 DROP TABLE t5;
110 DROP TABLE t6;
111 UNINSTALL COMPONENT "file://component_test_mysql_command_services";