Skip to content

Commit a938f32

Browse files
committed
New depend code auto-drops sequence, fix copy2.out.
1 parent 1133342 commit a938f32

File tree

2 files changed

+0
-148
lines changed

2 files changed

+0
-148
lines changed

src/test/regress/expected/copy2.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -40,6 +40,5 @@ COPY x TO stdout;
4040
4 4 stuff test_4 after trigger fired
4141
5 5 stuff test_5 after trigger fired
4242
DROP TABLE x;
43-
DROP SEQUENCE x_a_seq;
4443
DROP FUNCTION fn_x_before();
4544
DROP FUNCTION fn_x_after();

src/test/regress/expected/select.out

Lines changed: 0 additions & 147 deletions
Original file line numberDiff line numberDiff line change
@@ -430,150 +430,3 @@ SELECT p.name, p.age FROM person* p ORDER BY age using >, name;
430430
mary | 8
431431
(58 rows)
432432

433-
--
434-
-- Test between syntax
435-
--
436-
SELECT 2 BETWEEN 1 AND 3;
437-
?column?
438-
----------
439-
t
440-
(1 row)
441-
442-
SELECT 2 BETWEEN 3 AND 1;
443-
?column?
444-
----------
445-
f
446-
(1 row)
447-
448-
SELECT 2 BETWEEN ASYMMETRIC 1 AND 3;
449-
?column?
450-
----------
451-
t
452-
(1 row)
453-
454-
SELECT 2 BETWEEN ASYMMETRIC 3 AND 1;
455-
?column?
456-
----------
457-
f
458-
(1 row)
459-
460-
SELECT 2 BETWEEN SYMMETRIC 1 AND 3;
461-
?column?
462-
----------
463-
t
464-
(1 row)
465-
466-
SELECT 2 BETWEEN SYMMETRIC 3 AND 1;
467-
?column?
468-
----------
469-
t
470-
(1 row)
471-
472-
SELECT 2 NOT BETWEEN 1 AND 3;
473-
?column?
474-
----------
475-
f
476-
(1 row)
477-
478-
SELECT 2 NOT BETWEEN 3 AND 1;
479-
?column?
480-
----------
481-
t
482-
(1 row)
483-
484-
SELECT 2 NOT BETWEEN ASYMMETRIC 1 AND 3;
485-
?column?
486-
----------
487-
f
488-
(1 row)
489-
490-
SELECT 2 NOT BETWEEN ASYMMETRIC 3 AND 1;
491-
?column?
492-
----------
493-
t
494-
(1 row)
495-
496-
SELECT 2 NOT BETWEEN SYMMETRIC 1 AND 3;
497-
?column?
498-
----------
499-
f
500-
(1 row)
501-
502-
SELECT 2 NOT BETWEEN SYMMETRIC 3 AND 1;
503-
?column?
504-
----------
505-
f
506-
(1 row)
507-
508-
SELECT -4 BETWEEN -1 AND -3;
509-
?column?
510-
----------
511-
f
512-
(1 row)
513-
514-
SELECT -4 BETWEEN -3 AND -1;
515-
?column?
516-
----------
517-
f
518-
(1 row)
519-
520-
SELECT -4 BETWEEN ASYMMETRIC -1 AND -3;
521-
?column?
522-
----------
523-
f
524-
(1 row)
525-
526-
SELECT -4 BETWEEN ASYMMETRIC -3 AND -1;
527-
?column?
528-
----------
529-
f
530-
(1 row)
531-
532-
SELECT -4 BETWEEN SYMMETRIC -1 AND -3;
533-
?column?
534-
----------
535-
f
536-
(1 row)
537-
538-
SELECT -4 BETWEEN SYMMETRIC -3 AND -1;
539-
?column?
540-
----------
541-
f
542-
(1 row)
543-
544-
SELECT -4 NOT BETWEEN -1 AND -3;
545-
?column?
546-
----------
547-
t
548-
(1 row)
549-
550-
SELECT -4 NOT BETWEEN -3 AND -1;
551-
?column?
552-
----------
553-
t
554-
(1 row)
555-
556-
SELECT -4 NOT BETWEEN ASYMMETRIC -1 AND -3;
557-
?column?
558-
----------
559-
t
560-
(1 row)
561-
562-
SELECT -4 NOT BETWEEN ASYMMETRIC -3 AND -1;
563-
?column?
564-
----------
565-
t
566-
(1 row)
567-
568-
SELECT -4 NOT BETWEEN SYMMETRIC -1 AND -3;
569-
?column?
570-
----------
571-
t
572-
(1 row)
573-
574-
SELECT -4 NOT BETWEEN SYMMETRIC -3 AND -1;
575-
?column?
576-
----------
577-
t
578-
(1 row)
579-

0 commit comments

Comments
 (0)