File: misc.result

package info (click to toggle)
mariadb-10.5 1%3A10.5.23-0%2Bdeb11u1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 712,240 kB
  • sloc: ansic: 2,158,658; cpp: 1,843,101; asm: 297,745; perl: 59,967; sh: 53,869; pascal: 38,348; java: 33,919; yacc: 19,639; python: 11,119; xml: 10,126; sql: 10,027; ruby: 8,544; makefile: 6,343; cs: 2,866; lex: 1,205; javascript: 1,037; objc: 80; tcl: 73; awk: 46; php: 22; sed: 16
file content (27 lines) | stat: -rw-r--r-- 1,406 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
set time_zone='+00:00';
#
# MDEV-29750 triggers can modify history
#
set sql_mode='', timestamp=unix_timestamp('2010-10-10 10:10:10');
create table t (a int, b int as (a+1), s timestamp(6) as row start, e timestamp(6) as row end, period for system_time(s,e)) with system versioning;
insert into t values (1,1, '2022-01-01','2023-01-01'),(2,2, '2022-02-02','2023-02-02');
Warnings:
Warning	1906	The value specified for generated column 'b' in table 't' has been ignored
Warning	1906	The value specified for generated column 's' in table 't' has been ignored
Warning	1906	The value specified for generated column 'e' in table 't' has been ignored
Warning	1906	The value specified for generated column 'b' in table 't' has been ignored
Warning	1906	The value specified for generated column 's' in table 't' has been ignored
Warning	1906	The value specified for generated column 'e' in table 't' has been ignored
create trigger tr before insert on t for each row set new.b=1, new.s = '2022-03-03', new.e = '2023-03-03';
insert into t (a) values (3),(4);
select * from t for system_time all;
a	b	s	e
1	2	2010-10-10 10:10:10.000000	2038-01-19 03:14:07.999999
2	3	2010-10-10 10:10:10.000000	2038-01-19 03:14:07.999999
3	4	2010-10-10 10:10:10.000000	2038-01-19 03:14:07.999999
4	5	2010-10-10 10:10:10.000000	2038-01-19 03:14:07.999999
drop table t;
set sql_mode=default, timestamp=default;
#
# End of 10.3 tests
#