reset password
Author Message
K3ViiiNN
Posts: 8
Posted 18:57 Nov 06, 2013 |

The field list can be omitted if the inserted record includes all the fields in the order specified in the CREATE TABLE statement.

Does this mean the user would create a table first and then do the insert statements?

cysun
Posts: 2935
Posted 19:35 Nov 06, 2013 |

Yes. Without a table an INSERT statement will fail no matter what syntax it's in.

harry_520
Posts: 76
Posted 15:52 Nov 08, 2013 |

For this problem,  do we have to get involved in all three processing - scanning, parsing and planning? And is it necessary to create new files, or just modifying exsisting files for both two problems?

cysun
Posts: 2935
Posted 15:54 Nov 08, 2013 |
harry_520 wrote:

For this problem,  do we have to get involved in all three processing - scanning, parsing and planning? And is it necessary to create new files, or just modifying exsisting files for both two problems?

Modifying existing files should be enough.

harry_520
Posts: 76
Posted 16:20 Nov 08, 2013 |

I'm still not quite sure that, in order to make the "insert" operation working, do we have to work on all three scan, parse and plan? It seems like "insert" does require scan.

cysun
Posts: 2935
Posted 16:25 Nov 08, 2013 |
harry_520 wrote:

I'm still not quite sure that, in order to make the "insert" operation working, do we have to work on all three scan, parse and plan? It seems like "insert" does require scan.

Well, it's a homework, so go figure it out.

harry_520
Posts: 76
Posted 17:46 Nov 08, 2013 |

Do we have to check if the table exists in the database before doing the insert?

cysun
Posts: 2935
Posted 17:47 Nov 08, 2013 |
harry_520 wrote:

Do we have to check if the table exists in the database before doing the insert?

No.

harry_520
Posts: 76
Posted 15:16 Nov 09, 2013 |

I' m stuck on this problem, I cannot figure out where in the simpleDB I need to work on. Can anyone give me some clues? I would be appreciatived.

Last edited by harry_520 at 15:18 Nov 09, 2013.
cysun
Posts: 2935
Posted 08:58 Nov 10, 2013 |
harry_520 wrote:

I' m stuck on this problem, I cannot figure out where in the simpleDB I need to work on. Can anyone give me some clues? I would be appreciatived.

Start by going over the lecture and understand what each component (lexer, parser, planner, and execution engine) does, then analyze the problem and see which component(s) needs to be modified.