This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new b4d8ae5204 [test](jdbc)add new pg case from other source (#14445)
b4d8ae5204 is described below
commit b4d8ae52048a4345836b37669d2e23c9f8e45ca8
Author: lsy3993 <[email protected]>
AuthorDate: Thu Nov 24 16:35:59 2022 +0800
[test](jdbc)add new pg case from other source (#14445)
---
.../data/jdbc_p0/test_jdbc_query_pg.out | 274 +++++++++++++++++++++
.../suites/jdbc_p0/test_jdbc_query_pg.groovy | 167 +++++++++++++
2 files changed, 441 insertions(+)
diff --git a/regression-test/data/jdbc_p0/test_jdbc_query_pg.out
b/regression-test/data/jdbc_p0/test_jdbc_query_pg.out
index 141a790826..a78defa987 100644
--- a/regression-test/data/jdbc_p0/test_jdbc_query_pg.out
+++ b/regression-test/data/jdbc_p0/test_jdbc_query_pg.out
@@ -1063,3 +1063,277 @@ true abc
710078936338096128 13978385225 10000 1993-08-03T15:28:11 10000
1993-08-03T15:28:11 201 456678 1993-08-03T15:28:10 010-18741038
{"wTS": "1596439690", "rfId": "010-18741038", "remark": "数据", "weight": 70.404}
1596439690-010-18741038 70.40 数据 \N \N \N \N
2022-11-19T14:43:54 1993-08-03
710078936338096128 13987240259651987 10000 1993-08-03T15:48:46
10000 1993-08-03T15:48:46 201 456678 1993-08-03T15:48:45
010-18741032 {"wTS": "1596440925", "rfId": "010-18741032", "remark": "数据",
"weight": 118.863} 1596440925-010-18741032 118.86 数据 \N \N
\N \N 2022-11-19T14:43:54 1993-08-03
+-- !sql1 --
+1026
+
+-- !sql2 --
+1023
+
+-- !sql3 --
+3
+
+-- !sql4 --
+0
+
+-- !sql5 --
+1026
+
+-- !sql6 --
+1026
+
+-- !sql7 --
+1026
+
+-- !sql8 --
+1026
+
+-- !sql9 --
+9
+
+-- !sql10 --
+1026
+
+-- !sql11 --
+2
+
+-- !sql12 --
+false 479 1
+true 547 1
+
+-- !sql13 --
+abc
\N
+
+-- !sql14 --
+\N 343
+0 136
+
+-- !sql15 --
+1026 1
+
+-- !sql16 --
+1025
+
+-- !sql17 --
+1025
+
+-- !sql18 --
+984 984
+
+-- !sql19 --
+1025 2
+
+-- !sql20 --
+abc
def 1 524800
+
+-- !sql21 --
+abc
1 1025
+
+-- !sql22 --
+1025
+
+-- !sql23 --
+1024 1026 1
+
+-- !sql24 --
+2 1 511.5038986354776
+
+-- !sql25 --
+1025
+
+-- !sql26 --
+
+-- !sql27 --
+false
+
+-- !sql28 --
+0
+0
+
+-- !sql29 --
+0
+0
+
+-- !sql30 --
+1
+1
+
+-- !sql31 --
+123 2
+234 1
+
+-- !sql32 --
+\N 1
+2 1025
+
+-- !sql33 --
+124 125 126 127 128 129 130 131 132 133
2
+235 236 237 238 239 240 241 242 243 244
1
+
+-- !sql35 --
+\N \N
+abc 246
+
+-- !sql38 --
+3
+
+-- !sql39 --
+2 1020 2 1020
+2 1021 2 1021
+2 1022 2 1022
+2 1023 2 1023
+2 1024 2 1024
+
+-- !sql42 --
+
+-- !sql43 --
+true abc
def 2022-10-11 1.2339999675750732
1 2 0 2022-10-22T10:59:59 34.123 \N \N
+true abc
def 2022-10-11 1.2339999675750732
1 2 16 2022-10-22T10:59:59 34.123 \N \N
+true abc
def 2022-10-11 1.2339999675750732
1 2 24 2022-10-22T10:59:59 34.123 \N \N
+true abc
def 2022-10-11 1.2339999675750732
1 2 32 2022-10-22T10:59:59 34.123 \N \N
+true abc
def 2022-10-11 1.2339999675750732
1 2 8 2022-10-22T10:59:59 34.123 \N \N
+
+-- !sql44 --
+\N \N \N \N \N \N \N \N \N \N
123 abc
+\N \N \N \N \N \N \N \N \N \N
123 abc
+\N \N \N \N \N \N \N \N \N \N
234 bcd
+
+-- !sql45 --
+
+-- !sql46 --
+
+-- !sql47 --
+
+-- !sql48 --
+0 1 1028
+
+-- !sql49 --
+true abc
def 2022-10-11 1.2339999675750732
1 2 234 2022-10-22T10:59:59 34.123 234 bcd 1
+
+-- !sql50 --
+115
+
+-- !sql51 --
+true
+
+-- !sql52 --
+true
+
+-- !sql53 --
+\N
+
+-- !sql54 --
+3
+
+-- !sql55 --
+3075
+
+-- !sql56 --
+2
+3
+
+-- !sql57 --
+2
+
+-- !sql58 --
+1029
+
+-- !sql59 --
+0
+
+-- !sql60 --
+10
+
+-- !sql61 --
+25
+
+-- !sql62 --
+118
+118
+118
+
+-- !sql63 --
+1 2
+
+-- !sql65 --
+0
+1
+
+-- !sql66 --
+0
+1
+
+-- !sql67 --
+true abc
def 2022-10-11 1.2339999675750732
1 2 3 2022-10-22T10:59:59 34.123 true abc
def 2022-10-11 1.2339999675750732 1 2 0
2022-10-22T10:59:59 34.123
+true abc
def 2022-10-11 1.2339999675750732
1 2 3 2022-10-22T10:59:59 34.123 true abc
def 2022-10-11 1.2339999675750732 1 2 1
2022-10-22T10:59:59 34.123
+true abc
def 2022-10-11 1.2339999675750732
1 2 3 2022-10-22T10:59:59 34.123 true abc
def 2022-10-11 1.2339999675750732 1 2 2
2022-10-22T10:59:59 34.123
+true abc
def 2022-10-11 1.2339999675750732
1 2 3 2022-10-22T10:59:59 34.123 true abc
def 2022-10-11 1.2339999675750732 1 2 3
2022-10-22T10:59:59 34.123
+true abc
def 2022-10-11 1.2339999675750732
1 2 3 2022-10-22T10:59:59 34.123 true abc
def 2022-10-11 1.2339999675750732 1 2 3
2022-10-22T10:59:59 34.123
+
+-- !sql68 --
+123 2
+
+-- !sql70 --
+1 2
+
+-- !sql71 --
+0 2
+
+-- !sql72 --
+123
+123
+234
+
+-- !sql73 --
+
+-- !sql74 --
+1026
+
+-- !sql75 --
+0
+
+-- !sql76 --
+
+-- !sql77 --
+
+-- !sql78 --
+99
+
+-- !sql79 --
+1
+
+-- !sql80 --
+4
+96
+97
+98
+99
+
+-- !sql81 --
+6 3.0
+8 4.0
+
+-- !sql82 --
+1
+
+-- !sql83 --
+4
+96
+97
+98
+99
+
+-- !sql84 --
+\N \N
+
+-- !sql85 --
+1026
+
+-- !sql86 --
+0
+1
+2
+3
+4
+5
+6
+
diff --git a/regression-test/suites/jdbc_p0/test_jdbc_query_pg.groovy
b/regression-test/suites/jdbc_p0/test_jdbc_query_pg.groovy
index 73416fbc27..d664f62d70 100644
--- a/regression-test/suites/jdbc_p0/test_jdbc_query_pg.groovy
+++ b/regression-test/suites/jdbc_p0/test_jdbc_query_pg.groovy
@@ -397,6 +397,173 @@ suite("test_jdbc_query_pg", "p0") {
order_qt_sql """ select count(*) from $dorisInTable1;"""
order_qt_sql """ select * from $dorisInTable1 order by id limit 5; """
+
+ // test for aggregate
+ order_qt_sql1 """ SELECT COUNT(true) FROM $jdbcPg14Table1 """
+ order_qt_sql2 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE k7 < k8
"""
+ order_qt_sql3 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE NOT k7 <
k8 """
+ order_qt_sql4 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE NULL """
+ order_qt_sql5 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE
NULLIF(k2, 'F') IS NULL """
+ order_qt_sql6 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE
NULLIF(k2, 'F') IS NOT NULL """
+ order_qt_sql7 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE
NULLIF(k2, 'F') = k2 """
+ order_qt_sql8 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE
COALESCE(NULLIF(k2, 'abc'), 'abc') = 'abc' """
+ order_qt_sql9 """ SELECT COUNT(*) FROM $jdbcPg14Table1 WHERE k7 < k8
AND k8 > 30 AND k8 < 40 """
+ order_qt_sql10 """ SELECT COUNT(*) FROM (SELECT k1 FROM
$jdbcPg14Table1) x """
+ order_qt_sql11 """ SELECT COUNT(*) FROM (SELECT k1, COUNT(*) FROM
$jdbcPg14Table1 GROUP BY k1) x """
+ order_qt_sql12 """ SELECT k1, c, count(*) FROM (SELECT k1, count(*) c
FROM $jdbcPg14Table1 GROUP BY k1) as a GROUP BY k1, c """
+ order_qt_sql13 """ SELECT k2, sum(CAST(NULL AS BIGINT)) FROM
$jdbcPg14Table1 GROUP BY k2 """
+ order_qt_sql14 """ SELECT `key`, COUNT(*) as c FROM (
+ SELECT CASE WHEN k8 % 3 = 0 THEN NULL WHEN k8 % 5
= 0 THEN 0 ELSE k8 END AS `key`
+ FROM $jdbcPg14Table1) as a GROUP BY `key` order by
c desc limit 2"""
+ order_qt_sql15 """ SELECT lines, COUNT(*) as c FROM (SELECT k7,
COUNT(*) lines FROM $jdbcPg14Table1 GROUP BY k7) U GROUP BY lines order by c"""
+ order_qt_sql16 """ SELECT COUNT(DISTINCT k8 + 1) FROM $jdbcPg14Table1
"""
+ order_qt_sql17 """ SELECT COUNT(*) FROM (SELECT DISTINCT k8 + 1 FROM
$jdbcPg14Table1) t """
+ order_qt_sql18 """ SELECT COUNT(DISTINCT k8), COUNT(*) from
$jdbcPg14Table1 where k8 > 40 """
+ order_qt_sql19 """ SELECT COUNT(DISTINCT k8) AS count, k7 FROM
$jdbcPg14Table1 GROUP BY k7 ORDER BY count, k7 """
+ order_qt_sql20 """ SELECT k2, k3, COUNT(DISTINCT k5), SUM(DISTINCT k8)
FROM $jdbcPg14Table1 GROUP BY k2, k3 order by k2, k3 """
+ order_qt_sql21 """ SELECT k2, COUNT(DISTINCT k7), COUNT(DISTINCT k8)
FROM $jdbcPg14Table1 GROUP BY k2 """
+ order_qt_sql22 """ SELECT SUM(DISTINCT x) FROM (SELECT k7,
COUNT(DISTINCT k8) x FROM $jdbcPg14Table1 GROUP BY k7) t """
+ order_qt_sql23 """ SELECT max(k8), COUNT(k7), sum(DISTINCT k6) FROM
$jdbcPg14Table1 """
+ order_qt_sql24 """ SELECT s, MAX(k6), SUM(a) FROM (SELECT k6, avg(k8)
AS a, SUM(DISTINCT k7) AS s FROM $jdbcPg14Table1 GROUP BY k6) as b group by
s"""
+ order_qt_sql25 """ SELECT COUNT(DISTINCT k8) FROM $jdbcPg14Table1
WHERE LENGTH(k2) > 2 """
+ sql """ drop table if exists $dorisExTable2 """
+ sql """
+ CREATE EXTERNAL TABLE `$dorisExTable2` (
+ `id` int NULL COMMENT "",
+ `name` varchar(20) NULL COMMENT ""
+ ) ENGINE=JDBC
+ PROPERTIES (
+ "resource" = "$jdbcResourcePg14",
+ "table" = "test3",
+ "table_type"="postgresql"
+ );
+ """
+ order_qt_sql26 """
+ SELECT max(id), min(id), count(id) + 1, count(id)
+ FROM (SELECT DISTINCT k8 FROM $jdbcPg14Table1) AS r1
+ LEFT JOIN ${dorisExTable2} as a ON r1.k8 = a.id GROUP
BY r1.k8
+ HAVING sum(id) < 110 """
+ order_qt_sql27 """ SELECT id BETWEEN 110 AND 115 from $dorisExTable2
GROUP BY id BETWEEN 110 AND 115; """
+ order_qt_sql28 """ SELECT CAST(id BETWEEN 1 AND 120 AS BIGINT) FROM
$dorisExTable2 GROUP BY id """
+ order_qt_sql29 """ SELECT CAST(50 BETWEEN id AND 120 AS BIGINT) FROM
$dorisExTable2 GROUP BY id """
+ order_qt_sql30 """ SELECT CAST(50 BETWEEN 1 AND id AS BIGINT) FROM
$dorisExTable2 GROUP BY id """
+ order_qt_sql31 """ SELECT CAST(id AS VARCHAR) as a, count(*) FROM
$dorisExTable2 GROUP BY CAST(id AS VARCHAR) order by a """
+ order_qt_sql32 """ SELECT NULLIF(k7, k8), count(*) as c FROM
$jdbcPg14Table1 GROUP BY NULLIF(k7, k8) order by c desc"""
+ order_qt_sql33 """ SELECT id + 1, id + 2, id + 3, id + 4, id + 5, id +
6, id + 7,id + 8, id + 9, id + 10, COUNT(*) AS c
+ FROM $dorisExTable2 GROUP BY id + 1, id + 2, id +
3, id + 4, id + 5, id + 6, id + 7,id + 8, id + 9, id + 10
+ ORDER BY c desc """
+ order_qt_sql35 """
+ SELECT name,SUM(CAST(id AS BIGINT))
+ FROM $dorisExTable2
+ WHERE name = 'abc'
+ GROUP BY name
+ UNION
+ SELECT NULL, SUM(CAST(id AS BIGINT))
+ FROM $dorisExTable2
+ WHERE name = 'abd' """
+
+
+ // test for distribute queries
+ sql """ drop table if exists $dorisExTable1 """
+ sql """
+ CREATE EXTERNAL TABLE `$dorisExTable1` (
+ `id` int NULL COMMENT "",
+ `name` varchar(20) NULL COMMENT ""
+ ) ENGINE=JDBC
+ PROPERTIES (
+ "resource" = "$jdbcResourcePg14",
+ "table" = "test3",
+ "table_type"="postgresql"
+ );
+ """
+ order_qt_sql38 """ SELECT count(*) FROM ${dorisExTable1} WHERE id IN
(SELECT k8 FROM $jdbcPg14Table1 WHERE k8 > 111); """
+ sql """ create view if not exists aview as select k7, k8 from
$jdbcPg14Table1; """
+ order_qt_sql39 """ SELECT * FROM aview a JOIN aview b on a.k8 = b.k8
order by a.k8 desc limit 5 """
+ order_qt_sql42 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l JOIN ${dorisExTable1} o ON l.k8 = o.id """
+ order_qt_sql43 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l LEFT JOIN ${dorisExTable1} o ON l.k8 = o.id order by k8 limit 5"""
+ order_qt_sql44 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l RIGHT JOIN ${dorisExTable1} o ON l.k8 = o.id"""
+ order_qt_sql45 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l JOIN
+ (SELECT id, COUNT(*) FROM ${dorisExTable1} WHERE
id > 111 GROUP BY id ORDER BY id) o ON l.k8 = o.id """
+ order_qt_sql46 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 8 = 0) l JOIN ${dorisExTable1} o ON l.k8 = o.id + 1"""
+ order_qt_sql47 """ SELECT * FROM (
+ SELECT k8 % 120 AS a, k8 % 3 AS b
+ FROM $jdbcPg14Table1) l JOIN
+ (SELECT t1.a AS a, SUM(t1.b) AS b,
SUM(LENGTH(t2.name)) % 3 AS d
+ FROM ( SELECT id AS a, id % 3 AS b FROM
${dorisExTable1}) t1
+ JOIN ${dorisExTable1} t2 ON t1.a = t2.id GROUP BY
t1.a) o
+ ON l.b = o.d AND l.a = o.a order by l.a desc limit
3"""
+ order_qt_sql48 """ SELECT x, y, COUNT(*) as c FROM (SELECT k8, 0 AS x
FROM $jdbcPg14Table1) a
+ JOIN (SELECT k8, 1 AS y FROM $jdbcPg14Table1) b ON
a.k8 = b.k8 group by x, y order by c desc limit 3 """
+ order_qt_sql49 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 WHERE
k8 % 120 > 110) l
+ JOIN (SELECT *, COUNT(1) OVER (PARTITION BY id
ORDER BY id) FROM ${dorisExTable1}) o ON l.k8 = o.id """
+ order_qt_sql50 """ SELECT COUNT(*) FROM $jdbcPg14Table1 as a LEFT
OUTER JOIN ${dorisExTable1} as b ON a.k8 = b.id AND a.k8 > 111 WHERE a.k8 < 114
"""
+ order_qt_sql51 """ SELECT count(*) > 0 FROM $jdbcPg14Table1 JOIN
${dorisExTable1} ON (cast(1.2 AS FLOAT) = CAST(1.2 AS decimal(2,1))) """
+ order_qt_sql52 """ SELECT count(*) > 0 FROM $jdbcPg14Table1 JOIN
${dorisExTable1} ON CAST((CASE WHEN (TRUE IS NOT NULL) THEN '1.2' ELSE '1.2'
END) AS FLOAT) = CAST(1.2 AS decimal(2,1)) """
+ order_qt_sql53 """ SELECT SUM(k8) FROM $jdbcPg14Table1 as a JOIN
${dorisExTable1} as b ON a.k8 = CASE WHEN b.id % 2 = 0 and b.name = 'abc' THEN
b.id ELSE NULL END """
+ order_qt_sql54 """ SELECT COUNT(*) FROM $jdbcPg14Table1 a JOIN
${dorisExTable1} b on not (a.k8 <> b.id) """
+ order_qt_sql55 """ SELECT COUNT(*) FROM $jdbcPg14Table1 a JOIN
${dorisExTable1} b on not not not (a.k8 = b.id) """
+ order_qt_sql56 """ SELECT x + y FROM (
+ SELECT id, COUNT(*) x FROM ${dorisExTable1} GROUP
BY id) a JOIN
+ (SELECT k8, COUNT(*) y FROM $jdbcPg14Table1 GROUP
BY k8) b ON a.id = b.k8 """
+ order_qt_sql57 """ SELECT COUNT(*) FROM ${dorisExTable1} as a JOIN
$jdbcPg14Table1 as b ON a.id = b.k8 AND a.name LIKE '%ab%' """
+ order_qt_sql58 """
+ SELECT COUNT(*) FROM
+ (SELECT a.k8 AS o1, b.id AS o2 FROM $jdbcPg14Table1 as
a LEFT OUTER JOIN ${dorisExTable1} as b
+ ON a.k8 = b.id AND b.id < 114
+ UNION ALL
+ SELECT a.k8 AS o1, b.id AS o2 FROM $jdbcPg14Table1 as
a RIGHT OUTER JOIN ${dorisExTable1} as b
+ ON a.k8 = b.id AND b.id < 114 WHERE a.k8 IS NULL) as t1
+ WHERE o1 IS NULL OR o2 IS NULL """
+ order_qt_sql59 """ SELECT COUNT(*) FROM $jdbcPg14Table1 as a JOIN
${dorisExTable1} as b ON a.k8 = 112 AND b.id = 112 """
+ order_qt_sql60 """ WITH x AS (SELECT DISTINCT k8 FROM $jdbcPg14Table1
ORDER BY k8 LIMIT 10)
+ SELECT count(*) FROM x a JOIN x b on a.k8 = b.k8
"""
+ order_qt_sql61 """ SELECT COUNT(*) FROM (SELECT * FROM $jdbcPg14Table1
ORDER BY k8 desc LIMIT 5) a
+ CROSS JOIN (SELECT * FROM $jdbcPg14Table1 ORDER BY
k8 desc LIMIT 5) b """
+ order_qt_sql62 """ SELECT a.k8 FROM (SELECT * FROM $jdbcPg14Table1
WHERE k8 < 119) a
+ CROSS JOIN (SELECT * FROM $jdbcPg14Table1 WHERE k8
> 100) b order by a.k8 desc limit 3"""
+ order_qt_sql63 """ SELECT * FROM (SELECT 1 a) x CROSS JOIN (SELECT 2
b) y """
+ order_qt_sql65 """ SELECT t.c FROM (SELECT 1) as t1 CROSS JOIN (SELECT
0 AS c UNION ALL SELECT 1) t """
+ order_qt_sql66 """ SELECT t.c FROM (SELECT 1) as a CROSS JOIN (SELECT
0 AS c UNION ALL SELECT 1) t """
+ order_qt_sql67 """ SELECT * FROM (SELECT * FROM $jdbcPg14Table1 ORDER
BY k8 LIMIT 5) a
+ JOIN (SELECT * FROM $jdbcPg14Table1 ORDER BY k8
LIMIT 5) b ON 123 = 123
+ order by a.k8 desc limit 5"""
+ order_qt_sql68 """ SELECT id, count(1) as c FROM $dorisExTable1 GROUP
BY id
+ HAVING c IN (select k8 from $jdbcPg14Table1 where
k8 = 2) """
+
+
+ // test for order by
+ order_qt_sql70 """ WITH t AS (SELECT 1 x, 2 y) SELECT x, y FROM t
ORDER BY x, y """
+ order_qt_sql71 """ WITH t AS (SELECT k8 x, k7 y FROM $jdbcPg14Table1)
SELECT x, y FROM t ORDER BY x, y LIMIT 1 """
+ order_qt_sql72 """ SELECT id X FROM ${dorisExTable1} ORDER BY x """
+
+
+ // test for queries
+ order_qt_sql73 """ SELECT k7, k8 FROM $jdbcPg14Table1 LIMIT 0 """
+ order_qt_sql74 """ SELECT COUNT(k8) FROM $jdbcPg14Table1 """
+ order_qt_sql75 """ SELECT COUNT(CAST(NULL AS BIGINT)) FROM
$jdbcPg14Table1 """
+ order_qt_sql76 """ SELECT k8 FROM $jdbcPg14Table1 WHERE k8 < 120
INTERSECT SELECT id as k8 FROM ${dorisExTable1} """
+ order_qt_sql77 """ SELECT k8 FROM $jdbcPg14Table1 WHERE k8 < 120
INTERSECT DISTINCT SELECT id as k8 FROM ${dorisExTable1} """
+ order_qt_sql78 """ WITH wnation AS (SELECT k7, k8 FROM
$jdbcPg14Table1)
+ SELECT k8 FROM wnation WHERE k8 < 100
+ INTERSECT SELECT k8 FROM wnation WHERE k8 > 98 """
+ order_qt_sql79 """ SELECT num FROM (SELECT 1 AS num FROM
$jdbcPg14Table1 WHERE k8=10
+ INTERSECT SELECT 1 FROM $jdbcPg14Table1 WHERE
k8=20) T """
+ order_qt_sql80 """ SELECT k8 FROM (SELECT k8 FROM $jdbcPg14Table1
WHERE k8 < 100
+ INTERSECT SELECT k8 FROM $jdbcPg14Table1 WHERE k8
> 95) as t1
+ UNION SELECT 4 """
+ order_qt_sql81 """ SELECT k8, k8 / 2 FROM (SELECT k8 FROM
$jdbcPg14Table1 WHERE k8 < 10
+ INTERSECT SELECT k8 FROM $jdbcPg14Table1 WHERE k8
> 4) T WHERE k8 % 2 = 0 order by k8 limit 3 """
+ order_qt_sql82 """ SELECT k8 FROM (SELECT k8 FROM $jdbcPg14Table1
WHERE k8 < 7
+ UNION SELECT k8 FROM $jdbcPg14Table1 WHERE k8 >
21) as t1
+ INTERSECT SELECT 1 """
+ order_qt_sql83 """ SELECT k8 FROM (SELECT k8 FROM $jdbcPg14Table1
WHERE k8 < 100
+ INTERSECT SELECT k8 FROM $jdbcPg14Table1 WHERE k8
> 95) as t1
+ UNION ALL SELECT 4 """
+ order_qt_sql84 """ SELECT NULL, NULL INTERSECT SELECT NULL, NULL FROM
$jdbcPg14Table1 """
+ order_qt_sql85 """ SELECT COUNT(*) FROM $jdbcPg14Table1 INTERSECT
SELECT COUNT(k8) FROM $jdbcPg14Table1 HAVING SUM(k7) IS NOT NULL """
+ order_qt_sql86 """ SELECT k8 FROM $jdbcPg14Table1 WHERE k8 < 7 EXCEPT
SELECT k8 FROM $jdbcPg14Table1 WHERE k8 > 21 """
+
+
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
