Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit7b71c50

Browse files
pashkinelfeMaxim Orlov
authored and
Maxim Orlov
committed
Add test for partial order query
1 parent2dd3840 commit7b71c50

File tree

3 files changed

+257
-0
lines changed

3 files changed

+257
-0
lines changed

‎expected/altorder.out

Lines changed: 127 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -432,3 +432,130 @@ SELECT id, d FROM atsts WHERE t @@ 'wr&qh' AND d >= '2016-05-16 14:21:25' ORDER
432432
496 | Sun May 22 11:21:22.326724 2016
433433
(32 rows)
434434

435+
EXPLAIN (costs off)
436+
SELECT id, d FROM atsts WHERE t @@ 'wr&q:*' AND d >= '2016-05-16 14:21:25' ORDER BY d;
437+
QUERY PLAN
438+
-----------------------------------------------------------------------------------------------------------------------------
439+
Sort
440+
Sort Key: d
441+
-> Index Scan using atsts_idx on atsts
442+
Index Cond: ((t @@ '''wr'' & ''q'':*'::tsquery) AND (d >= 'Mon May 16 14:21:25 2016'::timestamp without time zone))
443+
(4 rows)
444+
445+
SELECT id, d FROM atsts WHERE t @@ 'wr&q:*' AND d >= '2016-05-16 14:21:25' ORDER BY d;
446+
id | d
447+
-----+---------------------------------
448+
361 | Mon May 16 20:21:22.326724 2016
449+
361 | Mon May 16 20:21:22.326724 2016
450+
361 | Mon May 16 20:21:22.326724 2016
451+
361 | Mon May 16 20:21:22.326724 2016
452+
369 | Tue May 17 04:21:22.326724 2016
453+
369 | Tue May 17 04:21:22.326724 2016
454+
369 | Tue May 17 04:21:22.326724 2016
455+
369 | Tue May 17 04:21:22.326724 2016
456+
371 | Tue May 17 06:21:22.326724 2016
457+
371 | Tue May 17 06:21:22.326724 2016
458+
371 | Tue May 17 06:21:22.326724 2016
459+
371 | Tue May 17 06:21:22.326724 2016
460+
372 | Tue May 17 07:21:22.326724 2016
461+
372 | Tue May 17 07:21:22.326724 2016
462+
372 | Tue May 17 07:21:22.326724 2016
463+
372 | Tue May 17 07:21:22.326724 2016
464+
375 | Tue May 17 10:21:22.326724 2016
465+
375 | Tue May 17 10:21:22.326724 2016
466+
375 | Tue May 17 10:21:22.326724 2016
467+
375 | Tue May 17 10:21:22.326724 2016
468+
388 | Tue May 17 23:21:22.326724 2016
469+
388 | Tue May 17 23:21:22.326724 2016
470+
388 | Tue May 17 23:21:22.326724 2016
471+
388 | Tue May 17 23:21:22.326724 2016
472+
405 | Wed May 18 16:21:22.326724 2016
473+
405 | Wed May 18 16:21:22.326724 2016
474+
405 | Wed May 18 16:21:22.326724 2016
475+
405 | Wed May 18 16:21:22.326724 2016
476+
406 | Wed May 18 17:21:22.326724 2016
477+
406 | Wed May 18 17:21:22.326724 2016
478+
406 | Wed May 18 17:21:22.326724 2016
479+
406 | Wed May 18 17:21:22.326724 2016
480+
415 | Thu May 19 02:21:22.326724 2016
481+
415 | Thu May 19 02:21:22.326724 2016
482+
415 | Thu May 19 02:21:22.326724 2016
483+
415 | Thu May 19 02:21:22.326724 2016
484+
422 | Thu May 19 09:21:22.326724 2016
485+
422 | Thu May 19 09:21:22.326724 2016
486+
422 | Thu May 19 09:21:22.326724 2016
487+
422 | Thu May 19 09:21:22.326724 2016
488+
428 | Thu May 19 15:21:22.326724 2016
489+
428 | Thu May 19 15:21:22.326724 2016
490+
428 | Thu May 19 15:21:22.326724 2016
491+
428 | Thu May 19 15:21:22.326724 2016
492+
441 | Fri May 20 04:21:22.326724 2016
493+
441 | Fri May 20 04:21:22.326724 2016
494+
441 | Fri May 20 04:21:22.326724 2016
495+
441 | Fri May 20 04:21:22.326724 2016
496+
444 | Fri May 20 07:21:22.326724 2016
497+
444 | Fri May 20 07:21:22.326724 2016
498+
444 | Fri May 20 07:21:22.326724 2016
499+
444 | Fri May 20 07:21:22.326724 2016
500+
457 | Fri May 20 20:21:22.326724 2016
501+
457 | Fri May 20 20:21:22.326724 2016
502+
457 | Fri May 20 20:21:22.326724 2016
503+
457 | Fri May 20 20:21:22.326724 2016
504+
458 | Fri May 20 21:21:22.326724 2016
505+
458 | Fri May 20 21:21:22.326724 2016
506+
458 | Fri May 20 21:21:22.326724 2016
507+
458 | Fri May 20 21:21:22.326724 2016
508+
463 | Sat May 21 02:21:22.326724 2016
509+
463 | Sat May 21 02:21:22.326724 2016
510+
463 | Sat May 21 02:21:22.326724 2016
511+
463 | Sat May 21 02:21:22.326724 2016
512+
465 | Sat May 21 04:21:22.326724 2016
513+
465 | Sat May 21 04:21:22.326724 2016
514+
465 | Sat May 21 04:21:22.326724 2016
515+
465 | Sat May 21 04:21:22.326724 2016
516+
466 | Sat May 21 05:21:22.326724 2016
517+
466 | Sat May 21 05:21:22.326724 2016
518+
466 | Sat May 21 05:21:22.326724 2016
519+
466 | Sat May 21 05:21:22.326724 2016
520+
468 | Sat May 21 07:21:22.326724 2016
521+
468 | Sat May 21 07:21:22.326724 2016
522+
468 | Sat May 21 07:21:22.326724 2016
523+
468 | Sat May 21 07:21:22.326724 2016
524+
471 | Sat May 21 10:21:22.326724 2016
525+
471 | Sat May 21 10:21:22.326724 2016
526+
471 | Sat May 21 10:21:22.326724 2016
527+
471 | Sat May 21 10:21:22.326724 2016
528+
475 | Sat May 21 14:21:22.326724 2016
529+
475 | Sat May 21 14:21:22.326724 2016
530+
475 | Sat May 21 14:21:22.326724 2016
531+
475 | Sat May 21 14:21:22.326724 2016
532+
481 | Sat May 21 20:21:22.326724 2016
533+
481 | Sat May 21 20:21:22.326724 2016
534+
481 | Sat May 21 20:21:22.326724 2016
535+
481 | Sat May 21 20:21:22.326724 2016
536+
484 | Sat May 21 23:21:22.326724 2016
537+
484 | Sat May 21 23:21:22.326724 2016
538+
484 | Sat May 21 23:21:22.326724 2016
539+
484 | Sat May 21 23:21:22.326724 2016
540+
485 | Sun May 22 00:21:22.326724 2016
541+
485 | Sun May 22 00:21:22.326724 2016
542+
485 | Sun May 22 00:21:22.326724 2016
543+
485 | Sun May 22 00:21:22.326724 2016
544+
493 | Sun May 22 08:21:22.326724 2016
545+
493 | Sun May 22 08:21:22.326724 2016
546+
493 | Sun May 22 08:21:22.326724 2016
547+
493 | Sun May 22 08:21:22.326724 2016
548+
496 | Sun May 22 11:21:22.326724 2016
549+
496 | Sun May 22 11:21:22.326724 2016
550+
496 | Sun May 22 11:21:22.326724 2016
551+
496 | Sun May 22 11:21:22.326724 2016
552+
499 | Sun May 22 14:21:22.326724 2016
553+
499 | Sun May 22 14:21:22.326724 2016
554+
499 | Sun May 22 14:21:22.326724 2016
555+
499 | Sun May 22 14:21:22.326724 2016
556+
506 | Sun May 22 21:21:22.326724 2016
557+
506 | Sun May 22 21:21:22.326724 2016
558+
506 | Sun May 22 21:21:22.326724 2016
559+
506 | Sun May 22 21:21:22.326724 2016
560+
(112 rows)
561+

‎expected/altorder_1.out

Lines changed: 127 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -431,3 +431,130 @@ SELECT id, d FROM atsts WHERE t @@ 'wr&qh' AND d >= '2016-05-16 14:21:25' ORDER
431431
496 | Sun May 22 11:21:22.326724 2016
432432
(32 rows)
433433

434+
EXPLAIN (costs off)
435+
SELECT id, d FROM atsts WHERE t @@ 'wr&q:*' AND d >= '2016-05-16 14:21:25' ORDER BY d;
436+
QUERY PLAN
437+
-------------------------------------------------------------------------------------------------------------------------
438+
Sort
439+
Sort Key: d
440+
-> Seq Scan on atsts
441+
Filter: ((t @@ '''wr'' & ''q'':*'::tsquery) AND (d >= 'Mon May 16 14:21:25 2016'::timestamp without time zone))
442+
(4 rows)
443+
444+
SELECT id, d FROM atsts WHERE t @@ 'wr&q:*' AND d >= '2016-05-16 14:21:25' ORDER BY d;
445+
id | d
446+
-----+---------------------------------
447+
361 | Mon May 16 20:21:22.326724 2016
448+
361 | Mon May 16 20:21:22.326724 2016
449+
361 | Mon May 16 20:21:22.326724 2016
450+
361 | Mon May 16 20:21:22.326724 2016
451+
369 | Tue May 17 04:21:22.326724 2016
452+
369 | Tue May 17 04:21:22.326724 2016
453+
369 | Tue May 17 04:21:22.326724 2016
454+
369 | Tue May 17 04:21:22.326724 2016
455+
371 | Tue May 17 06:21:22.326724 2016
456+
371 | Tue May 17 06:21:22.326724 2016
457+
371 | Tue May 17 06:21:22.326724 2016
458+
371 | Tue May 17 06:21:22.326724 2016
459+
372 | Tue May 17 07:21:22.326724 2016
460+
372 | Tue May 17 07:21:22.326724 2016
461+
372 | Tue May 17 07:21:22.326724 2016
462+
372 | Tue May 17 07:21:22.326724 2016
463+
375 | Tue May 17 10:21:22.326724 2016
464+
375 | Tue May 17 10:21:22.326724 2016
465+
375 | Tue May 17 10:21:22.326724 2016
466+
375 | Tue May 17 10:21:22.326724 2016
467+
388 | Tue May 17 23:21:22.326724 2016
468+
388 | Tue May 17 23:21:22.326724 2016
469+
388 | Tue May 17 23:21:22.326724 2016
470+
388 | Tue May 17 23:21:22.326724 2016
471+
405 | Wed May 18 16:21:22.326724 2016
472+
405 | Wed May 18 16:21:22.326724 2016
473+
405 | Wed May 18 16:21:22.326724 2016
474+
405 | Wed May 18 16:21:22.326724 2016
475+
406 | Wed May 18 17:21:22.326724 2016
476+
406 | Wed May 18 17:21:22.326724 2016
477+
406 | Wed May 18 17:21:22.326724 2016
478+
406 | Wed May 18 17:21:22.326724 2016
479+
415 | Thu May 19 02:21:22.326724 2016
480+
415 | Thu May 19 02:21:22.326724 2016
481+
415 | Thu May 19 02:21:22.326724 2016
482+
415 | Thu May 19 02:21:22.326724 2016
483+
422 | Thu May 19 09:21:22.326724 2016
484+
422 | Thu May 19 09:21:22.326724 2016
485+
422 | Thu May 19 09:21:22.326724 2016
486+
422 | Thu May 19 09:21:22.326724 2016
487+
428 | Thu May 19 15:21:22.326724 2016
488+
428 | Thu May 19 15:21:22.326724 2016
489+
428 | Thu May 19 15:21:22.326724 2016
490+
428 | Thu May 19 15:21:22.326724 2016
491+
441 | Fri May 20 04:21:22.326724 2016
492+
441 | Fri May 20 04:21:22.326724 2016
493+
441 | Fri May 20 04:21:22.326724 2016
494+
441 | Fri May 20 04:21:22.326724 2016
495+
444 | Fri May 20 07:21:22.326724 2016
496+
444 | Fri May 20 07:21:22.326724 2016
497+
444 | Fri May 20 07:21:22.326724 2016
498+
444 | Fri May 20 07:21:22.326724 2016
499+
457 | Fri May 20 20:21:22.326724 2016
500+
457 | Fri May 20 20:21:22.326724 2016
501+
457 | Fri May 20 20:21:22.326724 2016
502+
457 | Fri May 20 20:21:22.326724 2016
503+
458 | Fri May 20 21:21:22.326724 2016
504+
458 | Fri May 20 21:21:22.326724 2016
505+
458 | Fri May 20 21:21:22.326724 2016
506+
458 | Fri May 20 21:21:22.326724 2016
507+
463 | Sat May 21 02:21:22.326724 2016
508+
463 | Sat May 21 02:21:22.326724 2016
509+
463 | Sat May 21 02:21:22.326724 2016
510+
463 | Sat May 21 02:21:22.326724 2016
511+
465 | Sat May 21 04:21:22.326724 2016
512+
465 | Sat May 21 04:21:22.326724 2016
513+
465 | Sat May 21 04:21:22.326724 2016
514+
465 | Sat May 21 04:21:22.326724 2016
515+
466 | Sat May 21 05:21:22.326724 2016
516+
466 | Sat May 21 05:21:22.326724 2016
517+
466 | Sat May 21 05:21:22.326724 2016
518+
466 | Sat May 21 05:21:22.326724 2016
519+
468 | Sat May 21 07:21:22.326724 2016
520+
468 | Sat May 21 07:21:22.326724 2016
521+
468 | Sat May 21 07:21:22.326724 2016
522+
468 | Sat May 21 07:21:22.326724 2016
523+
471 | Sat May 21 10:21:22.326724 2016
524+
471 | Sat May 21 10:21:22.326724 2016
525+
471 | Sat May 21 10:21:22.326724 2016
526+
471 | Sat May 21 10:21:22.326724 2016
527+
475 | Sat May 21 14:21:22.326724 2016
528+
475 | Sat May 21 14:21:22.326724 2016
529+
475 | Sat May 21 14:21:22.326724 2016
530+
475 | Sat May 21 14:21:22.326724 2016
531+
481 | Sat May 21 20:21:22.326724 2016
532+
481 | Sat May 21 20:21:22.326724 2016
533+
481 | Sat May 21 20:21:22.326724 2016
534+
481 | Sat May 21 20:21:22.326724 2016
535+
484 | Sat May 21 23:21:22.326724 2016
536+
484 | Sat May 21 23:21:22.326724 2016
537+
484 | Sat May 21 23:21:22.326724 2016
538+
484 | Sat May 21 23:21:22.326724 2016
539+
485 | Sun May 22 00:21:22.326724 2016
540+
485 | Sun May 22 00:21:22.326724 2016
541+
485 | Sun May 22 00:21:22.326724 2016
542+
485 | Sun May 22 00:21:22.326724 2016
543+
493 | Sun May 22 08:21:22.326724 2016
544+
493 | Sun May 22 08:21:22.326724 2016
545+
493 | Sun May 22 08:21:22.326724 2016
546+
493 | Sun May 22 08:21:22.326724 2016
547+
496 | Sun May 22 11:21:22.326724 2016
548+
496 | Sun May 22 11:21:22.326724 2016
549+
496 | Sun May 22 11:21:22.326724 2016
550+
496 | Sun May 22 11:21:22.326724 2016
551+
499 | Sun May 22 14:21:22.326724 2016
552+
499 | Sun May 22 14:21:22.326724 2016
553+
499 | Sun May 22 14:21:22.326724 2016
554+
499 | Sun May 22 14:21:22.326724 2016
555+
506 | Sun May 22 21:21:22.326724 2016
556+
506 | Sun May 22 21:21:22.326724 2016
557+
506 | Sun May 22 21:21:22.326724 2016
558+
506 | Sun May 22 21:21:22.326724 2016
559+
(112 rows)
560+

‎sql/altorder.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -81,3 +81,6 @@ EXPLAIN (costs off)
8181
SELECT id, dFROM atstsWHERE t @@'wr&qh'AND d>='2016-05-16 14:21:25'ORDER BY d;
8282
SELECT id, dFROM atstsWHERE t @@'wr&qh'AND d>='2016-05-16 14:21:25'ORDER BY d;
8383

84+
EXPLAIN (costs off)
85+
SELECT id, dFROM atstsWHERE t @@'wr&q:*'AND d>='2016-05-16 14:21:25'ORDER BY d;
86+
SELECT id, dFROM atstsWHERE t @@'wr&q:*'AND d>='2016-05-16 14:21:25'ORDER BY d;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp