This worklog has been replaced with mariadb.org/jira

This site is here for historical purposes only. Do not add or edit tasks here!

 
 
 

WorkLog Frontpage Log in / Register
High-Level Description | Task Dependencies | High-Level Specification | Low-Level Design | File Attachments | User Comments | Time Estimates | Funding and Votes | Progress Reports

 options for CREATE TABLE
Title
Task ID43
Queue
Version
Status
Priority
Copies toSergei
Monty

Created bySanja11 Aug 2009Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level Description
Add ability to create table with additional option which can be passed to engine.

Also make current options such as TRANSACTIONAL working via this mechanism.
 Task Dependencies
Others waiting for Task 43Task 43 is waiting forGraph
 
 High-Level Specification
Table definition will look like the following:

CREATE TABLE table
  (field int ... field_opt1=fval1 field_opt2=fval2,
   key key1(field) key_opt1=kval1 key_opt2=kval2)
   table_option1=tval1, table_option2=tval2;

Exceptions should be made for old table and key options where
'=' was not obligatory. These options will behave as they did,
no changes from the user point of view.

Old key options:
KEY_BLOCK_SIZE <num> -> KEY_BLOCK_SIZE=num
WITH PARSER <name> -> PARSER=name

Old table options:
ENGINE name ->  ENGINE=name
TYPE name -> TYPE=name
MAX_ROWS num -> MAX_ROWS=num
MIX_ROWS num -> MIX_ROWS=num
AVG_ROW_LENGTH num -> AVG_ROW_LENGTH=num
PASSWORD string -> PASSWORD=string
COMMENT string -> COMMENT=string
AUTO_INCREMENT num -> AUTO_INCREMENT=num
PACK_KEYS num/default -> PACK_KEYS=num/default
CHECKSUM num -> CHECKSUM=num
TABLE_CHECKSUM num -> TABLE_CHECKSUM=num
PAGE_CHECKSUM num -> PAGE_CHECKSUM=num
DELAY_KEY_WRITE num -> DELAY_KEY_WRITE=num
ROW_FORMAT name -> ROW_FORMAT=name
INSERT_METHOD name -> INSERT_METHOD=name
KEY_BLOCK_SIZE num -> KEY_BLOCK_SIZE=num
TRANSACTIONAL num -> TRANSACTIONAL=num

Table options which will be left hardcoded
UNION
default charset
default collation
DATA DIRECTORY
INDEX DIRECTORY
TABLESPACE
STORAGE

Incorrect option during creation/altering table lead only to a warning.
Strict mode makes them errors, as expected.
When opening a table all unrecognised options should be ignored.
 Low-Level Design
Options stored in a list as pairs key, value which are LEX_STRING.

Handler have access to the options during creation and after opening frm.


 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
This Task03232
Total03232
 
 Funding and Votes
Votes: 0: 0%
 Make vote: Useless    Nice to have    Important    Very important    

Funding: 0 offers, total 0 Euro
 Progress Reports
