Home
last modified time | relevance | path

Searched +refs:where +refs:history (Results 1 – 25 of 33686) sorted by relevance

12345678910>>...1348

/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/versioning/t/
H A Dpartition_rotation.test10 (partition p1 history, partition pn current);
16 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
25 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
29 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
35 set @ts=(select row_end from t1 for system_time all where i=1);
36 select * from t1 for system_time all where row_end = @ts;
38 explain partitions select * from t1 for system_time all where row_end = @ts;
47 partition p0 history,
[all …]
H A Dpartition.test225 delete from t1 where x < 4;
280 delete from t1 where x < 3;
331 where table_name = 't1' into @a;
370 delete from t1 where x = 1;
371 delete from t1 where x = 2;
443 delete from t1 where a is not null;
466 delete from t1 where pk in (11, 12);
475 delete from t1 where pk in (11, 12);
500 select * from t1 where i > 0 or pk = 1000 limit 1;
518 delete from t1 where x < 3;
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/versioning/t/
H A Dpartition_rotation.test10 (partition p1 history, partition pn current);
16 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
25 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
29 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
35 set @ts=(select row_end from t1 for system_time all where i=1);
36 select * from t1 for system_time all where row_end = @ts;
38 explain partitions select * from t1 for system_time all where row_end = @ts;
47 partition p0 history,
[all …]
H A Dpartition.test225 delete from t1 where x < 4;
280 delete from t1 where x < 3;
331 where table_name = 't1' into @a;
370 delete from t1 where x = 1;
371 delete from t1 where x = 2;
443 delete from t1 where a is not null;
466 delete from t1 where pk in (11, 12);
475 delete from t1 where pk in (11, 12);
500 select * from t1 where i > 0 or pk = 1000 limit 1;
518 delete from t1 where x < 3;
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/versioning/t/
H A Dpartition_rotation.test10 (partition p1 history, partition pn current);
16 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
25 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
29 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
35 set @ts=(select row_end from t1 for system_time all where i=1);
36 select * from t1 for system_time all where row_end = @ts;
38 explain partitions select * from t1 for system_time all where row_end = @ts;
47 partition p0 history,
[all …]
H A Dpartition.test225 delete from t1 where x < 4;
280 delete from t1 where x < 3;
331 where table_name = 't1' into @a;
379 delete from t1 where x = 1;
380 delete from t1 where x = 2;
452 delete from t1 where a is not null;
475 delete from t1 where pk in (11, 12);
484 delete from t1 where pk in (11, 12);
509 select * from t1 where i > 0 or pk = 1000 limit 1;
527 delete from t1 where x < 3;
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/versioning/t/
H A Dpartition_rotation.test10 (partition p1 history, partition pn current);
16 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
25 select subpartition_name,partition_description,table_rows from information_schema.partitions where …
29 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
35 set @ts=(select row_end from t1 for system_time all where i=1);
36 select * from t1 for system_time all where row_end = @ts;
38 explain partitions select * from t1 for system_time all where row_end = @ts;
47 partition p0 history,
[all …]
H A Dpartition.test225 delete from t1 where x < 4;
280 delete from t1 where x < 3;
331 where table_name = 't1' into @a;
379 delete from t1 where x = 1;
380 delete from t1 where x = 2;
452 delete from t1 where a is not null;
475 delete from t1 where pk in (11, 12);
484 delete from t1 where pk in (11, 12);
509 select * from t1 where i > 0 or pk = 1000 limit 1;
527 delete from t1 where x < 3;
[all …]
/dports/www/luakit-devel/luakit-2.3-20-g4b10e55/lib/
H A Dhistory_chrome.lua10 local history = require("history")
339 local where, args, argc = {}, {}, 1
343 table.insert(where, (notlike == "-" and "NOT " or "") ..
350 if #where ~= 0 then
352 table.insert(sql, "WHERE " .. table.concat(where, " AND "))
364 if #where ~= 0 then
369 local rows = history.db:exec(sql, args)
381 history.db:exec [[ DELETE FROM history ]]
388 history.db:exec("DELETE FROM history WHERE id IN ("
409 history.add_signal("add", function (uri)
/dports/www/luakit/luakit-2.3/lib/
H A Dhistory_chrome.lua10 local history = require("history")
339 local where, args, argc = {}, {}, 1
343 table.insert(where, (notlike == "-" and "NOT " or "") ..
350 if #where ~= 0 then
352 table.insert(sql, "WHERE " .. table.concat(where, " AND "))
364 if #where ~= 0 then
369 local rows = history.db:exec(sql, args)
381 history.db:exec [[ DELETE FROM history ]]
388 history.db:exec("DELETE FROM history WHERE id IN ("
409 history.add_signal("add", function (uri)
/dports/www/moodle310/moodle/grade/report/history/classes/output/
H A Dtablelog.php232 $itemid = $history->itemid;
235 if (!empty($this->cms->instances[$history->itemmodule][$history->iteminstance])) {
236 $cm = $this->cms->instances[$history->itemmodule][$history->iteminstance];
267 $userid = $history->usermodified;
315 return $history->feedback;
322 $history->feedback,
327 $history->id
435 list($where, $params) = $this->get_filters_sql_and_params();
442 WHERE $where";
518 list($where, $params) = $DB->get_in_or_equal($idlist);
[all …]
/dports/www/moodle311/moodle/grade/report/history/classes/output/
H A Dtablelog.php233 $itemid = $history->itemid;
236 if (!empty($this->cms->instances[$history->itemmodule][$history->iteminstance])) {
237 $cm = $this->cms->instances[$history->itemmodule][$history->iteminstance];
268 $userid = $history->usermodified;
316 return $history->feedback;
323 $history->feedback,
328 $history->id
438 list($where, $params) = $this->get_filters_sql_and_params();
445 WHERE $where";
521 list($where, $params) = $DB->get_in_or_equal($idlist);
[all …]
/dports/www/moodle39/moodle/grade/report/history/classes/output/
H A Dtablelog.php232 $itemid = $history->itemid;
235 if (!empty($this->cms->instances[$history->itemmodule][$history->iteminstance])) {
236 $cm = $this->cms->instances[$history->itemmodule][$history->iteminstance];
267 $userid = $history->usermodified;
315 return $history->feedback;
322 $history->feedback,
327 $history->id
435 list($where, $params) = $this->get_filters_sql_and_params();
442 WHERE $where";
518 list($where, $params) = $DB->get_in_or_equal($idlist);
[all …]
/dports/finance/prestashop/prestashop/classes/stock/
H A DSupplyOrder.php294 $details->where('id_supply_order', '=', $this->id);
365 $history = new SupplyOrderHistory();
366 $history->id_supply_order = $this->id;
367 $history->id_state = $this->id_supply_order_state;
368 $history->id_employee = (int) $context->employee->id;
369 $history->employee_firstname = pSQL($context->employee->firstname);
370 $history->employee_lastname = pSQL($context->employee->lastname);
372 $history->save();
404 $query->where('sos.enclosed != 1');
429 $query->where('sos.enclosed != 1');
[all …]
/dports/www/thirtybees/thirtybees-1.1.0/classes/stock/
H A DSupplyOrder.php326 $details->where('id_supply_order', '=', $this->id);
417 $history = new SupplyOrderHistory();
418 $history->id_supply_order = $this->id;
419 $history->id_state = $this->id_supply_order_state;
420 $history->id_employee = (int) $context->employee->id;
421 $history->employee_firstname = pSQL($context->employee->firstname);
422 $history->employee_lastname = pSQL($context->employee->lastname);
424 $history->save();
464 $query->where('sos.enclosed != 1');
493 $query->where('sos.enclosed != 1');
[all …]
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/versioning/r/
H A Dpartition_rotation.result5 (partition p1 history, partition pn current);
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
36 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
43 1 SIMPLE t1 pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL 2 Using where
46 …MPLE t1 p0_p0sp0,p0_p0sp1,p2_p2sp0,p2_p2sp1,pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL # Using where
47 set @ts=(select row_end from t1 for system_time all where i=1);
48 select * from t1 for system_time all where row_end = @ts;
51 explain partitions select * from t1 for system_time all where row_end = @ts;
60 partition p0 history,
[all …]
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/versioning/r/
H A Dpartition_rotation.result5 (partition p1 history, partition pn current);
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
36 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
43 1 SIMPLE t1 pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL 2 Using where
46 …MPLE t1 p0_p0sp0,p0_p0sp1,p2_p2sp0,p2_p2sp1,pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL # Using where
47 set @ts=(select row_end from t1 for system_time all where i=1);
48 select * from t1 for system_time all where row_end = @ts;
51 explain partitions select * from t1 for system_time all where row_end = @ts;
60 partition p0 history,
[all …]
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/versioning/r/
H A Dpartition_rotation.result5 (partition p1 history, partition pn current);
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
36 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
43 1 SIMPLE t1 pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL 2 Using where
46 …MPLE t1 p0_p0sp0,p0_p0sp1,p2_p2sp0,p2_p2sp1,pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL # Using where
47 set @ts=(select row_end from t1 for system_time all where i=1);
48 select * from t1 for system_time all where row_end = @ts;
51 explain partitions select * from t1 for system_time all where row_end = @ts;
60 partition p0 history,
[all …]
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/versioning/r/
H A Dpartition_rotation.result5 (partition p1 history, partition pn current);
19 alter table t1 add partition (partition p0 history, partition p2 history);
23 update t1 set i=6 where i=5;
36 where table_schema='test' and table_name='t1' and partition_name='p0' limit 1);
43 1 SIMPLE t1 pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL 2 Using where
46 …MPLE t1 p0_p0sp0,p0_p0sp1,p2_p2sp0,p2_p2sp1,pn_pnsp0,pn_pnsp1 ALL NULL NULL NULL NULL # Using where
47 set @ts=(select row_end from t1 for system_time all where i=1);
48 select * from t1 for system_time all where row_end = @ts;
51 explain partitions select * from t1 for system_time all where row_end = @ts;
60 partition p0 history,
[all …]
/dports/www/firefox-legacy/firefox-52.8.0esr/browser/components/migration/content/
H A Dextra-migration-strings.properties3 …ndo.message.all = Pick up where you left off. We’ve imported these sites and your boo…
4 automigration.undo.message.bookmarks = Pick up where you left off. We’ve imported these site…
5 automigration.undo.message.bookmarks.logins = Pick up where you left off. We’ve imported these site…
6 …do.message.bookmarks.visits = Pick up where you left off. We’ve imported these sites and your book…
7 automigration.undo.message.logins = Pick up where you left off. We’ve imported your passw…
8 …tion.undo.message.logins.visits = Pick up where you left off. We’ve imported these sites and yo…
9 …tion.undo.message.visits = Pick up where you left off. We’ve imported these sites and yo…
/dports/lang/spidermonkey60/firefox-60.9.0/docshell/base/
H A DnsIDownloadHistory.idl12 * This interface can be used to add a download to history. There is a separate
14 * downloads differently from other types of history.
19 * Adds a download to history. This will also notify observers that the
24 * The source of the download we are adding to history. This cannot be
32 * [optional] The target where the download is to be saved on the local
35 * In a situation where a history implementation is not available,
36 * where 'history implementation' refers to something like
39 * the actual addition to the underlying history implementation. If you
41 * history implementation's notifications system (e.g. nsINavHistoryObserver
49 * Remove all downloads from history.
[all …]
/dports/www/firefox-legacy/firefox-52.8.0esr/docshell/base/
H A DnsIDownloadHistory.idl12 * This interface can be used to add a download to history. There is a separate
14 * downloads differently from other types of history.
19 * Adds a download to history. This will also notify observers that the
24 * The source of the download we are adding to history. This cannot be
32 * [optional] The target where the download is to be saved on the local
35 * In a situation where a history implementation is not available,
36 * where 'history implementation' refers to something like
39 * the actual addition to the underlying history implementation. If you
41 * history implementation's notifications system (e.g. nsINavHistoryObserver
49 * Remove all downloads from history.
[all …]
/dports/devel/flyspray/flyspray-0.9.9.7_4/includes/
H A Devents.inc.php7 function get_events($task_id, $where = '') argument
56 WHERE h.task_id = ? $where
63 function event_description($history) { argument
74 foreach($history as $key=> $value) {
80 $new_value = $history['new_value'];
81 $old_value = $history['old_value'];
83 switch($history['event_type']) {
90 $field = $history['field_changed'];
175 if ($history['c_date_added']) {
195 if ($history['orig_name']) {
[all …]
/dports/security/p5-openxpki-i18n/openxpki-3.16.1/core/server/OpenXPKI/Server/Workflow/Persister/
H A DDBI.pm109 where => {
182 where => {
225 where => {
252 where => {
329 my @history = @_;
336 foreach my $entry (@history) {
365 return @history;
379 my @history = ();
411 push @history, $hist;
415 return @history;
[all …]
/dports/security/p5-openxpki/openxpki-3.16.1/core/server/OpenXPKI/Server/Workflow/Persister/
H A DDBI.pm109 where => {
182 where => {
225 where => {
252 where => {
329 my @history = @_;
336 foreach my $entry (@history) {
365 return @history;
379 my @history = ();
411 push @history, $hist;
415 return @history;
[all …]

12345678910>>...1348