Home
last modified time | relevance | path

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

12

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dtester.tcl193 proc execsql {sql {db db}} {
195 return [$db eval $sql]
200 proc catchsql {sql {db db}} {
209 proc explain {sql {db db}} {
213 $db eval "explain $sql" {} {
221 proc execsql2 {sql} { argument
223 db eval $sql data {
233 proc stepsql {dbptr sql} { argument
234 set sql [string trim $sql]
236 while {[string length $sql]>0} {
[all …]
H A Dtableapi.test168 set sql "CREATE TABLE t2("
171 append sql ${sep}x$i
174 append sql )
175 sqlite_get_table_printf $::dbx $sql {}
176 set sql "INSERT INTO t2 VALUES("
179 append sql ${sep}$i
182 append sql )
183 sqlite_get_table_printf $::dbx $sql {}
187 set sql "INSERT INTO t2 VALUES("
190 append sql ${sep}[expr {$i+1000}]
[all …]
H A Dinterrupt.test24 set txt [$db eval {SELECT name, type, sql FROM sqlite_master}]\n
36 # This routine attempts to execute the sql in $sql. It triggers an
41 proc interrupt_test {testid sql result {initcnt 0} {maxcnt 1000000}} {
52 } [list $sql]] 1
154 set sql {
158 execsql $sql
163 catchsql $sql
H A Djoin3_28.test29 set sql "SELECT * FROM t1"
30 for {set i 2} {$i<=$N} {incr i} {append sql ", t$i"}
31 execsql $sql
H A Dtable.test30 SELECT sql FROM sqlite_master WHERE type!='meta'
200 set sql "CREATE TABLE [format test%03d $i] ("
202 append sql "field$k text,"
204 append sql "last_field text)"
205 execsql $sql
224 set sql "DROP TABLE [format TEST%03d $i]"
225 execsql $sql
235 set sql "DROP TABLE [format test%03d $i]"
236 execsql $sql
316 SELECT sql FROM sqlite_master WHERE name='t2';
[all …]
H A Drowid.test42 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
43 execsql $sql
47 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
48 execsql $sql
52 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
53 execsql $sql
57 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
58 execsql $sql
63 execsql $sql
136 execsql $sql
[all …]
H A Dbigrow.test45 set sql "INSERT INTO t1 VALUES('abc',"
46 append sql "'$::big1', 'xyz');"
47 execsql $sql
55 set sql "INSERT INTO t1 VALUES('abc2',"
56 append sql "'$::big2', 'xyz2');"
57 set r [catch {execsql $sql} msg]
H A Dselect2.test35 set sql {SELECT DISTINCT f1 FROM tbl1 ORDER BY f1}
37 db eval $sql data {
49 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
51 db eval $sql data {
H A Dtrans.test690 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
698 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
742 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
754 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
769 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
780 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
806 execsql {SELECT md5sum(type,name,tbl_name,rootpage,sql) FROM sqlite_master}
/illumos-gate/usr/src/lib/smbsrv/libsmb/common/
H A Dsmb_lgrp.c803 char *sql; in smb_lgrp_iteropen() local
1321 char *sql; in smb_lgrp_gtbl_lookup() local
1405 char *sql; in smb_lgrp_gtbl_exists() local
1439 char *sql; in smb_lgrp_gtbl_count() local
1481 char *sql; in smb_lgrp_gtbl_insert() local
1530 char *sql; in smb_lgrp_gtbl_delete() local
1565 char *sql; in smb_lgrp_gtbl_update() local
1624 char *sql; in smb_lgrp_gtbl_update_mlist() local
1719 char *sql; in smb_lgrp_gtbl_update_plist() local
1804 char *sql; in smb_lgrp_dtbl_insert() local
[all …]
H A Dsmb_nic.c735 char *sql; in smb_nic_hlist_dbget() local
740 if (sql == NULL) in smb_nic_hlist_dbget()
992 char *sql; in smb_nic_dbvalidate() local
999 if (sql == NULL) in smb_nic_dbvalidate()
1039 if (sql == NULL) { in smb_nic_dbvalidate()
1069 char *sql; in smb_nic_dbaddhost() local
1075 if (sql == NULL) in smb_nic_dbaddhost()
1102 char *sql; in smb_nic_dbdelhost() local
1107 if (sql == NULL) in smb_nic_dbdelhost()
1139 char *sql; in smb_nic_dbsetinfo() local
[all …]
/illumos-gate/usr/src/tools/smatch/src/smatch_data/db/
H A Dfill_db_caller_info.pl67 my ($fn, $dummy, $sql);
85 ($dummy, $dummy, $sql) = split(/:/, $_, 3);
87 if ($sql =~ /%call_marker%/) {
88 $sql =~ s/%call_marker%//; # don't need this taking space in the db.
91 $sql =~ s/%CALL_ID%/$call_id/;
93 $db->do($sql);
H A Dfill_db_sql.pl22 my ($dummy, $sql);
30 ($dummy, $dummy, $sql) = split(/:/, $_, 3);
32 $db->do($sql);
42 ($dummy, $dummy, $sql) = split(/:/, $_, 3);
44 $db->do($sql);
H A Dcreate_db.sh27 if [ -e ${info_file}.sql ] ; then
28 ${bin_dir}/fill_db_sql.pl "$PROJ" ${info_file}.sql $db_file
H A Dfill_db_type_size.pl133 my $sql = "insert into type_size values ('$type', '$printed_range');";
134 $db->do($sql);
H A Dfill_db_type_value.pl137 my $sql = "insert into type_value values ('$type', '$printed_range');";
138 $db->do($sql);
/illumos-gate/usr/src/lib/libsqlite/tool/
H A Dspeedtest2.tcl16 set sql [string trim [read $fd [file size $sqlfile]]]
18 set sx [split $sql \n]
21 set sql {}
22 for {set i 0} {$i<3} {incr i} {append sql [lindex $sx $i]<br>\n}
23 append sql "<i>... [expr {$n-6}] lines omitted</i><br>\n"
25 append sql [lindex $sx $i]<br>\n
28 regsub -all \n [string trim $sql] <br> sql
31 puts "$sql"
H A Dspeedtest.tcl16 set sql [string trim [read $fd [file size $sqlfile]]]
18 set sx [split $sql \n]
21 set sql {}
22 for {set i 0} {$i<3} {incr i} {append sql [lindex $sx $i]<br>\n}
23 append sql "<i>... [expr {$n-6}] lines omitted</i><br>\n"
25 append sql [lindex $sx $i]<br>\n
28 regsub -all \n [string trim $sql] <br> sql
31 puts "$sql"
H A Dspace_used.tcl36 set sql {
53 foreach {name type rootpage} [db eval $sql] {
H A Dspaceanal.tcl53 set sql {
63 foreach {name tblname type rootpage} [db eval $sql] {
100 set sql "INSERT INTO space_used VALUES('$name'"
102 append sql ",'$tblname',[expr {$type=="index"}],$n_entry"
103 append sql ",$size,$mx_size,$cnt_ovfl,"
104 append sql "$n_primary,$n_overflow,$unused_primary,$unused_ovfl);"
105 mem eval $sql
/illumos-gate/usr/src/cmd/idmap/idmapd/
H A Ddbutils.c495 char *sql[4]; in init_dbs() local
501 sql[2] = NULL; in init_dbs()
511 sql[3] = NULL; in init_dbs()
1015 if (sql != NULL) in add_namerule()
1065 if (sql != NULL) in rm_namerule()
3271 if (sql != NULL) in name_based_mapping_sid2pid()
3771 sql = NULL; in update_cache_pid2sid()
3796 if (sql != NULL) in update_cache_pid2sid()
3851 sql = NULL; in update_cache_sid2pid()
3921 sql = NULL; in update_cache_sid2pid()
[all …]
H A Dserver.c62 rcode = process_list_svc_sql(db, dbname, sql, limit, flag, cb, res);\
666 char *sql = NULL; in idmap_list_mappings_1_svc() local
707 sql = sqlite_mprintf("SELECT rowid, sidprefix, rid, pid, w2u, " in idmap_list_mappings_1_svc()
716 if (sql == NULL) { in idmap_list_mappings_1_svc()
730 if (sql) in idmap_list_mappings_1_svc()
731 sqlite_freemem(sql); in idmap_list_mappings_1_svc()
818 char *sql = NULL; in idmap_list_namerules_1_svc() local
863 if (sql == NULL) { in idmap_list_namerules_1_svc()
870 PROCESS_LIST_SVC_SQL(retcode, db, IDMAP_DBNAME, sql, limit, in idmap_list_namerules_1_svc()
879 if (sql) in idmap_list_namerules_1_svc()
[all …]
/illumos-gate/usr/src/tools/smatch/src/smatch_scripts/
H A Dtest_kernel.sh72 find -name \*.c.smatch.sql -exec cat \{\} \; -exec rm \{\} \; > $WLOG.sql
/illumos-gate/usr/src/tools/smatch/src/
H A Dsmatch.h925 …exec(struct sqlite3 *db, int (*callback)(void*, int, char**, char**), void *data, const char *sql);
927 #define sql_helper(db, call_back, data, sql...) \ argument
931 sqlite3_snprintf(sizeof(sql_txt), sql_txt, sql); \
937 #define run_sql(call_back, data, sql...) \ argument
941 sql_helper(smatch_db, call_back, data, sql); \
944 #define mem_sql(call_back, data, sql...) \ argument
945 sql_helper(mem_db, call_back, data, sql)
947 #define cache_sql(call_back, data, sql...) \ argument
948 sql_helper(cache_db, call_back, data, sql)
/illumos-gate/usr/src/uts/common/os/
H A Dstrsubr.c4586 syncql_t *sql, *sql2; in strlock() local
4646 for (sql = sqlist->sqlist_head; sql; sql = sql->sql_next) { in strlock()
4709 syncql_t *sql; in strunlock() local
4726 for (sql = sqlist->sqlist_head; sql; sql = sql->sql_next) { in strunlock()
5289 syncql_t *sql; in strblock() local
5302 for (sql = sqlist->sqlist_head; sql != NULL; sql = sql->sql_next) in strblock()
5314 syncql_t *sql; in strunblock() local
5332 for (sql = sqlist->sqlist_head; sql != NULL; sql = sql->sql_next) in strunblock()
5335 for (sql = sqlist->sqlist_head; sql != NULL; in strunblock()
5336 sql = sql->sql_next) in strunblock()
[all …]

12