[Firebird-checkins] SF.net SVN: firebird:[63656] qa/fbt-repository/trunk/tests/bugs/core_5431. fbt

[<ta...@us...>]

Revision: 63656
          http://sourceforge.net/p/firebird/code/63656
Author:   tabloid
Date:     2016-12-29 07:27:19 +0000 (Thu, 29 Dec 2016)
Log Message:
-----------
See added / modified .fbt file(s)

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

Added: qa/fbt-repository/trunk/tests/bugs/core_5431.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_5431.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_5431.fbt	2016-12-29 07:27:19 UTC (rev 63656)
@@ -0,0 +1,68 @@
+{
+'id': 'bugs.core_5431',
+'qmid': None,
+'tracker_id': 'CORE-5431',
+'title': 'Support for DROP IDENTITY clause',
+'description':
+ """
+   Checked on 4.0.0.477
+ """,
+'min_versions': '4.0',
+'versions': [
+{
+ 'firebird_version': '4.0',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'init_script':
+  """
+  """,
+ 'test_script':
+  """
+    set list on;
+    --set echo on;
+
+    recreate table test1(
+        id smallint generated by default as identity ( start with 32767 increment -65535 )
+    );
+
+    commit;
+
+    -- Should be 1:
+    select count(*) as identity_sequences_count_1
+    from rdb$generators
+    where rdb$system_flag = 6;
+
+    insert into test1 default values returning id as test1_id;
+    commit;
+
+    alter table test1 alter column id drop identity;
+    commit;
+
+    -- Should be 0:
+    select count(*) as identity_sequences_count_2
+    from rdb$generators
+    where rdb$system_flag = 6;
+
+    -- Should issue
+    -- Statement failed, SQLSTATE = 42000
+    -- invalid request BLR at offset 47
+    -- -generator RDB$nnn is not defined
+    insert into test1 default values returning id as test1_id;
+
+  """,
+ 'expected_stdout': 
+  """
+    IDENTITY_SEQUENCES_COUNT_1      1
+    TEST1_ID                        -32768
+    IDENTITY_SEQUENCES_COUNT_2      0
+  """,
+ 'expected_stderr': 
+  """
+    Statement failed, SQLSTATE = 42000
+    invalid request BLR at offset 47
+    -generator RDB is not defined
+  """,
+  'substitutions':[('RDB\$[\d]+', 'RDB')]
+}
+]
+}


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