SF.net SVN: firebird:[63793] qa/fbt-repository/trunk/tests/bugs/ core_4436.fbt

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SF.net SVN: firebird:[63793] qa/fbt-repository/trunk/tests/bugs/ core_4436.fbt

Firebird Checkins mailing list
Revision: 63793
          http://sourceforge.net/p/firebird/code/63793
Author:   tabloid
Date:     2017-07-29 07:26:29 +0000 (Sat, 29 Jul 2017)
Log Message:
-----------
See added / modified .fbt file(s)

Added Paths:
-----------
    qa/fbt-repository/trunk/tests/bugs/core_4436.fbt

Added: qa/fbt-repository/trunk/tests/bugs/core_4436.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_4436.fbt                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_4436.fbt 2017-07-29 07:26:29 UTC (rev 63793)
@@ -0,0 +1,56 @@
+{
+'id': 'bugs.core_4436',
+'qmid': '',
+'tracker_id': 'CORE-4436',
+'title': '',
+'description':
+ """
+   Test verifies only:
+   1) ability to use syntax: hash(<string> using <algo>)
+   2) non-equality of hash results for sha1, sha256 and sha512 using _TRIVIAL_ sample from ticket.
+   build 4.0.0.713: OK, 1.094s.
+
+   Note that for strings:
+   '20177527e04e05d5e7b448c1ab2b872f86831d0b' and '20177527e04e05d5e7b448c1ab2b872f86831d0b'
+   - current imlpementation of SHA1, SHA256 and SHA512 gives the same hash value.
+   (See: https://stackoverflow.com/questions/3475648/sha1-collision-demo-example )
+
+ """,
+'min_versions': '4.0.0',
+'versions': [
+{
+ 'firebird_version': '4.0',
+ 'platform': 'All',
+ 'init_script':
+  """
+  """,
+ 'test_type': 'ISQL',
+ 'test_script':
+  """
+    set list on;
+
+    recreate table test(s varchar(32765));
+    commit;
+    insert into test(s) values('4-20100433-01775-LOTES');
+    insert into test(s) values('1-20100433-01765-LOTES');
+    commit;
+
+    select -(count(s) - count(distinct hash(s))) as hash_default_result from test;
+
+    select -(count(s) - count(distinct hash(s using sha1))) as hash_sha1_result from test;
+    select -(count(s) - count(distinct hash(s using sha256))) as hash_sha256_result from test;
+    select -(count(s) - count(distinct hash(s using sha512))) as hash_sha512_result from test;
+  """,
+ 'expected_stdout':
+  """
+    HASH_DEFAULT_RESULT             -1
+    HASH_SHA1_RESULT                0
+    HASH_SHA256_RESULT              0
+    HASH_SHA512_RESULT              0
+  """,
+ 'expected_stderr':
+  """
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_4436.fbt
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-checkins mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-checkins