Changeset: 134cdc4cc0c4 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=134cdc4cc0c4 Modified Files: Branch: default Log Message:
Merge with Jun2010 branch. diffs (truncated from 506 to 300 lines): diff -r 7ce79e5e8afe -r 134cdc4cc0c4 sql/src/test/BugTracker-2010/Tests/crash-with-huge-query.Bug-2647.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/src/test/BugTracker-2010/Tests/crash-with-huge-query.Bug-2647.sql Fri Aug 20 17:04:56 2010 +0200 @@ -0,0 +1,492 @@ +-- +-- Table structure for table payments +-- + +CREATE TABLE payments ( + id integer, + order_id integer default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL, + amount decimal(8,2) NOT NULL default '0.00', + creditcard_id integer default NULL, + paytype varchar(255) default NULL +); + +-- +-- Table structure for table addresses +-- + +CREATE TABLE addresses ( + id integer, + firstname varchar(255) default NULL, + lastname varchar(255) default NULL, + address1 varchar(255) default NULL, + address2 varchar(255) default NULL, + city varchar(255) default NULL, + state_id integer default NULL, + zipcode varchar(255) default NULL, + country_id integer default NULL, + phone varchar(255) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL, + state_name varchar(255) default NULL +); + +-- +-- Table structure for table countries +-- + +CREATE TABLE countries ( + id integer, + iso_name varchar(255) default NULL, + iso varchar(255) default NULL, + name varchar(255) default NULL, + iso3 varchar(255) default NULL, + numcode integer default NULL +); + +-- +-- Table structure for table line_items +-- + +CREATE TABLE line_items ( + id integer, + order_id integer default NULL, + variant_id integer default NULL, + quantity integer NOT NULL, + price decimal(8,2) NOT NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL +); + +-- +-- Table structure for table orders +-- + +CREATE TABLE orders ( + id integer default NULL, + user_id integer default NULL, + number varchar(255) default NULL, + ship_amount decimal(8,2) NOT NULL default '0.00', + tax_amount decimal(8,2) NOT NULL default '0.00', + item_total decimal(8,2) NOT NULL default '0.00', + total decimal(8,2) NOT NULL default '0.00', + ip_address varchar(255) default NULL, + special_instructions text, + created_at timestamp default NULL, + updated_at timestamp default NULL, + state varchar(255) default NULL, + checkout_complete integer default NULL, + token varchar(255) default NULL, + email varchar(255) default NULL, + bill_address_id integer default NULL, + ship_address_id integer default NULL +); + +-- +-- Table structure for table products +-- + +CREATE TABLE products ( + id integer default NULL, + name varchar(255) NOT NULL default '', + description text, + master_price decimal(8,2) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL, + permalink varchar(255) default NULL, + available_on timestamp default NULL, + tax_category_id integer default NULL, + shipping_category integer default NULL, + deleted_at timestamp default NULL, + meta_description varchar(255) default NULL, + meta_keywords varchar(255) default NULL +); + +-- +-- Table structure for table schema_migrations +-- + +CREATE TABLE schema_migrations ( + version varchar(255) NOT NULL +); + +-- +-- Table structure for table shipments +-- + +CREATE TABLE shipments ( + id integer, + order_id integer default NULL, + shipping_method_id integer default NULL, + tracking varchar(255) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL, + number varchar(255) default NULL, + cost decimal(8,2) default NULL, + shipped_at timestamp default NULL, + address_id integer default NULL +); + +-- +-- Table structure for table shipping_methods +-- + +CREATE TABLE shipping_methods ( + id integer, + zone_id integer default NULL, + shipping_calculator varchar(255) default NULL, + name varchar(255) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL +); + +-- +-- Table structure for table states +-- + +CREATE TABLE states ( + id integer, + name varchar(255) default NULL, + abbr varchar(255) default NULL, + country_id integer default NULL +); + +-- +-- Table structure for table tax_categories +-- + +CREATE TABLE tax_categories ( + id integer, + name varchar(255) default NULL, + description varchar(255) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL +); + +-- +-- Table structure for table tax_rates +-- + +CREATE TABLE tax_rates ( + id integer default NULL, + zone_id integer default NULL, + amount decimal(8,4) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL, + tax_type integer default NULL, + tax_category_id integer default NULL +); + +-- +-- Table structure for table variants +-- + +CREATE TABLE variants ( + id integer default NULL, + product_id integer default NULL, + sku varchar(255) default NULL, + price decimal(8,2) NOT NULL, + weight decimal(8,2) default NULL, + height decimal(8,2) default NULL, + width decimal(8,2) default NULL, + depth decimal(8,2) default NULL, + deleted_at timestamp default NULL +); + +-- +-- Table structure for table zone_members +-- + +CREATE TABLE zone_members ( + id integer default NULL, + zone_id integer default NULL, + country_id integer default NULL, + zoneable_type varchar(255) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL +); + +-- +-- Table structure for table zones +-- + +CREATE TABLE zones ( + id integer default NULL, + name varchar(255) default NULL, + description varchar(255) default NULL, + created_at timestamp default NULL, + updated_at timestamp default NULL +); + +-- +-- Constraints for table zones +-- + +ALTER TABLE zones + ADD CONSTRAINT prim_zones_id + PRIMARY KEY(id); +ALTER TABLE zones + ALTER COLUMN id SET NOT NULL; + +-- +-- Constraints for table orders +-- + +ALTER TABLE orders + ADD CONSTRAINT prim_orders_id + PRIMARY KEY(id); +ALTER TABLE orders + ALTER COLUMN id SET NOT NULL; + +-- +-- Constraints for table addresses +-- + +ALTER TABLE addresses + ADD CONSTRAINT prim_addresses_id + PRIMARY KEY(id); +ALTER TABLE addresses + ALTER COLUMN id SET NOT NULL; + +-- +-- Constraints for table countries +-- + +ALTER TABLE countries + ADD CONSTRAINT prim_countries_id + PRIMARY KEY(id); +ALTER TABLE countries + ALTER COLUMN id SET NOT NULL; + +-- +-- Constraints for table states +-- + +ALTER TABLE states + ADD CONSTRAINT prim_states_id + PRIMARY KEY(id); +ALTER TABLE states + ALTER COLUMN id SET NOT NULL; + +ALTER TABLE states + ADD CONSTRAINT for_key_states_country_id + FOREIGN KEY (country_id) REFERENCES states(id); + + + + + +-- +-- Constraints for table payments +-- + +ALTER TABLE payments + ADD CONSTRAINT prim_payments_id + PRIMARY KEY(id); +ALTER TABLE payments + ALTER COLUMN id SET NOT NULL; + +ALTER TABLE payments + ADD CONSTRAINT for_key_payments_order_id + FOREIGN KEY (order_id) REFERENCES orders(id); + +-- +-- Constraints for table products +-- _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
