📄 regression.solaris-sparc
字号:
QUERY: SELECT '' AS four, ABSTIME_TBL.******************* 106,112 **** -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PST (3 rows) QUERY: SELECT '' AS three, ABSTIME_TBL.*--- 106,112 ---- -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PDT (3 rows) QUERY: SELECT '' AS three, ABSTIME_TBL.******************* 116,122 **** -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PST (3 rows) QUERY: SELECT '' AS three, ABSTIME_TBL.*--- 116,122 ---- -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PDT (3 rows) QUERY: SELECT '' AS three, ABSTIME_TBL.******************* 126,132 **** -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PST (3 rows) QUERY: SELECT '' AS three, ABSTIME_TBL.*--- 126,132 ---- -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PDT (3 rows) QUERY: SELECT '' AS three, ABSTIME_TBL.******************* 136,142 **** -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PST (3 rows) QUERY: SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime--- 136,142 ---- -----+---------------------------- |Sun Jan 14 03:14:21 1973 PST |epoch ! |Sat May 10 23:59:12 1947 PDT (3 rows) QUERY: SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime****************** 145,155 **** ORDER BY abstime, reltime; ten|abstime |reltime ---+----------------------------+-------------! |Sat May 10 23:59:12 1947 PST|@ 14 secs ago! |Sat May 10 23:59:12 1947 PST|@ 1 min ! |Sat May 10 23:59:12 1947 PST|@ 5 hours ! |Sat May 10 23:59:12 1947 PST|@ 10 days ! |Sat May 10 23:59:12 1947 PST|@ 3 mons |epoch |@ 14 secs ago |epoch |@ 1 min |epoch |@ 5 hours --- 145,155 ---- ORDER BY abstime, reltime; ten|abstime |reltime ---+----------------------------+-------------! |Sat May 10 23:59:12 1947 PDT|@ 14 secs ago! |Sat May 10 23:59:12 1947 PDT|@ 1 min ! |Sat May 10 23:59:12 1947 PDT|@ 5 hours ! |Sat May 10 23:59:12 1947 PDT|@ 10 days ! |Sat May 10 23:59:12 1947 PDT|@ 3 mons |epoch |@ 14 secs ago |epoch |@ 1 min |epoch |@ 5 hours ----------------------*** expected/tinterval.out Mon Oct 12 16:56:57 1998--- results/tinterval.out Tue Oct 27 16:34:41 1998****************** 19,25 **** five|f1 ----+--------------------------------------------------------------- |["-infinity" "infinity"] ! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] --- 19,25 ---- five|f1 ----+--------------------------------------------------------------- |["-infinity" "infinity"] ! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] ****************** 38,44 **** WHERE t.f1 #<> '@ 1 months'; three|f1 -----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)--- 38,44 ---- WHERE t.f1 #<> '@ 1 months'; three|f1 -----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)****************** 63,69 **** WHERE t.f1 #> '@ 1 year'; three|f1 -----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)--- 63,69 ---- WHERE t.f1 #> '@ 1 year'; three|f1 -----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)****************** 73,79 **** WHERE t.f1 #>= '@ 3 years'; three|f1 -----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)--- 73,79 ---- WHERE t.f1 #>= '@ 3 years'; three|f1 -----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)****************** 98,104 **** five|f1 |f1 ----+---------------------------------------------------------------+--------------------------------------------------------------- |["-infinity" "infinity"] |["-infinity" "infinity"] ! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] |["Thu Feb 15 12:15:03 1990 PST" "current"] --- 98,104 ---- five|f1 |f1 ----+---------------------------------------------------------------+--------------------------------------------------------------- |["-infinity" "infinity"] |["-infinity" "infinity"] ! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] |["Thu Feb 15 12:15:03 1990 PST" "current"] ****************** 110,129 **** ORDER BY interval1, interval2; fourteen|interval1 |interval2 --------+---------------------------------------------------------------+---------------------------------------------------------------! |["-infinity" "infinity"] |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["-infinity" "infinity"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["-infinity" "infinity"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] ! |["-infinity" "infinity"] |["Thu Feb 15 12:15:03 1990 PST" "current"] ! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["-infinity" "infinity"] - |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"] |["Thu Feb 15 12:15:03 1990 PST" "current"] |["-infinity" "infinity"] ! |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"] ! |["Thu Feb 15 12:15:03 1990 PST" "current"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] (14 rows) QUERY: SELECT '' AS five, t1.f1--- 110,129 ---- ORDER BY interval1, interval2; fourteen|interval1 |interval2 --------+---------------------------------------------------------------+---------------------------------------------------------------! |["-infinity" "infinity"] |["Thu Feb 15 12:15:03 1990 PST" "current"] ! |["-infinity" "infinity"] |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["-infinity" "infinity"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["-infinity" "infinity"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] ! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["-infinity" "infinity"] |["Thu Feb 15 12:15:03 1990 PST" "current"] |["-infinity" "infinity"] ! |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]! |["Thu Feb 15 12:15:03 1990 PST" "current"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] ! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["epoch" "Mon May 01 00:30:30 1995 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"] ! |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"] (14 rows) QUERY: SELECT '' AS five, t1.f1****************** 133,139 **** ORDER BY t1.f1; five|f1 ----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)--- 133,139 ---- ORDER BY t1.f1; five|f1 ----+---------------------------------------------------------------! |["Sat May 10 23:59:12 1947 PDT" "Sun Jan 14 03:14:21 1973 PST"] |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"] |["Thu Feb 15 12:15:03 1990 PST" "current"] (3 rows)----------------------*** expected/horology.out Mon Oct 12 16:56:40 1998--- results/horology.out Tue Oct 27 16:34:44 1998****************** 430,436 **** ORDER BY abstime; four|abstime |year|month|day|hour|minute|second ----+----------------------------+----+-----+---+----+------+------! |Sat May 10 23:59:12 1947 PST|1947| 5| 10| 23| 59| 12 |epoch |1969| 12| 31| 16| 0| 0 |Sun Jan 14 03:14:21 1973 PST|1973| 1| 14| 3| 14| 21⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -