Correctness of SQL Queries on Databases with Nulls

  • Cust 2 Ord, Cust, John Cust
  • Published 2017
Multiple issues with SQL’s handling of nulls have been well documented. Having efficiency as its main goal, SQL disregards the standard notion of correctness on incomplete databases – certain answers – due to its high complexity. As a result, the evaluation of SQL queries on databases with nulls may produce answers that are just plain wrong. However, SQL… CONTINUE READING