[MDEV-4022] table attributes with sysvar as a default value Created: 2013-01-10  Updated: 2013-04-10  Resolved: 2013-04-10

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.0.2

Type: Task Priority: Major
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: plugins

Issue Links:
Blocks

 Description   

I've had the need for this few times already (e.g. Aria engine does that with the page checksum).
It's a table attribute where the default value is not fixed, but set via a server variable. Like in

SET SESSION opt_val=17;
CREATE TABLE t1 ( .... ) opt_val=DEFAULT;
CREATE TABLE t2 ( .... );
CREATE TABLE t3 ( .... ) opt_val=10;

for tables t1 and t2 the value of opt_val will be 17.

Note that the value of opt_val is remembered when a table is created, later changes of the session variable don't affect the table.



 Comments   
Comment by Sergei Golubchik [ 2013-04-10 ]

pushed in 10.0-base

Generated at Thu Feb 08 06:53:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.