diff options
author | unknown <msvensson@neptunus.(none)> | 2005-10-31 12:25:08 +0100 |
---|---|---|
committer | unknown <msvensson@neptunus.(none)> | 2005-10-31 12:25:08 +0100 |
commit | 91faec36f9e2591e09a602d6064e9a67dae69ded (patch) | |
tree | aef130518970c644ae37873562a9661e38c6e992 /mysql-test/t/alias.test | |
parent | 8ba28aa38b6ac71b35da8eae28949e276ff4c4f3 (diff) | |
download | mariadb-git-91faec36f9e2591e09a602d6064e9a67dae69ded.tar.gz |
WL#2930 Adding view and cursor 'protocols' to mysqltest
- Cleanup of mysqltest.c before extending it
client/mysqltest.c:
Cleanup functions run_query_* before adding new functionality.
Break out common functions used in both run_query_stmt and run_query_normal
Move functionality for all run_query_* calls into run_query
Since the normal way of handling an unepected error is to call die(which will never return), remove all return values from functions that does not return.
Add comments.
Remove unused vars.
Cleanup...
Removed oboslete syntax @<file_name>, "require" or "result" should be used.
mysql-test/include/master-slave.inc:
remove obsolete syntax @, use "require" command
mysql-test/include/ps_query.inc:
Remove this comment, mysqltest will now produce output. Old mysqltest didn't return any output since command starting with @ was treated as a require. Uggh.
mysql-test/r/mysqltest.result:
Update test result
mysql-test/r/ps_2myisam.result:
Update test result
mysql-test/r/ps_3innodb.result:
Update test result
mysql-test/r/ps_4heap.result:
Update test result
mysql-test/r/ps_5merge.result:
Update test result
mysql-test/r/ps_6bdb.result:
Update test result
mysql-test/r/ps_7ndb.result:
Update test result
mysql-test/t/alias.test:
Remove --disable/enable_ps_protocol, only used to mask bugs in mysqltest
mysql-test/t/group_by.test:
Remove --disable/enable_ps_protocol, only used to mask bugs in mysqltest
mysql-test/t/mysqltest.test:
Add test for "Missing delimiter until eof"
mysql-test/t/union.test:
Remove --disable/enable_ps_protocol, "select found_rows" works with ps_protocol now!
Diffstat (limited to 'mysql-test/t/alias.test')
-rw-r--r-- | mysql-test/t/alias.test | 2 |
1 files changed, 0 insertions, 2 deletions
diff --git a/mysql-test/t/alias.test b/mysql-test/t/alias.test index 2746409c7e5..6546581eef2 100644 --- a/mysql-test/t/alias.test +++ b/mysql-test/t/alias.test @@ -61,9 +61,7 @@ INSERT INTO t1 VALUES (3359361,406,3359361,'Mustermann Musterfrau',7001,'2000-05 INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1509984,2145874,'+','','P',1909154,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); # This died because we used the field Kundentyp twice ---disable_ps_protocol SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie; ---enable_ps_protocol drop table t1; |