Warning: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Declaration of ADODB2_sapdb::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-sapdb.inc.php on line 103
Warning: Declaration of ADODB2_sapdb::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-sapdb.inc.php on line 111
CREATE DATABASE KUTU; DROP TABLE KUTU.testtable; CREATE TABLE KUTU.testtable ( ID INTEGER NOT NULL DEFAULT SERIAL, FIRSTNAME VARCHAR(30) DEFAULT 'Joan', LASTNAME VARCHAR(28) NOT NULL DEFAULT 'Chen', averylonglongfieldname LONG, price FIXED(7,2) DEFAULT 0.00, MYDATE DATE DEFAULT DATE, BIGFELLOW LONG, TS_SECS TIMESTAMP DEFAULT TIMESTAMP, TS_SUBSEC TIMESTAMP DEFAULT TIMESTAMP, PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE INDEX idx ON KUTU.testtable (price, firstname, lastname); CREATE INDEX idx2 ON KUTU.testtable (price, lastname); ALTER TABLE KUTU.testtable ADD (height FLOAT(38), weight FLOAT(38)); ALTER TABLE KUTU.testtable MODIFY (height FLOAT(38) NOT NULL, weight FLOAT(38) NOT NULL);
sapdb
ALTER TABLE KUTU.table DROP ("my col", "col2_with_Quotes", A_col3, "col3(10)");
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) );
Warning: Declaration of ADODB2_sybase::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-sybase.inc.php on line 90
Warning: Declaration of ADODB2_sybase::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-sybase.inc.php on line 102
CREATE DATABASE KUTU; DROP TABLE KUTU.testtable; CREATE TABLE KUTU.testtable ( ID INT DEFAULT AUTOINCREMENT 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_SECS DATETIME NULL, TS_SUBSEC DATETIME NULL, PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE CLUSTERED INDEX idx ON KUTU.testtable (price, 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;
sybase
ALTER TABLE KUTU.table DROP COLUMN "my col", DROP COLUMN "col2_with_Quotes", DROP COLUMN A_col3, DROP COLUMN "col3(10)";
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) NULL );
CREATE DATABASE KUTU; DROP TABLE IF EXISTS 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 TEXT, price NUMERIC(7,2) DEFAULT 0.00, MYDATE TIMESTAMP, BIGFELLOW TEXT, TS_SECS TIMESTAMP, TS_SUBSEC TIMESTAMP, PRIMARY KEY (ID, LASTNAME) )ENGINE=INNODB; ALTER TABLE KUTU.`KUTU.testtable` ADD INDEX idx_name (FIRSTNAME); ALTER TABLE KUTU.`KUTU.testtable` ADD INDEX idx_lastname (LASTNAME); ALTER TABLE KUTU.`KUTU.testtable` ADD INDEX idx_date (MYDATE); ALTER TABLE KUTU.testtable ADD FULLTEXT INDEX idx (price, firstname, lastname); ALTER TABLE KUTU.testtable ADD INDEX idx2 (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;
mysql
ALTER TABLE KUTU.table DROP COLUMN `my col`; ALTER TABLE KUTU.table DROP COLUMN `col2_with_Quotes`; ALTER TABLE KUTU.table DROP COLUMN A_col3; ALTER TABLE KUTU.table DROP COLUMN `col3(10)`;
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) );
Warning: Declaration of ADODB2_access::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-access.inc.php on line 80
Warning: Declaration of ADODB2_access::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-access.inc.php on line 87
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_SECS)
Warning: Access does not supported DEFAULT values (field TS_SUBSEC)
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_SECS DATETIME, TS_SUBSEC DATETIME, PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON testtable (FIRSTNAME); CREATE INDEX idx_lastname ON testtable (LASTNAME); CREATE INDEX idx_date ON testtable (MYDATE); CREATE INDEX idx ON testtable (price, firstname, lastname); CREATE INDEX idx2 ON testtable (price, lastname); ALTER TABLE testtable ADD height DOUBLE; ALTER TABLE testtable ADD weight DOUBLE;
accessDropColumnSQL not supported
CREATE TABLE adoxyz ( LASTNAME VARCHAR(32) );
Warning: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Declaration of ADODB2_oci8::MetaType($t, $len = -1) should be compatible with ADODB_DataDict::MetaType($t, $len = -1, $fieldobj = false) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-oci8.inc.php on line 27
Warning: Declaration of ADODB2_oci8::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-oci8.inc.php on line 131
Warning: Declaration of ADODB2_oci8::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-oci8.inc.php on line 144
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 KUTU.seq_testtable; CREATE TABLE KUTU.testtable ( ID NUMBER(10) NOT NULL, FIRSTNAME VARCHAR(30) DEFAULT 'Joan', LASTNAME VARCHAR(28) DEFAULT 'Chen' NOT NULL, averylonglongfieldname VARCHAR(4000), price NUMBER(7,2) DEFAULT 0.00, MYDATE DATE DEFAULT TRUNC(SYSDATE), BIGFELLOW VARCHAR(4000), TS_SECS DATE DEFAULT SYSDATE, TS_SUBSEC TIMESTAMP DEFAULT SYSDATE, PRIMARY KEY (ID, LASTNAME) )TABLESPACE USERS; CREATE SEQUENCE KUTU.SEQ_testtable ; CREATE OR REPLACE TRIGGER KUTU.TRIG_SEQ_testtable BEFORE insert ON KUTU.testtable FOR EACH ROW WHEN (NEW.ID IS NULL OR NEW.ID = 0) BEGIN select KUTU.SEQ_testtable.nextval into :new.ID from dual; END;; CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE BITMAP INDEX idx ON KUTU.testtable (price, firstname, lastname); CREATE INDEX idx2 ON KUTU.testtable (price, lastname); ALTER TABLE testtable ADD ( height NUMBER, weight NUMBER); ALTER TABLE testtable MODIFY( height NUMBER NOT NULL, weight NUMBER NOT NULL);
oci8
ALTER TABLE table DROP("my col", "col2_with_Quotes", A_col3, "col3(10)") CASCADE CONSTRAINTS;
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) );
Warning: Declaration of ADODB2_mssql::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-mssql.inc.php on line 140
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_SECS DATETIME DEFAULT GetDate(), TS_SUBSEC DATETIME DEFAULT GetDate(), PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE CLUSTERED INDEX idx ON KUTU.testtable (price, 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;
CREATE TABLE adoxyz ( 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_SECS DATETIME DEFAULT GetDate(), TS_SUBSEC DATETIME DEFAULT GetDate(), PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON adoxyz (FIRSTNAME); CREATE INDEX idx_lastname ON adoxyz (LASTNAME); CREATE INDEX idx_date ON adoxyz (MYDATE);
mssql
ALTER TABLE table DROP COLUMN "my col", DROP COLUMN "col2_with_Quotes", DROP COLUMN A_col3, DROP COLUMN "col3(10)";
CREATE TABLE adoxyz ( LASTNAME VARCHAR(32) NULL );
Warning: Declaration of ADODB2_generic::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-generic.inc.php on line 52
Warning: Declaration of ADODB2_generic::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-generic.inc.php on line 59
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_SECS DATE, TS_SUBSEC DATE, PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE INDEX idx ON KUTU.testtable (price, 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);
genericDropColumnSQL not supported
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) );
Warning: Use of undefined constant DB2_BINARY - assumed 'DB2_BINARY' (this will throw an Error in a future version of PHP) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb.inc.php on line 4230
Warning: Declaration of ADODB2_db2::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-db2.inc.php on line 61
Warning: Declaration of ADODB2_db2::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-db2.inc.php on line 68
Warning: Declaration of ADODB2_db2::ChangeTableSQL($tablename, $flds, $tableoptions = false) should be compatible with ADODB_DataDict::ChangeTableSQL($tablename, $flds, $tableoptions = false, $dropOldFlds = false) in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-db2.inc.php on line 75
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_SECS TIMESTAMP DEFAULT CURRENT TIMESTAMP, TS_SUBSEC TIMESTAMP DEFAULT CURRENT TIMESTAMP, PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE INDEX idx ON KUTU.testtable (price, firstname, lastname); CREATE INDEX idx2 ON KUTU.testtable (price, lastname); ALTER TABLE KUTU.testtable ADD height DOUBLE; ALTER TABLE KUTU.testtable ADD weight DOUBLE;
db2DropColumnSQL not supported
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) );
Warning: Declaration of ADODB2_ibase::AlterColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-ibase.inc.php on line 52
Warning: Declaration of ADODB2_ibase::DropColumnSQL($tabname, $flds) should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /opt/lampp/htdocs/tarki_survey/classes/adodb5/datadict/datadict-ibase.inc.php on line 59
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 timestamp), BIGFELLOW VARCHAR(4000), TS_SECS TIMESTAMP DEFAULT CURRENT_TIMESTAMP, TS_SUBSEC TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (ID, LASTNAME) ); CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME); CREATE INDEX idx_lastname ON KUTU."KUTU.testtable" (LASTNAME); CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE); CREATE INDEX idx ON KUTU.testtable (price, 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;
ibaseDropColumnSQL not supported
CREATE TABLE KUTU.adoxyz ( LASTNAME VARCHAR(32) );
Fatal error: Uncaught Error: Call to undefined function pg_escape_string() in /opt/lampp/htdocs/tarki_survey/classes/adodb5/drivers/adodb-postgres64.inc.php:244
Stack trace:
#0 /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb-datadict.inc.php(779): ADODB_postgres64->qstr('Joan')
#1 /opt/lampp/htdocs/tarki_survey/classes/adodb5/adodb-datadict.inc.php(565): ADODB_DataDict->_GenFields(Array, true)
#2 /opt/lampp/htdocs/tarki_survey/classes/adodb5/tests/test-datadict.php(64): ADODB_DataDict->CreateTableSQL('testtable', '\nID ...', Array)
#3 {main}
thrown in /opt/lampp/htdocs/tarki_survey/classes/adodb5/drivers/adodb-postgres64.inc.php on line 244