List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT GET_LOCK('" . $arg . "', 10) AS ci_session_lock" | 1 |
|
| 'SELECT "colname" FROM "syscat"."columns" WHERE LOWER("tabschema") = ' . $this->escape(strtolower($this->database)) . ' AND LOWER("tabname") = ' . $this->escape(strtolower($table)) | 1 |
|
| 'SELECT "RDB$RELATION_NAME" FROM "RDB$RELATIONS" WHERE "RDB$RELATION_NAME" NOT LIKE \'RDB$%\' AND "RDB$RELATION_NAME" NOT LIKE \'MON$%\'' | 1 |
|
| 'SELECT "RDB$FIELD_NAME" FROM "RDB$RELATION_FIELDS" WHERE "RDB$RELATION_NAME" = ' . $this->escape($table) | 1 |
|
| 'SELECT pg_advisory_lock(' . $arg . ')' | 1 |
|
| 'SELECT ' . $this->escape_identifiers('TABLE_NAME') . ' FROM ' . $this->escape_identifiers('_USER_TABLES') | 1 |
|
| 'SELECT ' . $this->escape_identifiers('COLUMN_NAME') . ' FROM ' . $this->escape_identifiers('_USER_COLUMNS') . ' WHERE ' . $this->escape_identifiers('TABLE_NAME') . ' = ' . $this->escape($table) | 1 |
|
| 'SELECT * FROM ' . $this->protect_identifiers($table, TRUE, NULL, FALSE) . ' LIMIT 1' | 1 |
|
| 'SELECT "tabname" FROM "systables" WHERE "tabid" > 99 AND "tabtype" = \'T\' AND LOWER("owner") = ' . $this->escape(strtolower($this->username)) | 1 |
|
| 'SELECT "colname" FROM "systables", "syscolumns" WHERE "systables"."tabid" = "syscolumns"."tabid" AND "systables"."tabtype" = \'T\' AND LOWER("systables"."owner") = ' . $this->escape(strtolower($owner)) . ' AND LOWER("systables"."tabname") = ' . $this->escape(strtolower($table)) | 1 |
|
| 'SELECT "syscolumns"."colname" AS "name", CASE "syscolumns"."coltype" WHEN 0 THEN \'CHAR\' WHEN 1 THEN \'SMALLINT\' WHEN 2 THEN \'INTEGER\' WHEN 3 THEN \'FLOAT\' WHEN 4 THEN \'SMALLFLOAT\' WHEN 5 THEN \'DECIMAL\' WHEN 6 THEN \'SERIAL\' WHEN 7 THEN \'DATE\' WHEN 8 THEN \'MONEY\' WHEN 9 THEN \'NULL\' WHEN 10 THEN \'DATETIME\' WHEN 11 THEN \'BYTE\' WHEN 12 THEN \'TEXT\' WHEN 13 THEN \'VARCHAR\' WHEN 14 THEN \'INTERVAL\' WHEN 15 THEN \'NCHAR\' WHEN 16 THEN \'NVARCHAR\' WHEN 17 THEN \'INT8\' WHEN 18 THEN \'SERIAL8\' WHEN 19 THEN \'SET\' WHEN 20 THEN \'MULTISET\' WHEN 21 THEN \'LIST\' WHEN 22 THEN \'Unnamed ROW\' WHEN 40 THEN \'LVARCHAR\' WHEN 41 THEN \'BLOB/CLOB/BOOLEAN\' WHEN 4118 THEN \'Named ROW\' ELSE "syscolumns"."coltype" END AS "type", "syscolumns"."collength" as "max_length", CASE "sysdefaults"."type" WHEN \'L\' THEN "sysdefaults"."default" ELSE NULL END AS "default" FROM "syscolumns", "systables", "sysdefaults" WHERE "syscolumns"."tabid" = "systables"."tabid" AND "systables"."tabid" = "sysdefaults"."tabid" AND "syscolumns"."colno" = "sysdefaults"."colno" AND "systables"."tabtype" = \'T\' AND LOWER("systables"."owner") = ' . $this->escape(strtolower($this->username)) . ' AND LOWER("systables"."tabname") = ' . $this->escape(strtolower($table)) . ' ORDER BY "syscolumns"."colno"' | 1 |
|
| 'SELECT ' . ($this->qb_offset ? 'SKIP ' . $this->qb_offset : '') . 'FIRST ' . $this->qb_limit . ' ' | 1 |
|
| 'SELECT "tabname" FROM "syscat"."tables" WHERE "type" = \'T\' AND LOWER("tabschema") = ' . $this->escape(strtolower($this->database)) | 1 |
|
| 'SELECT "colname" AS "name", "typename" AS "type", "default" AS "default", "length" AS "max_length", CASE "keyseq" WHEN NULL THEN 0 ELSE 1 END AS "primary_key" FROM "syscat"."columns" WHERE LOWER("tabschema") = ' . $this->escape(strtolower($this->database)) . ' AND LOWER("tabname") = ' . $this->escape(strtolower($table)) . ' ORDER BY "colno"' | 1 |
|
| "SELECT name FROM sqlite_master WHERE type='table'" | 1 |
|
| 'SELECT * FROM (' . $sql . ') WHERE rownum > ' . $this->qb_offset | 1 |
|
| 'SELECT "NAME" FROM "SQLITE_MASTER" WHERE "TYPE" = \'table\'' | 1 |
|
| 'SELECT column_name FROM information_schema.columns WHERE table_name = ' . $this->escape($table) | 1 |
|
| 'SHOW COLUMNS FROM ' . $table | 1 |
|
| 'SELECT TOP 1 FROM ' . $table | 1 |
|
| 'SELECT TRIM("RDB$RELATION_NAME") AS TABLE_NAME FROM "RDB$RELATIONS" WHERE "RDB$RELATION_NAME" NOT LIKE \'RDB$%\' AND "RDB$RELATION_NAME" NOT LIKE \'MON$%\'' | 1 |
|
| 'SELECT TRIM("RDB$FIELD_NAME") AS COLUMN_NAME FROM "RDB$RELATION_FIELDS" WHERE "RDB$RELATION_NAME" = ' . $this->escape($table) | 1 |
|
| 'SELECT @@IDENTITY AS insert_id' | 1 |
|
| 'SELECT datname FROM pg_database' | 1 |
|
| 'SELECT pg_get_serial_sequence(\'' . $table . "', '" . $column . "') AS seq" | 1 |
|
| 'SELECT CURRVAL(\'' . $seq . "') AS ins_id" | 1 |
|
| 'SELECT TOP 1 * FROM ' . $this->protect_identifiers($table) | 1 |
|
| 'SELECT username FROM dba_users' | 1 |
|
| 'SELECT "NAME" FROM "SQLITE_MASTER" WHERE "TYPE" = \'table\'' . (($prefix_limit !== FALSE && $this->dbprefix != '') ? ' AND "NAME" LIKE \'' . $this->escape_like_str($this->dbprefix) . '%\' ' . sprintf($this->_like_escape_str, $this->_like_escape_chr) : '') | 1 |
|
| 'INSERT INTO ' . $table . ' (' . implode(', ', $keys) . ') VALUES ' . implode(', ', $values) | 1 |
|
| 'SELECT ' | 1 |
|
| 'SELECT SCOPE_IDENTITY() AS last_id' | 1 |
|
| 'SELECT @@IDENTITY AS last_id' | 1 |
|
| 'SELECT @@VERSION AS ver' | 1 |
|
| 'DELETE FROM ' . $table . $this->_compile_wh('qb_where') . ($this->qb_limit ? ' LIMIT ' . $this->qb_limit : '') | 1 |
|
| 'SELECT DISTINCT ' | 1 |
|
| 'UPDATE ' . $table . ' SET ' . implode(', ', $valstr) . $this->_compile_wh('qb_where') . $this->_compile_order_by( ) . ($this->qb_limit ? ' LIMIT ' . $this->qb_limit : '') | 1 |
|
| 'INSERT INTO ' . $table . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $values) . ')' | 1 |
|
| 'SELECT VERSION() AS ver' | 1 |
|
| 'SELECT COUNT(*) AS ' | 1 |
|
| 'SELECT @@ERROR AS code' | 1 |
|
| 'SELECT pg_advisory_unlock(' . $this->_lock . ')' | 1 |
|
| "SELECT RELEASE_LOCK('" . $this->_lock . "') AS ci_session_lock" | 1 |
|
| 'SHOW TABLES FROM ' . $this->escape_identifiers($this->database) | 2 |
|
| 'SELECT * FROM (SELECT inner_query.*, rownum rnum FROM (' . $sql . ') inner_query WHERE rownum < ' . ($this->qb_offset + $this->qb_limit + 1) . ')' . ($this->qb_offset ? ' WHERE rnum >= ' . ($this->qb_offset + 1) : '') | 2 |
|
| "INSERT ALL\n" | 2 |
|
| 'SELECT COLUMN_NAME, DATA_TYPE, CHAR_LENGTH, DATA_PRECISION, DATA_LENGTH, DATA_DEFAULT, NULLABLE FROM ALL_TAB_COLUMNS WHERE UPPER(OWNER) = ' . $this->escape(strtoupper($owner)) . ' AND UPPER(TABLE_NAME) = ' . $this->escape(strtoupper($table)) | 2 |
|
| 'SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE UPPER(OWNER) = ' . $this->escape(strtoupper($owner)) . ' AND UPPER(TABLE_NAME) = ' . $this->escape(strtoupper($table)) | 2 |
|
| 'SELECT "TABLE_NAME" FROM "ALL_TABLES"' | 2 |
|
| 'SELECT COUNT(1) AS ' | 2 |
|
| "SELECT table_name FROM information_schema.tables WHERE table_schema = '" . $this->schema . "'" | 2 |
|
| 'SHOW DATABASES' | 2 |
|
| 'SELECT "rfields"."RDB$FIELD_NAME" AS "name", CASE "fields"."RDB$FIELD_TYPE" WHEN 7 THEN \'SMALLINT\' WHEN 8 THEN \'INTEGER\' WHEN 9 THEN \'QUAD\' WHEN 10 THEN \'FLOAT\' WHEN 11 THEN \'DFLOAT\' WHEN 12 THEN \'DATE\' WHEN 13 THEN \'TIME\' WHEN 14 THEN \'CHAR\' WHEN 16 THEN \'INT64\' WHEN 27 THEN \'DOUBLE\' WHEN 35 THEN \'TIMESTAMP\' WHEN 37 THEN \'VARCHAR\' WHEN 40 THEN \'CSTRING\' WHEN 261 THEN \'BLOB\' ELSE NULL END AS "type", "fields"."RDB$FIELD_LENGTH" AS "max_length", "rfields"."RDB$DEFAULT_VALUE" AS "default" FROM "RDB$RELATION_FIELDS" "rfields" JOIN "RDB$FIELDS" "fields" ON "rfields"."RDB$FIELD_SOURCE" = "fields"."RDB$FIELD_NAME" WHERE "rfields"."RDB$RELATION_NAME" = ' . $this->escape($table) . ' ORDER BY "rfields"."RDB$FIELD_POSITION"' | 2 |
|
| 'SELECT "column_name", "data_type", "character_maximum_length", "numeric_precision", "column_default" FROM "information_schema"."columns" WHERE LOWER("table_name") = ' . $this->escape(strtolower($table)) | 2 |
|
| 'UPDATE "RDB$RELATION_FIELDS" SET "RDB$NULL_FLAG" = ' . ($field[$i]['null'] === TRUE ? 'NULL' : '1') . ' WHERE "RDB$FIELD_NAME" = ' . $this->db->escape($field[$i]['name']) . ' AND "RDB$RELATION_NAME" = ' . $this->db->escape($table) | 2 |
|
| 'SELECT ' . $select | 2 |
|
| 'SELECT "table_name" FROM "information_schema"."tables" WHERE "table_schema" = \'' . $this->schema . "'" | 2 |
|
| 'SELECT "column_name" FROM "information_schema"."columns" WHERE LOWER("table_name") = ' . $this->escape(strtolower($table)) | 2 |
|
| 'SELECT LASTVAL() AS ins_id' | 2 |
|
| 'INSERT INTO ' . $this->db->protect_identifiers($table) . ' (' . $field_str . ') VALUES (' . $val_str . ');' . $newline | 2 |
|
| 'SELECT * FROM ' . $this->db->protect_identifiers($table) | 2 |
|
| 'SHOW CREATE TABLE ' . $this->db->escape_identifiers($this->db->database . '.' . $table) | 2 |
|
| 'INSERT OR ' . parent::_replace($table, $keys, $values) | 3 |
|
| 'SHOW TABLES' | 3 |
|
| 'SELECT CASE WHEN (@@OPTIONS | 256) = @@OPTIONS THEN 1 ELSE 0 END AS qi' | 4 |
|
| 'SELECT ' . $this->escape_identifiers('name') . ' FROM ' . $this->escape_identifiers('sysobjects') . ' WHERE ' . $this->escape_identifiers('type') . " = 'U'" | 4 |
|
| 'SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE UPPER(TABLE_NAME) = ' . $this->escape(strtoupper($table)) | 4 |
|
| 'SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.Columns WHERE UPPER(TABLE_NAME) = ' . $this->escape(strtoupper($table)) | 4 |
|
| 'SELECT ' . $select . " FROM (\n\n" . preg_replace('/^(SELECT( DISTINCT)?)/i', '\\1 ROW_NUMBER() OVER(' . trim($orderby) . ') AS ' . $this->escape_identifiers('CI_rownum') . ', ', $sql) . "\n\n) " . $this->escape_identifiers('CI_subquery') . "\nWHERE " . $this->escape_identifiers('CI_rownum') . ' BETWEEN ' . ($this->qb_offset + 1) . ' AND ' . $limit | 4 |
|
| 'UPDATE ' . $table . ' SET ' . substr($cases, 0, -2) . $this->_compile_wh('qb_where') | 5 |
|
| 'DELETE FROM ' . $table | 7 |
|
| 'SHOW COLUMNS FROM ' . $this->protect_identifiers($table, TRUE, NULL, FALSE) | 10 |
|