search

ekinoguz / sprout-database

Database project of a graduate class.
0 stars 0 forks source link

Error in either CLI or InsertTuple? #20

Closed ekinoguz closed 11 years ago

ekinoguz commented 11 years ago

While I am trying to add 2 records using file import in cli, I see "VarChar is larger than maximum error". However size of the data is 12 and max size of the varchar in database is 100. I don't know if there is a problem in cli or rm. If you run clitest in ixcli branch, you will see the errors. (I commented out other test cases)

cesarghali commented 11 years ago

I will take a look at it from the rm side.

diedthreetimes commented 11 years ago

Ok, the issue seems to be that the tuples formated to insert are not formatted correctly. Because of this the "Major" field is being read incorrectly, specifically it's size, thus printing the strange message.

Notice that the columns printed above the error are

EmpName | tbl_employee | 0 | 2 | 100 | Age | tbl_employee | 1 | 0 | 4 | Height | tbl_employee | 2 | 1 | 4 | Salary | tbl_employee | 3 | 0 | 4 | Major | tbl_employee | 4 | 2 | 100 | Year | tbl_employee | 5 | 0 | 4 |

And then the tuples in the file are,

John Brigham,63,2.4,Computer Science Bull Boshit,45,6.3,Culture Science

I'm not sure what is causing the inconsistency however, and am looking into it.