Precondition: Only the KDb patch needed (against 3.1 branch), no changes in KEXI.
0. Run KDb autotests
Expected: 100% passes
1. Open a new design in KEXI Query Designer.
Note: Visual designer does not support these constants, use the SQL view.
2. Type a number of statements involving Date, Time and Date/Time constants
You can use test cases from autotests/parser/data/statements.txt, sections:
- Date Constants (KDbSQL EXTENSION)
- Time Constants (KDbSQL EXTENSION)
- Date/Time Constants (KDbSQL EXTENSION)
Use the Check Query button to try both valid and invalid constants. For example "SELECT #12:13:01#" should work and "SELECT #2018-11-37#" should be rejected as invalid constant.
Expected: Valid constants should be accepted and then data view should work, there should be warning for invalid constants.
Expected: Saving of both valid and invalid statements should be possible in the SQL view.
{F6453115}
3. Create table with columns of type date, time and date/time and add some records.
4. Open a new design in Query SQL Designer, create statements involving both constants and columns
e.g. SELECT #12:13:01# AS expr1, timecolumn FROM table where table.timecolumn < #2018-11-37#
Expected: valid statement, the Data view works.
{F6453113}