[Firebird-devel] [FB-Tracker] Created: (CORE-3514) extentions of GSTAT output in 3.0
extentions of GSTAT output in 3.0 - Key: CORE-3514 URL: http://tracker.firebirdsql.org/browse/CORE-3514 Project: Firebird Core Issue Type: New Feature Components: GSTAT Affects Versions: 3.0 Alpha 1, 3.0 Beta 1, 3.0.0 Reporter: kdv I ask to extend GSTAT output with the information, already provided by InterBase XE gstat. These options are: for tables: now Average record length: 67.06, total records: 31 nice to implement Average record length: 67.06, total records: 31, max record length: 83 i.e. add maximal record length detected (rounded up integer) and information about Blobs in tables (don't exist now at all), like this: JOB (129) Primary pointer page: 382, Index root page: 383 Average record length: 67.06, total records: 31, max record length: 83 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 4, data page slots: 4, average fill: 65% Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 0 60 - 79% = 3 80 - 99% = 0 Blob pointer page: 446 Average blob length: 129.95, total blobs: 39, max blob length: 273 Average segment length: 44.81, total segments: 114, max segment length: 85 Blob pages: 7, blob page slots: 7, average fill: 90% Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 0 60 - 79% = 1 80 - 99% = 6 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3483) Ref to undefined TABLE ALIAS gives error message about unknown COLUMN
Den 2011-05-18 16:28 skrev Kjell Rilbe (JIRA) såhär: > Ref to undefined TABLE ALIAS gives error message about unknown COLUMN > - > > Key: CORE-3483 > URL: http://tracker.firebirdsql.org/browse/CORE-3483 > Project: Firebird Core >Issue Type: Bug >Components: Engine > Affects Versions: 2.1.3 > Environment: Windows 2008 server 64 bit. Classic. > Reporter: Kjell Rilbe > Priority: Minor > > > select * > from "Investeringskategori" X > inner join "Värdeförrådsvärde" Y on Z."ECO_ID" = X."ECO_ID" > > Please note that in the join condition I accidentally wrote Z instead of Y. > Alias Z isn't defined ANYWHERE. But I still get this error: > > Engine Code: 335544569 > Engine Message : > Dynamic SQL Error > SQL error code = -206 > Column unknown > Z.ECO_ID > At line 14, column 41 > > This may be related to CORE-2959. Now that I've noticed this bug, I see that it seems to happen each and every time you happen to reference anything using an undefined table alias in a select. Always. So, a pretty consistent bug! :-) Kjell -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] SQLSubType weird behavior
Hi Jason, > I have been testing UTF8 character set with various collations. > > I'm using FB 2.5. > > I created this table in a database using UTF8 as default character set: > > CREATE TABLE TEST_COLLATE > ( ID BIGINT NOT NULL PRIMARY KEY > , T_UTF8_CI VARCHAR( 10 ) COLLATE UNICODE_CI > , T_UTF8_UN VARCHAR( 10 ) COLLATE UNICODE > , T_UTF8 VARCHAR( 10 ) > ) > > For some reason, the SQLSubType value I get back from the server for the > two columns with non-default COLLATE gives me a value of 772 and 516. > > Why would I get such a strange value for SQLSubType when normally I get > the character set id. For (VAR)CHARS, the high byte of the subtype contains the collation ID. Cheers, Paul Vinkenoog -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel