Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 29) sorted by relevance

12

/titanic_41/usr/src/lib/libsqlite/test/
H A Dtester.tcl195 proc execsql {sql {db db}} {
197 return [$db eval $sql]
202 proc catchsql {sql {db db}} {
204 set r [catch {$db eval $sql} msg]
211 proc explain {sql {db db}} {
215 $db eval "explain $sql" {} {
223 proc execsql2 {sql} { argument
225 db eval $sql data {
235 proc stepsql {dbptr sql} { argument
236 set sql [string trim $sql]
[all …]
H A Dtableapi.test170 set sql "CREATE TABLE t2("
173 append sql ${sep}x$i
176 append sql )
177 sqlite_get_table_printf $::dbx $sql {}
178 set sql "INSERT INTO t2 VALUES("
181 append sql ${sep}$i
184 append sql )
185 sqlite_get_table_printf $::dbx $sql {}
189 set sql "INSERT INTO t2 VALUES("
192 append sql ${sep}[expr {$i+1000}]
[all …]
H A Dinterrupt.test26 set txt [$db eval {SELECT name, type, sql FROM sqlite_master}]\n
38 # This routine attempts to execute the sql in $sql. It triggers an
43 proc interrupt_test {testid sql result {initcnt 0} {maxcnt 1000000}} {
54 } [list $sql]] 1
156 set sql {
160 execsql $sql
165 catchsql $sql
H A Djoin3_28.test31 set sql "SELECT * FROM t1"
32 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
33 execsql $sql
H A Dtable.test32 SELECT sql FROM sqlite_master WHERE type!='meta'
169 execsql {SELECT sql FROM sqlite_master WHERE type=='table'}
202 set sql "CREATE TABLE [format test%03d $i] ("
204 append sql "field$k text,"
206 append sql "last_field text)"
207 execsql $sql
226 set sql "DROP TABLE [format TEST%03d $i]"
227 execsql $sql
237 set sql "DROP TABLE [format test%03d $i]"
238 execsql $sql
[all …]
H A Drowid.test44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
45 execsql $sql
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
50 execsql $sql
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
55 execsql $sql
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
60 execsql $sql
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
65 execsql $sql
[all …]
H A Dbigrow.test47 set sql "INSERT INTO t1 VALUES('abc',"
48 append sql "'$::big1', 'xyz');"
49 execsql $sql
57 set sql "INSERT INTO t1 VALUES('abc2',"
58 append sql "'$::big2', 'xyz2');"
59 set r [catch {execsql $sql} msg]
H A Dselect2.test37 set sql {SELECT DISTINCT f1 FROM tbl1 ORDER BY f1}
39 db eval $sql data {
51 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
53 db eval $sql data {
H A Dtrans.test692 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
700 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
744 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
756 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
771 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
782 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
808 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
H A Dindex.test30 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
36 execsql {SELECT name, sql, tbl_name, type FROM sqlite_master
85 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
86 execsql $sql
H A Dformat3.test255 proc count sql {
257 return [concat [execsql $sql] $::sqlite_search_count]
565 proc cksort {sql} {
566 set data [execsql $sql]
567 set prog [execsql "EXPLAIN $sql"]
H A Dwhere.test47 proc count sql {
49 return [concat [execsql $sql] $::sqlite_search_count]
366 proc cksort {sql} {
367 set data [execsql $sql]
368 set prog [execsql "EXPLAIN $sql"]
H A Dlock.test297 proc tx_exec {sql} {
298 db2 eval $sql
H A Dioerr.test63 set txt [$db eval {SELECT name, type, sql FROM sqlite_master}]\n
H A Dvacuum.test23 set txt [$db eval {SELECT name, type, sql FROM sqlite_master}]\n
H A Dintpkey.test248 proc count sql {
250 return [concat [execsql $sql] $::sqlite_search_count]
/titanic_41/usr/src/lib/smbsrv/libsmb/common/
H A Dsmb_lgrp.c799 char *sql; in smb_lgrp_iteropen() local
810 sql = sqlite_mprintf("SELECT * FROM groups"); in smb_lgrp_iteropen()
811 if (sql == NULL) { in smb_lgrp_iteropen()
818 sqlite_freemem(sql); in smb_lgrp_iteropen()
823 rc = sqlite_compile(iter->sgi_db, sql, NULL, &iter->sgi_vm, &errmsg); in smb_lgrp_iteropen()
824 sqlite_freemem(sql); in smb_lgrp_iteropen()
1317 char *sql; in smb_lgrp_gtbl_lookup() local
1333 sql = sqlite_mprintf("SELECT * FROM groups WHERE name = '%s'", in smb_lgrp_gtbl_lookup()
1353 sql = sqlite_mprintf("SELECT * FROM groups " in smb_lgrp_gtbl_lookup()
1364 if (sql == NULL) in smb_lgrp_gtbl_lookup()
[all …]
H A Dsmb_nic.c735 char *sql; in smb_nic_hlist_dbget() local
739 sql = sqlite_mprintf("SELECT * FROM hosts"); in smb_nic_hlist_dbget()
740 if (sql == NULL) in smb_nic_hlist_dbget()
745 sqlite_freemem(sql); in smb_nic_hlist_dbget()
749 rc = sqlite_compile(db, sql, NULL, &vm, &errmsg); in smb_nic_hlist_dbget()
750 sqlite_freemem(sql); in smb_nic_hlist_dbget()
992 char *sql; in smb_nic_dbvalidate() local
998 sql = sqlite_mprintf("SELECT * FROM db_info"); in smb_nic_dbvalidate()
999 if (sql == NULL) in smb_nic_dbvalidate()
1004 sqlite_freemem(sql); in smb_nic_dbvalidate()
[all …]
/titanic_41/usr/src/lib/libsqlite/tool/
H A Dspeedtest2.tcl19 set sql [string trim [read $fd [file size $sqlfile]]]
21 set sx [split $sql \n]
24 set sql {}
25 for {set i 0} {$i<3} {incr i} {append sql [lindex $sx $i]<br>\n}
26 append sql "<i>... [expr {$n-6}] lines omitted</i><br>\n"
28 append sql [lindex $sx $i]<br>\n
31 regsub -all \n [string trim $sql] <br> sql
34 puts "$sql"
H A Dspeedtest.tcl19 set sql [string trim [read $fd [file size $sqlfile]]]
21 set sx [split $sql \n]
24 set sql {}
25 for {set i 0} {$i<3} {incr i} {append sql [lindex $sx $i]<br>\n}
26 append sql "<i>... [expr {$n-6}] lines omitted</i><br>\n"
28 append sql [lindex $sx $i]<br>\n
31 regsub -all \n [string trim $sql] <br> sql
34 puts "$sql"
H A Dspace_used.tcl39 set sql {
56 foreach {name type rootpage} [db eval $sql] {
H A Dspaceanal.tcl56 set sql {
66 foreach {name tblname type rootpage} [db eval $sql] {
103 set sql "INSERT INTO space_used VALUES('$name'"
105 append sql ",'$tblname',[expr {$type=="index"}],$n_entry"
106 append sql ",$size,$mx_size,$cnt_ovfl,"
107 append sql "$n_primary,$n_overflow,$unused_primary,$unused_ovfl);"
108 mem eval $sql
/titanic_41/usr/src/cmd/idmap/idmapd/
H A Ddbutils.c217 static int sql_exec_tran_no_cb(sqlite *db, char *sql, const char *dbname,
227 const char *detect_version_sql, char * const *sql, in init_db_instance() argument
307 sql[curr_version]); in init_db_instance()
309 rc = sql_exec_tran_no_cb(db, sql[curr_version], dbname, in init_db_instance()
449 char *sql[4]; in init_dbs() local
453 sql[0] = DB_INSTALL_SQL; in init_dbs()
454 sql[1] = DB_UPGRADE_FROM_v1_SQL; in init_dbs()
455 sql[2] = NULL; in init_dbs()
457 if (init_db_instance(IDMAP_DBNAME, DB_VERSION, DB_VERSION_SQL, sql, in init_dbs()
462 sql[0] = CACHE_INSTALL_SQL; in init_dbs()
[all …]
H A Dserver.c60 #define PROCESS_LIST_SVC_SQL(rcode, db, dbname, sql, limit, flag, cb, res, len)\ argument
61 rcode = process_list_svc_sql(db, dbname, sql, limit, flag, cb, res);\
657 char *sql = NULL; in idmap_list_mappings_1_svc() local
698 sql = sqlite_mprintf("SELECT rowid, sidprefix, rid, pid, w2u, " in idmap_list_mappings_1_svc()
707 if (sql == NULL) { in idmap_list_mappings_1_svc()
714 PROCESS_LIST_SVC_SQL(retcode, cache, IDMAP_CACHENAME, sql, limit, in idmap_list_mappings_1_svc()
718 if (sql) in idmap_list_mappings_1_svc()
719 sqlite_freemem(sql); in idmap_list_mappings_1_svc()
807 char *sql = NULL; in idmap_list_namerules_1_svc() local
846 sql = sqlite_mprintf("SELECT rowid, is_user, is_wuser, windomain, " in idmap_list_namerules_1_svc()
[all …]
/titanic_41/usr/src/uts/common/os/
H A Dstrsubr.c4561 syncql_t *sql, *sql2; in strlock() local
4621 for (sql = sqlist->sqlist_head; sql; sql = sql->sql_next) { in strlock()
4622 syncq_t *sq = sql->sql_sq; in strlock()
4645 for (sql2 = sqlist->sqlist_head; sql2 != sql; in strlock()
4684 syncql_t *sql; in strunlock() local
4701 for (sql = sqlist->sqlist_head; sql; sql = sql->sql_next) { in strunlock()
4702 SQ_PUTLOCKS_EXIT(sql->sql_sq); in strunlock()
4703 mutex_exit(SQLOCK(sql->sql_sq)); in strunlock()
5264 syncql_t *sql; in strblock() local
5277 for (sql = sqlist->sqlist_head; sql != NULL; sql = sql->sql_next) in strblock()
[all …]

12