Home
last modified time | relevance | path

Searched refs:sql1 (Results 1 – 25 of 490) sorted by relevance

12345678910>>...20

/dports/databases/sqlite3/sqlite-src-3350500/test/
H A Dexists.test89 sql1 { DROP TABLE IF EXISTS t1 }
91 sql1 { DROP TABLE IF EXISTS t1 }
98 sql1 { CREATE TABLE t2(x) }
99 sql1 { DROP INDEX IF EXISTS i2 }
101 sql1 { DROP INDEX IF EXISTS i2 }
108 sql1 { DROP VIEW IF EXISTS v1 }
110 sql1 { DROP VIEW IF EXISTS v1 }
144 sql1 { DROP TABLE IF EXISTS t1 }
153 sql1 { CREATE TABLE aux.t2(x) }
175 sql1 { DROP VIEW IF EXISTS v1 }
[all …]
H A Dbackcompat.test162 do_test backcompat-1.1.1 { sql1 {
180 do_test backcompat-1.2.1 { sql1 {
194 do_test backcompat-1.2.3 { sql1 {
218 sql1 {
233 sql1 {
243 sql1 {
270 do_test backcompat-2.1.1 { sql1 {
295 do_test backcompat-2.1.4 { sql1 {
339 do_test backcompat-3.3 { sql1 {
402 sql1 {
[all …]
/dports/databases/sqlcipher/sqlcipher-3.4.2/test/
H A Dexists.test89 sql1 { DROP TABLE IF EXISTS t1 }
91 sql1 { DROP TABLE IF EXISTS t1 }
98 sql1 { CREATE TABLE t2(x) }
99 sql1 { DROP INDEX IF EXISTS i2 }
101 sql1 { DROP INDEX IF EXISTS i2 }
108 sql1 { DROP VIEW IF EXISTS v1 }
110 sql1 { DROP VIEW IF EXISTS v1 }
144 sql1 { DROP TABLE IF EXISTS t1 }
153 sql1 { CREATE TABLE aux.t2(x) }
175 sql1 { DROP VIEW IF EXISTS v1 }
[all …]
H A Dbackcompat.test162 do_test backcompat-1.1.1 { sql1 {
180 do_test backcompat-1.2.1 { sql1 {
194 do_test backcompat-1.2.3 { sql1 {
218 sql1 {
233 sql1 {
243 sql1 {
270 do_test backcompat-2.1.1 { sql1 {
295 do_test backcompat-2.1.4 { sql1 {
339 do_test backcompat-3.3 { sql1 {
402 sql1 {
[all …]
/dports/www/chromium-legacy/chromium-88.0.4324.182/third_party/sqlite/src/test/
H A Dexists.test89 sql1 { DROP TABLE IF EXISTS t1 }
91 sql1 { DROP TABLE IF EXISTS t1 }
98 sql1 { CREATE TABLE t2(x) }
99 sql1 { DROP INDEX IF EXISTS i2 }
101 sql1 { DROP INDEX IF EXISTS i2 }
108 sql1 { DROP VIEW IF EXISTS v1 }
110 sql1 { DROP VIEW IF EXISTS v1 }
144 sql1 { DROP TABLE IF EXISTS t1 }
153 sql1 { CREATE TABLE aux.t2(x) }
175 sql1 { DROP VIEW IF EXISTS v1 }
[all …]
H A Dbackcompat.test162 do_test backcompat-1.1.1 { sql1 {
180 do_test backcompat-1.2.1 { sql1 {
194 do_test backcompat-1.2.3 { sql1 {
218 sql1 {
233 sql1 {
243 sql1 {
270 do_test backcompat-2.1.1 { sql1 {
295 do_test backcompat-2.1.4 { sql1 {
339 do_test backcompat-3.3 { sql1 {
402 sql1 {
[all …]
/dports/databases/db5/db-5.3.28/lang/sql/sqlite/test/
H A Dexists.test88 sql1 { DROP TABLE IF EXISTS t1 }
90 sql1 { DROP TABLE IF EXISTS t1 }
97 sql1 { CREATE TABLE t2(x) }
98 sql1 { DROP INDEX IF EXISTS i2 }
100 sql1 { DROP INDEX IF EXISTS i2 }
107 sql1 { DROP VIEW IF EXISTS v1 }
109 sql1 { DROP VIEW IF EXISTS v1 }
143 sql1 { DROP TABLE IF EXISTS t1 }
152 sql1 { CREATE TABLE aux.t2(x) }
174 sql1 { DROP VIEW IF EXISTS v1 }
[all …]
/dports/www/dolibarr13/dolibarr-13.0.5/htdocs/accountancy/expensereport/
H A Dindex.php74 $sql1 = "UPDATE ".MAIN_DB_PREFIX."expensereport_det as erd"; variable
75 $sql1 .= " SET fk_code_ventilation = 0";
76 $sql1 .= ' WHERE erd.fk_code_ventilation NOT IN';
77 $sql1 .= ' (SELECT accnt.rowid ';
82 $sql1 .= ' AND fk_code_ventilation <> 0';
84 $resql1 = $db->query($sql1);
101 $sql1 = "UPDATE ".MAIN_DB_PREFIX."expensereport_det"; variable
102 $sql1 .= " SET fk_code_ventilation = accnt.rowid";
109 $sql1 .= " SET erd.fk_code_ventilation = accnt.rowid";
112 $sql1 .= " AND erd.fk_code_ventilation = 0";
[all …]
/dports/net/freeradius3/freeradius-server-3.0.25/doc/configuration/
H A Dload_balance.rst21 sql1
46 This says "load balance between sql1 and sql2, but if sql1 is down,
82 This says "try to load balance between sql1 and sql2; if sql1 is down,
83 use sql2; if sql2 is down use sql1; if both sql1 and sql2 are down,
95 sql1
106 } # sql1, etc.
112 sql1
115 sql1
124 sql1
129 sql1
[all …]
/dports/www/dolibarr/dolibarr-14.0.3/htdocs/accountancy/expensereport/
H A Dindex.php76 $sql1 = "UPDATE ".MAIN_DB_PREFIX."expensereport_det as erd"; variable
77 $sql1 .= " SET fk_code_ventilation = 0";
78 $sql1 .= ' WHERE erd.fk_code_ventilation NOT IN';
79 $sql1 .= ' (SELECT accnt.rowid ';
84 $sql1 .= ' AND fk_code_ventilation <> 0';
86 $resql1 = $db->query($sql1);
103 $sql1 = "UPDATE ".MAIN_DB_PREFIX."expensereport_det"; variable
104 $sql1 .= " SET fk_code_ventilation = accnt.rowid";
111 $sql1 .= " SET erd.fk_code_ventilation = accnt.rowid";
114 $sql1 .= " AND erd.fk_code_ventilation = 0";
[all …]
/dports/databases/p5-SQL-Abstract/SQL-Abstract-2.000001/lib/SQL/Abstract/
H A DTest.pm87 my $same_sql = eq_sql($sql1, $sql2);
96 _sql_differ_diag($sql1, $sql2);
107 my ($sql1, $sql2, $msg) = @_;
110 my $same_sql = eq_sql($sql1, $sql2);
118 _sql_differ_diag($sql1, $sql2);
159 my $sql1 = shift || '';
166 $_ = $sqlat->format($_) for ($sql1, $sql2);
171 ." got: $sql1\n"
189 return eq_sql($sql1, $sql2) && eq_bind($bind_ref1, $bind_ref2);
196 my ($sql1, $sql2) = @_;
[all …]
/dports/databases/postgis25/postgis-2.5.5/topology/test/regress/
H A Dst_remedgemodface.sql27 sql1 text;
31 sql1 := 'node_id,
38 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
44 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
72 sql1 text;
76 sql1 := 'edge_id,
84 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
90 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
114 sql1 text;
118 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
H A Dst_remedgenewface.sql27 sql1 text;
31 sql1 := 'node_id,
38 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
44 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
72 sql1 text;
76 sql1 := 'edge_id,
84 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
90 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
114 sql1 text;
118 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
/dports/databases/postgis32/postgis-3.2.0/topology/test/regress/
H A Dst_remedgemodface.sql25 sql1 text;
29 sql1 := 'node_id,
36 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
42 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
70 sql1 text;
74 sql1 := 'edge_id,
82 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
88 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
112 sql1 text;
116 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
H A Dst_remedgenewface.sql25 sql1 text;
29 sql1 := 'node_id,
36 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
42 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
70 sql1 text;
74 sql1 := 'edge_id,
82 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
88 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
112 sql1 text;
116 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
/dports/databases/postgis30/postgis-3.0.4/topology/test/regress/
H A Dst_remedgemodface.sql25 sql1 text;
29 sql1 := 'node_id,
36 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
42 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
70 sql1 text;
74 sql1 := 'edge_id,
82 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
88 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
112 sql1 text;
116 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
H A Dst_remedgenewface.sql25 sql1 text;
29 sql1 := 'node_id,
36 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
42 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
70 sql1 text;
74 sql1 := 'edge_id,
82 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
88 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
112 sql1 text;
116 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
/dports/databases/postgis31/postgis-3.1.4/topology/test/regress/
H A Dst_remedgemodface.sql25 sql1 text;
29 sql1 := 'node_id,
36 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
42 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
70 sql1 text;
74 sql1 := 'edge_id,
82 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
88 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
112 sql1 text;
116 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
H A Dst_remedgenewface.sql25 sql1 text;
29 sql1 := 'node_id,
36 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
42 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
70 sql1 text;
74 sql1 := 'edge_id,
82 'SELECT ' || quote_literal(lbl) || ',''+'' as op,' || sql1 ||
88 'SELECT ' || quote_literal(lbl) || ',''-'',' || sql1 ||
112 sql1 text;
116 sql1 := 'face_id, ST_AsEWKT(mbr) FROM city_data.face';
[all …]
/dports/devel/fpc-fcl-db/fpc-3.2.2/packages/fcl-db/tests/
H A Dsqldbtoolsunit.pas467 Sql,sql1: String;
505 sql1 := sql1 + ',' + testValues[FType,CountID]
510 … sql1 := sql1 + ', HEXTORAW(' + QuotedStr(String2Hex(testValues[FType,CountID])) + ') '
516 sql1 := sql1 + ', DATE ' + QuotedStr(testValues[FType,CountID])
522 sql1 := sql1 + ', TIMESTAMP ' + QuotedStr(testValues[FType,CountID])
524 sql1 := sql1 + ', DATE ' + QuotedStr(testValues[FType,CountID]);
530 sql1 := sql1 + ', TIMESTAMP ' + QuotedStr('0001-01-01 '+testValues[FType,CountID])
532 sql1 := sql1 + ',' + QuotedStr(testValues[FType,CountID])
534 sql1 := sql1 + ',NULL';
537 Sql1 := sql1+ ')';
[all …]
/dports/lang/fpc-source/fpc-3.2.2/packages/fcl-db/tests/
H A Dsqldbtoolsunit.pas467 Sql,sql1: String;
505 sql1 := sql1 + ',' + testValues[FType,CountID]
510 … sql1 := sql1 + ', HEXTORAW(' + QuotedStr(String2Hex(testValues[FType,CountID])) + ') '
516 sql1 := sql1 + ', DATE ' + QuotedStr(testValues[FType,CountID])
522 sql1 := sql1 + ', TIMESTAMP ' + QuotedStr(testValues[FType,CountID])
524 sql1 := sql1 + ', DATE ' + QuotedStr(testValues[FType,CountID]);
530 sql1 := sql1 + ', TIMESTAMP ' + QuotedStr('0001-01-01 '+testValues[FType,CountID])
532 sql1 := sql1 + ',' + QuotedStr(testValues[FType,CountID])
534 sql1 := sql1 + ',NULL';
537 Sql1 := sql1+ ')';
[all …]
/dports/devel/spark/spark-2.1.1/sql/core/src/test/scala/org/apache/spark/sql/execution/command/
H A DDDLCommandSuite.scala88 val parsed1 = parser.parsePlan(sql1)
127 val parsed1 = parser.parsePlan(sql1)
152 val parsed1 = parser.parsePlan(sql1)
167 val sql1 = constant
179 val parsed1 = parser.parsePlan(sql1)
207 val parsed1 = parser.parsePlan(sql1)
482 val parsed1 = parser.parsePlan(sql1)
524 val sql1 = constant
726 val sql1 = "SHOW DATABASES" constant
825 val sql1 = "SHOW COLUMNS FROM t1" constant
[all …]
/dports/net-mgmt/pandorafms_console/pandorafms_console-6.0SP2/operation/agentes/
H A Dexport_csv.php62 $sql1=" variable
69 $sql1 = " variable
76 $sql1 = " variable
82 $result1 = db_get_all_rows_sql ($sql1, true);
/dports/databases/sqlcipher/sqlcipher-3.4.2/ext/fts5/test/
H A Dfts5multiclient.test24 sql1 { CREATE VIRTUAL TABLE t1 USING fts5(x, detail=%DETAIL%) }
25 sql1 { INSERT INTO t1 VALUES('a b c') }
31 sql1 { SELECT rowid FROM t1('b') }
36 sql1 { SELECT rowid FROM t1('b') }
41 sql1 { INSERT INTO t1 VALUES('a b c') }
/dports/databases/sqlite3/sqlite-src-3350500/ext/fts5/test/
H A Dfts5multiclient.test24 sql1 { CREATE VIRTUAL TABLE t1 USING fts5(x, detail=%DETAIL%) }
25 sql1 { INSERT INTO t1 VALUES('a b c') }
31 sql1 { SELECT rowid FROM t1('b') }
36 sql1 { SELECT rowid FROM t1('b') }
41 sql1 { INSERT INTO t1 VALUES('a b c') }

12345678910>>...20