Home
last modified time | relevance | path

Searched refs:tt1 (Results 101 – 125 of 2505) sorted by relevance

12345678910>>...101

/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql96-docs/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_view.sql241 CREATE VIEW tt1 AS view
247 \d+ tt1
248 SELECT * FROM tt1;
249 SELECT a::varchar(3) FROM tt1;
250 DROP VIEW tt1;
259 select * from tt1
262 select * from tt1 a1
265 select * from tt1
269 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
283 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql96-client/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_view.sql241 CREATE VIEW tt1 AS view
247 \d+ tt1
248 SELECT * FROM tt1;
249 SELECT a::varchar(3) FROM tt1;
250 DROP VIEW tt1;
259 select * from tt1
262 select * from tt1 a1
265 select * from tt1
269 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
283 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql96-contrib/postgresql-9.6.24/src/test/regress/sql/
H A Dcreate_view.sql241 CREATE VIEW tt1 AS view
247 \d+ tt1
248 SELECT * FROM tt1;
249 SELECT a::varchar(3) FROM tt1;
250 DROP VIEW tt1;
259 select * from tt1
262 select * from tt1 a1
265 select * from tt1
269 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
283 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/
H A Dcreate_view.sql249 CREATE VIEW tt1 AS view
255 \d+ tt1
256 SELECT * FROM tt1;
257 SELECT a::varchar(3) FROM tt1;
258 DROP VIEW tt1;
267 select * from tt1
270 select * from tt1 a1
273 select * from tt1
277 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
291 ALTER TABLE tt1 RENAME TO a2;
[all …]
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/ndbcluster/
H A Dtemp_tables.result10 CREATE TEMPORARY TABLE tt1 AS SELECT * FROM t1;
11 SHOW CREATE TABLE tt1;
13 tt1 CREATE TEMPORARY TABLE `tt1` (
19 CREATE TEMPORARY TABLE tt1 LIKE t1;
24 CREATE TEMPORARY TABLE tt1 LIKE t1;
29 CREATE TEMPORARY TABLE tt1 LIKE t1;
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_view.out308 \d+ tt1
353 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
364 tt1.f3
396 tt1.f3
412 tt1.f3
429 tt1.f3
461 tt1.f3
477 tt1.f3
542 tt1.f3
607 tt1.f3
[all …]
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_view.out308 \d+ tt1
353 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
364 tt1.f3
396 tt1.f3
412 tt1.f3
429 tt1.f3
461 tt1.f3
477 tt1.f3
542 tt1.f3
607 tt1.f3
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_view.out308 \d+ tt1
353 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
364 tt1.f3
396 tt1.f3
412 tt1.f3
429 tt1.f3
461 tt1.f3
477 tt1.f3
542 tt1.f3
607 tt1.f3
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/expected/
H A Dcreate_view.out308 \d+ tt1
353 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
364 tt1.f3
396 tt1.f3
412 tt1.f3
429 tt1.f3
461 tt1.f3
477 tt1.f3
542 tt1.f3
607 tt1.f3
[all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/expected/
H A Dcreate_view.out334 \d+ tt1
379 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
390 tt1.f3
422 tt1.f3
438 tt1.f3
455 tt1.f3
487 tt1.f3
503 tt1.f3
568 tt1.f3
633 tt1.f3
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/expected/
H A Dcreate_view.out334 \d+ tt1
379 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
390 tt1.f3
422 tt1.f3
438 tt1.f3
455 tt1.f3
487 tt1.f3
503 tt1.f3
568 tt1.f3
633 tt1.f3
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/expected/
H A Dcreate_view.out334 \d+ tt1
379 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
390 tt1.f3
422 tt1.f3
438 tt1.f3
455 tt1.f3
487 tt1.f3
503 tt1.f3
568 tt1.f3
633 tt1.f3
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/expected/
H A Dcreate_view.out334 \d+ tt1
379 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
390 tt1.f3
422 tt1.f3
438 tt1.f3
455 tt1.f3
487 tt1.f3
503 tt1.f3
568 tt1.f3
633 tt1.f3
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/expected/
H A Dcreate_view.out334 \d+ tt1
379 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
390 tt1.f3
422 tt1.f3
438 tt1.f3
455 tt1.f3
487 tt1.f3
503 tt1.f3
568 tt1.f3
633 tt1.f3
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/expected/
H A Dcreate_view.out334 \d+ tt1
379 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
390 tt1.f3
422 tt1.f3
438 tt1.f3
455 tt1.f3
487 tt1.f3
503 tt1.f3
568 tt1.f3
633 tt1.f3
[all …]

12345678910>>...101