mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-28 06:45:06 +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>
19 lines
1.0 KiB
Plaintext
19 lines
1.0 KiB
Plaintext
USE tpch1;
|
|
select cdate, cdatetime, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm where TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') > 0;
|
|
cdate cdatetime TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')
|
|
2009-12-28 2009-12-31 23:59:56 838:59:59
|
|
2009-12-29 2009-12-31 23:59:57 838:59:59
|
|
2009-12-30 2009-12-31 23:59:58 838:59:59
|
|
2009-12-31 2009-12-31 23:59:59 838:59:59
|
|
2009-12-31 2009-12-31 23:59:59 838:59:59
|
|
2009-12-31 2009-12-31 23:59:59 838:59:59
|
|
select cdate, cdatetime, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm where TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') = 0;
|
|
cdate cdatetime TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')
|
|
select cdate, cdatetime, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm where TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') < 0;
|
|
cdate cdatetime TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')
|
|
1997-01-01 1997-01-01 00:00:00 -838:59:59
|
|
1997-01-01 1997-01-01 00:00:01 -838:59:59
|
|
1997-01-02 1997-01-02 00:00:01 -838:59:59
|
|
1997-01-03 1997-01-03 00:00:02 -838:59:59
|
|
1997-01-04 1997-01-04 00:00:03 -838:59:59
|