mysql


Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname LONGTEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           TIMESTAMP,
BIGFELLOW        LONGTEXT,
TS               TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
)TYPE=ISAM;
CREATE FULLTEXT INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           DOUBLE;
ALTER TABLE KUTU.testtable  ADD weight           DOUBLE;
ALTER TABLE KUTU.testtable  MODIFY COLUMN height           DOUBLE NOT NULL;
ALTER TABLE KUTU.testtable  MODIFY COLUMN weight           DOUBLE NOT NULL;

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /opt/lampp/htdocs/autobackup/adodb/drivers/adodb-mysql.inc.php on line 235
CREATE TABLE adoxyz (
ID               INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname LONGTEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           TIMESTAMP,
BIGFELLOW        LONGTEXT,
TS               TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);

access


Notice: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181
Warning: Access does not supported DEFAULT values (field FIRSTNAME)
Warning: Access does not supported DEFAULT values (field LASTNAME)
Warning: Access does not supported DEFAULT values (field price)
Warning: Access does not supported DEFAULT values (field MYDATE)
Warning: Access does not supported DEFAULT values (field TS)
AlterColumnSQL not supported

DROP TABLE testtable;
CREATE TABLE testtable (
ID               COUNTER,
FIRSTNAME        VARCHAR(30),
LASTNAME         VARCHAR(28) NOT NULL,
averylonglongfieldname MEMO,
price            NUMERIC(7,2),
MYDATE           DATETIME,
BIGFELLOW        MEMO,
TS               DATETIME,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON testtable (firstname,lastname);
CREATE INDEX idx2 ON testtable (price,lastname);
ALTER TABLE testtable  ADD height           DOUBLE;
ALTER TABLE testtable  ADD weight           DOUBLE;

oci8


Notice: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181

CREATE USER KUTU IDENTIFIED BY tiger;
/
GRANT CREATE SESSION, CREATE TABLE,UNLIMITED TABLESPACE,CREATE SEQUENCE TO KUTU;
/
DROP TABLE KUTU.testtable CASCADE CONSTRAINTS;
/
drop sequence seq_KUTU.testtable;
/
CREATE TABLE KUTU.testtable (
ID               DECIMAL(10) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(4000),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT TRUNC(SYSDATE),
BIGFELLOW        VARCHAR(4000),
TS               DATE DEFAULT SYSDATE,
                 PRIMARY KEY (ID, LASTNAME)
)TABLESPACE USERS;
/
DROP SEQUENCE KUTU.SEQ_testtable;
/
CREATE SEQUENCE KUTU.SEQ_testtable;
/
CREATE OR REPLACE TRIGGER KUTU.TRIG_SEQ_testtable BEFORE insert ON KUTU.testtable 
		FOR EACH ROW
		BEGIN
		  select KUTU.SEQ_testtable.nextval into :new.ID from dual;
		END;;
/
CREATE BITMAP INDEX idx ON KUTU.testtable (firstname,lastname);
/
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
/
ALTER TABLE testtable ADD (
 height           DECIMAL,
 weight           DECIMAL);
/
ALTER TABLE testtable MODIFY(
 height           DECIMAL NOT NULL,
 weight           DECIMAL NOT NULL);
/

postgres


Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181
AlterColumnSQL not supported for PostgreSQL

CREATE DATABASE KUTU LOCATION='/u01/postdata';
DROP TABLE KUTU.testtable;
drop sequence KUTU.testtable_m_id_seq;
CREATE TABLE KUTU.testtable (
ID               SERIAL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT CURRENT_DATE,
BIGFELLOW        TEXT,
TS               TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable USING HASH (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           FLOAT8;
ALTER TABLE KUTU.testtable  ADD weight           FLOAT8;

odbc_mssql


Notice: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INT IDENTITY(1,1) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT NULL,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATETIME DEFAULT GetDate(),
BIGFELLOW        TEXT NULL,
TS               DATETIME DEFAULT GetDate(),
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE CLUSTERED INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD
 height           REAL NULL,
 weight           REAL NULL;
ALTER TABLE KUTU.testtable  ALTER COLUMN height           REAL NOT NULL;
ALTER TABLE KUTU.testtable  ALTER COLUMN weight           REAL NOT NULL;

odbc


Notice: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181
AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               DECIMAL(10) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(250),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE,
BIGFELLOW        VARCHAR(250),
TS               DATE,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           DECIMAL(32,8);
ALTER TABLE KUTU.testtable  ADD weight           DECIMAL(32,8);

sybase


Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INT IDENTITY(1,1) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT NULL,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATETIME DEFAULT GetDate(),
BIGFELLOW        TEXT NULL,
TS               DATETIME NULL,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE CLUSTERED INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD
 height           REAL NULL,
 weight           REAL NULL;
ALTER TABLE KUTU.testtable  ALTER COLUMN height           REAL NOT NULL;
ALTER TABLE KUTU.testtable  ALTER COLUMN weight           REAL NOT NULL;

firebird


Notice: Use of undefined constant IBASE_DEFAULT - assumed 'IBASE_DEFAULT' in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3221

Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181
AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INTEGER NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(4000),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT cast('TODAY' as date),
BIGFELLOW        VARCHAR(4000),
TS               TIMESTAMP DEFAULT cast('NOW' as timestamp),
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           DOUBLE PRECISION;
ALTER TABLE KUTU.testtable  ADD weight           DOUBLE PRECISION;

informix


Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181
AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               SERIAL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT,
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT TODAY,
BIGFELLOW        TEXT,
TS               DATETIME DEFAULT CURRENT,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           FLOAT;
ALTER TABLE KUTU.testtable  ADD weight           FLOAT;

db2


Notice: Only variable references should be returned by reference in /opt/lampp/htdocs/autobackup/adodb/adodb.inc.php on line 3181
AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INTEGER GENERATED ALWAYS AS IDENTITY,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(3600),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT CURRENT_DATE,
BIGFELLOW        VARCHAR(3600),
TS               TIMESTAMP DEFAULT CURRENT TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable (firstname,lastname);
CREATE INDEX idx2 ON KUTU.testtable (price,lastname);
ALTER TABLE KUTU.testtable  ADD height           DOUBLE;
ALTER TABLE KUTU.testtable  ADD weight           DOUBLE;