Author: wyoung
Date: Wed Oct 24 15:38:14 2007
New Revision: 1782
URL: http://svn.gna.org/viewcvs/mysqlpp?rev=1782&view=rev
Log:
Regenerated bmark.txt, reflecting increase of item column width and move
to doing main develoment on a MySQL 5.x machine, which changes the way
some examples run, particularly the multiquery one.
Modified:
trunk/bmark.txt
Modified: trunk/bmark.txt
URL:
http://svn.gna.org/viewcvs/mysqlpp/trunk/bmark.txt?rev=1782&r1=1781&r2=1782&view=diff
==============================================================================
--- trunk/bmark.txt (original)
+++ trunk/bmark.txt Wed Oct 24 15:38:14 2007
@@ -37,10 +37,10 @@
---------------- BEGIN store_if OUTPUT ----------------
Records found: 2
-Item Num Weight Price Date
-
-Nürnberger Brats 97 1.5 8.79 2005-03-10
-Hot Mustard 73 0.95 0.97 1998-05-25
+Item Num Weight Price Date
+
+Nürnberger Brats 97 1.5 8.79 2005-03-10
+Hot Mustard 73 0.95 0.97 1998-05-25
================ END store_if OUTPUT ================
---------------- BEGIN for_each OUTPUT ----------------
@@ -57,18 +57,47 @@
DROP TABLE test_table
Result set 0 is empty.
+Result set 1 is empty.
+Result set 2 is empty.
+Result set 3 is empty.
+Result set 4 has 1 row:
+ +----+
+ | id |
+ +----+
+ | 20 |
+ +----+
+Result set 5 is empty.
+Stored procedure query:
+DROP PROCEDURE IF EXISTS get_stock;
+CREATE PROCEDURE get_stock
+( i_item varchar(20) )
+BEGIN
+SET i_item = concat('%', i_item, '%');
+SELECT * FROM stock WHERE lower(item) like lower(i_item);
+END
+;
+Result set 0 is empty.
+Result set 1 is empty.
+Query: CALL get_stock('relish')
+Result set 0 has 1 row:
+ +---------------+-----+--------+-------+------------+
+ | item | num | weight | price | sdate |
+ +---------------+-----+--------+-------+------------+
+ | Pickle Relish | 87 | 1.5 | 1.75 | 1998-09-04 |
+ +---------------+-----+--------+-------+------------+
+Result set 1 is empty.
================ END multiquery OUTPUT ================
---------------- BEGIN tquery1 OUTPUT ----------------
Query: select * from stock
Records found: 4
-Item Num Weight Price Date
-
-Nuerenberger Bratwur 97 1.5 8.79 2005-03-10
-Pickle Relish 87 1.5 1.75 1998-09-04
-Hot Mustard 73 0.95 0.97 1998-05-25
-Hotdog Buns 65 1.1 1.1 1998-04-23
+Item Num Weight Price Date
+
+Nuerenberger Bratwurst 97 1.5 8.79 2005-03-10
+Pickle Relish 87 1.5 1.75 1998-09-04
+Hot Mustard 73 0.95 0.97 1998-05-25
+Hotdog Buns 65 1.1 1.1 1998-04-23
================ END tquery1 OUTPUT ================
---------------- BEGIN resetdb OUTPUT ----------------
@@ -84,12 +113,12 @@
Query: select * from stock
Records found: 4
-Item Num Weight Price Date
-
-Nuerenberger Bratwur 97 1.5 8.79 2005-03-10
-Pickle Relish 87 1.5 1.75 1998-09-04
-Hot Mustard 73 0.95 0.97 1998-05-25
-Hotdog Buns 65 1.1 1.1 1998-04-23
+Item Num Weight Price Date
+
+Nuerenberger Bratwurst 97 1.5 8.79 2005-03-10
+Pickle Relish 87 1.5 1.75 1998-09-04
+Hot Mustard 73 0.95 0.97 1998-05-25
+Hotdog Buns 65 1.1 1.1 1998-04-23
================ END tquery2 OUTPUT ================
---------------- BEGIN dbinfo OUTPUT ----------------
@@ -102,13 +131,13 @@
=============================== describe images
================================
|field ||type ||null||key||default |
- id int(10) unsigned PRI NULL
+ id int(10) unsigned NO PRI NULL
data blob YES NULL
================================ describe stock
================================
|field ||type ||null||key||default |
- item char(20)
+ item char(30) NO
num bigint(20) YES NULL
weight double YES NULL
price double YES NULL
@@ -138,21 +167,21 @@
================ END resetdb OUTPUT ================
---------------- BEGIN usequery OUTPUT ----------------
- Nürnberger Brats 97 1.5 8.79 2005-03-10
- Pickle Relish 87 1.5 1.75 1998-09-04
- Hot Mustard 73 0.95 0.97 1998-05-25
- Hotdog Buns 65 1.1 1.1 1998-04-23
+ Nürnberger Brats 97 1.5 8.79 2005-03-10
+ Pickle Relish 87 1.5 1.75 1998-09-04
+ Hot Mustard 73 0.95 0.97 1998-05-25
+ Hotdog Buns 65 1.1 1.1 1998-04-23
================ END usequery OUTPUT ================
---------------- BEGIN custom1 OUTPUT ----------------
Records found: 4
-Item Num Weight Price Date
-
-Nürnberger Brats 97 1.5 8.79 2005-03-10
-Pickle Relish 87 1.5 1.75 1998-09-04
-Hot Mustard 73 0.95 0.97 1998-05-25
-Hotdog Buns 65 1.1 1.1 1998-04-23
+Item Num Weight Price Date
+
+Nürnberger Brats 97 1.5 8.79 2005-03-10
+Pickle Relish 87 1.5 1.75 1998-09-04
+Hot Mustard 73 0.95 0.97 1998-05-25
+Hotdog Buns 65 1.1 1.1 1998-04-23
================ END custom1 OUTPUT ================
---------------- BEGIN custom2 OUTPUT ----------------
@@ -160,13 +189,13 @@
Query: select * from stock
Records found: 5
-Item Num Weight Price Date
-
-Nürnberger Brats 97 1.5 8.79 2005-03-10
-Pickle Relish 87 1.5 1.75 1998-09-04
-Hot Mustard 73 0.95 0.97 1998-05-25
-Hotdog Buns 65 1.1 1.1 1998-04-23
-Hot Dogs 100 1.5 1.75 1998-09-25
+Item Num Weight Price Date
+
+Nürnberger Brats 97 1.5 8.79 2005-03-10
+Pickle Relish 87 1.5 1.75 1998-09-04
+Hot Mustard 73 0.95 0.97 1998-05-25
+Hotdog Buns 65 1.1 1.1 1998-04-23
+Hot Dogs 100 1.5 1.75 1998-09-25
================ END custom2 OUTPUT ================
---------------- BEGIN custom3 OUTPUT ----------------
@@ -174,25 +203,25 @@
Query: select * from stock
Records found: 5
-Item Num Weight Price Date
-
-Nuerenberger Bratwur 97 1.5 8.79 2005-03-10
-Pickle Relish 87 1.5 1.75 1998-09-04
-Hot Mustard 73 0.95 0.97 1998-05-25
-Hotdog Buns 65 1.1 1.1 1998-04-23
-Hot Dogs 100 1.5 1.75 1998-09-25
+Item Num Weight Price Date
+
+Nuerenberger Bratwurst 97 1.5 8.79 2005-03-10
+Pickle Relish 87 1.5 1.75 1998-09-04
+Hot Mustard 73 0.95 0.97 1998-05-25
+Hotdog Buns 65 1.1 1.1 1998-04-23
+Hot Dogs 100 1.5 1.75 1998-09-25
================ END custom3 OUTPUT ================
---------------- BEGIN custom4 OUTPUT ----------------
Records found: 5
-Item Num Weight Price Date
-
-Hot Dogs 100 1.5 1.75 1998-09-25
-Hot Mustard 73 0.95 0.97 1998-05-25
-Hotdog Buns 65 1.1 1.1 1998-04-23
-Nuerenberger Bratwur 97 1.5 8.79 2005-03-10
-Pickle Relish 87 1.5 1.75 1998-09-04
+Item Num Weight Price Date
+
+Hot Dogs 100 1.5 1.75 1998-09-25
+Hot Mustard 73 0.95 0.97 1998-05-25
+Hotdog Buns 65 1.1 1.1 1998-04-23
+Nuerenberger Bratwurst 97 1.5 8.79 2005-03-10
+Pickle Relish 87 1.5 1.75 1998-09-04
Currently 65 hotdog buns in stock.
================ END custom4 OUTPUT ================
@@ -204,7 +233,7 @@
---------------- BEGIN custom6 OUTPUT ----------------
We have:
- Nuerenberger Bratwur
+ Nuerenberger Bratwurst
Pickle Relish
Hot Mustard
Hotdog Buns
_______________________________________________
Mysqlpp-commits mailing list
[email protected]
https://mail.gna.org/listinfo/mysqlpp-commits
