PageRenderTime 22ms queryFilters 16ms Sphinxql 302ms app.CodeModel.GetByIds 7ms findMatchingLines 27ms GetByIds 34ms meta 0ms repositoryFilters 7ms languageFilters 1ms sourceFilters 1ms

6,312,158 results for 'select repo:boyter/batf' (22 ms)

Source

Language

Repository

props.htm https://bitbucket.org/ericson_cepeda/calubini.git | HTML | 845 lines
35				<td colspan="3">
36					<select id="text_font" name="text_font" class="mceEditableSelect mceFocus"></select>
37				</td>
43						<tr>
44							<td><select id="text_size" name="text_size" class="mceEditableSelect"></select></td>
45							<td>&nbsp;</td>
297				<td>&nbsp;&nbsp;&nbsp;<label for="box_float">{#style_dlg.box_float}</label></td>
298				<td><select id="box_float" name="box_float" class="mceEditableSelect"></select></td>
299			</tr>
584					<tr>
585						<td><select id="border_width_left" name="border_width_left" class="mceEditableSelect" disabled="disabled"></select></td>
586						<td>&nbsp;</td>
613			<td><label for="list_type">{#style_dlg.list_type}</label></td>
614			<td><select id="list_type" name="list_type" class="mceEditableSelect"></select></td>
615		</tr>
where8.test https://bitbucket.org/aware/sqlite.git | Unknown | 720 lines
60do_test where8-1.2 { 
61  execsql_status2 { SELECT c FROM t1 WHERE a = 1 OR b = 'nine' }
62} {I IX 0 0 6}
68do_test where8-1.4 { 
69  execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 't*' }
70} {IX X III II 0 0 9}
72do_test where8-1.5 { 
73  execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 'f*' }
74} {IX X V IV 0 0 9}
76do_test where8-1.6 { 
77  execsql_status { SELECT c FROM t1 WHERE a = 1 OR b = 'three' ORDER BY rowid }
78} {I III 0 1}
279  execsql_status {
280    SELECT c FROM t1 WHERE a > (SELECT d FROM t2 WHERE e = b) OR a = 5
281  }
where5.test https://bitbucket.org/aware/sqlite.git | Unknown | 289 lines
29    INSERT INTO t1 VALUES(1);
30    INSERT INTO t2 SELECT * FROM t1;
31    INSERT INTO t3 SELECT * FROM t2;
33  execsql {
34    SELECT * FROM t1 WHERE x<0
35  }
38  execsql {
39    SELECT * FROM t1 WHERE x<=0
40  }
43  execsql {
44    SELECT * FROM t1 WHERE x=0
45  }
48  execsql {
49    SELECT * FROM t1 WHERE x>=0
50  }
where2.test https://bitbucket.org/aware/sqlite.git | Unknown | 655 lines
83  queryplan {
84    SELECT * FROM t1 WHERE w=85 AND x=6 AND y=7396
85  }
123  queryplan {
124    SELECT * FROM t1 ORDER BY rowid DESC LIMIT 2
125  }
154      queryplan {
155        SELECT * FROM t1 WHERE z IN (SELECT 10207 UNION SELECT 10006)
156                         AND y IN (10000,10201)
162      queryplan {
163        SELECT * FROM t1 WHERE z IN (SELECT 10207 UNION SELECT 10006)
164                         AND y IN (SELECT 10000 UNION SELECT 10201)
192           SELECT 10207 UNION ALL SELECT 10006
193           UNION ALL SELECT 10006 UNION ALL SELECT 10207)
194        ORDER BY w
where.test https://bitbucket.org/aware/sqlite.git | Unknown | 1,263 lines
34    execsql {
35      INSERT INTO t2 SELECT 101-w, x, (SELECT max(y) FROM t1)+1-y, y FROM t1;
36    }
74do_test where-1.1.4 {
75  db eval {SELECT x, y, w FROM t1 WHERE +w=10}
76} {3 121 10}
172do_test where-1.19 {
173  count {SELECT w FROM t1 WHERE x=3 AND 225<y}
174} {15 3}
1242  execsql {
1243    SELECT a.id, (SELECT b.id FROM tbooking AS b WHERE b.id>a.id)
1244    FROM tbooking AS a
1249  execsql {
1250    SELECT a.id, (SELECT b.id FROM tbooking AS b WHERE b.id>a.id)
1251    FROM (SELECT 1.5 AS id) AS a
vtab6.test https://bitbucket.org/aware/sqlite.git | Unknown | 574 lines
54    INSERT INTO t1 VALUES(3,4,5);
55    SELECT * FROM t1;
56  }  
78  execsql2 {
79    SELECT * FROM t2 AS x NATURAL JOIN t1;
80  }
167    execsql2 {
168      SELECT * FROM (SELECT b as 'c', c as 'd', d as 'e' FROM t2) as 'tx'
169          NATURAL JOIN t1
389    execsql {
390      SELECT * FROM t9 LEFT JOIN (SELECT x, q FROM t10, t11 WHERE t10.y=t11.p)
391           ON( a=x);
427      EXCEPT
428      SELECT * FROM t12 NATURAL LEFT JOIN (SELECT * FROM t13 WHERE b>0);
429    }
vtab1.test https://bitbucket.org/aware/sqlite.git | Unknown | 1,297 lines
477} [list xBestIndex \
478        {SELECT rowid, * FROM 'treal' WHERE b LIKE (SELECT '%'||?||'%')}  \
479        xFilter \
1098  set echo_module
1099} [list xBestIndex {SELECT rowid, * FROM 'c'} xFilter {SELECT rowid, * FROM 'c'}]
1100
1104  set echo_module
1105} [list xBestIndex {SELECT rowid, * FROM 'c' WHERE rowid = ?} xFilter {SELECT rowid, * FROM 'c' WHERE rowid = ?} 1]
1106
1110  set echo_module
1111} [list xBestIndex {SELECT rowid, * FROM 'c' WHERE a = ?} xFilter {SELECT rowid, * FROM 'c' WHERE a = ?} 1]
1112
1116  set echo_module
1117} [list xBestIndex {SELECT rowid, * FROM 'c'} xFilter {SELECT rowid, * FROM 'c'}]
1118
view.test https://bitbucket.org/aware/sqlite.git | Unknown | 580 lines
29    INSERT INTO t1 VALUES(7,8,9);
30    SELECT * FROM t1;
31  }
48  execsql {
49    CREATE VIEW v1 AS SELECT a,b FROM t1;
50    SELECT * FROM v1 ORDER BY a;
158  execsql2 {
159    CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
160    SELECT * FROM v3 LIMIT 4;
439    execsql {
440      SELECT * FROM (SELECT * FROM t4) WHERE a = 'THIS';
441    }
574    CREATE TABLE t1(c1);
575    CREATE VIEW v1 AS SELECT c1 FROM (SELECT t1.c1 FROM t1);
576  }
update.test https://bitbucket.org/aware/sqlite.git | Unknown | 609 lines
41  }
42  execsql {SELECT * FROM test1 ORDER BY f1}
43} {1 2 2 4 3 8 4 16 5 32 6 64 7 128 8 256 9 512 10 1024}
68
69# verify that SELECT does not reset the change counter
70do_test update-3.5.2 {
70do_test update-3.5.2 {
71  db eval {SELECT count(*) FROM test1}
72} {10}
77do_test update-3.6 {
78  execsql {SELECT * FROM test1 ORDER BY f1}
79} {1 6 2 12 3 24 4 48 5 96 6 192 7 384 8 768 9 1536 10 3072}
84do_test update-3.8 {
85  execsql {SELECT * FROM test1 ORDER BY f1}
86} {1 2 2 4 3 8 4 16 5 32 6 192 7 384 8 768 9 1536 10 3072}
trans.test https://bitbucket.org/aware/sqlite.git | Unknown | 957 lines
28    INSERT INTO one VALUES(3,'three');
29    SELECT b FROM one ORDER BY a;
30  }
38    INSERT INTO two VALUES(10,'X');
39    SELECT b FROM two ORDER BY a;
40  }
43  sqlite3 altdb test.db
44  execsql {SELECT b FROM one ORDER BY a} altdb
45} {one two three}
46do_test trans-1.10 {
47  execsql {SELECT b FROM two ORDER BY a} altdb
48} {I V X}
80    BEGIN;
81    SELECT a FROM one ORDER BY a;
82    SELECT a FROM two ORDER BY a;
tkt2927.test https://bitbucket.org/aware/sqlite.git | Unknown | 675 lines
34    INSERT INTO t1 VALUES(5,55);
35    SELECT * FROM t1;
36  }
41  db eval {
42    SELECT a, b FROM t1
43    UNION ALL
43    UNION ALL
44    SELECT a, b FROM t1
45  }
49  db eval {
50    SELECT a, b FROM t1
51    UNION ALL
51    UNION ALL
52    SELECT a, abs(b) FROM t1
53  }
tkt2822.test https://bitbucket.org/aware/sqlite.git | Unknown | 337 lines
129  execsql {
130    SELECT t1.a, b, c FROM t1 UNION ALL SELECT t2.a, b, c FROM t2 ORDER BY t1.a;
131  }
239  execsql {
240    SELECT p PX, q QX FROM t6a UNION ALL SELECT x XX, y YX FROM t6b
241    ORDER BY XX, QX
245  execsql {
246    SELECT p PX, q QX FROM t6a UNION ALL SELECT x XX, y YX FROM t6b
247    ORDER BY QX, XX
251  execsql {
252    SELECT p PX, q QX FROM t6a UNION ALL SELECT x XX, y YX FROM t6b
253    ORDER BY t6b.x, QX
257  execsql {
258    SELECT p PX, q QX FROM t6a UNION ALL SELECT x XX, y YX FROM t6b
259    ORDER BY t6a.q, XX
temptable.test https://bitbucket.org/aware/sqlite.git | Unknown | 442 lines
36  execsql {INSERT INTO t1 VALUES(1,2,3);}
37  execsql {SELECT * FROM t1}
38} {1 2 3}
39do_test temptable-1.2 {
40  catch {db2 eval {SELECT * FROM sqlite_master}}
41  db2 eval {SELECT * FROM t1}
43do_test temptable-1.3 {
44  execsql {SELECT name FROM sqlite_master}
45} {t1}
46do_test temptable-1.4 {
47  db2 eval {SELECT name FROM sqlite_master}
48} {t1}
57  }
58  db2 eval {SELECT * FROM t2}
59} {4 5 6}
tclsqlite.test https://bitbucket.org/aware/sqlite.git | Unknown | 642 lines
50  set v [catch {
51    db eval {SELECT * FROM t1} data {
52      error "The error message"
58  set v [catch {
59    db eval {SELECT * FROM t2} data {
60      error "The error message"
66  set v [catch {
67    db eval {SELECT * FROM t1} data {
68      break
75  set v [catch {
76    db eval {SELECT * FROM t1} data {
77      expr x*
165  execsql "INSERT INTO t\u0123x VALUES(1,2.3)"
166  db eval "SELECT * FROM t\u0123x" result break
167  set result(*)
table.test https://bitbucket.org/aware/sqlite.git | Unknown | 729 lines
28  execsql {
29    SELECT sql FROM sqlite_master WHERE type!='meta'
30  }
48  sqlite3 db test.db
49  execsql {SELECT name, tbl_name, type from sqlite_master WHERE type!='meta'}
50} {test1 test1 table}
55  execsql {DROP TABLE test1}
56  execsql {SELECT * FROM sqlite_master WHERE type!='meta'}
57} {}
64  sqlite3 db test.db
65  execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
66} {}
586    execsql {
587      CREATE TABLE t8 AS SELECT b, h, a as i, (SELECT f FROM t7) as j FROM t7;
588    }
subselect.test https://bitbucket.org/aware/sqlite.git | Unknown | 211 lines
34  }
35  execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
36} {3 4}
50do_test subselect-1.3b {
51  execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
52} {4}
102  execsql {
103    SELECT (SELECT a FROM t1 ORDER BY a), (SELECT a FROM t1 ORDER BY a DESC)
104  }
195    INSERT INTO t4 VALUES('c','3');
196    SELECT a FROM t4 WHERE b IN (SELECT b FROM t4 ORDER BY b);
197  }
205  execsql {
206    SELECT a FROM t4 WHERE b IN (SELECT b FROM t4 ORDER BY b DESC LIMIT 1);
207  }
subquery.test https://bitbucket.org/aware/sqlite.git | Unknown | 585 lines
107  execsql {
108    SELECT * FROM (SELECT (SELECT a), b FROM t1);
109  }
408  catchsql {
409    SELECT max((SELECT a FROM (SELECT count(x) AS a FROM t35b))) FROM t35a;
410  }
413  execsql {
414    SELECT max((SELECT a FROM (SELECT count(y) AS a FROM t35b))) FROM t35a;
415  }
568  execsql {
569    SELECT (SELECT (SELECT c7+max(c8)+c9 FROM t9) FROM t8) FROM t7
570  }
573  execsql {
574    SELECT (SELECT (SELECT c7+c8+max(c9) FROM t9) FROM t8) FROM t7
575  }
sqllimits1.test https://bitbucket.org/aware/sqlite.git | Unknown | 845 lines
36do_test sqllimits1-1.5 {
37  sqlite3_limit db SQLITE_LIMIT_COMPOUND_SELECT -1
38} $SQLITE_MAX_COMPOUND_SELECT
110  do_test sqllimits1-2.5.1 {
111    sqlite3_limit db SQLITE_LIMIT_COMPOUND_SELECT \
112                    [expr {$::SQLITE_MAX_COMPOUND_SELECT/2}]
112                    [expr {$::SQLITE_MAX_COMPOUND_SELECT/2}]
113  } $SQLITE_MAX_COMPOUND_SELECT
114  do_test sqllimits1-2.5.2 {
588  }
589  catchsql "SELECT sql4 FROM (SELECT [join $cols ,] FROM sqlite_master)"
590} {1 {too many columns in result set}}
654  }
655  set sql "SELECT c, c+1, c+2 FROM t1 UNION SELECT c-1, c-2, c-3 FROM t1"
656  append sql " ORDER BY [join $cols ,]"
sort.test https://bitbucket.org/aware/sqlite.git | Unknown | 468 lines
302  execsql {
303    SELECT a FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
304  }
317  execsql {
318    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
319  }
341#  execsql {
342#    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE blob;
343#  }
346#  execsql {
347#    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE clob;
348#  }
351#  execsql {
352#    SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE varchar;
353#  }
shared4.test https://bitbucket.org/aware/sqlite.git | Unknown | 238 lines
77  db1 eval {
78     SELECT a FROM t1 UNION ALL
79     SELECT b FROM t2 UNION ALL
79     SELECT b FROM t2 UNION ALL
80     SELECT c FROM t3 UNION ALL
81     SELECT d FROM t4;
85  db2 eval {
86     SELECT a FROM t1 UNION ALL
87     SELECT b FROM t2 UNION ALL
87     SELECT b FROM t2 UNION ALL
88     SELECT d FROM t4 UNION ALL
89     SELECT c FROM t3;
93  db3 eval {
94     SELECT a FROM t1 UNION ALL
95     SELECT c FROM t3 UNION ALL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21