mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-28 13:01:26 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
35 lines
1.0 KiB
Plaintext
35 lines
1.0 KiB
Plaintext
USE tpch1;
|
|
select cdatetime, year(cdatetime), week(cdatetime) from datatypetestm group by 1, 2, 3 order by 1;
|
|
cdatetime year(cdatetime) week(cdatetime)
|
|
1997-01-01 00:00:00 1997 0
|
|
1997-01-01 00:00:01 1997 0
|
|
1997-01-02 00:00:01 1997 0
|
|
1997-01-03 00:00:02 1997 0
|
|
1997-01-04 00:00:03 1997 0
|
|
2009-12-31 23:59:56 2009 52
|
|
2009-12-31 23:59:57 2009 52
|
|
2009-12-31 23:59:58 2009 52
|
|
2009-12-31 23:59:59 2009 52
|
|
select cdatetime, week(cdatetime) from datatypetestm group by 1, 2 order by 1;
|
|
cdatetime week(cdatetime)
|
|
1997-01-01 00:00:00 0
|
|
1997-01-01 00:00:01 0
|
|
1997-01-02 00:00:01 0
|
|
1997-01-03 00:00:02 0
|
|
1997-01-04 00:00:03 0
|
|
2009-12-31 23:59:56 52
|
|
2009-12-31 23:59:57 52
|
|
2009-12-31 23:59:58 52
|
|
2009-12-31 23:59:59 52
|
|
select cdatetime, year(cdatetime) from datatypetestm group by 1, 2 order by 1;
|
|
cdatetime year(cdatetime)
|
|
1997-01-01 00:00:00 1997
|
|
1997-01-01 00:00:01 1997
|
|
1997-01-02 00:00:01 1997
|
|
1997-01-03 00:00:02 1997
|
|
1997-01-04 00:00:03 1997
|
|
2009-12-31 23:59:56 2009
|
|
2009-12-31 23:59:57 2009
|
|
2009-12-31 23:59:58 2009
|
|
2009-12-31 23:59:59 2009
|