diff options
author | Constantin Michael <constantin@codesynthesis.com> | 2011-10-26 15:37:32 +0200 |
---|---|---|
committer | Constantin Michael <constantin@codesynthesis.com> | 2011-10-26 17:16:04 +0200 |
commit | 06712594f44e8300570103c05f54d686dfc4fb53 (patch) | |
tree | 1bcb3b857160268ef8b8b6a4db88fb30de762062 /common/query/test.std | |
parent | 899732d4e111e0144d3e3bbaa91c054950361e1c (diff) |
Add BLOB comparison and null predicate test cases to query test
Diffstat (limited to 'common/query/test.std')
-rw-r--r-- | common/query/test.std | 93 |
1 files changed, 50 insertions, 43 deletions
diff --git a/common/query/test.std b/common/query/test.std index 978282a..f351eab 100644 --- a/common/query/test.std +++ b/common/query/test.std @@ -1,7 +1,7 @@ test 001 -John Doe 30 married -Jane Doe 29 married -Joe Squeaky Dirt 31 single +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single test 002 Jane Doe 29 married @@ -10,89 +10,96 @@ Joe Squeaky Dirt 31 single Johansen J Johansen 32 single test 003 -John Doe 30 married +John Doe 30 married 35-3-21 test 004 -John Doe 30 married +John Doe 30 married 35-3-21 test 005 -John Doe 30 married +John Doe 30 married 35-3-21 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 test 006 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single test 007 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single test 008 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 test 009 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single test 010 -Jane Doe 29 married +Jane Doe 29 married 19-19-84 -John Doe 30 married -Jane Doe 29 married -Joe Squeaky Dirt 31 single +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 +Joe Squeaky Dirt 31 single 8-98-53 -Jane Doe 29 married +Jane Doe 29 married 19-19-84 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 Johansen J Johansen 32 single -Jane Doe 29 married -John Doe 30 married +Jane Doe 29 married 19-19-84 +John Doe 30 married 35-3-21 test 011 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 -John Doe 30 married -Jane Doe 29 married -Joe Squeaky Dirt 31 single +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 +Joe Squeaky Dirt 31 single 8-98-53 test 012 Johansen J Johansen 32 single test 013 -Joe Squeaky Dirt 31 single +Joe Squeaky Dirt 31 single 8-98-53 test 014 test 015 -John Doe 30 married -Jane Doe 29 married +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 + +test 016 +Johansen J Johansen 32 single + +John Doe 30 married 35-3-21 +Jane Doe 29 married 19-19-84 +Joe Squeaky Dirt 31 single 8-98-53 |