代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378791
sql simplescroll.sql
-- simple scroll cursor tests
create table t (a int);
insert into t values (1),(2),(3),(4),(5);
get scroll insensitive cursor c1 as 'select * from t';
-- should be 1
first c1;
-- should be 2
next c1;
www.eeworm.com/read/173141/5378792
sql holdcursorij.sql
-- create a table
create table t1(c11 int, c12 int);
-- insert data into tables
insert into t1 values(1,1);
insert into t1 values(2,2);
-- set autocommit off
autocommit off;
-- first test - make su
www.eeworm.com/read/173141/5378794
sql primarykey.sql
-- tests for primary/unique key
-- most testing currently deferred since we have extensive index tests
-- and no foreign keys yet.
-- negative tests
-- duplicate primary keys
create table neg (c1 i
www.eeworm.com/read/173141/5378795
sql wisconsin.sql
-- This test is an adaptation of the Wisconsin benchmark, as documented in
-- The Benchmark Handbook, Second Edition (edited by Jim Gray). The structure
-- of the tables and the data in the tables ar
www.eeworm.com/read/173141/5378797
sql errorcode.sql
--
-- this test shows the error code functionality
--
-- specify an invalid driver
driver 'java.lang.Integer';
-- now a valid driver
driver 'org.apache.derby.jdbc.EmbeddedDriver';
-- specify an inv
www.eeworm.com/read/173141/5378800
sql openscans.sql
-- minimal testing to verify no scans left open
CREATE FUNCTION ConsistencyChecker() RETURNS VARCHAR(128)
EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_ConsistencyChecker.runConsistencyC
www.eeworm.com/read/173141/5378806
sql distinctelimination.sql
-- test distinct elimination
set isolation to rr;
-- eliminate distincts based on a uniqueness condition
-- create tables
create table one(c1 int, c2 int, c3 int, c4 int, c5 int);
create unique inde
www.eeworm.com/read/173141/5378807
sql orderbyelimination.sql
-- test elimination of sort for order by
set isolation to rr;
-- test combining of sorts for distinct and order by
-- create some tables
create table t1(c1 int, c2 int, c3 int, c4 int);
insert into
www.eeworm.com/read/173141/5378810
sql positioneddelupd.sql
-- ** insert positionedDelete.sql
--
-- tests for positioned delete
--
-- note that comments that begin '-- .' are test cases from the test plan
-- assumed available in queries at time of initial wri
www.eeworm.com/read/173141/5378812
sql emptystatistics.sql
-- test to verify that RTS functionality is stubbed out
call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
values 1, 2, 3;
values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();