csql-core Mailing List for CSQL Main Memory Database / Cache (Page 2)
Main Memory Database Cache
Brought to you by:
prabatuty
Menu
▾
▴
csql-core — core development team
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(16) |
Dec
(30) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(3) |
Feb
(7) |
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Gopal S. <gop...@gm...> - 2007-12-10 07:12:19
|
Hi Praba, I have submitted code JDBC change to support SELECT. All datatype should work fine. Some non-major functions are yet to be implemented. Will update as I get time. Will look into test scripts. Thanks. Regards Gopal S. |
|
From: prabakaran <pra...@ya...> - 2007-12-10 03:52:27
|
Minutes of meeting added in the wiki page.
Please add whatever i have missed there.
Prabakaran
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
|
|
From: Gopal S. <gop...@gm...> - 2007-12-09 08:18:10
|
Hi Praba, I have posted some points in discussion page. Somehow this discussion appeared in first wiki page itself, though I posted it in 'Gateway Arch' page. Regards Gopal S. prabakaran wrote: > I have put some architecture diagrams under "New > feature ideas" wiki section. > If u get time go through it before the meeting. > We will discuss about it in the meeting. > Regards > Prabakaran > > > > ____________________________________________________________________________________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs > > |
|
From: Ganga B K. <gan...@gm...> - 2007-12-09 03:30:25
|
Gopal and Aruna, Let us know whether u guys are joining. We (Praba, Praveen and myself) logged into skype. Ganga On Dec 9, 2007 12:57 AM, prabakaran <pra...@ya...> wrote: > I have put some architecture diagrams under "New > feature ideas" wiki section. > If u get time go through it before the meeting. > We will discuss about it in the meeting. > Regards > Prabakaran > > > > ____________________________________________________________________________________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs > |
|
From: prabakaran <pra...@ya...> - 2007-12-08 19:27:23
|
I have put some architecture diagrams under "New
feature ideas" wiki section.
If u get time go through it before the meeting.
We will discuss about it in the meeting.
Regards
Prabakaran
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
|
|
From: prabakaran <pra...@ya...> - 2007-12-08 14:56:30
|
Hi All,
Let us meet tommorow morning 9AM IST through skype.
My id praba_tuty
Sorry for late notice.
Regards
Prabakaran
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
|
|
From: aruna b. <aru...@ya...> - 2007-12-07 19:15:36
|
Praba,
I got a similar report, but total tests executed were 202.
Few tests in dbapi/Index and system/Allocator are missing. Please check if you missed submitting new files. I have done cvs update in both the directories.
Regards,
Aruna
prabakaran <pra...@ya...> wrote: Added support for DROP TABLE, DROP INDEX, CREATE
INDEX.
Aruna: thanks for cleaning up the code as well.
Also changed the TableDef::addField signature.
Now the behaviour would be
For creating unique and primary constrain one needs to
create an index on it.
This is the latest report
====================================================================
MODULE TESTPASSED
TESTFAILED
====================================================================
dbapi/Connection 51
7
dbapi/Index 9
2
dbapi/DataType 17
5
dbapi/Table 7
2
dbapi/UserManager 1
0
dbapi/Predicate 24
0
system/config 26
6
system/Allocator 13
1
system/proc 1
0
system/lock 17
1
system/trans 18
0
tools/catalog 4
0
====================================================================
TOTAL 188
24
====================================================================
TOTAL Executed: 212
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Csql-core mailing list
Csq...@li...
https://lists.sourceforge.net/lists/listinfo/csql-core
---------------------------------
Explore your hobbies and interests. Click here to begin. |
|
From: prabakaran <pra...@ya...> - 2007-12-07 05:15:13
|
Added support for DROP TABLE, DROP INDEX, CREATE
INDEX.
Aruna: thanks for cleaning up the code as well.
Also changed the TableDef::addField signature.
Now the behaviour would be
For creating unique and primary constrain one needs to
create an index on it.
This is the latest report
====================================================================
MODULE TESTPASSED
TESTFAILED
====================================================================
dbapi/Connection 51
7
dbapi/Index 9
2
dbapi/DataType 17
5
dbapi/Table 7
2
dbapi/UserManager 1
0
dbapi/Predicate 24
0
system/config 26
6
system/Allocator 13
1
system/proc 1
0
system/lock 17
1
system/trans 18
0
tools/catalog 4
0
====================================================================
TOTAL 188
24
====================================================================
TOTAL Executed: 212
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
|
|
From: prabakaran <pra...@ya...> - 2007-12-05 13:23:54
|
Hi All,
I have changed the default user name to "root".
With that i have submitted fixes for some bugs and not
null feature, added more test scripts.
This is the latest test report. I am yet to update the
wiki pages test case section.
====================================================================
MODULE TESTPASSED
TESTFAILED
====================================================================
dbapi/Connection 50
8
dbapi/Index 5
2
dbapi/DataType 17
5
dbapi/Table 8
1
dbapi/UserManager 1
0
dbapi/Predicate 24
0
system/config 26
6
system/Allocator 7
1
system/proc 0
1
system/lock 18
0
system/trans 18
0
tools/catalog 4
0
====================================================================
TOTAL 178
24
====================================================================
TOTAL Executed: 202
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
|
|
From: prabakaran <pra...@ya...> - 2007-12-04 05:56:06
|
Done. I changed your settings. you should be able to
do it yourself from now on. Let me know if you still
face this issue.
Regards
Prabakaran
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
|
|
From: aruna b. <aru...@ya...> - 2007-12-03 21:33:49
|
Hello Praba,
I couldnt get drop down box to assign a bug to myself. I have logged in to sourceforge.
I would like to work on bug 1842197. If nobody else has taken it up, could you assign it to me.
Regards,
Aruna
---------------------------------
Explore your hobbies and interests. Click here to begin. |
|
From: aruna b. <aru...@ya...> - 2007-12-03 18:31:21
|
Praba,
This Week:
Submitted first patch for DDL.
Went through test reports, fixed few expected output files.
Next Week:
Work on low priority bugs, or check failing test scripts, raise bugs.
Regards,
Aruna
Gopal Shankar <gop...@gm...> wrote: Hi Praba,
This week:
Coded JdbcSqlResultSet.
Changed TSL() asm
Fixed index::destroy() to avoid double delete.
Next week:
Code JSqlResultSet and JSqlResultSetMetaData
Write some basic jdbc tests
Regards
Gopal S.
Ganga B Kondapalli wrote:
This week:
------------
* Checked allocator module and part of dbmgmt
* Checked B-tree code.
Next week:
-------------
* DDL implementation
* Need to decide whether to go ahead and do the b-tree index or not.
- Ganga
On Dec 1, 2007 12:26 PM, prabakaran <pra...@ya...> wrote:
Hi All,
We will have our meeting next week.
Find below the status of the tasks i handled.
Let us send mail to this mailing list about our task
status in the format i have used. I will summarize and
add it to wiki after i receive status from all of us.
Regards
Prabakaran
This Week:
-----------
1842163 (Catalog tool to print db usage info) -
submitted first patch, it prints page wise usage
1842151 (Chunk::allocate does not return DbRetval)-
Fixed
1842152 (Table with multiple indexes does not work. It
dumps core)- Fixed
Added test scripts for predicates
Added test scripts for isolation level
Modified DMLThreadTest to add select tests
Next Week:
-----------
1842163 (Catalog tool to print db usage info) - should
print proctable, transtable, locktable, undologtable
1842188 (Catalog tool to print table and index usage
info)
1837968 (Script to start, stop, status for csqlserver)
Add test scripts for allocator
Add test scripts for csql tool - DDL, DML
Add test scripts for catalog tool
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Csql-core mailing list Csq...@li... https://lists.sourceforge.net/lists/listinfo/csql-core
------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Csql-core mailing list Csq...@li... https://lists.sourceforge.net/lists/listinfo/csql-core
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4_______________________________________________
Csql-core mailing list
Csq...@li...
https://lists.sourceforge.net/lists/listinfo/csql-core
---------------------------------
Bring your gang together - do your thing. Start your group. |
|
From: Gopal S. <gop...@gm...> - 2007-12-02 02:17:20
|
Hi Praba, This week: Coded JdbcSqlResultSet. Changed TSL() asm Fixed index::destroy() to avoid double delete. Next week: Code JSqlResultSet and JSqlResultSetMetaData Write some basic jdbc tests Regards Gopal S. Ganga B Kondapalli wrote: > This week: > ------------ > * Checked allocator module and part of dbmgmt > * Checked B-tree code. > > Next week: > ------------- > * DDL implementation > * Need to decide whether to go ahead and do the b-tree index or not. > > - Ganga > > > On Dec 1, 2007 12:26 PM, prabakaran <pra...@ya...> wrote: > >> Hi All, >> We will have our meeting next week. >> Find below the status of the tasks i handled. >> Let us send mail to this mailing list about our task >> status in the format i have used. I will summarize and >> add it to wiki after i receive status from all of us. >> >> Regards >> Prabakaran >> >> This Week: >> ----------- >> 1842163 (Catalog tool to print db usage info) - >> submitted first patch, it prints page wise usage >> 1842151 (Chunk::allocate does not return DbRetval)- >> Fixed >> 1842152 (Table with multiple indexes does not work. It >> dumps core)- Fixed >> Added test scripts for predicates >> Added test scripts for isolation level >> Modified DMLThreadTest to add select tests >> >> Next Week: >> ----------- >> 1842163 (Catalog tool to print db usage info) - should >> print proctable, transtable, locktable, undologtable >> 1842188 (Catalog tool to print table and index usage >> info) >> 1837968 (Script to start, stop, status for csqlserver) >> Add test scripts for allocator >> Add test scripts for csql tool - DDL, DML >> Add test scripts for catalog tool >> >> >> ____________________________________________________________________________________ >> Get easy, one-click access to your favorites. >> Make Yahoo! your homepage. >> http://www.yahoo.com/r/hs >> >> ------------------------------------------------------------------------- >> SF.Net email is sponsored by: The Future of Linux Business White Paper >> from Novell. From the desktop to the data center, Linux is going >> mainstream. Let it simplify your IT future. >> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 >> _______________________________________________ >> Csql-core mailing list >> Csq...@li... >> https://lists.sourceforge.net/lists/listinfo/csql-core >> >> > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > > |
|
From: Ganga B K. <gan...@gm...> - 2007-12-01 17:04:16
|
This week: ------------ * Checked allocator module and part of dbmgmt * Checked B-tree code. Next week: ------------- * DDL implementation * Need to decide whether to go ahead and do the b-tree index or not. - Ganga On Dec 1, 2007 12:26 PM, prabakaran <pra...@ya...> wrote: > Hi All, > We will have our meeting next week. > Find below the status of the tasks i handled. > Let us send mail to this mailing list about our task > status in the format i have used. I will summarize and > add it to wiki after i receive status from all of us. > > Regards > Prabakaran > > This Week: > ----------- > 1842163 (Catalog tool to print db usage info) - > submitted first patch, it prints page wise usage > 1842151 (Chunk::allocate does not return DbRetval)- > Fixed > 1842152 (Table with multiple indexes does not work. It > dumps core)- Fixed > Added test scripts for predicates > Added test scripts for isolation level > Modified DMLThreadTest to add select tests > > Next Week: > ----------- > 1842163 (Catalog tool to print db usage info) - should > print proctable, transtable, locktable, undologtable > 1842188 (Catalog tool to print table and index usage > info) > 1837968 (Script to start, stop, status for csqlserver) > Add test scripts for allocator > Add test scripts for csql tool - DDL, DML > Add test scripts for catalog tool > > > ____________________________________________________________________________________ > Get easy, one-click access to your favorites. > Make Yahoo! your homepage. > http://www.yahoo.com/r/hs > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > |
|
From: prabakaran <pra...@ya...> - 2007-12-01 06:57:12
|
Hi All,
We will have our meeting next week.
Find below the status of the tasks i handled.
Let us send mail to this mailing list about our task
status in the format i have used. I will summarize and
add it to wiki after i receive status from all of us.
Regards
Prabakaran
This Week:
-----------
1842163 (Catalog tool to print db usage info) -
submitted first patch, it prints page wise usage
1842151 (Chunk::allocate does not return DbRetval)-
Fixed
1842152 (Table with multiple indexes does not work. It
dumps core)- Fixed
Added test scripts for predicates
Added test scripts for isolation level
Modified DMLThreadTest to add select tests
Next Week:
-----------
1842163 (Catalog tool to print db usage info) - should
print proctable, transtable, locktable, undologtable
1842188 (Catalog tool to print table and index usage
info)
1837968 (Script to start, stop, status for csqlserver)
Add test scripts for allocator
Add test scripts for csql tool - DDL, DML
Add test scripts for catalog tool
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs
|
|
From: prabakaran <pra...@ya...> - 2007-12-01 05:36:03
|
Hi All,
Latest test report on Dec-01, 2007
====================================================================
MODULE TESTPASSED
TESTFAILED
====================================================================
dbapi/Connection 50
8
dbapi/Index 5
0
dbapi/DataType 17
5
dbapi/Table 2
3
dbapi/UserManager 1
0
system/config 26
6
dbapi/Predicate 24
0
====================================================================
TOTAL 125
22
====================================================================
TOTAL Executed: 147
Regards
Prabakaran
____________________________________________________________________________________
Be a better sports nut! Let your teams follow you
with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ
|
|
From: Gopal S. <gop...@gm...> - 2007-12-01 02:15:29
|
Hi All, To make life little easy, i have put this file in root directory. Change it as required. Thanks. |
|
From: prabakaran <pra...@ya...> - 2007-11-29 05:17:20
|
Find my comments inlined.
Forwarding it to mailing list.
Praba
Praba,
I was looking at allocator code. Below are the
comments I have.
file: ChunkIterator.c
Chunk::getIterator() - why are we returning a local
variable?
PRABA::It is returning by value not by reference.
ChunkIterator::nextElement -
checking for variable size iterator can be done in
getIterator
PRABA::Create a bug for this and assign low priority.
Why can't we store number of elements used in
PageInfo instead of iterating? offset can be
maintained along with this to store where to allocate
next from. Tuple deletion will change this offset to
where ever needs to be allocated
This can be written as recursive function
PRABA::Refer 1821209 for this. The Offset will be
stored in ChunkIterator object itself rather than
pageInfo object.
Where to allocate next from is stored in Chunk object.
This offset needs to be changed to ptr.
file: Chunk.c
Chunk::getSize
Usage of sizeof(int) for every allocation in chunk
should be
more
> clear. Better to have new struct and maintain this
I did not get this. Are you talking about setSize?
Chunk::getTotalDataNodes - dont we maintain list of
rows in table struct?
PRABA::I think u meant count of rows. It is not
maintained. Create bug for this.
Overall I feel, this allocation algorithms can be
improved to give better performance. We can take this
up later.
PRABA::create an action item for this.we will discuss
about it there.
- Ganga
____________________________________________________________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/
|
|
From: aruna b. <aru...@ya...> - 2007-11-28 17:14:56
|
Fwding ganga's email. Ganga B Kondapalli <gan...@gm...> wrote: I'll take a look at dbapi/connection failures. Let me know if somebody is already looking into it. On 11/28/07, aruna baliga wrote: > This is the present test report i have > > ==================================================================== > MODULE TESTPASSED TESTFAILED > ==================================================================== > dbapi/Connection 22 > 36 > dbapi/Index 2 3 > dbapi/DataType 17 > 5 > dbapi/Table 2 3 > dbapi/UserManager 1 > 0 > system/config 26 6 > ==================================================================== > TOTAL 70 53 > ==================================================================== > TOTAL Executed: 123 > > > If any of you have a different report let me know. > > > ________________________________ > Explore your hobbies and interests. Click here to begin. > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > > --------------------------------- Forgot the famous last words? Access your message archive online. Click here. |
|
From: prabakaran <pra...@ya...> - 2007-11-28 15:32:01
|
Hi Aruna,
For me it was around
Passed: 100
Failed: 25
last week when i checked before test script
submission.
I will check and let you know tommorow.
Regards
Prabakaran
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs
|
|
From: Gopal S. <gop...@gm...> - 2007-11-28 06:04:06
|
Hi Aruna, I was also getting lots of failures today. I have some proposed fixes in bug 1834515 and 1840027 under review yet, not submitted. Can you please check if that works ? Regards Gopal S. On Nov 27, 2007 5:30 PM, aruna baliga <aru...@ya...> wrote: > This is the present test report i have > > ==================================================================== > MODULE TESTPASSED TESTFAILED > ==================================================================== > dbapi/Connection 22 36 > dbapi/Index 2 3 > dbapi/DataType 17 5 > dbapi/Table 2 3 > dbapi/UserManager 1 0 > system/config 26 6 > ==================================================================== > TOTAL 70 53 > ==================================================================== > TOTAL Executed: 123 > > > If any of you have a different report let me know. > > ------------------------------ > Explore your hobbies and interests. Click here to begin.<http://in.rd.yahoo.com/tagline_groups_6/*http://in.promos.yahoo.com/groups> > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > > |
|
From: prabakaran <pra...@ya...> - 2007-11-28 05:29:52
|
test worked again
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs
|
|
From: Gopal S. <gop...@gm...> - 2007-11-28 05:08:35
|
testing once again. On Nov 27, 2007 8:43 AM, prabakaran <pra...@ya...> wrote: > test worked > > > > > ____________________________________________________________________________________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs > |
|
From: aruna b. <aru...@ya...> - 2007-11-27 23:30:44
|
This is the present test report i have
====================================================================
MODULE TESTPASSED TESTFAILED
====================================================================
dbapi/Connection 22 36
dbapi/Index 2 3
dbapi/DataType 17 5
dbapi/Table 2 3
dbapi/UserManager 1 0
system/config 26 6
====================================================================
TOTAL 70 53
====================================================================
TOTAL Executed: 123
If any of you have a different report let me know.
---------------------------------
Explore your hobbies and interests. Click here to begin. |
|
From: prabakaran <pra...@ya...> - 2007-11-27 14:43:29
|
test worked
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
|
