Code review comment for lp:~paul-mccullagh/maria/maria-pbxt-rc2
- maria-pbxt-rc2
- Merge into 5.1-converting
Revision history for this message
Kristian Nielsen (knielsen) wrote : | # |
1 | === modified file 'mysql-test/suite/pbxt/r/lowercase_view.result' |
2 | --- mysql-test/suite/pbxt/r/lowercase_view.result 2009-04-02 20:36:52 +0000 |
3 | +++ mysql-test/suite/pbxt/r/lowercase_view.result 2009-08-28 11:19:59 +0000 |
4 | @@ -119,7 +119,7 @@ create table t1Aa (col1 int); |
5 | create view v1Aa as select col1 from t1Aa as AaA; |
6 | show create view v1AA; |
7 | View Create View character_set_client collation_connection |
8 | -v1aa CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1aa` AS select `AaA`.`col1` AS `col1` from `t1aa` `AaA` latin1 latin1_swedish_ci |
9 | +v1aa CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1aa` AS select `aaa`.`col1` AS `col1` from `t1aa` `aaa` latin1 latin1_swedish_ci |
10 | drop view v1AA; |
11 | select Aaa.col1 from t1Aa as AaA; |
12 | col1 |
13 | @@ -128,7 +128,7 @@ drop view v1AA; |
14 | create view v1Aa as select AaA.col1 from t1Aa as AaA; |
15 | show create view v1AA; |
16 | View Create View character_set_client collation_connection |
17 | -v1aa CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1aa` AS select `AaA`.`col1` AS `col1` from `t1aa` `AaA` latin1 latin1_swedish_ci |
18 | +v1aa CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1aa` AS select `aaa`.`col1` AS `col1` from `t1aa` `aaa` latin1 latin1_swedish_ci |
19 | drop view v1AA; |
20 | drop table t1Aa; |
21 | CREATE TABLE t1 (a int, b int); |
22 | @@ -142,7 +142,7 @@ CREATE OR REPLACE VIEW v1 AS |
23 | select X.a from t1 AS X group by X.b having (X.a = 1); |
24 | SHOW CREATE VIEW v1; |
25 | View Create View character_set_client collation_connection |
26 | -v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `X`.`a` AS `a` from `t1` `X` group by `X`.`b` having (`X`.`a` = 1) latin1 latin1_swedish_ci |
27 | +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `x`.`a` AS `a` from `t1` `x` group by `x`.`b` having (`x`.`a` = 1) latin1 latin1_swedish_ci |
28 | SELECT * FROM v1; |
29 | a |
30 | DROP VIEW v1; |
31 | |
32 | === added file 'mysql-test/suite/pbxt/t/lowercase_table_grant-master.opt' |
33 | --- mysql-test/suite/pbxt/t/lowercase_table_grant-master.opt 1970-01-01 00:00:00 +0000 |
34 | +++ mysql-test/suite/pbxt/t/lowercase_table_grant-master.opt 2009-08-28 11:13:02 +0000 |
35 | @@ -0,0 +1 @@ |
36 | +--lower_case_table_names |
37 | |
38 | === added file 'mysql-test/suite/pbxt/t/lowercase_table_qcache-master.opt' |
39 | --- mysql-test/suite/pbxt/t/lowercase_table_qcache-master.opt 1970-01-01 00:00:00 +0000 |
40 | +++ mysql-test/suite/pbxt/t/lowercase_table_qcache-master.opt 2009-08-28 11:22:29 +0000 |
41 | @@ -0,0 +1 @@ |
42 | +--lower_case_table_names |
43 | |
44 | === added file 'mysql-test/suite/pbxt/t/lowercase_view-master.opt' |
45 | --- mysql-test/suite/pbxt/t/lowercase_view-master.opt 1970-01-01 00:00:00 +0000 |
46 | +++ mysql-test/suite/pbxt/t/lowercase_view-master.opt 2009-08-28 11:10:22 +0000 |
47 | @@ -0,0 +1 @@ |
48 | +--lower_case_table_names=1 |
49 | |
50 | === added file 'mysql-test/suite/pbxt/t/udf-master.opt' |
51 | --- mysql-test/suite/pbxt/t/udf-master.opt 1970-01-01 00:00:00 +0000 |
52 | +++ mysql-test/suite/pbxt/t/udf-master.opt 2009-08-28 11:24:08 +0000 |
53 | @@ -0,0 +1 @@ |
54 | +$UDF_EXAMPLE_LIB_OPT |
Paul McCullagh <email address hidden> writes:
> Paul McCullagh has proposed merging lp:~paul-mccullagh/maria/maria-pbxt-rc2 into lp:maria.
>
> Requested reviews:
> Maria-captains (maria-captains)
>
> Updated the PBXT engine to RC2 (lp:pbxt/rc2), version 1.0.08c. All tests in the PBXT suite pass.
>
> Note that this branch does not yet include the entire history of PBXT because attempts to do this have failed so far due to problems with bzr.
Thanks a lot Paul for preparing this.
I tried building your tree and running the test suite. I have a question, as I
got some build and test failures. I suspect that perhaps your tree is missing
a commit, or maybe has one too many.
Your tree has the following 3 commits in addition to lp:maria:
2722 Paul McCullagh 2009-08-18
Merged changes for bug fix update 1.0.08c RC2
2721 Paul McCullagh 2009-08-17
Updated all tests for RC2
2720 Paul McCullagh 2009-08-17
Updated PBXT to version 1.0.08 RC2
If I build revision 2721 (drop the last commit), things look good. I even have
zero failures in the test suite with a simple patch (attached), mostly some
simple fixes for case-sensitive file system.
But if I try the current tree, revision 2722, I get both build and test
failures, as detailed below.
So the basic question is, should I merge just revision 2721, or should I merge
2722 with some additional build (and test?) fixes?
------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -
So some more details.
First, I fixed all of the test failures in revision 2721 with a simple patch
(attached). The only problem was the *-master.opt files were not copied along
with test .test files from the main suite. This caused failures on
case-sensitive file systems (and also failure in udf.test due to wrong search
path for .so). You should of course check the patch, but I think it should be
ok.
Now, for the problems in revision 2722:
They might be related to the replacement of stream_xt with pbms_enabled. To
even build, I need this patch:
--- storage/ pbxt/src/ Makefile. am 2009-05-09 04:01:53 +0000 pbxt/src/ Makefile. am 2009-08-28 10:11:41 +0000
tabcache_ xt.h table_xt.h trace_xt.h thread_xt.h \
datadic_ xt.cc datalog_xt.cc filesys_xt.cc hashtab_xt.cc \
tabcache_ xt.cc table_xt.cc trace_xt.cc thread_xt.cc \
+++ storage/
@@ -19,7 +19,7 @@ noinst_HEADERS = bsearch_xt.h cache_xt.
datadic_xt.h datalog_xt.h filesys_xt.h hashtab_xt.h \
ha_pbxt.h heap_xt.h index_xt.h linklist_xt.h \
memory_xt.h myxt_xt.h pthread_xt.h restart_xt.h \
- streaming_xt.h sortedlist_xt.h strutil_xt.h \
+ pbms_enabled.h sortedlist_xt.h strutil_xt.h \
util_xt.h xaction_xt.h xactlog_xt.h lock_xt.h \
systab_xt.h ha_xtsys.h discover_xt.h \
@@ -30,7 +30,7 @@ libpbxt_la_SOURCES = bsearch_xt.cc cache
ha_pbxt.cc heap_xt.cc index_xt.cc linklist_xt.cc \
memory_xt.cc myxt_xt.cc pthread_xt.cc restart_xt.cc \
- streaming_xt.cc sortedlist_xt.cc strutil_xt.cc \
+ pbms_enabled.cc sortedlist_xt.cc strutil_xt.cc \
systab_xt.cc ha_xtsys.cc discover_xt.cc \
util_xt.cc xaction_xt.cc xactlog_xt.cc lock_xt.cc locklist_xt.cc
I assume you must have something similar, maybe you forgot to push it?
And in the test suite, I get some failures. For example, the following:
create database mysqltest;
create table t1 (c1 int);
alter table t1 rename mysqltest.t1;
mysqltest: At line 3: query 'alter table t1 rename mysqltest.t1' failed: 1025: Error on rename of './test/t1' to './mysqltest/t1' (errno: 16)
In the mysqld.1.err log I have this:
090828 16:19:14 [Error] pbms_rename_ table_with_ blobs() Error: PBMS does not support renaming tables across databases.
Which is a bit strange since table t1 has only an int?
There are 3 other test failures, which from a quick look might be related to
blob. I attached the full mysql-test-run output, maybe you can take a look?
Please let me know if you know what the issue is, or what more I can do to
help.
- Kristian.