| /dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/ |
| H A D | privileges.sql | 85 atest1;
93 atest1
110 atest1;
119 atest1;
144 atest1;
170 atest1
186 atest1
215 atest1
267 atest1
291 atest1
[all …]
|
| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
104 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
108 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
272 SELECT atest1.* FROM atest1, atest5; -- ok
273 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
274 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/ |
| H A D | privileges.sql | 48 SELECT * FROM atest1;
50 DELETE FROM atest1;
52 TRUNCATE atest1;
58 SELECT * FROM atest1;
80 INSERT INTO atest1 SELECT 1, b FROM atest1; -- ok
105 INSERT INTO atest1 SELECT 1, b FROM atest1; -- fail
109 UPDATE atest2 SET col2 = true FROM atest1 WHERE atest1.a = 5; -- ok
303 SELECT atest1.* FROM atest1, atest5; -- ok
304 SELECT atest1.*,atest5.one FROM atest1, atest5; -- ok
305 SELECT atest1.*,atest5.one FROM atest1 JOIN atest5 ON (atest1.a = atest5.two); -- fail
[all …]
|