Contents

create table names (
    name varchar(255),
    age integer
);
---
insert into names (name, age) values ('Joe', 19);
---
insert into names (name, age) values ('Jim', 30);
---
insert into names (name, age) values ('Bob', 21);
---
create table precision_test (text_field varchar(20) primary key not null, integer_field integer, decimal_field decimal(2,1), numeric_field numeric(30,6));
---
CREATE TABLE blob_test (name VARCHAR(30), data OID);
---
create view view_names as select * from names;
---
create or replace function test_insert (varchar(255), integer) 
    returns integer 
    language sql 
    as 'insert into names (name, age) values ($1, $2); select age from names where name = $1';
---
create table boolean_test (num integer, mybool boolean);
---
create table time_test (mytime time);
---
create table timestamp_test (mytimestamp timestamp);
---
create table bit_test (mybit bit);
---
create table field_types_test (foo integer not null primary key default 1);
---
create table db_specific_types_test (foo integer);

Version data entries

4 entries across 4 versions & 2 rubygems

Version	Path
ydbi-0.6.0	test/dbd/odbc/up.sql
ydbi-0.5.7	test/dbd/odbc/up.sql
ydbi-0.5.0	test/dbd/odbc/up.sql
dbd-odbc-0.2.5	test/dbd/odbc/up.sql