← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/suite/falcon/t/falcon_bug_22168.test

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/falcon/t/falcon_bug_22168.test
1
1
--source include/have_falcon.inc
2
 
SET STORAGE_ENGINE = Falcon;
3
2
#
4
3
# Bug #22168: Inserting bad early dates
5
4
#
6
5
--echo *** Bug #22168 ***
 
6
 
 
7
# ----------------------------------------------------- #
 
8
# --- Initialisation                                --- #
 
9
# ----------------------------------------------------- #
 
10
let $engine = 'Falcon';
 
11
eval SET @@storage_engine = $engine;
 
12
 
7
13
--disable_warnings
8
14
DROP TABLE IF EXISTS t1;
9
15
--enable_warnings
13
19
  b datetime
14
20
);
15
21
 
 
22
# ----------------------------------------------------- #
 
23
# --- Test                                          --- #
 
24
# ----------------------------------------------------- #
16
25
INSERT INTO t1 (a) VALUES ('0999-01-01');
17
26
SELECT count(*) FROM t1 WHERE a = '0999-01-01';
18
27
 
19
28
INSERT INTO t1 (b) VALUES ('0001-01-01 00:00:00');
20
29
SELECT count(*) FROM t1 WHERE b = '0001-01-01 00:00:00';
21
30
 
22
 
# Final cleanup.
 
31
# ----------------------------------------------------- #
 
32
# --- Check                                         --- #
 
33
# ----------------------------------------------------- #
 
34
SELECT count(*) FROM t1;
 
35
 
 
36
# ----------------------------------------------------- #
 
37
# --- Final cleanup                                 --- #
 
38
# ----------------------------------------------------- #
23
39
DROP TABLE t1;