date math not very right

[zhouqingqing]

I used the c# built in class for it but not in the right way

see DateTime class (AddMonths() etc).

[zhouqingqing]

You can start with it after psql

[TheWanderingMinstrel]

Qingqing,

Ok, I figured how to write strings to files in c# so the first task should not be too hard.

Don

On Tue, Jan 21, 2020, 4:35 PM Qingqing Zhou [email protected] wrote:

You can start with it after psql

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/zhouqingqing/adb/issues/9?email_source=notifications&email_token=AKW7CIC4MYZ2WZVD2WDZ5CLQ66IENA5CNFSM4J7TMPUKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJRZW7A#issuecomment-576953212, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKW7CIDFKQWXTNNTWJHAH7TQ66IENANCNFSM4J7TMPUA .

[zhouqingqing]

@zhouruiapple do you want to take a look. Without this, we may not able to run tpch very correctly.

[9DemonFox]

@zhouruiapple do you want to take a look. Without this, we may not able to run tpch very correctly.

I test the subquery in those sql(tpch) containing date, and find the answers are the same as the postgreSQL.

[9DemonFox]

@zhouqingqing But this test case I don't understand.

        public void HopWindow()
        {
            var phyplan = "";
            var sql = "select count(*) from ast group by hop(a0, interval '5' second, interval '10' second)";
            TU.ExecuteSQL(sql, "2;4;2;1;1", out phyplan);
            Assert.AreEqual(1, TU.CountStr(phyplan, "ProjectSet"));
        }

and the table ast is

05/12/2020 07:22:16|0|1|2|3
05/12/2020 07:22:17|1|2|3|4
05/12/2020 07:22:26|2|3|4|5
05/12/2020 07:22:28|3|3|4|5
05/12/2020 07:22:56|4|3|4|5

07:22:56-07:22:16= 40s And there is one hop per 5s. Why the result has only 5 values.