Changeset: 335efc7b71a1 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=335efc7b71a1
Added Files:
sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.sql
sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.err
sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.out
Modified Files:
sql/test/BugTracker-2013/Tests/All
Branch: Feb2013
Log Message:
Added test for bug 3241.
diffs (54 lines):
diff --git a/sql/test/BugTracker-2013/Tests/All
b/sql/test/BugTracker-2013/Tests/All
--- a/sql/test/BugTracker-2013/Tests/All
+++ b/sql/test/BugTracker-2013/Tests/All
@@ -3,3 +3,4 @@ select-around-zero.Bug-3220
segfault_in_aggregation.Bug-3225
subtract-one-year.Bug-3215
perl-undef-0.Bug-3235
+crash-from-optimizer.Bug-3241
diff --git a/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.sql
b/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.sql
@@ -0,0 +1,29 @@
+START TRANSACTION;
+
+CREATE TABLE "_dict" (
+ "idstr" CHARACTER LARGE OBJECT,
+ "id" INTEGER NOT NULL,
+ CONSTRAINT "_dict_id_pkey" PRIMARY KEY ("id")
+);
+COPY 7 RECORDS INTO "_dict" FROM stdin USING DELIMITERS ' ','\n','"';
+"entity.department-dummy:11be0f0ab68e55dbbb205fa871914d89" 0
+"entity.person:e1c055925f3783a7631a2efcde7d4413" 1
+"entity.section:3673f53d1a8e1e5981b8bb6726923e68" 2
+"entity.department-dummy:d57100c1f843d4d0f5a611ba7ac711f3" 3
+"entity.department-dummy:2895b2eae68f91e3240e109e1df3296f" 4
+"entity.department-dummy:c3f049405e2d621ff271bb92b4f921b9" 5
+"entity.department-dummy:ce5f9e283849737fcebebd0c973ed0ac" 6
+
+create function pcre_index(pat string, s string) returns int external name
pcre."patindex";
+
+create function gettype(str string) returns string
+begin
+ return substring(str, pcre_index('.', str) + 1,pcre_index(':', str) - 1 -
pcre_index('.', str));
+end;
+
+create view dict as select *, gettype(idstr) as type, 1.0e0 as prob from _dict;
+
+
+SELECT * FROM dict WHERE type='company';
+
+ROLLBACK;
diff --git
a/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.err
b/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.err
@@ -0,0 +1,1 @@
+to be filled
diff --git
a/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.out
b/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.stable.out
@@ -0,0 +1,1 @@
+to be filled
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
