On 6/2/11 4:37 PM, Lowterm wrote:
Hi Martin,
thanks for you reply. How I see, there are many SQL statements that are not supported by MonetDB. I am Student and I would like compare MonetDB with other databases, but I
Yes, the work of a student calls for reading the background material and not assuming that two SQL database systems are the same. http://www.monetdb.org/Documentation/Manuals/SQLreference/Features
have massive problems alone with changes the SQL statements. I have for example the following Greate Table statement:
CREATE TABLE dim_customer ( customer_key int NOT NULL, customer_id int NOT NULL DEFAULT '0', customer_first_name varchar(35) NOT NULL DEFAULT 'not applicable', customer_middle_initial char(1) DEFAULT '', customer_last_name varchar(30) NOT NULL DEFAULT 'not applicable', customer_address1 varchar(50) NOT NULL DEFAULT 'not applicable', customer_address2 varchar(50) DEFAULT 'not applicable', customer_postal_code varchar(10) NOT NULL DEFAULT 'N/A', customer_city_name varchar(64) NOT NULL DEFAULT 'not applicable', customer_region_code char(2) NOT NULL DEFAULT 'NA', customer_region_name varchar(50) NOT NULL DEFAULT 'not applicable', customer_country_code char(2) NOT NULL DEFAULT 'NA', customer_country_name varchar(50) NOT NULL DEFAULT 'not applicable', customer_email_address varchar(64) NOT NULL DEFAULT 'not applicable', customer_telephone_number char(12) NOT NULL DEFAULT 'N/A', customer_date_of_birth date NOT NULL DEFAULT '1900-01-01', customer_website_name varchar(50) NOT NULL DEFAULT 'not applicable', demography_key smallint NOT NULL DEFAULT '0', valid_from date NOT NULL DEFAULT '1900-01-01', valid_to date NOT NULL DEFAULT '2199-01-01', version int NOT NULL DEFAULT '0', current_record int NOT NULL DEFAULT '0',
last_modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
customer_date_registered date NOT NULL DEFAULT '1900-01-01', customer_date_unregistered date NOT NULL DEFAULT '2100-01-01', customer_balance decimal(6,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (customer_key)
KEY date_registered (customer_date_registered,customer_website_name), KEY date_unregistered (customer_date_unregistered,customer_website_name), KEY demography (demography_key), KEY cust_id (customer_id) )
and I have problem with "ON UPDATE" and "KEY" statements and I can't find any good documentation about solution of such problems. I am grateful for your links, but it can't help me because such problems can not be treated there.
Thanks