Welcome to the Infobright bug tracking system
Please take a minute to Register and Login, in order to be able to see and report issues.
If you believe you have found a defect or you want to request a feature enhancement, there are two ways you can bring this to the attention of the ICE community. Please check to see if it is already a known issue by searching in the Tracker and the Forums. If you are unsure about a defect, ask the community on the Forum before opening a tracker item.
Team Infobright
Open ICE Tickets
Tickets #891 Default MySQL tests included in Infobright contain tests that will not run#933 Results of queries executed by IB engine aren't cached#935 Usability: "Cannot start bhloader" needs improved error message#939 Database collation type shows as latin1_swedish_ci, should be latin1_ascii_bin#960 escaped N should be loaded as NULL#987 Cannot support Debian Etch because fdopendir is available in glibc from version 2.4#997 Embedded enclosure character aborts load without error or warning#1010 Server crashes if, for some reason, one of the DPN files doesn't exist or not accessible#1026 ICE Src: ability to set build comment from commandline#1031 ICE: delete with condition doesn't report error#1039 Untarring the 3.0.2 tarbal will overwrite contents in previous 3.0 install - it does not create new 3.0.2 dir#1042 Queries with join on Infobright and myisam table do not return warning that is executed by mysql.#1072 "LINES TERMINATED BY" ignored on export#1115 text load skips last line if no newline present#1141 ICE: compile warning#1161 ICE: Misleading error message about termination of session#1172 Dropping a table while it is currently loading hangs rather than returning an error#1174 LOCK TABLES does not work as expected.#1177 rename source tar to not have hardware (i686 or x86_64 or win32)#1179 Permission issue in Infobright binary causes the installation to fail for /home or /root folder#1188 load of a lookup column slows a lot for larger number of distinct values#1235 ICE32 VMWare: export file gets newline character M at the end of each line #1256 ICE needs to throw error if bh_dataformat set incorrectly#1305 Unsupported LOAD syntax does not give errors#1310 Wrong conversion value '0000-00-00 00:00:00' in timestamp datatype column.#1315 "CHARACTER SET" not recognized in LOAD DATA INFILE#1338 Loader - enhancement to allow for rejected records option#1344 Problems related to character_set_server#1370 Analyze the man pages we install#1375 BH_RSI_Repository should not be usable as a database#1452 dump/load is inconsistent#1453 inconsistent dump/load, continued#1454 corrupt dump/load when ordering data#1469 SHOW xxx returns BINARY#1470 --debug-info broken in mysql-ib#1479 security issue in InfoBright? engine#1483 Win Installer should check for previous version#1484 LOAD DATA INFILE ignores "LINES TERMINATED BY"#1533 Upgrade Issues with new install packages#1534 Post install script missing config items#1536 Windows installer has no config options#1537 Install MUST NOT conflict with MySQL by defaul in any way#1601 DATE_FORMAT returns a binary result#1621 Error Message for installing 32-bit vs 64-bit#1627 No ability to change name/location of my-ib.cnf with RPM/DEB#1638 Fedora 9,10,11,12,13 End-of-Lifed, Must Move to Fedora 14#1649 bugs in build system#1657 non-database folders and files in data directory#1662 "Numeric string" cannot be inserted into numeric columns, inconsistent with standard MySQL treatment#1707 documentation - location of license file#1718 importing escaped backslashes fails#1720 Add brighthouse.ini variable to make bh_dataformat="txt_variable" default#1730 mysqld crashes when process killed#1735 Export to outfile does not escape characters#1749 Dynamic Content in Installers#1750 DML Should not flush Cache#1752 export in mysql format fails on existing file#1757 problems when changing KNFolder#1764 SQL_CALC_FOUND_ROWS not supported#1766 STDDEV wrong result#1770 crash when with select and subquery and <> any#1780 Hash-based authentication#1794 ETL connector performance#1801 ICE importer ignores IGNORE LINES#1803 Grammar Error in postconfig.sh#1806 Add start/stop using the ‘service’ utility to the Startup Script#1820 Query with Union , distinct and group by on varchar data type columns cause crash.#1821 Talend connector performance#1841 Cannot use bh loader to insert a double quote character#1884 Select into outfile saves file with permission of 660 instead of standard mysql 666 - which causes mysql import issues#1894 Loader incorrect behaviour when there are extra columns#1903 "\N" load as N or 0 instead of Null by Infobright loader in opposite of Mysql.#1911 Impossible to retrieve rows filtering by timestamp after daylight change#1916 LOAD DATA introduces too much disk size overhead.#1940 Significant Query Slowdown during LOAD#1946 configure cache folder on block device?#1953 ICE: Remove Comment Character from CharacterSet? Settings#1955 rename table across databases: crashes mysqld#1957 Error Handling within Column Data#1958 Query Returns different values after consecutive executions#1966 roughattrstats broken in 32-bit#1968 export with IFNULL pads to max width#1976 Add Functionality to Rebuild Knowledge Grid#1978 misleading bh.err log messages from Describe Table#1982 From Forum: bhloader loads data incorrectly#1992 ICE 3.4.2: null pointer deref when accessing information_schema.routines#1994 VIEW + UNION + TIMESTAMP not taking consideration of time_zone when querying view#1996 small issues in postconfig.sh#1997 LIMIT clause with simple WHERE query can return too few rows#1998 Problem loading scientific format into [big]int field#2027 LOAD DATA LOCAL in Win32 is Hanging when full path to file not specified#2032 Trac#2032 Windows 64K limit for LOAD DATA LOCAL INFILE#2034 string modifier functions (at least lower/upper) in group, order or join cause query go MySQL engine#2038 LOAD DATA LOCAL Fails to load Sample File#2041 Feature Request:: Information_Schema Table#2042 GLIBC Issues when Installing ICE on latest Ubuntu#2043 Support for Group_Concat Function#2044 No server name in bcp commands (ICE Breaker for SQL server)#2058 Sort Order inconsistent within UTF8#2062 Execut Query Mix of Variable and Table Through Optimizer#2071 alias column in a view which is in a subquery make ib switch to mysql engineClosed ICE Tickets
Tickets #848 Knowledge Node files intermittently become unavailable to queries, resulting in slower queries#870 Infobright can't find numbers in numeric text; inconsistent with MyISAM's treatment#873 ICE: a couple of minor issues in compilation/installation instructions in INSTALL-INFOBRIGHT-SOURCE#875 Infobright engine appears as transactional - cosmetic only; no impact on performance#881 Subqueries with EXIST compiled in sub optimal way, potentially resulting in sub optimal query response#883 ICE installation may overwrite existing MySQL installation with new configurations#886 ICE: import txt fails when bh_dataformat is not set.#887 ICE:src: install / compile instructions in root of tar#888 installer hardening: quotes in path (and spaces) not handled by installer#890 Support server start on bootup#893 Incorrect entry in /etc/my.cnf for basedir may cause install script to fail#895 Loader will halt when loading multiple datasets with 64K identical values in a column#896 Cannot run Infobright server on debian etch 4.0 - reports library error: /lib/libc.so.6: version `GLIBC_2.4' not found#904 my.cnf still used even with --config given#916 Use of constants in select causes switch to MySQL Path (and slow performance)#917 Loader crash (Windows)#918 IB Loader wrongly calculates size of the field whenever there is an escape character present in the data.#932 While query_cache_size is on, query executed by mysql engine on brighthouse tables return wrong results.#949 ICE32 build does not work on older machines#959 ICE ignores ONLY_FULL_GROUP_BY sql mode#967 insert into TIMESTAMP columns do not respect session time_zone#977 ICE 32: crashes when running select count(distinct) with group by a few times in a row#980 ICE 32: Illegal mix of collations error on select#1017 Kettle connector - password shows in plain text#1019 mysqld crashes when killing mysql client during load#1022 Install shell scripts should detect 32/64 bit of OS, and give nice message#1030 ICE: make 'txt_variable' as the default dataformat for export#1073 FF: Query using views with a condition in the WHERE clause using function/complex expression on column from views switches to mysql engine.#1169 CTRL+C do not rollback transaction and block table.#1181 README for ICE/IEE 3.1 still says 3.0#1232 ICE bhloader concurrency issue (Brighthouse: Session terminated)#1234 mysql-ib script doesn't handle quoted strings correctly#1245 TPC-H Query 2 crashes after running query 5#1247 Win32: loading large number to double datatype fails - ERROR 5 (HY000): Unknown error.#1264 Print brighthouse.ini parameters and their values in bh.err file on startup#1270 Loader hangs when loading with quotes#1272 ICE 3.1 for windows 32, startup error "mysqld-nt: unknown option '--skip-federated'"#1274 loader when autocommit=0 doesn't report the line info of an error#1281 Loader hangs if matching " is missing#1282 A variable declaration as a result of an aggregation may switch to mysql query path#1293 Query with left outer join cause crash.#1309 Compare date / datetime / timestamp column to value '0000-00-00' / '0000-00-00 00:00:00' return error.#1314 Running ICE as a Windows Service#1356 can't insert values in table with ICE 3.1.1 VMWare Virtual Machines#1367 Performance in grouping depends on table order#1368 By default we must not conflict with MySQL#1380 division of sum#1391 rpm installer sets smaller memory setting for 4GB physical memory#1412 Unable to start BHLoader. It says - BHLoader does not exist in ./bhloader#1418 rpm install: force installation or upgrade doesn't set the owner on data directory#1472 LOJ with constant in join condition switches to MySQL#1480 Backdating the system clock gets around Eval Key#1535 TRAC fields need some work#1634 Install Registration - 1. Windows Installer#1635 Install Registration - 2. UNIX Packages#1636 Install Registration - 3. VMs#1697 INSERT INTO SELECT results in a deadloop#1702 LOAD DATA INFILE failed…#1705 Broken results when enclosing known (but unimplemented) mysql functions in other functions#1708 select with range test on negative double does not return expected result#1738 Error: Out of resources in JOIN: COUNT(DISTINCT x) with LEFT JOIN in ICE 3.2#1740 Talend inforbright connector problem#1745 connector not compatible with JDK1.5#1755 Connector on Windows times out first time after reboot#1758 Bug when connecting remotly to IB on 64bits#1759 use of boolean operators in result flips to MySQL#1774 joining large tables without WHERE conditions very slow on rough level.#1785 bhloader fails and warns about wrong data/column on a unexisting row#1786 select format(count(*),0) from ... crash server.#1789 rpm install with prefix parameter doesn't work#1804 RENAME TABLE causes the table to be inaccessible#1809 CHAR and VARCHAR sizes aren't handled correctly#1827 Typo in the RPM Script#1857 IEE Trial Key System generating bad keys#1858 Issue with IEE 3.4 and License Files#1864 iblicense.dat file corruption every restart#1865 Issue with Registration and Key Generation#1896 LOAD DATA INFILE / SELECT INTO OUTFILE with timestamp columns differ in time_zone usage.#1901 mysqld got signal 11, because = 0 in where condition#1930 UDF crashing mysqld#1951 Bug when connecting remotly to IB on 64bits#1954 Incorrect handling of quoted "\N" (null) in load file#1972 LOJ evaluation with OR clause#1975 UNION of BIGINTS produces incorrect results#1985 Error: I/O operation on /data/db/ib/cache/PS_CB_0000004BF15320xa47b3e8.bh_tmp failed with error - Bad file descriptor File name /data/db/ib/cache/PS_CB_0000004BF15320xa47b3e8.bh_tmp#2000 LOAD DATA INFILE can lose last character of string#2001 Data loss during export to file#2015 Version 3.5.2 returns duplicates on GROUP BY and DISTINCT#2023 Problem using explicit null for column in a union#2024 ICE 3.5.2P1 mysqld crash when using integrated loader in mysqld#2025 bhloader error when loading ssbm customer and supplier data in 3.5.2#2026 Memory leak when adding interval to a date#2051 Fields escaped by ‘ ’ not working when exporting data#2061 Poor performance and large temporary files on queries using string functions such as SUBSTRING#2063 2011_06_27_ICE_Quick_ Start.pdf Should Include 64-bit Windows in List for Which ICE Is Optimized#2066 ICE 4.0 - Crash on Multiple Left Joins#2075 Infobright Community Edition 4.0.3 User Guide mentions IEE commands#2080 End User Docs: DomainExpert? Corrections#2083 Certain joins crash IB 4.0.3#2112 Compression Ratio Increases Dramatically After Export/Import? 
