Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_from.result

raw
1 DROP TABLE IF EXISTS t1;
2 DROP TABLE IF EXISTS t2;
3 CREATE TABLE t1 (c1 INT, c2 CHAR(100),c3 FLOAT);
4 INSERT INTO t1 VALUES (null,null,0.0);
5 INSERT INTO t1 VALUES (1,'',1.0);
6 INSERT INTO t1 VALUES (2,'abcde',2.0);
7 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
8 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
9 INSERT INTO t2 VALUES (1,'abcde');
10 INSERT INTO t2 VALUES (2,'abcde');
11 SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
12 FROM t1) AS sb WHERE sb1 > 1;
13 sb1 sb2 sb3
14 2 abcde 4
15 100 abcdefghij 6
16 SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
17 GROUP BY c1) AS t1;
18 AVG(sum_column1)
19 34.3333
20 DROP TABLE t1;
21 DROP TABLE t2;
22 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100),c3 FLOAT);
23 INSERT INTO t1 VALUES (null,null,0.0);
24 INSERT INTO t1 VALUES (1,'',1.0);
25 INSERT INTO t1 VALUES (2,'abcde',2.0);
26 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
27 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
28 INSERT INTO t2 VALUES (1,'abcde');
29 INSERT INTO t2 VALUES (2,'abcde');
30 SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
31 FROM t1) AS sb WHERE sb1 > 1;
32 sb1 sb2 sb3
33 2 abcde 4
34 100 abcdefghij 6
35 SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
36 GROUP BY c1) AS t1;
37 AVG(sum_column1)
38 34.3333
39 DROP TABLE t1;
40 DROP TABLE t2;
41 CREATE TABLE t1 (c1 INT, c2 BINARY(100),c3 FLOAT);
42 INSERT INTO t1 VALUES (null,null,0.0);
43 INSERT INTO t1 VALUES (1,'',1.0);
44 INSERT INTO t1 VALUES (2,'abcde',2.0);
45 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
46 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
47 INSERT INTO t2 VALUES (1,'abcde');
48 INSERT INTO t2 VALUES (2,'abcde');
49 SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
50 FROM t1) AS sb WHERE sb1 > 1;
51 sb1 sb2 sb3
52 2 abcde 4
53 100 abcdefghij 6
54 SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
55 GROUP BY c1) AS t1;
56 AVG(sum_column1)
57 34.3333
58 DROP TABLE t1;
59 DROP TABLE t2;
60 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100),c3 FLOAT);
61 INSERT INTO t1 VALUES (null,null,0.0);
62 INSERT INTO t1 VALUES (1,'',1.0);
63 INSERT INTO t1 VALUES (2,'abcde',2.0);
64 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
65 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
66 INSERT INTO t2 VALUES (1,'abcde');
67 INSERT INTO t2 VALUES (2,'abcde');
68 SELECT sb1,sb2,sb3 FROM (SELECT c1 AS sb1, c2 AS sb2, c3*2 AS sb3
69 FROM t1) AS sb WHERE sb1 > 1;
70 sb1 sb2 sb3
71 2 abcde 4
72 100 abcdefghij 6
73 SELECT AVG(sum_column1) FROM (SELECT SUM(c1) AS sum_column1 FROM t1
74 GROUP BY c1) AS t1;
75 AVG(sum_column1)
76 34.3333
77 DROP TABLE t1;
78 DROP TABLE t2;