📄 regression.aix41
字号:
----------------------*** expected/abstime.out Fri Jan 9 03:01:55 1998--- results/abstime.out Thu Feb 26 10:24:51 1998****************** 22,28 **** |current |infinity |-infinity ! |Sat May 10 23:59:12 1947 PST |invalid (8 rows) --- 22,28 ---- |current |infinity |-infinity ! |Sun May 11 00:59:12 1947 PDT |invalid (8 rows) ****************** 35,41 **** |epoch |current |-infinity ! |Sat May 10 23:59:12 1947 PST (6 rows) QUERY: SELECT '' AS six, ABSTIME_TBL.*--- 35,41 ---- |epoch |current |-infinity ! |Sun May 11 00:59:12 1947 PDT (6 rows) QUERY: SELECT '' AS six, ABSTIME_TBL.******************* 47,53 **** |epoch |current |infinity ! |Sat May 10 23:59:12 1947 PST (6 rows) QUERY: SELECT '' AS six, ABSTIME_TBL.*--- 47,53 ---- |epoch |current |infinity ! |Sun May 11 00:59:12 1947 PDT (6 rows) QUERY: SELECT '' AS six, ABSTIME_TBL.******************* 75,81 **** -----+---------------------------- |epoch |-infinity ! |Sat May 10 23:59:12 1947 PST (3 rows) QUERY: SELECT '' AS four, ABSTIME_TBL.*--- 75,81 ---- -----+---------------------------- |epoch |-infinity ! |Sun May 11 00:59:12 1947 PDT (3 rows) QUERY: SELECT '' AS four, ABSTIME_TBL.******************* 85,91 **** |Sun Jan 14 03:14:21 1973 PST |epoch |-infinity ! |Sat May 10 23:59:12 1947 PST (4 rows) QUERY: SELECT '' AS four, ABSTIME_TBL.*--- 85,91 ---- |Sun Jan 14 03:14:21 1973 PST |epoch |-infinity ! |Sun May 11 00:59:12 1947 PDT (4 rows) 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 ! |Sun May 11 00: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 ! |Sun May 11 00: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 ! |Sun May 11 00: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 ! |Sun May 11 00: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 ---+----------------------------+-------------! |Sun May 11 00:59:12 1947 PDT|@ 14 secs ago! |Sun May 11 00:59:12 1947 PDT|@ 1 min ! |Sun May 11 00:59:12 1947 PDT|@ 5 hours ! |Sun May 11 00:59:12 1947 PDT|@ 10 days ! |Sun May 11 00:59:12 1947 PDT|@ 3 mons |epoch |@ 14 secs ago |epoch |@ 1 min |epoch |@ 5 hours ----------------------*** expected/tinterval.out Fri Jan 9 03:02:00 1998--- results/tinterval.out Thu Feb 26 10:24:54 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"] ! |["Sun May 11 00: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 -----+---------------------------------------------------------------! |["Sun May 11 00: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 -----+---------------------------------------------------------------! |["Sun May 11 00: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 -----+---------------------------------------------------------------! |["Sun May 11 00: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,107 **** five|f1 |f1 ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -