Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Simplify the new test case added in the previous check-in. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | ac29179121a6a8e588ad6ca4610dc625 |
| User & Date: | mistachkin 2017-06-10 01:09:13 |
Context
|
2017-06-10
| ||
| 17:38 | Merge updates from trunk. check-in: 091bc3a48a user: mistachkin tags: branch-1.0.105 | |
| 17:22 | Update SQLite core library to the 3.19.3 release. check-in: 05a7dc5557 user: mistachkin tags: trunk | |
| 01:09 | Simplify the new test case added in the previous check-in. check-in: ac29179121 user: mistachkin tags: trunk | |
| 00:56 | Fix issue that prevented SQLiteBlob creation from succeeding for tables that did not have an integer primary key. check-in: a47688aca5 user: mistachkin tags: trunk | |
Changes
Changes to Tests/basic.eagle.
4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652 4653 4654 4655 4656 4657 4658 4659 4660 4661 4662 4663 4664 4665 4666 4667 4668 4669 4670 4671 4672 4673 4674 4675 4676 4677 4678 4679 4680 |
INSERT INTO t1 (x, y) VALUES(
'12345679-0000-0000-0000-000000000000',
X'0102030405060708090A0B0C0D0E0F101113'
);
}
set sql(1) { \
SELECT rowid, y FROM t1 \
WHERE x = '12345678-0000-0000-0000-000000000000'; \
}
set sql(2) { \
SELECT rowid, y FROM t1 \
WHERE x = '12345679-0000-0000-0000-000000000000'; \
}
set dataReader [sql execute -execute reader -format datareader \
-behavior +KeyInfo -alias $db $sql(1)]
while {[$dataReader Read]} {
set blob [object invoke -alias \
System.Data.SQLite.SQLiteBlob Create $dataReader 1 true]
lappend result [$blob GetCount]
$blob Close
}
$dataReader Close; unset dataReader
set dataReader [sql execute -execute reader -format datareader \
-behavior +KeyInfo -alias $db $sql(2)]
while {[$dataReader Read]} {
set blob [object invoke -alias \
System.Data.SQLite.SQLiteBlob Create $dataReader 1 true]
lappend result [$blob GetCount]
$blob Close
}
$dataReader Close; unset dataReader
|
| | | | |
4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652 4653 4654 4655 4656 4657 4658 4659 4660 4661 4662 4663 4664 4665 4666 4667 4668 4669 4670 4671 4672 4673 4674 4675 4676 4677 4678 4679 4680 |
INSERT INTO t1 (x, y) VALUES(
'12345679-0000-0000-0000-000000000000',
X'0102030405060708090A0B0C0D0E0F101113'
);
}
set sql(1) { \
SELECT y FROM t1 \
WHERE x = '12345678-0000-0000-0000-000000000000'; \
}
set sql(2) { \
SELECT y FROM t1 \
WHERE x = '12345679-0000-0000-0000-000000000000'; \
}
set dataReader [sql execute -execute reader -format datareader \
-behavior +KeyInfo -alias $db $sql(1)]
while {[$dataReader Read]} {
set blob [object invoke -alias \
System.Data.SQLite.SQLiteBlob Create $dataReader 0 true]
lappend result [$blob GetCount]
$blob Close
}
$dataReader Close; unset dataReader
set dataReader [sql execute -execute reader -format datareader \
-behavior +KeyInfo -alias $db $sql(2)]
while {[$dataReader Read]} {
set blob [object invoke -alias \
System.Data.SQLite.SQLiteBlob Create $dataReader 0 true]
lappend result [$blob GetCount]
$blob Close
}
$dataReader Close; unset dataReader
|