(Monty - Wed, 30 Nov 2011, 09:30
    
Category updated.
--- /tmp/wklog.43.old.11860	2011-11-30 09:30:56.000000000 +0000
+++ /tmp/wklog.43.new.11860	2011-11-30 09:30:56.000000000 +0000
@@ -1,2 +1,2 @@
-Server-BackLog
+Server-Sprint
 

(Monty - Wed, 30 Nov 2011, 09:30
    
Supervisor updated: Bothorsen -> Igor

(Guest - Fri, 23 Apr 2010, 11:02
    
Status updated.
--- /tmp/wklog.43.old.24328	2010-04-23 11:02:07.000000000 +0000
+++ /tmp/wklog.43.new.24328	2010-04-23 11:02:07.000000000 +0000
@@ -1 +1 @@
-Assigned
+Complete

(Sergei - Sun, 11 Apr 2010, 11:58
    
Low Level Design modified.
--- /tmp/wklog.43.old.24176	2010-04-11 11:58:36.000000000 +0000
+++ /tmp/wklog.43.new.24176	2010-04-11 11:58:36.000000000 +0000
@@ -2,6 +2,5 @@
 
 Handler have access to the options during creation and after opening frm.
 
-It should has C interface.
 
 

(Sergei - Thu, 04 Mar 2010, 16:15
    
High-Level Specification modified.
--- /tmp/wklog.43.old.32502	2010-03-04 16:15:12.000000000 +0000
+++ /tmp/wklog.43.new.32502	2010-03-04 16:15:12.000000000 +0000
@@ -1,13 +1,13 @@
-Table definition ca looks like following
+Table definition will look like the following:
 
 CREATE TABLE table
   (field int ... field_opt1=fval1 field_opt2=fval2,
    key key1(field) key_opt1=kval1 key_opt2=kval2)
    table_option1=tval1, table_option2=tval2;
 
-Exclusion should be made for old table and key options where
-'=' was not obligatory. Behaviour and way of storage for existing options will
-be left as is.
+Exceptions should be made for old table and key options where
+'=' was not obligatory. These options will behave as they did,
+no changes from the user point of view.
 
 Old key options:
 KEY_BLOCK_SIZE <num> -> KEY_BLOCK_SIZE=num
@@ -37,12 +37,11 @@
 default charset
 default collation
 DATA DIRECTORY
+INDEX DIRECTORY
 TABLESPACE
 STORAGE
 
-For fields options can go with field attributes (NOT NULL, UNIQUE and so on) can
-be separated from them by '=' sign.
-
-Incorrect option during creation/altering table lead only to worning. During
-opening unrecognised options should be ignored.
+Incorrect option during creation/altering table lead only to a warning.
+Strict mode makes them errors, as expected.
+When opening a table all unrecognised options should be ignored.
 

(Sergei - Mon, 18 Jan 2010, 22:12
    
Observers changed: Monty,Sergei

(Monty - Tue, 12 Jan 2010, 17:04
    
Version updated.
--- /tmp/wklog.43.old.21802	2010-01-12 17:04:31.000000000 +0200
+++ /tmp/wklog.43.new.21802	2010-01-12 17:04:31.000000000 +0200
@@ -1 +1 @@
-Server-5.1
+Server-5.2

(Guest - Fri, 18 Sep 2009, 14:24
    
Low Level Design modified.
--- /tmp/wklog.43.old.31654	2009-09-18 14:24:41.000000000 +0300
+++ /tmp/wklog.43.new.31654	2009-09-18 14:24:41.000000000 +0300
@@ -2,4 +2,6 @@
 
 Handler have access to the options during creation and after opening frm.
 
+It should has C interface.
+
 

(Sanja - Fri, 18 Sep 2009, 13:32
    
Low Level Design modified.
--- /tmp/wklog.43.old.29567	2009-09-18 13:32:41.000000000 +0300
+++ /tmp/wklog.43.new.29567	2009-09-18 13:32:41.000000000 +0300
@@ -1 +1,5 @@
+Options stored in a list as pairs key, value which are LEX_STRING.
+
+Handler have access to the options during creation and after opening frm.
+
 

(Sanja - Fri, 18 Sep 2009, 13:21
    
High-Level Specification modified.
--- /tmp/wklog.43.old.29107	2009-09-18 13:21:19.000000000 +0300
+++ /tmp/wklog.43.new.29107	2009-09-18 13:21:19.000000000 +0300
@@ -6,7 +6,8 @@
    table_option1=tval1, table_option2=tval2;
 
 Exclusion should be made for old table and key options where
-'=' was not obligatory.
+'=' was not obligatory. Behaviour and way of storage for existing options will
+be left as is.
 
 Old key options:
 KEY_BLOCK_SIZE <num> -> KEY_BLOCK_SIZE=num
@@ -42,6 +43,6 @@
 For fields options can go with field attributes (NOT NULL, UNIQUE and so on) can
 be separated from them by '=' sign.
 
-
-
+Incorrect option during creation/altering table lead only to worning. During
+opening unrecognised options should be ignored.
 
-- View All Progress Notes (12 total) --


Report Generator:
 
Saved Reports:

WorkLog v4.0.0
  © 2010  Sergei Golubchik and Monty Program AB
  © 2004  Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003  Matt Wagner <matt@mysql.com> and MySQL AB