SQLite

Diff
Login

Differences From Artifact [6912c428]:

To Artifact [1b63f8c0]:


597
598
599
600
601
602
603











604
605
      Always
      AS ('xyzzy'),
    e int                         Always default(5)
  );
  INSERT INTO t1(a) VALUES(5);
  SELECT name, type FROM pragma_table_xinfo('t1');
} {a INTEGER b INT c TEXT d {} e INT}












finish_test







>
>
>
>
>
>
>
>
>
>
>


597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
      Always
      AS ('xyzzy'),
    e int                         Always default(5)
  );
  INSERT INTO t1(a) VALUES(5);
  SELECT name, type FROM pragma_table_xinfo('t1');
} {a INTEGER b INT c TEXT d {} e INT}

# 2021-09-07 forum https://sqlite.org/forum/forumpost/699b44b3ee
#
reset_db
do_execsql_test gencol1-22.1 {
  CREATE TABLE t0(a PRIMARY KEY,b TEXT AS ('2') UNIQUE);
  INSERT INTO t0(a) VALUES(2);
  SELECT * FROM t0 AS x JOIN t0 AS y
   WHERE x.b='2'
     AND (y.a=2 OR (x.b LIKE '2*' AND y.a=x.b));
} {2 2 2 2}

finish_test