summaryrefslogtreecommitdiff
path: root/storage/mroonga/mysql-test/mroonga/storage/r/column_datetime_64bit_2038.result
blob: f0f03a82c9851d45164bc0adf9e451efc2f98eda (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
DROP TABLE IF EXISTS diaries;
CREATE TABLE diaries (
id INT PRIMARY KEY AUTO_INCREMENT,
title TEXT,
created_at DATETIME
) DEFAULT CHARSET UTF8;
INSERT INTO diaries (title, created_at)
VALUES ('2038-01-19 03:14:07', '2038-01-19 03:14:07');
INSERT INTO diaries (title, created_at)
VALUES ('2038-01-19 03:14:08', '2038-01-19 03:14:08');
SELECT * FROM diaries;
id	title	created_at
1	2038-01-19 03:14:07	2038-01-19 03:14:07
2	2038-01-19 03:14:08	2038-01-19 03:14:08
DROP TABLE diaries;