Menu
▾
▴
firebird-test — Firebird engine testing, test flight/suite discussion/information
You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(13) |
Oct
(12) |
Nov
(26) |
Dec
(2) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(8) |
Feb
|
Mar
|
Apr
(20) |
May
(31) |
Jun
(7) |
Jul
(6) |
Aug
(56) |
Sep
(2) |
Oct
|
Nov
(3) |
Dec
(1) |
| 2002 |
Jan
(4) |
Feb
(2) |
Mar
(2) |
Apr
(4) |
May
(2) |
Jun
(20) |
Jul
(31) |
Aug
(14) |
Sep
(30) |
Oct
(14) |
Nov
(13) |
Dec
(32) |
| 2003 |
Jan
(29) |
Feb
(46) |
Mar
(1) |
Apr
(3) |
May
(9) |
Jun
(3) |
Jul
(7) |
Aug
(6) |
Sep
(5) |
Oct
(4) |
Nov
(7) |
Dec
(5) |
| 2004 |
Jan
(6) |
Feb
|
Mar
(5) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(3) |
Aug
(3) |
Sep
(4) |
Oct
(4) |
Nov
(5) |
Dec
(3) |
| 2005 |
Jan
|
Feb
(2) |
Mar
(23) |
Apr
(1) |
May
(5) |
Jun
|
Jul
(5) |
Aug
(1) |
Sep
(1) |
Oct
(4) |
Nov
(4) |
Dec
|
| 2006 |
Jan
(1) |
Feb
(3) |
Mar
(1) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(1) |
Aug
(10) |
Sep
(3) |
Oct
(2) |
Nov
(3) |
Dec
|
| 2007 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(2) |
Oct
(1) |
Nov
|
Dec
|
| 2008 |
Jan
|
Feb
(1) |
Mar
(28) |
Apr
(18) |
May
(1) |
Jun
|
Jul
(4) |
Aug
(1) |
Sep
(1) |
Oct
|
Nov
|
Dec
(20) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2010 |
Jan
(1) |
Feb
(1) |
Mar
(2) |
Apr
(2) |
May
|
Jun
(5) |
Jul
(1) |
Aug
(2) |
Sep
(10) |
Oct
(3) |
Nov
(4) |
Dec
(2) |
| 2011 |
Jan
(2) |
Feb
(3) |
Mar
(2) |
Apr
(3) |
May
(1) |
Jun
|
Jul
|
Aug
(5) |
Sep
(2) |
Oct
|
Nov
|
Dec
(1) |
| 2012 |
Jan
(1) |
Feb
(7) |
Mar
(1) |
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
|
Aug
(1) |
Sep
|
Oct
(7) |
Nov
(3) |
Dec
|
| 2014 |
Jan
|
Feb
(3) |
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <Yu2...@po...> - 2002-09-24 16:30:56
|
PCEtLSBzYXZlZCBmcm9tIHVybD0oMDAyMilodHRwOi8vaW50ZXJuZXQuZS1t YWlsIC0tPg0KPGh0bWw+PGhlYWQ+PHRpdGxlPjwvdGl0bGU+DQo8U1RZTEU+ QTpsaW5rIHtmb250OiBib2xkOyBjb2xvcjpibGFjazsgdGV4dC1kZWNvcmF0 aW9uOm5vbmU7fQ0KUCB7dGV4dC1hbGlnbjpsZWZ0OyBmb250OiBub3JtYWwg OHB0ICJWZXJkYW5hIiwgIkFyaWFsIjsgY29sb3I6d2hpdGU7fQ0KUC50eHQg e3RleHQtYWxpZ246Y2VudGVyOyBmb250OiBib2xkIDEycHQvMS4yZW0gICJW ZXJkYW5hIiwgIkFyaWFsIjsgY29sb3I6YmxhY2s7fQ0KUC5zdHJldGNoIHt0 ZXh0LWFsaWduOmNlbnRlcjsgZm9udDogYm9sZCAxNHB0ICJWZXJkYW5hIiwg IkFyaWFsIjsgbGV0dGVyLXNwYWNpbmc6LjE1ZW07IGNvbG9yOmJsYWNrO30N ClAuc21sVHh0IHt0ZXh0LWFsaWduOmNlbnRlcjsgZm9udDogbm9ybWFsIDEw cHQgIlZlcmRhbmEiLCAiQXJpYWwiOyBjb2xvcjpibGFjazt9DQpIMSB7dGV4 dC1hbGlnbjpjZW50ZXI7IGZvbnQ6IGJvbGQgMjRwdCAiVmVyZGFuYSIsICJB cmlhbCI7IGNvbG9yPXdoaXRlO30NClQxIHt0ZXh0LWFsaWduOmNlbnRlcjsg Zm9udDogbm9ybWFsIDEycHQvMS41ZW0gICJWZXJkYW5hIiwgIkFyaWFsIjsg Y29sb3I6YmxhY2s7fTwvU1RZTEU+DQo8L2hlYWQ+PGJvZHkgYmdjb2xvcj0i I2ZmZmZmZiIgdGV4dD0iIzAwMDAwMCIgYm90dG9tTWFyZ2luPTUgPjxjZW50 ZXI+DQo8dGFibGUgd2lkdGg9IjYwMCIgY2VsbHBhZGRpbmc9MCBjZWxsc3Bh Y2luZz0wIGJnY29sb3I9IzY4Njg2ZT48dGJvZHk+DQoJPHRyPjx0ZCBjb2xz cGFuPSIzIiBoZWlnaHQ9MSB3aWR0aD0xIGJnY29sb3I9IzY4Njg2ZT48L3Rk PjwvdHI+DQoJPHRyPg0KCQk8dGQgd2lkdGg9IjEiIGJnY29sb3I9IzY4Njg2 ZT48L3RkPg0KCQk8dGQ+PHRhYmxlIGNlbGxwYWRkaW5nPSIxNSIgY2VsbHNw YWNpbmc9IjMiID48dGJvZHk+DQoJCQk8dHI+PHRkIHZhbGlnbj0idG9wIiBi Z2NvbG9yPSNmZmZmZmY+DQoJCQkJPFAgY2xhc3M9c3RyZXRjaD5Xb3JsZCBF dmVudHMgYXJlIGFmZmVjdGluZyB0aGUgd2F5IHdlIGxpdmUuPEJSPjxCUj5J dJJzIHRpbWUgdG8gZmlnaHQgYmFjayE8QlI+PEJSPjwvUD4NCgkJCQk8Rk9O VCBmYWNlPSJWZXJkYW5hLCBBcmlhbCIgc2l6ZT0iMiI+PGNlbnRlcj4NCgkJ CQkJTGVhcm4gaG93IGludmVzdG9ycyBjYW4gdXRpbGl6ZSBvcHRpb24gc3Ry YXRlZ2llcyB0byBwb3NpdGlvbiA8QlI+dGhlbXNlbHZlcyBpbiB0aGUgdm9s YXRpbGUgb2lsIG1hcmtldC48QlI+PEJSPg0KCQkJCQlXZSBhcmUgYSBsaWNl bnNlZCBwcm9mZXNzaW9uYWwgY29tbW9kaXR5IGJyb2tlcmFnZSBmaXJtIHRo YXQgPEJSPnNwZWNpYWxpemVzIGluIG9wdGlvbnMgdHJhZGluZy48QlI+PEJS Pg0KCQkJCQlPdXIgZmlybSBpcyBtYWtpbmcgYSBtYWpvciByZWNvbW1lbmRh dGlvbiBpbiB0aGUgb2lsIG1hcmtldCAtIDxCUj5zcGVjaWZpY2FsbHkgSGVh dGluZyBPaWwgT3B0aW9ucyE8QlI+PEJSPg0KCQkJCQlUaGUgZmFybWVyknMg YWxtYW5hYyBoYXMgcHJvamVjdGVkIGEgbXVjaCBjb2xkZXIgd2ludGVyIHRo aXMgeWVhciBmb3IgdGhlPEJSPm5vcnRoZXJuIFVuaXRlZCBTdGF0ZXMsIHdo aWxlIHRoZSBkZXBhcnRtZW50IG9mIGVuZXJneSBoYXMgPEJSPnJlcG9ydGVk IHRoYXQgc3VwcGxpZXMgYXJlIGRlY3JlYXNpbmcuPEJSPjxCUj4NCgkJCQkJ RmlsbCBvdXQgb3VyIGZvcm0gYW5kIGdldCB0aGUgPEI+PEEgaHJlZj0iaHR0 cDovL3d3dy5ob3N0aW5nc3ByZWVuZXQuY29tL3d3dzUxOC8iIHRhcmdldD0i X2JsYW5rIj5TcGVjaWFsIFJlcG9ydCBvbiBIZWF0aW5nIE9pbCAyMDAyLjwv Qj48L0E+PEJSPjxCUj4NCgkJCQkJRnV0dXJlcyBhbmQgb3B0aW9ucyBpbnZl c3RpbmcgaW52b2x2ZSBzdWJzdGFudGlhbCByaXNrIG9mIGxvc3MgPEJSPmFu ZCBhcmUgbm90IHN1aXRhYmxlIGZvciBldmVyeW9uZS4gQnV5aW5nIG9wdGlv bnMgcHJvdmlkZXMgPEJSPnByZWRldGVybWluZWQgcmlzayB3aXRoIHVubGlt aXRlZCBwcm9maXQgcG90ZW50aWFsLjxCUj48QlI+DQoJCQkJCURvbpJ0IG1p c3Mgd2hhdCB3ZSBmZWVsIGlzIGEgdW5pcXVlIG9wcG9ydHVuaXR5IHRvIDxC Uj5wb3NpdGlvbiB5b3Vyc2VsZiBpbiB0aGlzIGV4Y2l0aW5nIG1hcmtldC48 QlI+PEJSPg0KCQkJCQlGaWxsIG91dCBvdXIgZm9ybSBhbmQgcmV2aWV3IHlv dXIgPEI+PEEgaHJlZj0iaHR0cDovL3d3dy5ob3N0aW5nc3ByZWVuZXQuY29t L3d3dzUxOC8iIHRhcmdldD0iX2JsYW5rIj5ObyBPYmxpZ2F0aW9uIEZyZWUg SW52ZXN0b3KScyBQYWNrYWdlIDwvQj48L0E+PEJSPmluY2x1ZGluZyB0aGUg Ym9va2xldCBvbiAyNiBQbGFpbiBMYW5ndWFnZSBBbnN3ZXJzIDxCUj5vbiBC dXlpbmcgT3B0aW9ucyBPbiBGdXR1cmVzIENvbnRyYWN0cy4NCgkJCQk8L2Nl bnRlcj48L0ZPTlQ+DQoJCQkJPFAgY2xhc3M9dHh0PjxBIGhyZWY9Imh0dHA6 Ly93d3cuaG9zdGluZ3NwcmVlbmV0LmNvbS93d3c1MTgvIiB0YXJnZXQ9Il9i bGFuayI+PEI+VGhlIGluZm9ybWF0aW9uIGNvdWxkIGJlIHByaWNlbGVzcyE8 L0I+PC9BPjxCUj4NCgkJCQk8Rk9OVCBmYWNlPSJWZXJkYW5hLCBBcmlhbCIg c2l6ZT0iMiI+PGNlbnRlcj4kNTAwMC4wMCBtaW5pbXVtIGludmVzdG1lbnQu ICBUaGlzIG9mZmVyIHZvaWQgd2hlcmUgcHJvaGliaXRlZC48L2NlbnRlcj48 L0ZPTlQ+PC9QPg0KCQkJPC90ZD48L3RyPg0KCQkJPHRyPjx0ZCBjb2xzcGFu PTMgYmdjb2xvcj0jNjY2NjY2PjxIUiBTSVpFPTEgd2lkdGg9IjkwJSIgY29s b3I9d2hpdGU+DQoJCQkJCTxQPllvdXIgcHJpdmFjeSBpcyBleHRyZW1lbHkg aW1wb3J0YW50IHRvIHVzLiBZb3UgcmVxdWVzdGVkIHRvIHJlY2VpdmUNCgkJ CQkJdGhpcyBtYWlsaW5nLCBieSBzdWJzY3JpYmluZyB0aHJvdWdoIG9uZSBv ZiBvdXIgbWFya2V0aW5nIHBhcnRuZXJzLiBBcyBhIGxlYWRlciBpbiBlbWFp bCBtYXJrZXRpbmcsIA0KCQkJCQl3ZSBhcmUgY29tbWl0dGVkIHRvIGRlbGl2 ZXJpbmcgYSBoaWdobHkgcmV3YXJkaW5nIGV4cGVyaWVuY2UsIHdpdGggb2Zm ZXJzIHRoYXQgaW5jbHVkZSBiYXJnYWlucywgDQoJCQkJCWVudGVydGFpbm1l bnQsIGFuZCAgbW9uZXktbWFraW5nIGlkZWFzLiBIb3dldmVyLCBpZiB5b3Ug d2lzaCB0byB1bnN1YnNjcmliZSwNCgkJCQkJPEEgaHJlZj0iaHR0cDovL3d3 dy5ob3N0aW5nc3ByZWVuZXQuY29tL3d3dzUxOC9vcHRvdXQuaHRtbCIgdGFy Z2V0PSJfYmxhbmsiPmNsaWNrIGhlcmU8L0E+ICZuYnNwO1RoaXJkLXBhcnR5 IA0KCQkJCQlvZmZlcnMgY29udGFpbmVkIGluIHRoaXMgZW1haWwgYXJlIHRo ZSBzb2xlIHJlc3BvbnNpYmlsaXR5IG9mIHRoZSBvZmZlciBvcmlnaW5hdG9y Lg0KCQkJCQk8L1A+PEhSIFNJWkU9MSB3aWR0aD0iOTAlIiBjb2xvcj13aGl0 ZT4NCgkJCQk8L3RkPg0KCQkJPC90cj48L1RCT0RZPjwvVEFCTEU+DQoJCTx0 ZCBjb2xzcGFuPSIzIiB3aWR0aD0xIGJnY29sb3I9IzY4Njg2ZT48L3RkPjwv dGQ+DQoJPC90cj4NCjwvVEJPRFk+PC9UQUJMRT48L0NFTlRFUj48L2JvZHk+ PC9odG1sPg0KMjg0M1lacHIzLTMzM2FSQWsxNDk5ZkxEaTAtbDI1 |
|
From: <jul...@ya...> - 2002-09-23 19:33:59
|
PGh0bWw+DQo8aGVhZD4NCjx0aXRsZT5XaWxkICZhbXA7IFJlYWR5PC90aXRs ZT4NCjwvaGVhZD4NCg0KPGJvZHk+DQo8ZGl2IGFsaWduPSJjZW50ZXIiPjxh IGhyZWY9Imh0dHA6Ly93aWxkMDEuYWR1bHRwb2ludHMuY29tL2VudGVyLmh0 bWw/aWQ9NjgyMzY4Ij48aW1nIHNyYz0iaHR0cDovL2NvbGxlZ2UudW5saW1p dGVkLWRvd25sb2Fkcy5jb20vZnBhMDEuanBnIiB3aWR0aD0iNTQwIiBoZWln aHQ9IjQwMCIgYm9yZGVyPSIwIj48L2E+IA0KICA8YnI+DQogIDxhIGhyZWY9 Imh0dHA6Ly93aWxkMDEuYWR1bHRwb2ludHMuY29tL2VudGVyLmh0bWw/aWQ9 NjgyMzY4Ij48Zm9udCBjb2xvcj0iIzk5NjZGRiIgc2l6ZT0iNCIgZmFjZT0i QXJpYWwsIEhlbHZldGljYSwgc2Fucy1zZXJpZiI+VEhFWSdSRSANCiAgV0lM RCAmYW1wOyBSRUFEWSBBTkQgQ0FVR0hUIE9OIENBTUVSQTwvZm9udD48L2E+ PC9kaXY+DQogIA0KPGJyPg0KPGJyPg0KPGJyPg0KPGJyPg0KPGJyPg0KPGJy Pg0KPGJyPg0KPGJyPg0KPGJyPg0KPGJyPg0KDQpIaSBob25leS4uIGRyb3Ag ZXZlcnl0aGluZyBhbmQgbG9vayBhdCB0aGlzIA0KPGJyPg0KPGJyPg0KVG8g dW5zdWJzY3JpYmUgOiA8YSBocmVmPSJodHRwOi8vY29sbGVnZS51bmxpbWl0 ZWQtZG93bmxvYWRzLmNvbS9vcHRvdXQuaHRtbCI+Q2xpY2sgDQpoZXJlIDwv YT4NCjxicj4NCjxicj4gPC9ib2R5Pg0KPC9odG1sPg0KDQoyOTk4YWw1 |
|
From: Wilhelm T. <wi...@se...> - 2002-09-23 08:16:09
|
SNLV works! Thanks a lot Slavomir! "Skopalik Slavomir" <sko...@hl...> wrote in message news:01C...@hl...... > See SNLV UDF function. > > Use like this: > 'asasd'||SNVL(SurName,'') > > SLavek > > > I have this problem with string concatenation: > > > > SELECT FIRST_NAME||LAST_NAME FROM CUSTOMERS > > > > returns NULL when any of the fields has a NULL value. > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Firebird-test mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-test > |
|
From: Martijn T. <m.t...@up...> - 2002-09-23 08:03:51
|
Hi Wilhelm, > Thanks for your quick response. (perhaps it's better to take this to mailto:ib-...@ya...) > I can agree with you, but there are any workarounds? > I don't want the result to be NULL but the value of not null field.... Anyway, if you don't want a NULL result, why are you storing NULL in the column? I mean, if it's an "unknown" value, you will get an "unknown" result - if you want an "empty" ( = "") value, store empty instead of NULL. With regards, Martijn Tonies InterBase Workbench - the developer tool for InterBase http://www.upscene.com Firebird Workbench - the developer tool for Firebird http://www.upscene.com Upscene Productions http://www.upscene.com "This is an object-oriented system. If we change anything, the users object." |
|
From: Skopalik S. <sko...@hl...> - 2002-09-23 07:58:00
|
See SNLV UDF function. Use like this: 'asasd'||SNVL(SurName,'') SLavek > I have this problem with string concatenation: > > SELECT FIRST_NAME||LAST_NAME FROM CUSTOMERS > > returns NULL when any of the fields has a NULL value. > |
|
From: Wilhelm T. <wi...@se...> - 2002-09-23 07:03:07
|
Thanks for your quick response. I can agree with you, but there are any workarounds? I don't want the result to be NULL but the value of not null field.... Thanks |
|
From: Martijn T. <m.t...@up...> - 2002-09-23 06:12:56
|
> Hi everybody! > > I have this problem with string concatenation: > > SELECT FIRST_NAME||LAST_NAME FROM CUSTOMERS > > returns NULL when any of the fields has a NULL value. > > Any ideas? I'm using FireBird 1.0 My idea: as designed - and according to the SQL standard. <something> + NULL = NULL <something> || NULL = NULL With regards, Martijn Tonies InterBase Workbench - the developer tool for InterBase http://www.upscene.com Firebird Workbench - the developer tool for Firebird http://www.upscene.com Upscene Productions http://www.upscene.com "This is an object-oriented system. If we change anything, the users object." |
|
From: Wilhelm T. <wi...@se...> - 2002-09-23 05:09:45
|
Hi everybody! I have this problem with string concatenation: SELECT FIRST_NAME||LAST_NAME FROM CUSTOMERS returns NULL when any of the fields has a NULL value. Any ideas? I'm using FireBird 1.0 Thanks |
|
From: <was...@ho...> - 2002-09-22 09:26:19
|
PGh0bWw+DQo8aGVhZD4NCjx0aXRsZT5XaWxkICZhbXA7IFJlYWR5PC90aXRs ZT4NCjwvaGVhZD4NCg0KPGJvZHk+DQo8ZGl2IGFsaWduPSJjZW50ZXIiPjxh IGhyZWY9Imh0dHA6Ly93aWxkMDEuYWR1bHRwb2ludHMuY29tL2VudGVyLmh0 bWw/aWQ9NjgyMzY4Ij48aW1nIHNyYz0iaHR0cDovL3d3dy5hZHVsdHBvaW50 cy5jb20vZnBhcy93aWxkYW5kcmVhZHkvZnBhMDEuanBnIiB3aWR0aD0iNTQw IiBoZWlnaHQ9IjQwMCIgYm9yZGVyPSIwIj48L2E+IA0KICA8YnI+DQogIDxh IGhyZWY9Imh0dHA6Ly93aWxkMDEuYWR1bHRwb2ludHMuY29tL2VudGVyLmh0 bWw/aWQ9NjgyMzY4Ij48Zm9udCBjb2xvcj0iIzk5NjZGRiIgc2l6ZT0iNCIg ZmFjZT0iQXJpYWwsIEhlbHZldGljYSwgc2Fucy1zZXJpZiI+VEhFWSdSRSAN CiAgV0lMRCAmYW1wOyBSRUFEWSBBTkQgQ0FVR0hUIE9OIENBTUVSQTwvZm9u dD48L2E+PC9kaXY+DQogIA0KPGJyPg0KPGJyPg0KPGJyPg0KPGJyPg0KPGJy Pg0KPGJyPg0KPGJyPg0KPGJyPg0KPGJyPg0KPGJyPg0KDQpIZWxsbyBiYWJl IGxvbmcgdGltZSBubyB0YWxrISANCjxicj4NCjxicj4NClRvIHVuc3Vic2Ny aWJlIDogPGEgaHJlZj0iaHR0cDovL2NvbGxlZ2UudW5saW1pdGVkLWRvd25s b2Fkcy5jb20vb3B0b3V0Lmh0bWwiPkNsaWNrIA0KaGVyZSA8L2E+DQo8YnI+ DQo8YnI+IDwvYm9keT4NCjwvaHRtbD4NCg0KMjU3NWRLWEo3LTM4NGhrTkk2 OTMzbFlCazQtMjY1VEFPUTkwNzRhSXloMS00NTFwc0RyMDk0M29MWHQxLTQx M3pFbDYy |
|
From: <Mag...@ya...> - 2002-09-21 04:38:24
|
On January 1st 2002, the European countries began using the new Euro. Never before have so many countries with such powerful economies united to use a single currency. Get your piece of history now! We would like to send you a FREE Euro and a FREE report on world currency. Just visit our site to request your Euro and Euro report: http://vicky.frankhostsnetworks.com/euro1/ In addition to our currency report, you can receive our FREE INVESTMENT PACKAGE: * Learn how $10,000 in options will leverage $1,000,000 in Euro Currency. This means even a small movement in the market has huge profit potential. If you are over age 18 and have some risk capital, it's important that you find out how the Euro will change the economic world and how you can profit! http://vicky.frankhostsnetworks.com/euro1/ Please carefully evaluate your financial position before trading. Only risk capital should be used. http://vicky.frankhostsnetworks.com/euro1/optout.html To OptOut. 1003XWoD4-044DpOZ3191mmVd5-223qYGM9639zfAv4-058sBYx9523mLyx7-008fl61 |
|
From: Gerhardus G. <ger...@se...> - 2002-09-20 17:36:12
|
Hi The more appropiate place to post would be ib-...@ya... for support questions. I suspect your problem has to do with mixing Numeric and Integer. Try to cast everything to either integer or numeric. I am not sure which is bigger but that would be the right one. eg cast(myvariable as integer) Groete Gerhardus > > Hi people > > I have a big problem. > I'm using FB-1.0.0.796-0.64IO.i386.rpm and when I define a calculate field > like > NUMERIC(18,4)*NUMERIC(18,8)/INTEGER i got wrong values > > eg. 157809.0000*1.00000000/1077=14652.6462 > when the correct value is 146.5264 > > Thanks in advance > > Agostinho Sousa > ago...@cl... |
|
From: news.clix.pt <ago...@cl...> - 2002-09-20 16:25:57
|
Hi people I have a big problem. I'm using FB-1.0.0.796-0.64IO.i386.rpm and when I define a calculate field like NUMERIC(18,4)*NUMERIC(18,8)/INTEGER i got wrong values eg. 157809.0000*1.00000000/1077=14652.6462 when the correct value is 146.5264 Thanks in advance Agostinho Sousa ago...@cl... |
|
From: Skopalik S. <sko...@hl...> - 2002-09-19 09:10:50
|
> SQL> INSERT INTO test VALUES(6,null); > Statement failed, SQLCODE = -803 > > violation of PRIMARY or UNIQUE KEY constraint "UNQ" on table "TEST" Sorry, my mistake, I forget unique in script. > Perhaps you have a special version of Firebird? > > Anyway, once I recreated the table without the unique index I tried this: I don't have problem with FB, I work on test for FB, reading doc and comparing result with doc. I try use fb-test to consult result of stataments before I post error to tracker database. > > Dialect 3 databases do integer arithmetic on integers. It doesn't > promote them to floats in anticipation of our expectations. It is > arguable whether the new behaviour is correct. Partisans of that > argument have fought it out twice now in ib-support. > > I'll leave you to experiment with the variations: > > SQL> SELECT AVG(id*1.00) FROM test > Problem is probably in FB doc, because AVG (or integer aritmetic ?) are not properly defined. Finally, integer div is unexcepted in result, but it is only my opinion. Slavek |
|
From: <Mar...@ya...> - 2002-09-17 23:57:33
|
PCEtLSBzYXZlZCBmcm9tIHVybD0oMDAyMilodHRwOi8vaW50ZXJuZXQuZS1t YWlsIC0tPg0KPEhUTUw+PEhFQUQ+DQo8VElUTEU+PC9USVRMRT4NCjxTVFlM RT5BOmxpbmsge2NvbG9yOnJlZH08L1NUWUxFPg0KPC9IRUFEPg0KPEJPRFkg YmdDb2xvcj0jZmZmZmZmPg0KPFRBQkxFIGNlbGxTcGFjaW5nPTAgY2VsbFBh ZGRpbmc9MTQgd2lkdGg9NjAwIGJvcmRlcj0zIGJvcmRlcmNvbG9yZGFyaz0j MDAzMzY2IGJvcmRlcmNvbG9ybGlnaHQ9IzY2OTk5OSBib3JkZXJjb2xvcj0j MDAzMzY2Pg0KICA8VEJPRFk+DQoJPFRSPg0KCTxURCB3aWR0aD0yMDAgYmdj b2xvcj0jNDY4MmI0IHZhbGlnbj10b3A+PEZPTlQgZmFjZT0iVmVyZGFuYSwg QXJpYWwiIGNvbG9yPSNmZmZmZmYgc2l6ZT00Pg0KCQk8Qj5ET04nVCBEUkVB TSBUTyBMSVZFISAuLi48QlI+PEJSPkxJVkUgVEhFIERSRUFNPC9CPjxCUj48 L0ZPTlQ+DQoJCTxGT05UIGZhY2U9IlZlcmRhbmEsIEFyaWFsIiBjb2xvcj0j ZmZmZmZmIHNpemU9Mj48QlI+PEI+DQoJCTxMST5CZSB5b3VyIG93biBCT1NT DQoJCTxMST5Xb3JrIHlvdXIgb3duIEhPVVJTDQoJCTxMST5ObyBGSVhFRCBv dmVyaGVhZA0KCQk8TEk+SGlnaCBDQVNIIHJldHVybiANCgkJPExJPklOQ09N RSBTdXBwbGVtZW50DQoJCTxMST5QYXJ0IFRpbWUgQnVzaW5lc3M8L0I+PC9G T05UPjwvTEk+DQoJCTxmb250IGNvbG9yPSM0NjgyYjQ+cXdlcnR5dWlvcGxr ajxCUj5oZ2Zkc2F6eGN2Ym5tLC48QlI+LzA5ODc2NTQzMjE8QlI+a2RqZGpk aGZ5aHNnZ2Y8QlI+SkRIWEdETkdEUlc8QlI+S0ZPRkdKREhESEdTPEJSPnNh enhjdmJubSwuPEJSPi8wOTg3NjU0MzIxPEJSPmtkamRqZGhmeWhzZ2dmPEJS PkpESFhHRDxCUj5xd2VydHl1aW9wbGtqPEJSPmhnZmRzYXp4Y3Zibm0sLjxC Uj4vMDk4NzY1NDMyMTxCUj5rZGpkamRoZnloc2dnZjxCUj5KREhYR0ROR0RS VzxCUj5LRk9GR0pESERIR1M8L2ZvbnQ+DQoJPC9URD4NCiAgICA8VEQgIHdp ZHRoPTQwMD4NCgkJPEZPTlQgZmFjZT0iVmVyZGFuYSwgQXJpYWwiIGNvbG9y PSMwMDAwNTAgc2l6ZT0zPg0KCQk8Qj5EZWFyIEZ1dHVyZSBCdXNpbmVzcyBP d25lciw8L0I+IA0KCQk8UCBhbGlnbj1jZW50ZXI+PEZPTlQgZmFjZT0iVmVy ZGFuYSwgQXJpYWwiIGNvbG9yPSMwMDAwNTAgc2l6ZT0yPg0KCQlZb3UgY2Fu IG5vdyBmb3IgdGhlIGZpcnN0IHRpbWUsIG93biBhIGJ1c2luZXNzIGluIHlv dXIgYXJlYSB3aXRoIHRoZSBtb3N0IHVuaXF1ZSwgaW5ub3ZhdGl2ZSBwcm9k dWN0IGluIEFtZXJpY2EgdG9kYXkuPEJSPjxCUj4NCgkJV29yayBsZXNzIHRo YW4gdGVuIGhvdXJzIGEgd2VlayB3aXRoIHRoZSBwb3RlbnRpYWwgdG8gZWFy biAkNTAsMDAwIGEgeWVhci48QlI+PEJSPkhlcmUncyBob3chICBPdmVyIDMw MCBNaWxsaW9uIHBlb3BsZSB1c2UgdGhpcyBwcm9kdWN0IGluIHRoZSBVLlMu DQoJCWRhaWx5LCB0aGF0J3MgcmlnaHQsIG92ZXIgMzAwIE1pbGxpb24gcGVv cGxlLjxCUj48Zm9udCBjb2xvcj0jRkZGRkZGPnF3ZXJ0eXVpb3Bsa2pqZmpo bSwuO3BvaXl1NVNIREZKSUZMaGdmZHNhenhjdmJubSwuPC9mb250PjxCUj5U aGUgcHJvZml0IG1hcmdpbiB3aXRoIHVzIGlzIGFuIGFtYXppbmcgNDAwJSwg eW91IHdpbGwgYmUgc2F5aW5nDQoJCXRvIHlvdXJzZWxmIHdoeSBkaWRuJ3Qg SSB0aGluayBvZiB0aGF0ITxCUj48Zm9udCBjb2xvcj0jRkZGRkZGPnF3ZXJ0 eXVpb3Bsa2pqZmpobSwuO3BvaXl1NVNIREZKSUZMaGdmZHNhenhjdmJubSwu PC9mb250PjxCUj4JQnJlYWsgZG93biB0aGUgd2FsbHMgYW5kIGxpdmUgdGhp cyBsaWZlIHlvdSd2ZSBvbmx5IGRyZWFtZWQgYWJvdXQuPEJSPjxCUj4NCgkJ PEJSPkF2YWlsYWJpbHR5IGlzIHlvdXIgYXJlYSBpcyBsaW1pdGVkLjxCUj48 QSBocmVmPSJodHRwOi8vMzY1LmJ1c2luZXNzb25saW5lbm93LmNvbS9icnVz aC8iPg0KCQk8Qj5DTElDSyBIRVJFIE5PVzwvQj48L0E+PEJSPlNvIHlvdSB0 b28gY2FuIHJlY2VpdmUgeW91ciBmcmVlIGluZm9ybWF0aW9uIHBhY2thZ2Ug dG9kYXkuDQoJCTxCUj48QlI+PEEgaHJlZj0iaHR0cDovLzM2NS5idXNpbmVz c29ubGluZW5vdy5jb20vYnJ1c2gvIj4NCgkJPEZPTlQgZmFjZT0iVmVyZGFu YSwgQXJpYWwiIGNvbG9yPSNjYzMzMzMgc2l6ZT01PjxCPjxJPkRvbid0IHdh aXQgYW55IGxvbmdlciE8QlI+R2V0IFN0YXJ0ZWQgVG9kYXkhITwvST48L0I+ PC9GT05UPjwvQT48L0ZPTlQ+PC9QPg0KCTwvVEQ+PC9UUj48L1RCT0RZPjwv VEFCTEU+PEJSPg0KPFRBQkxFIHdpZHRoPTU1MD4NCiAgPFRCT0RZPg0KICA8 VFIgPg0KICAgIDxURCBhbGlnbj1jZW50ZXI+DQoJCTxIUiBTSVpFPTEgd2lk dGg9IjEwMCUiIGNvbG9yPWluZGlnbz4NCgkJPGZvbnQgc2l6ZT0iMSIgZmFj ZT0iVmVyZGFuYSwgQXJpYWwiPllvdXIgZW1haWwgYWRkcmVzcyB3YXMgb2J0 YWluZWQgZnJvbSBhbiBvcHQtaW4gbGlzdC4gT3B0LWluIE1SU0EgTGlzdA0K CQk8QlI+UHVyY2hhc2UgQ29kZSAjIDMxMi0yNDEyLiAgSWYgeW91IHdpc2gg dG8gYmUgdW5zdWJzY3JpYmVkIGZyb20gdGhpcyBsaXN0LCBwbGVhc2UgPEEg aHJlZj0iaHR0cDovLzM2NS5idXNpbmVzc29ubGluZW5vdy5jb20vYnJ1c2gv cmVtb3ZlLmh0bWwiIHRhcmdldD0iX2JsYW5rIj5jbGljayBoZXJlPC9BPjwv Zm9udD4NCgkJPGZvbnQgY29sb3I9ZmZmZmZmPnF3ZXJ0eXVpb3Bsa2poZ2Zk c2F6eGN2Ym5tLC4vMDk4NzY1NDMyMTwvZm9udD4NCiAgICA8L1REPjwvVFI+ PC9UQk9EWT48L1RBQkxFPjwvQk9EWT48L0hUTUw+DQo5Nzg3SlZMdTQtNTU4 SmZkUDM1bDE4 |
|
From: <Lau...@ho...> - 2002-09-17 11:27:14
|
T24gSmFudWFyeSAxc3QgMjAwMiwgdGhlIEV1cm9wZWFuIGNvdW50cmllcyBi ZWdhbg0KdXNpbmcgdGhlIG5ldyBFdXJvLiAgTmV2ZXIgYmVmb3JlIGhhdmUg c28NCm1hbnkgY291bnRyaWVzIHdpdGggc3VjaCBwb3dlcmZ1bCBlY29ub21p ZXMgdW5pdGVkDQp0byB1c2UgYSBzaW5nbGUgY3VycmVuY3kuICBHZXQgeW91 ciBwaWVjZSBvZiBoaXN0b3J5DQpub3chICBXZSB3b3VsZCBsaWtlIHRvIHNl bmQgeW91IGEgRlJFRSBFdXJvDQphbmQgYSBGUkVFIHJlcG9ydCBvbiB3b3Js ZCBjdXJyZW5jeS4gIEp1c3QgdmlzaXQNCm91ciBzaXRlIHRvIHJlcXVlc3Qg eW91ciBFdXJvIGFuZCBFdXJvIHJlcG9ydDoNCg0KaHR0cDovL3ZpY2t5Lmhv c3RjZW50cmVsLmNvbS9ldXJvMS8NCg0KSW4gYWRkaXRpb24gdG8gb3VyIGN1 cnJlbmN5IHJlcG9ydCwgeW91IGNhbiByZWNlaXZlDQpvdXIgRlJFRSBJTlZF U1RNRU5UIFBBQ0tBR0U6DQoNCiogIExlYXJuIGhvdyAkMTAsMDAwIGluIG9w dGlvbnMgd2lsbCBsZXZlcmFnZSAkMSwwMDAsMDAwIGluDQpFdXJvIEN1cnJl bmN5LiBUaGlzIG1lYW5zIGV2ZW4gYSBzbWFsbCBtb3ZlbWVudCBpbiB0aGUg bWFya2V0DQpoYXMgaHVnZSBwcm9maXQgcG90ZW50aWFsLg0KDQpJZiB5b3Ug YXJlIG92ZXIgYWdlIDE4IGFuZCBoYXZlIHNvbWUgcmlzayBjYXBpdGFsLCBp dCdzDQppbXBvcnRhbnQgdGhhdCB5b3UgZmluZCBvdXQgaG93IHRoZSBFdXJv IHdpbGwNCmNoYW5nZSB0aGUgZWNvbm9taWMgd29ybGQgYW5kIGhvdyB5b3Ug Y2FuIHByb2ZpdCENCg0KaHR0cDovL3ZpY2t5Lmhvc3RjZW50cmVsLmNvbS9l dXJvMS8NCg0KJDEwLDAwMCBtaW5pbXVtIGludmVzdG1lbnQNCg0KUGxlYXNl IGNhcmVmdWxseSBldmFsdWF0ZSB5b3VyIGZpbmFuY2lhbCBwb3NpdGlvbiBi ZWZvcmUNCnRyYWRpbmcuICBPbmx5IHJpc2sgY2FwaXRhbCBzaG91bGQgYmUg dXNlZC4NCg0KaHR0cDovL3ZpY2t5Lmhvc3RjZW50cmVsLmNvbS9ldXJvMS9v cHRvdXQuaHRtbCBUbyBPcHRPdXQuDQoNCg0KDQoNCg0KNTAyOGtKR045LWw5 |
|
From: Paul R. <pr...@ib...> - 2002-09-15 19:53:56
|
Skopalik Slavomir wrote:
>>From description of AVG function (Original FireBird Lang. Ref.) I can't
> determine result of this:
> CREATE TABLE test( id INTEGER NOT NULL CONSTRAINT unq UNIQUE,
> text VARCHAR(32));
>
The second insert generates this error:
SQL> INSERT INTO test VALUES(6,null);
Statement failed, SQLCODE = -803
violation of PRIMARY or UNIQUE KEY constraint "UNQ" on table "TEST"
Perhaps you have a special version of Firebird?
Anyway, once I recreated the table without the unique index I tried this:
SELECT AVG(id*1.0) FROM test1;
AVG
=====================
5.6
which is the answer I expected.
Dialect 3 databases do integer arithmetic on integers. It doesn't
promote them to floats in anticipation of our expectations. It is
arguable whether the new behaviour is correct. Partisans of that
argument have fought it out twice now in ib-support.
I'll leave you to experiment with the variations:
SQL> SELECT AVG(id*1.00) FROM test
etc.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
|
|
From: Skopalik S. <sko...@hl...> - 2002-09-15 11:21:13
|
From description of AVG function (Original FireBird Lang. Ref.) I can't
determine result of this:
CREATE TABLE test( id INTEGER NOT NULL CONSTRAINT unq UNIQUE,
text VARCHAR(32));
INSERT INTO test VALUES(5,null);
INSERT INTO test VALUES(6,null);
INSERT INTO test VALUES(6,null);
SELECT AVG(id) FROM test;
FB 1.0.821 - result is 5 !
It's see as SUM() DIV COUNT() insted Round(SUM()/COUNT).
Slavek
ing. Slavomir Skopalik DEL a.s.
Olomoucka 355 Marianske udoli 783 75
Czech Republic
----------------------------------------------
Tel: 068 535 35 48
Mobil: 0602 795 874
Fax: 068 535 23 64
e-mail:sko...@hl...
http://hlubocky.del.cz
|
|
From: <Ray...@ya...> - 2002-09-14 08:09:11
|
PCEtLSBzYXZlZCBmcm9tIHVybD0oMDAyMilodHRwOi8vaW50ZXJuZXQuZS1t YWlsIC0tPg0KPEhUTUw+PEhFQUQ+DQo8VElUTEU+PC9USVRMRT4NCjxTVFlM RT5BOmxpbmsge2NvbG9yOnJlZH08L1NUWUxFPg0KPC9IRUFEPg0KPEJPRFkg YmdDb2xvcj0jZmZmZmZmPg0KPFRBQkxFIGNlbGxTcGFjaW5nPTAgY2VsbFBh ZGRpbmc9MTQgd2lkdGg9NjAwIGJvcmRlcj0zIGJvcmRlcmNvbG9yZGFyaz0j MDAzMzY2IGJvcmRlcmNvbG9ybGlnaHQ9IzY2OTk5OSBib3JkZXJjb2xvcj0j MDAzMzY2Pg0KICA8VEJPRFk+DQoJPFRSPg0KCTxURCB3aWR0aD0yMDAgYmdj b2xvcj0jNDY4MmI0IHZhbGlnbj10b3A+PEZPTlQgZmFjZT0iVmVyZGFuYSwg QXJpYWwiIGNvbG9yPSNmZmZmZmYgc2l6ZT00Pg0KCQk8Qj5ET04nVCBEUkVB TSBUTyBMSVZFISAuLi48QlI+PEJSPkxJVkUgVEhFIERSRUFNPC9CPjxCUj48 L0ZPTlQ+DQoJCTxGT05UIGZhY2U9IlZlcmRhbmEsIEFyaWFsIiBjb2xvcj0j ZmZmZmZmIHNpemU9Mj48QlI+PEI+DQoJCTxMST5CZSB5b3VyIG93biBCT1NT DQoJCTxMST5Xb3JrIHlvdXIgb3duIEhPVVJTDQoJCTxMST5ObyBGSVhFRCBv dmVyaGVhZA0KCQk8TEk+SGlnaCBDQVNIIHJldHVybiANCgkJPExJPklOQ09N RSBTdXBwbGVtZW50DQoJCTxMST5QYXJ0IFRpbWUgQnVzaW5lc3M8L0I+PC9G T05UPjwvTEk+DQoJCTxmb250IGNvbG9yPSM0NjgyYjQ+cXdlcnR5dWlvcGxr ajxCUj5oZ2Zkc2F6eGN2Ym5tLC48QlI+LzA5ODc2NTQzMjE8QlI+a2RqZGpk aGZ5aHNnZ2Y8QlI+SkRIWEdETkdEUlc8QlI+S0ZPRkdKREhESEdTPEJSPnNh enhjdmJubSwuPEJSPi8wOTg3NjU0MzIxPEJSPmtkamRqZGhmeWhzZ2dmPEJS PkpESFhHRDxCUj5xd2VydHl1aW9wbGtqPEJSPmhnZmRzYXp4Y3Zibm0sLjxC Uj4vMDk4NzY1NDMyMTxCUj5rZGpkamRoZnloc2dnZjxCUj5KREhYR0ROR0RS VzxCUj5LRk9GR0pESERIR1M8L2ZvbnQ+DQoJPC9URD4NCiAgICA8VEQgIHdp ZHRoPTQwMD4NCgkJPEZPTlQgZmFjZT0iVmVyZGFuYSwgQXJpYWwiIGNvbG9y PSMwMDAwNTAgc2l6ZT0zPg0KCQk8Qj5EZWFyIEZ1dHVyZSBCdXNpbmVzcyBP d25lciw8L0I+IA0KCQk8UCBhbGlnbj1jZW50ZXI+PEZPTlQgZmFjZT0iVmVy ZGFuYSwgQXJpYWwiIGNvbG9yPSMwMDAwNTAgc2l6ZT0yPg0KCQlZb3UgY2Fu IG5vdyBmb3IgdGhlIGZpcnN0IHRpbWUsIG93biBhIGJ1c2luZXNzIGluIHlv dXIgYXJlYSB3aXRoIHRoZSBtb3N0IHVuaXF1ZSwgaW5ub3ZhdGl2ZSBwcm9k dWN0IGluIEFtZXJpY2EgdG9kYXkuPEJSPjxCUj4NCgkJV29yayBsZXNzIHRo YW4gdGVuIGhvdXJzIGEgd2VlayB3aXRoIHRoZSBwb3RlbnRpYWwgdG8gZWFy biAkNTAsMDAwIGEgeWVhci48QlI+PEJSPkhlcmUncyBob3chICBPdmVyIDMw MCBNaWxsaW9uIHBlb3BsZSB1c2UgdGhpcyBwcm9kdWN0IGluIHRoZSBVLlMu DQoJCWRhaWx5LCB0aGF0J3MgcmlnaHQsIG92ZXIgMzAwIE1pbGxpb24gcGVv cGxlLjxCUj48Zm9udCBjb2xvcj0jRkZGRkZGPnF3ZXJ0eXVpb3Bsa2pqZmpo bSwuO3BvaXl1NVNIREZKSUZMaGdmZHNhenhjdmJubSwuPC9mb250PjxCUj5U aGUgcHJvZml0IG1hcmdpbiB3aXRoIHVzIGlzIGFuIGFtYXppbmcgNDAwJSwg eW91IHdpbGwgYmUgc2F5aW5nDQoJCXRvIHlvdXJzZWxmIHdoeSBkaWRuJ3Qg SSB0aGluayBvZiB0aGF0ITxCUj48Zm9udCBjb2xvcj0jRkZGRkZGPnF3ZXJ0 eXVpb3Bsa2pqZmpobSwuO3BvaXl1NVNIREZKSUZMaGdmZHNhenhjdmJubSwu PC9mb250PjxCUj4JQnJlYWsgZG93biB0aGUgd2FsbHMgYW5kIGxpdmUgdGhp cyBsaWZlIHlvdSd2ZSBvbmx5IGRyZWFtZWQgYWJvdXQuPEJSPjxCUj4NCgkJ PEJSPkF2YWlsYWJpbHR5IGlzIHlvdXIgYXJlYSBpcyBsaW1pdGVkLjxCUj48 QSBocmVmPSJodHRwOi8vMzY1LmJ1c2luZXNzb25saW5lbm93LmNvbS9icnVz aC8iPg0KCQk8Qj5DTElDSyBIRVJFIE5PVzwvQj48L0E+PEJSPlNvIHlvdSB0 b28gY2FuIHJlY2VpdmUgeW91ciBmcmVlIGluZm9ybWF0aW9uIHBhY2thZ2Ug dG9kYXkuDQoJCTxCUj48QlI+PEEgaHJlZj0iaHR0cDovLzM2NS5idXNpbmVz c29ubGluZW5vdy5jb20vYnJ1c2gvIj4NCgkJPEZPTlQgZmFjZT0iVmVyZGFu YSwgQXJpYWwiIGNvbG9yPSNjYzMzMzMgc2l6ZT01PjxCPjxJPkRvbid0IHdh aXQgYW55IGxvbmdlciE8QlI+R2V0IFN0YXJ0ZWQgVG9kYXkhITwvST48L0I+ PC9GT05UPjwvQT48L0ZPTlQ+PC9QPg0KCTwvVEQ+PC9UUj48L1RCT0RZPjwv VEFCTEU+PEJSPg0KPFRBQkxFIHdpZHRoPTU1MD4NCiAgPFRCT0RZPg0KICA8 VFIgPg0KICAgIDxURCBhbGlnbj1jZW50ZXI+DQoJCTxIUiBTSVpFPTEgd2lk dGg9IjEwMCUiIGNvbG9yPWluZGlnbz4NCgkJPGZvbnQgc2l6ZT0iMSIgZmFj ZT0iVmVyZGFuYSwgQXJpYWwiPllvdXIgZW1haWwgYWRkcmVzcyB3YXMgb2J0 YWluZWQgZnJvbSBhbiBvcHQtaW4gbGlzdC4gT3B0LWluIE1SU0EgTGlzdA0K CQk8QlI+UHVyY2hhc2UgQ29kZSAjIDMxMi0yNDEyLiAgSWYgeW91IHdpc2gg dG8gYmUgdW5zdWJzY3JpYmVkIGZyb20gdGhpcyBsaXN0LCBwbGVhc2UgPEEg aHJlZj0iaHR0cDovLzM2NS5idXNpbmVzc29ubGluZW5vdy5jb20vYnJ1c2gv cmVtb3ZlLmh0bWwiIHRhcmdldD0iX2JsYW5rIj5jbGljayBoZXJlPC9BPjwv Zm9udD4NCgkJPGZvbnQgY29sb3I9ZmZmZmZmPnF3ZXJ0eXVpb3Bsa2poZ2Zk c2F6eGN2Ym5tLC4vMDk4NzY1NDMyMTwvZm9udD4NCiAgICA8L1REPjwvVFI+ PC9UQk9EWT48L1RBQkxFPjwvQk9EWT48L0hUTUw+DQowMDEwRHR4RzUtNDQ5 RGFucTMzMzdOVndxOS0wOTdQV3dmODk2MGtlQndsNDA= |
|
From: Skopalik S. <sko...@hl...> - 2002-09-10 08:53:59
|
> With SHOW statement, we'll be bound to the ISQL. I'd like implement > tests in Python instead whenever possible (at least for core set of > tests), just for reference. If any test fails, we have to investigate the > real source of this failure, including db layer. Using ISQL along with > Python/kinterbasdb will add one more layer to check. Or can you provide > us both, SHOW and system tables result checks ? In the worst case, I can > translate SHOW to system tables myself. > > Best regards > Pavel Cisar > http://www.ibphoenix.com > For all your upto date Firebird and > InterBase information I think, that test trough isql (or any else) is not problem, if any test fails, it easy locate why, but is hard to locate any fails before release. Else technique: many test can be realized as excepted effect on data like this test : SET TERM ^; CREATE PROCEDURE test RETURNS (id INTEGER)AS BEGIN id=1; END ^ CREATE PROCEDURE testd RETURNS (id INTEGER)AS BEGIN EXECUTE PROCEDURE test RETURNING_VALUES :id; END ^ /* Tested command: */ ALTER PROCEDURE test(aid INTEGER) RETURNS (id INTEGER)AS BEGIN id=aid; END ^ SET TERM ;^ EXECUTE PROCEDURE testd; /* Expected result: No Error. Additional checks: ID ============ 2 Slavek |
|
From: <Pea...@ye...> - 2002-09-10 00:32:05
|
T24gSmFudWFyeSAxc3QgMjAwMiwgdGhlIEV1cm9wZWFuIGNvdW50cmllcyBi ZWdhbg0KdXNpbmcgdGhlIG5ldyBFdXJvLiAgTmV2ZXIgYmVmb3JlIGhhdmUg c28NCm1hbnkgY291bnRyaWVzIHdpdGggc3VjaCBwb3dlcmZ1bCBlY29ub21p ZXMgdW5pdGVkDQp0byB1c2UgYSBzaW5nbGUgY3VycmVuY3kuICBHZXQgeW91 ciBwaWVjZSBvZiBoaXN0b3J5DQpub3chICBXZSB3b3VsZCBsaWtlIHRvIHNl bmQgeW91IGEgRlJFRSBFdXJvDQphbmQgYSBGUkVFIHJlcG9ydCBvbiB3b3Js ZCBjdXJyZW5jeS4gIEp1c3QgdmlzaXQNCm91ciBzaXRlIHRvIHJlcXVlc3Qg eW91ciBFdXJvIGFuZCBFdXJvIHJlcG9ydDoNCg0KaHR0cDovL3ZpY2t5Lmhv c3RjZW50cmVsLmNvbS9ldXJvMS8NCg0KSW4gYWRkaXRpb24gdG8gb3VyIGN1 cnJlbmN5IHJlcG9ydCwgeW91IGNhbiByZWNlaXZlDQpvdXIgRlJFRSBJTlZF U1RNRU5UIFBBQ0tBR0U6DQoNCiogIExlYXJuIGhvdyAkMTAsMDAwIGluIG9w dGlvbnMgd2lsbCBsZXZlcmFnZSAkMSwwMDAsMDAwIGluDQpFdXJvIEN1cnJl bmN5LiBUaGlzIG1lYW5zIGV2ZW4gYSBzbWFsbCBtb3ZlbWVudCBpbiB0aGUg bWFya2V0DQpoYXMgaHVnZSBwcm9maXQgcG90ZW50aWFsLg0KDQpJZiB5b3Ug YXJlIG92ZXIgYWdlIDE4IGFuZCBoYXZlIHNvbWUgcmlzayBjYXBpdGFsLCBp dCdzDQppbXBvcnRhbnQgdGhhdCB5b3UgZmluZCBvdXQgaG93IHRoZSBFdXJv IHdpbGwNCmNoYW5nZSB0aGUgZWNvbm9taWMgd29ybGQgYW5kIGhvdyB5b3Ug Y2FuIHByb2ZpdCENCg0KaHR0cDovL3ZpY2t5Lmhvc3RjZW50cmVsLmNvbS9l dXJvMS8NCg0KJDEwLDAwMCBtaW5pbXVtIGludmVzdG1lbnQNCg0KUGxlYXNl IGNhcmVmdWxseSBldmFsdWF0ZSB5b3VyIGZpbmFuY2lhbCBwb3NpdGlvbiBi ZWZvcmUNCnRyYWRpbmcuICBPbmx5IHJpc2sgY2FwaXRhbCBzaG91bGQgYmUg dXNlZC4NCg0KaHR0cDovL3ZpY2t5Lmhvc3RjZW50cmVsLmNvbS9ldXJvMS9v cHRvdXQuaHRtbCBUbyBPcHRPdXQuDQoNCg0KDQoNCg0KNzU0OXBQaU0yLTI2 MEZSU3Q3NDg0TlpEajUtNjAxdHBFTjU3MDVKclFUMS00NzByanBMMWw0OQ== |
|
From: Pavel C. <pc...@us...> - 2002-09-09 18:17:03
|
Hi, On 8 Sep 2002 at 15:03, Skopalik Slavomir wrote: > I was developed test script, that using SHOW isql statament instead select from RDB$... tables. > I'm think, that is more readable (and little clear) than select from system tables because > system tables may be change. > Can be used this technique is test scripts ? With SHOW statement, we'll be bound to the ISQL. I'd like implement tests in Python instead whenever possible (at least for core set of tests), just for reference. If any test fails, we have to investigate the real source of this failure, including db layer. Using ISQL along with Python/kinterbasdb will add one more layer to check. Or can you provide us both, SHOW and system tables result checks ? In the worst case, I can translate SHOW to system tables myself. Best regards Pavel Cisar http://www.ibphoenix.com For all your upto date Firebird and InterBase information |
|
From: Skopalik S. <sko...@hl...> - 2002-09-09 07:47:23
|
I was developed test script, that using SHOW isql statament instead select from RDB$... tables.
I'm think, that is more readable (and little clear) than select from system tables because
system tables may be change.
Can be used this technique is test scripts ?
Slavek
There is a example:
/*
Author: Slavomir Skopalik (sko...@hl...)
Test ID: skopalik_0027
Test type: POSITIVE
Description: ALTER TABLE - DROP
Dependencies:
CREATE DATABASE
CREATE TABLE
SHOW TABLE
Prerequisites: NONE
Initialization script:
*/
CREATE DATABASE "test.gdb" USER "sysdba" PASSWORD "masterkey";
CREATE TABLE test( id INTEGER NOT NULL,
text VARCHAR(32));
/*
Tested command:
*/
ALTER TABLE test DROP text;
SHOW TABLE test;
/*
Expected result: No Error.
Additional checks:
ID INTEGER Not Null
/*
Clear temp DB
*/
DROP DATABASE;
ing. Slavomir Skopalik DEL a.s.
Olomoucka 355 Marianske udoli 783 75
Czech Republic
----------------------------------------------
Tel: 068 535 35 48
Mobil: 0602 795 874
Fax: 068 535 23 64
e-mail:sko...@hl...
http://hlubocky.del.cz
|
|
From: <Sha...@ya...> - 2002-09-09 01:36:36
|
<!-- saved from url=(0022)http://internet.e-mail -->
<HTML><HEAD>
<TITLE></TITLE>
<STYLE>A:link {color:red}</STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<TABLE cellSpacing=0 cellPadding=14 width=600 border=3 bordercolordark=#003366 bordercolorlight=#669999 bordercolor=#003366>
<TBODY>
<TR>
<TD width=200 bgcolor=#4682b4 valign=top><FONT face="Verdana, Arial" color=#ffffff size=4>
<B>DON'T DREAM TO LIVE! ...<BR><BR>LIVE THE DREAM</B><BR></FONT>
<FONT face="Verdana, Arial" color=#ffffff size=2><BR><B>
<LI>Be your own BOSS
<LI>Work your own HOURS
<LI>No FIXED overhead
<LI>High CASH return
<LI>INCOME Suppliment
<LI>Part Time Business</B></FONT></LI>
<font color=#4682b4>qwertyuioplkj<BR>hgfdsazxcvbnm,.<BR>/0987654321<BR>kdjdjdhfyhsggf<BR>JDHXGDNGDRW<BR>KFOFGJDHDHGS<BR>sazxcvbnm,.<BR>/0987654321<BR>kdjdjdhfyhsggf<BR>JDHXGD<BR>qwertyuioplkj<BR>hgfdsazxcvbnm,.<BR>/0987654321<BR>kdjdjdhfyhsggf<BR>JDHXGDNGDRW<BR>KFOFGJDHDHGS</font>
</TD>
<TD width=400>
<FONT face="Verdana, Arial" color=#000050 size=3>
<B>Dear Future Business Owner,</B>
<P align=center><FONT face="Verdana, Arial" color=#000050 size=2>
You can now for the first time, own a business in your area with the most unique, innovative product in America today.<BR><BR>
Work less than ten hours a week with the potential to earn $50,000 a year.<BR><BR>Here's how! Over 300 Million people use this product in the U.S.
daily, that's right, over 300 Million people.<BR><BR>The profit margin with us is an amazing 400%, you will be saying
to yourself why didn't I think of that!<BR><BR> Break down the walls and live this life you've only dreamed about.<BR><BR>
<BR>Availabilty is your area is limited.<BR><A href="http://365.businessonlinenow.com/brush/">
<B>CLICK HERE NOW</B></A><BR>So you too can receive your free information package today.
<BR><BR><A href="http://365.businessonlinenow.com/brush/">
<FONT face="Verdana, Arial" color=#cc3333 size=5><B><I>Don't wait any longer!<BR>Get Started Today!!</I></B></FONT></A></FONT></P>
</TD></TR></TBODY></TABLE><BR>
<TABLE width=550>
<TBODY>
<TR >
<TD align=center>
<HR SIZE=1 width="100%" color=indigo>
<font size="1" face="Verdana, Arial">Your email address was obtained from an opt-in list. Opt-in MRSA List
<BR>Purchase Code # 312-2412. If you wish to be unsubscribed from this list, please <A href="http://365.businessonlinenow.com/brush/remove.html" target="_blank">click here</A></font>
<font color=ffffff>qwertyuioplkjhgfdsazxcvbnm,./0987654321</font>
</TD></TR></TBODY></TABLE></BODY></HTML>
8979OyOq3-676Lbid1980plSg1-968QCxa3640XkfO3-278zmkG929l51
|
|
From: agostinho <ago...@cl...> - 2002-09-08 08:40:31
|
Hi
I have the following problem
I have this code bellow in a SP inside a for select and it only work =
wih
the IN clause.
If i chenge to =3D it dosen't work
Is it a bug?
I'm using firebird 1.0
UPDATE inventario SET CUSTOMEDIO =3D (
SELECT PRECOMEDIO FROM CUSTEIO
WHERE custeioid IN (SELECT MAX(CUSTEIOID)
FROM CUSTEIO WHERE (codart=3D:CODART) =
AND
(tipo=3D0) and (data <=3D:DATAF)))
WHERE (CODART=3D:CODART) AND (CODARM=3D:CODARM) AND (util =
=3D user);
Best regards
Agostinho
ago...@cl...
|
|
From: news.clix.pt <ago...@cl...> - 2002-09-08 08:39:39
|
Hi
I have the following problem
I have this code bellow in a SP inside a for select and it only work wih
the IN clause.
If i chenge to = it dosen't work
Is it a bug?
I'm using firebird 1.0
UPDATE inventario SET CUSTOMEDIO = (
SELECT PRECOMEDIO FROM CUSTEIO
WHERE custeioid IN (SELECT MAX(CUSTEIOID)
FROM CUSTEIO WHERE (codart=:CODART) AND
(tipo=0) and (data <=:DATAF)))
WHERE (CODART=:CODART) AND (CODARM=:CODARM) AND (util = user);
Best regards
Agostinho
ago...@cl...
|
23 messages has been excluded from this view by a project administrator.
