[MDEV-22598] HeidiSQL does not recognize system-versioned or application-time period tables Created: 2020-05-16  Updated: 2021-06-05  Resolved: 2021-06-05

Status: Closed
Project: MariaDB Server
Component/s: Platform Windows
Affects Version/s: 10.3, 10.4, 10.5
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Vladislav Vaintroub
Resolution: Won't Fix Votes: 0
Labels: None

Attachments: PNG File HeidiSQL_t1.png     PNG File HeidiSQL_t2.png    

 Description    

CREATE OR REPLACE TABLE t1 (a INT) WITH system versioning;
 
CREATE OR REPLACE TABLE t2 (a INT, s DATE, e DATE, period FOR p(s,e));

(can be executed either via command-line client or via HeidiSQL query).

Table t1:CREATE code - MariaDB 10.5.3 / HeidiSQL 11.0.0.5919

 
CREATE TABLE `t1` (
 
	`a` INT(11) NULL DEFAULT NULL
 
)
 
COLLATE='latin1_swedish_ci'
 
ENGINE=InnoDB
 
;

Talbe t2:CREATE code

 
CREATE TABLE `t2` (
 
	`a` INT(11) NULL DEFAULT NULL,
 
	`s` DATE NOT NULL,
 
	`e` DATE NOT NULL
 
)
 
COLLATE='latin1_swedish_ci'
 
ENGINE=InnoDB
 
;

Screenshots are attached.

I suppose we need to request an update from upstream and then include it into our releases.

 Comments   
Comment by Vladislav Vaintroub [ 2020-05-16 ]

What does "provided with MariaDB" imply? That upstream can do that but we can't ? We have the latest release.

Comment by Elena Stepanova [ 2020-05-17 ]

It just means that I don't know whether we have the latest release. I thought that we probably did, hence the last line – "I suppose we need to request an update from upstream and then include it into our releases".

Comment by Vladislav Vaintroub [ 2021-06-05 ]

I'm closing since it is not our bug, that we can fix.
It is already filed in HeidiSQL's tracker as https://github.com/HeidiSQL/HeidiSQL/issues/1273

Whenever it will be fixed in HeidiSQL, we'll update our copy.

Note : https://github.com/HeidiSQL/HeidiSQL/issues/1273#issuecomment-753447689 seems to be looking for input or ideas, maybe you can help.

Generated at Thu Feb 08 09:15:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.